How to create a report in Oracle EBS

How to create a report in Oracle EBS

Hi friends, We are going to discuss about how to create a report in Oracle EBS. We will be try to share the details steps to create a report in oracle ebs. In Oracle EBS , We create a report to extract the date in oracle ebs. We do create reports in oracle ebs as per our requirement. Oracle reports helps to save the manual effort for creating report. In Oracle EBS , we do design the custom reports as per our business requirement. In Oracle EBS , We can create two types of reports. In Oracle EBS , We have the tool called Report Builder. Report Builder have different versions 6I or 10G . Using this report builder tool , We do create a report in oracle EBS. Here below , We will discuss more about creating oracle ebs reports.Please below the details steps to create report in oracle ebs.

2 Types of Report in Oracle EBS.

1. Paper Layout Reports 

2.XML Reports.

Paper Layouts Reports :- 

In Paper Layout reports , we do design the report layout in the Report builder itself. In Report builder Paper layout reports, we do write the report code as well the report designing part.

XML reports :- 

In XML report , We do write the report code in the Report builder but do the report designing outside the report builder. In XML reports, we do design the report layout in Microsoft Word/RTF. 

All report layouts designs , we do handle in the XML Publisher for XML reports.

Step by step to Create a report in Oracle EBS

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 a report in Oracle EBS

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

How to create a report in Oracle EBS

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

How to create a report in Oracle EBS

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

How to create a report in Oracle EBS

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

How to create a report in Oracle EBS

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

How to create a report in Oracle EBS

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 a report in Oracle EBS

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

How to create a report in Oracle EBS

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 a report in Oracle EBS

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

How to create a report in Oracle EBS

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

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

How to create a report in Oracle EBS

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

How to create a report in Oracle EBS

Step 12:- Here below , xml got generated.

How to create a report in Oracle EBS

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

How to create a report in Oracle EBS

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

How to create a report in Oracle EBS

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 a report in Oracle EBS

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

How to create a report in Oracle EBS

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

How to create a report in Oracle EBS

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 a report in Oracle EBS

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 a report in Oracle EBS

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 a report in Oracle EBS

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 a report in Oracle EBS

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

How to create a report in Oracle EBS

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

How to create a report in Oracle EBS

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

Home ==> Data Definitions

How to create a report in Oracle EBS

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 a report in Oracle EBS

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 a report in Oracle EBS

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 a report in Oracle EBS

How to create a report in Oracle EBS

How to create a report in Oracle EBS