How to create xml report in oracle apps r12

How to create xml report in oracle apps r12

Hi Friends , We are going to discuss about the xml reports in oracle apps r12. We will share the detail steps to create the xml report in oracle apps r12. XML report is the new reporting tool available in oracle apps r12 to develop the custom reports. In XML report , report layout designing is very easy as compared to the traditional oracle rdf paper based layout report. There are lots of limitations in the paper layout report as compared to xml reports. XML reports layout designing is very easy and advanced which helps to design the complex business data extraction and statutory reports. In Oracle apps , xml reports are divided into two parts. First part is the report code to extract the data from oracle apps data base and second part involves the designing. There are two methods to write the code to extract the data. We can use old report builder tool and the Data definition  option in the xml publisher itself in the oracle apps r12. Here below , we will share the detail steps for how to create xml report in oracle apps r12.

2 Types of XML reports in Oracle apps r12

1. XML Publisher report in oracle apps with Data Definition Data Templates.

2. XML Publisher report in oracle apps with RDF.

Step by Step to create the xml report in oracle apps r12.

Step 1:- First step is to design the develop the report code. In this Part , we do write the sql query as per our data extraction requirement in the report.

Step 2:- Go to Report Builder(Reports 10 G) tool as below. Click on '+' icon as below to create report to create the new rdf report using xml publisher.

How to create xml report in oracle apps r12

Step 3:- We need to select the option 'Build a new report manually'.

How to create xml report in oracle apps r12

Step 4:- Now we are on report dashboard. We need to click on the 'sql' icon as highlighted below.

How to create xml report in oracle apps r12

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

How to create xml report in oracle apps r12

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

How to create xml report in oracle apps r12

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

How to create xml report in oracle apps r12

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

How to create xml report in oracle apps r12

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

How to create xml report in oracle apps r12

Step 10:- 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.

How to create xml report in oracle apps r12

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

How to create xml report in oracle apps r12

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

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

How to create xml report in oracle apps r12

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

How to create xml report in oracle apps r12

Step 12:- Here below , xml got generated.

How to create xml report in oracle apps r12

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

How to create xml report in oracle apps r12

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

How to create xml report in oracle apps r12

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

Click on Insert ==> All Fields

How to create xml report in oracle apps r12

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

How to create xml report in oracle apps r12

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

How to create xml report in oracle apps r12

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

Now our RTF report layout has been designed.

How to create xml report in oracle apps r12

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

How to create xml report in oracle apps r12

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

How to create xml report in oracle apps r12

Step 21:- 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.

How to create xml report in oracle apps r12

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

How to create xml report in oracle apps r12

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

How to create xml report in oracle apps r12

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

Home ==> Data Definitions

How to create xml report in oracle apps r12

Step 25:-  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.

How to create xml report in oracle apps r12

Step 26:- 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.

How to create xml report in oracle apps r12

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


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

How to create xml report in oracle apps r12

How to create xml report in oracle apps r12