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

Oracle HRMS Overview ab 1

Select the Report menu option

Oracle HRMS Overview ab 2

Select using wizard

Oracle HRMS Overview ab 3

Select the Create Paper Layout Only option

Oracle HRMS Overview ab 4

Select Tabular option

Oracle HRMS Overview ab 5

Select SQL Query option

Oracle HRMS Overview ab 6

Copy query from SQL Developer/TOAD

Oracle HRMS Overview ab 7

Paste the query in editor

Oracle HRMS Overview ab 8

System gives following message for creation of parameters

Oracle HRMS Overview ab 9

After creation, parameters look like this

Oracle HRMS Overview ab 10

Click on next button on the wizard that was in progress

Oracle HRMS Overview ab 11

Select No Template option

Oracle HRMS Overview ab 12

Generate XML File

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

Oracle HRMS Overview ab 13

Following file will be generated

Oracle HRMS Overview ab 14

Create RTF Template

Create the RTF Template file using the XML File generated above

Oracle HRMS Overview ab 15

Create Value Sets

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

Oracle HRMS Overview ab 16

Oracle HRMS Overview ab 17

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

Oracle HRMS Overview ab 18

Oracle HRMS Overview ab 19

 

Create Executable

Create executable as shown below

Oracle HRMS Overview ab 20

Oracle HRMS Overview ab 21

 

Create Concurrent Program

Create concurrent program as shown below

Oracle HRMS Overview ab 22

Oracle HRMS Overview ab 23

Create Employee Parameter

Oracle HRMS Overview ab 24

Create Responsibility Parameter

Oracle HRMS Overview ab 25

Create Data Definition

For data definition, you need XML Publisher Administrator responsibility.

Oracle HRMS Overview ab 26

Create data definition template

Oracle HRMS Overview ab 27

 

Create Template Definition

Create template definition

Oracle HRMS Overview ab 28

Oracle HRMS Overview ab 29

upload the RTF file created in steps above

Oracle HRMS Overview ab 30

 

Add Concurrent Program in Request Group

From sysadmin responsibility, identify the Request group as shown below

Oracle HRMS Overview ab 31

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

Oracle HRMS Overview ab 32

Open the screen from the navigation shown below

Oracle HRMS Overview ab 33

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

Oracle HRMS Overview ab 34

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

Oracle HRMS Overview ab 35

 

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.

Oracle HRMS Overview ab 36

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

Oracle HRMS Overview ab 37

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

Oracle HRMS Overview ab 38

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

Oracle HRMS Overview ab 39

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

Oracle HRMS Overview ab 40

Click Submit Button

Oracle HRMS Overview ab 41

Click No

Oracle HRMS Overview ab 42

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

Oracle HRMS Overview ab 43

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

Oracle HRMS Overview ab 44

Under Progress………………