XML Publisher reports in oracle

XML Publisher reports in oracle

Hi Friends, we are going to discuss about the XML Publisher reports in oracle. XML publisher is the new reporting tool in oracle apps r12. Using XML publisher we can develop the complex reports in oracle. One of the good part of xml publisher report , is the user friendly report layout design. We do design the reports layouts in xml publisher reports in Microsoft word. In MS Word, We do design the complete report layout. It's very easy to design the complex report design in xml reports. If we do compare the xml publisher report with the old paper layout reports in the oracle reports RDF tool , then its too easy to use and understand as compared to old RDF paper layout report. Here below , we will discuss the complete details about XML Publisher reports in oracle.

2 Types of reports in XML Publisher reports in oracle

1. XML Publisher report in oracle apps with RDF.

2. XML Publisher report in oracle apps with Data Template.

Here in this post , We are going to discuss the XML Publisher reports in oracle with rdf.

Step by Step to design the XML Publisher report in oracle apps with rdf

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 10G) tool as below. Click on '+' icon as below to create report.

XML Publisher reports in oracle

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

XML Publisher reports in oracle

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

XML Publisher reports in oracle

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

XML Publisher reports in oracle

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

XML Publisher reports in oracle

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

XML Publisher reports in oracle

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

XML Publisher reports in oracle

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

XML Publisher reports in oracle

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.

XML Publisher reports in oracle

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

XML Publisher reports in oracle

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

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

XML Publisher reports in oracle

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

XML Publisher reports in oracle

Step 12:- Here below , xml got generated.

XML Publisher reports in oracle

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

XML Publisher reports in oracle

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

XML Publisher reports in oracle

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

Click on Insert ==> All Fields

XML Publisher reports in oracle

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

XML Publisher reports in oracle

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

XML Publisher reports in oracle

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.

XML Publisher reports in oracle

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

XML Publisher reports in oracle

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.

XML Publisher reports in oracle

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.

XML Publisher reports in oracle

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

XML Publisher reports in oracle

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

XML Publisher reports in oracle

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

Home ==> Data Definitions

XML Publisher reports in oracle

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.

XML Publisher reports in oracle

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.

XML Publisher reports in oracle

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.

XML Publisher reports in oracle

XML Publisher reports in oracle