Steps to Develop Report in Oracle Apps

By | September 20, 2016

Table of Contents

Develop RDF Report
Generate XML File
Create RTF Template
Create Value Sets
Create Executable
Create Concurrent Program
Create Data Definition
Create Template Definition
Add Concurrent Program in Request Group
Transfer RDF Report to Server
Run the Report

Develop RDF 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 TOAD or from text file that i have provided

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
Back to top

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
Back to top

Create RTF Template


Create the RTF Template file using the XML File generated above

Oracle HRMS Overview ab 15
Back to top

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
Back to top

Create Executable

Create executable as shown below

Oracle HRMS Overview ab 20

Oracle HRMS Overview ab 21
Back to top

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
Back to top

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
Back to top

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
Back to top

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
Back to top

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

Back to top

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

If you have liked the contents in this post and you think it can be helpful to others, please share

Related Posts

WISTU – Oracle Workflow Builder
Free Online Test
Solved Issued of Empty Email Notification
Steps for creating custom form in Oracle Apps
How to create backend logging mechanism
Useful Apps SQL Queries Pool
Top 10 Apps Technical Interview Questions