Oracle Reports (RDF) Concurrent Program in Oracle Apps

Oracle Reports is the one of execution method available in Oracle Apps while defining concurrent program executable. Oracle Reports is enterprise reporting tool. It enables businesses to give immediate access to information to all levels within and outside of the organization in an unrivaled scalable and secure environment.

In this article, I will cover how to define concurrent program based on Oracle Reports (RDF) executable.

Read:- How to define Concurrent Program in Oracle Apps

Note: This method is obsolete to define concurrent program on Reports. Oracle recommends to use XML publisher instead as Oracle Reports released with Oracle Fusion Middleware’s 12.2.1.3.0 will be its terminal release.

Pre-requisite

Working knowledge of Oracle Apps and Oracle Reports Builder Tool

Software/Hardware environment

  • Oracle apps 11i or R12
  • Putty
  • Winscp
  • Oracle Report Builder 10G or 11G

Step 1 – Create a sample/demo report (RDF)

To demonstrate working, let’s create a sample report on DBA_OBJECTES table to display 20 rows in a tabular format. You can use any table or data source to create a report. This report has an owner as an input parameter. Depending on Owner name respective object data should get displayed.

Start Oracle Reports Builder and using wizard-driven approach simply create a tabular report. Below is the tree layout of the report.

Oracle Report Layout

The paper layout of the report.

oracle report paper layout

Report Parameters

We are going to have only one parameter for demo purpose. p_conc_request_id is the important and mandatory parameter you need to create. It holds request id returned by the concurrent manager. If you miss this parameter, your program will end in error.

  • P_CONC_REQUEST_ID – This user parameter is mandatory when you run it in Oracle Apps environment. Concurrent Manager returns request_id in this parameter.
  • P_OWNER – Placeholder for custom OWNER Parameter.

Report Triggers:

Add below code the respective triggers mention.

Before Report 

function BeforeReport return boolean is
begin
SRW.USER_EXIT('FND SRWINIT');
return (TRUE);
end;

 

After Report

function AfterReport return boolean is
begin
SRW.USER_EXIT('FND SRWEXIT');
return (TRUE);
end;

SRW.USER_EXIT(‘FND SRWINIT’) – This user exit sets up information for use by profile options and other AOL features. Always use it in before report trigger.

SRW.USER_EXIT(‘FND SRWEXIT’) – This user exit frees all the memory allocation done by other AOL exits. Always use it in after report trigger.

Step 2 – Copy/FTP the report file to Unix Server

Copy this RDF file to the UNIX server. If there is a multi-node environment, make sure to copy in each node. RDF is a binary file, so transfer it using Binary FTP mode. Either use WINSCP of FILEZILLA. Both are free to use software.

Step 3 – Define executable

Navigate to Application Developer -> Concurrent -> Executable. Define executable as shown below.

concurrent program executable on rdf file

Step 4 – Define Concurrent Program

Navigate to Application Developer -> Concurrent -> Program. Define concurrent program as shown below.

concurrent program definition

Define concurrent program parameter as shown below. The Token label show at the end of the image should match to the name of your parameter in rdf file.

concurrent program parameter

Step 5 – Register concurrent program

Next register program in valid responsibility. Navigate to System Administrator -> Security -> Responsibility – > Request. Add this program to request group

Step 6 – Submit concurrent program

Navigate to the responsibility where you registered the concurrent program. Submit it and check the output. Below is sample output shown. Oracle Report supports PDF, Text, XML output.

Reference

Related Post