How to restrict the user to enter invoice only though Invoice Batch

Question:
How to stop user to enter invoices directly though invoices window without creating Invoice Batch?

Answer:
Enable profile "AP: Use Invoice Batch Controls"

When this option is enabled, you cannot enter invoices directly in the Invoices window.

Enable this option to enable use of the Invoice Batches window, which you can use to specify batch defaults that help speed and control invoice entry in the Invoice Workbench.

Enabling this option also allows you to specify an invoice batch name to a group of invoice records when you submit Payables Open Interface Import.

Query to find details of Data Definition, Template, File Name of a Concurrent Program

Query to find details of Data Definition, Template, File Name of a Concurrent Program

Background:
For creating XML Publisher Report, we need to create Data Definition whose code should be exactly equal to the Application Short Name of the concurrent program. Then we create Template based on the Data Definition we have created.

Script:
Provide Concurrent Program Short Name, Application Name (Eg. General Ledger) to the following script. It gets Data Definition information & Template information for you.

SELECT XDDV.data_source_code "Data Definition Code",
       XDDV.data_source_name "Data Definition",
       XDDV.description "Data Definition Description",
       XTB.template_code "Template Code",
       XTT.template_name "Template Name",
       XTT.description "Template Description",
       XTB.template_type_code "Type",
       XL.file_name "File Name",
       XTB.default_output_type "Default Output Type"
  FROM apps.XDO_DS_DEFINITIONS_VL XDDV,
       apps.XDO_TEMPLATES_B XTB,
       apps.XDO_TEMPLATES_TL XTT,
       apps.XDO_LOBS XL,
       apps.FND_APPLICATION_TL FAT,
       apps.FND_APPLICATION FA
 WHERE      XDDV.data_source_code = '&CP_Short_Name'
       AND FAT.application_name = '&Application_Name'
       AND XDDV.application_short_name = FA.application_short_name
       AND FAT.application_id = FA.application_id
       AND XTB.application_short_name = XDDV.application_short_name
       AND XDDV.data_source_code = XTB.data_source_code
       AND XTT.template_code = XTB.template_code
       AND XL.lob_code = XTB.template_code    
       AND XL.xdo_file_type = XTB.template_type_code;