XML Publisher Report in Oracle Apps

Oracle Application report can be developed and registered with combination of Report builder and RTF Layout.

Below is the process of generating XML file using Report builder and Layout will be designed using RTF. 

Complete Step by step process of developing and registering Report in Oracle applications using XML publisher as below

1. Develop RDF Report
2. Generate XML File
3. Create RTF Template
4. Create Value Sets
5. Create Executable
6. Create Concurrent Program
7. Create Data Definition
8. Create Template Definition
9. Add Concurrent Program in Request Group
10. Transfer RDF Report to Server
11. Run the Report

Open the report builder

Select the Report menu option

Select using wizard

Select the Create Paper Layout Only option

Select Tabular option

Select SQL Query option

Copy query from SQL Developer/TOAD

Paste the query in editor

System gives following message for creation of parameters

After creation, parameters look like this

Click on next button on the wizard that was in progress

Select No Template option

Generate XML File

Once report is completed and saved, select the following option to generate the XML File

Following file will be generated

Create RTF Template

Create the RTF Template file using the XML File generated above

Create Value Sets

Create value set for Employees. It should select only active employees of Vision University

Create Value Set for responsibility. All responsibilities should be visible in this value set

Create Executable

Create executable as shown below

Create Concurrent Program

Create concurrent program as shown below

Create Employee Parameter

Create Responsibility Parameter

Create Data Definition

For data definition, you need XML Publisher Administrator responsibility.

Create data definition template

Create Template Definition

Create template definition

upload the RTF file created in steps above

Add Concurrent Program in Request Group

From sysadmin responsibility, identify the Request group as shown below

Search for HRMS Manager, Vision University responsibility, Copy the Request Group Name.

Open the screen from the navigation shown below

Search the Request group ‘ US SHRMS Reports & Processes’ and Add the newly created concurrent program as shown below

Transfer RDF Report to Server

After report is ready, we need to transfer the report to Server. RDF Report are placed in reports folder in Respective TOP. For transfer of RDF file from development machine to server, any file transfer software can be used. In my case, i have used WINSCP to connect with server and transfer file to server

Run the Report

At this point when all objects have been created and migrated to server. Now it’s time to run the report and see the output.
As a business user, login with LCARSON user, This is HRMS Manager for Vision University.

By default, LCARSON has following responsibilities assigned to his user. Select the HRMS Manager, Vision University responsibility

Click on Enter and Maintain function. It will open the java applet and oracle form will be loaded in the browser. From the Menu Option, select the View -> Requests

Option will appear asking to select the single request or request set. Select the option to submit Single Request Submission. Following screen will appear, now write the name of concurrent program created in steps above and as shown in screenshot below

System will ask the parameters. Select any responsibility, For example i have selected HRMS Manager responsibility and click OK

Click Submit Button

Click No

Keep clicking on Refresh data button unless the status of program becomes Normal. Click on View Output button

Following Output is displayed. It will show all people which have the responsibility of HRMS Manager, Vision responsibility.

Under Progress………………