xml reports in oracle apps with rdf

xml reports in oracle apps with rdf

Hi Friends , We are going to discuss about the xml reports in oracle apps with rdf. We will show the details steps to create the xml reports in oracle with rdf. In Oracle apps , We have the report builder tool which helps to create the reports. In Report Builder , We develop the report code and this code save as rdf. After rdf design , we design the report layout/template. In XML reports we do design the report layout or design the oracle reports. In RDF , we can design two types of report. First is the paper layout in which we design the report layout itself in the rdf. Second , is the XML reports in which we design the reports layout in xml publisher , these are called xml reports. In XML report , we design the reports layout using MS Word and then later we do save as rtf. Here below is the details steps to create xml reports in oracle apps with rdf.

2 Types of XML reports in Oracle apps

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

2. XML Publisher report in oracle apps with RDF.

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

Step by Step to create the xml reports 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 10 G) tool as below. Click on '+' icon as below to create report to create the new rdf report using xml publisher.

xml reports in oracle apps with rdf

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

xml reports in oracle apps with rdf

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

xml reports in oracle apps with rdf

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

xml reports in oracle apps with rdf

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

xml reports in oracle apps with rdf

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

xml reports in oracle apps with rdf

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

xml reports in oracle apps with rdf

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

xml reports in oracle apps with rdf

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 reports in oracle apps with rdf

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

xml reports in oracle apps with rdf

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

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

xml reports in oracle apps with rdf

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

xml reports in oracle apps with rdf

Step 12:- Here below , xml got generated.

xml reports in oracle apps with rdf

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

xml reports in oracle apps with rdf

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

xml reports in oracle apps with rdf

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

Click on Insert ==> All Fields

xml reports in oracle apps with rdf

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

xml reports in oracle apps with rdf

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

xml reports in oracle apps with rdf

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 reports in oracle apps with rdf

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 reports in oracle apps with rdf

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 reports in oracle apps with rdf

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 reports in oracle apps with rdf

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

xml reports in oracle apps with rdf

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

xml reports in oracle apps with rdf

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

Home ==> Data Definitions

xml reports in oracle apps with rdf

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 reports in oracle apps with rdf

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 reports in oracle apps with rdf