How To Register a Report in Oracle APPS

  How To Register a Report in Oracle  APPS

 

Whenever we create a report in Oracle report builder we need to register it with oracle applications for viewing it's output in real time with real data. Usually we create two types of reports Simple and Parametric report. Following are the steps to register each of these reports in Oracle applications. 

Steps Required for Registering a Simple Report

1. Create a Report using Report Builder.

2. Compile and copy .RDF file in module specific directory.

3. Register the executable with System Administrator Module.

4. Define the Concurrent Program.

5. Assign the executable to Concurrent Program.

6. Assign the Concurrent Program to desired Request Group.

7. Assign the Request Group to the desired Responsibility.

8. Assign the Responsibility to the desired User.

Steps Required Registering Parametric Reports

1. Create a Report using Report Builder with parameters.

2. Compile and copy .RDF file in module specific directory.

3. Register the executable with System Administrator Module.

4. Define the Value set to validate the parameters.

5. Define the Concurrent Program.

6. Assign the executable to Concurrent Program.

7. Define Parameters.

8. Assign Value Set to the Parameters.

9. Assign bind parameter of yours to the TOKEN.

Note: Token is used to map bind parameters with the formal parameters of the Concurrent Program.

10. Assign the Concurrent Program to Request Group.

11. Assign the Request Group to the Responsibility.

12. Assign the Responsibility to the User.

To reference the values of Prior Parameters of a particular program into the values of other parameter is based on the Value Set. The value of the 1st parameter is to be referenced in where clause of the 2nd Parameter.