Steps to register concurrent program in Oracle apps

Steps to register concurrent program in Oracle apps

Hi friends, We are going share the Steps to register concurrent program in Oracle apps. We will provide you the complete steps to register concurrent program in Oracle apps.We can refer this post , to know the complete details about concurrent program in Oracle apps. This post having the complete details about how to create the new report in oracle apps and then we will register that report as an concurrent program in oracle apps. This post having the complete details about the concurrent program in oracle apps. We know that to run any report in oracle apps , we need to register that report as a concurrent program in oracle apps. Please find below the detail steps to register concurrent program in Oracle apps.

Steps to register concurrent program in Oracle apps

Step 1:- 

Steps to register concurrent program in Oracle apps

Step 2:- Now we need to put the sql code or query to extract the data from database.

Steps to register concurrent program in Oracle apps

Step 3:- Once we will click on the sql query , it will ask for connection for database.

Steps to register concurrent program in Oracle apps

Step 4:- As below , Data group has been created as per the sql query.

Steps to register concurrent program in Oracle apps

Step 5:- If we want to create the parameter for report then we need to click on the q_1 as highlighted below.

Steps to register concurrent program in Oracle apps

Step 6:- As below , We have put the the :P_VENDOR_ID parameter in the report query.

Steps to register concurrent program in Oracle apps

Step 7:- If we want to see the parameters , we can see below. If we want to change the parameter data type , then we need to double click on the 'User Parameters' as below.

Steps to register concurrent program in Oracle apps

Step 8:- Now we need to save the report  in report builder as below.

Steps to register concurrent program in Oracle apps

Step 9:- Now we need to generate the xml for this report.

Navigation : File ==> Generate to File ==> xml

Steps to register concurrent program in Oracle apps

Step 10:- Here below , we need to enter the value for the parameter :P Vendor Id.

Steps to register concurrent program in Oracle apps

Step 11:- Here below , xml got generated.

Steps to register concurrent program in Oracle apps

Step 12:- Now we need to design the layout for the report. Go to Add-ins in the Word Doc.

Steps to register concurrent program in Oracle apps

Step 13:-  In Add-ins ==> Go to Load XML Data

Steps to register concurrent program in Oracle apps

Step 14:- Then , If we want to auto generate the layout based on all the report columns.

Click on Insert ==> All Fields

Steps to register concurrent program in Oracle apps

Step 15:-  As below , Report layout has been designed.

Steps to register concurrent program in Oracle apps

Step 16:- Now , we need to see the output of the report. Now , Click on Preview ==> PDF.

Steps to register concurrent program in Oracle apps

Step 17: As below , System will ask to save the layout in the rtf format as below.

Now our RTF report layout has been designed.

Steps to register concurrent program in Oracle apps

Step 18:- Now we need to go to the Oracle Application to register this report as an xml publisher report in oracle apps r12.

Steps to register concurrent program in Oracle apps

Step 19:-
First We need to create the report Executable.
Concurrent ==> Executable.
We need to give the same report name(RDF Name) created in previous steps.

Steps to register concurrent program in Oracle apps

Step 20:- Once Executable has been created. Now we need to create the Concurrent Program.

Navigation :Concurrent ==> Concurrent Program.

Click on the Parameters button to create report parameter.

Steps to register concurrent program in Oracle apps

Step 21:- As below , Copying the Report parameter for Concurrent Program.

Steps to register concurrent program in Oracle apps

Step 22:- As below , P_VENDOR_ID column got created.

Steps to register concurrent program in Oracle apps

Step 23:- Now we need to goto the XML Publisher Administrator responsibility.

Home ==> Data Definitions

Steps to register concurrent program in Oracle apps

Step 24:-  Here below , We need to create the report Data Definition.

Note : We need to use the Short Name of Concurrent Program in Step 21 in Data Definition code field as below.

Steps to register concurrent program in Oracle apps

Step 25:- After Creating the Data Definition , We need to create the report Templates as below.
We need to attach the report Data Definition created in Step 25 in Report Templates.

Steps to register concurrent program in Oracle apps

Step 26:- In Report Templates , We can define the Report Output Type as below.


Step 27:- We need to Attach the report layout RTF template created in Step 18.

Steps to register concurrent program in Oracle apps

Step 28:- Now our concurrent program registration steps have been completed in oracle apps.

Steps to register concurrent program in Oracle apps