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.
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 18.104.22.168.0 will be its terminal release.
Working knowledge of Oracle Apps and Oracle Reports Builder Tool
- Oracle apps 11i or R12
- 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.
The paper layout of the report.
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.
Add below code the respective triggers mention.
function BeforeReport return boolean is begin SRW.USER_EXIT('FND SRWINIT'); return (TRUE); end;
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.
Step 4 – Define Concurrent Program
Navigate to Application Developer -> Concurrent -> Program. Define concurrent program as shown below.
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.
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.
- Oracle E-Business Suite Developer’s Guide – Coding Oracle Reports Concurrent Programs
- Symbol Characters (“Greek”) Instead Of Expected Characters Are Displayed in Reports or Reports Parameter Form (Doc ID 300416.1)
- Master Note : Comprehensive REP-3000 Troubleshooting and Overview Guide (Doc ID 200474.1)