Adding a custom Report in Oracle Apps R12

Pre Requisites 

1-Develop a report using Oracle Developer and placed it in respective module folder in oracle apps tier.
2- User must have access to system administration responsibility


Configurations :

In order to display the report in your concurrent programs following step must be followed

1- Login into system and select system administrator responsibility

2- Define Executable : Navigate to  Concurrent >Program > Executable  , following screen will be appears :-

• Enter Name of Executable :  any meaningful name  (i.e  GL_TRANSACTION_CUST)
• Short Name : Short name  (i.e  GL_TRANSACTION_CUST)
• Application: Choose Module  ( This will be module in which report exists)
• Description : Any description that will help to recognize it later
• Execution Method : Choose  Oracle Reports from List
• Execution File Name : this will be actual name of RDF report and press save button

3-  Define Concurrent Program :Navigate to  Concurrent >Program >Define  , following screen will be appears :

• Program : Enter Name of report  that will appear in Concurrent Program list
• Short Name : Short Name of Program

Application : Module where this will appear

• Executable : Select executable name that you have created in above step
• Output : Output type of report like PDF,txt , html etc
• Now Click on Parameters to enter parameters for report, Following screen will be appeared :-

• Enter Parameters Name appear in Report
• In Token Field write down actual parameter name that is parameter name in report ( this will match with RDF report parameter Name

4- Add it to Request Group : Navigate to Security>responsibility >Request

• Select Request Group in which you want to add report
• Select Type as Program and Select name of program created in step 3

5- Now you can view you custom built report in respective module concurrent program manager list