Registering Reports in Oracle Application


Registering Reports in Oracle Application

 

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 Request Group.

7. Assign the Request Group to the Responsibility.

8. Assign the Responsibility to the User.

 

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.

WHERE Deptno = :$FLEX$.First_Parameter

Advertisements

3 Responses to Registering Reports in Oracle Application

  1. meera says:

    Thank you. Its really useful !

  2. James Rami says:

    its good but much better when you also provide a screenshot with this

  3. Tariq says:

    Thanks it’s really useful.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: