How to integrate a report (RDF) with Oracle Apps

Once you have developed the report in Oracle Report builder, you need to integrate it with Oracle Applications, so that users could run it as a concurrent program request.

I am assuming that you have created the report (RDF), so lets start integrating with Oracle.


1) Navigation: System Administrator --> Concurrent --> Program --> Executable

Executable: Name of the executable file name of your choice. It is not referenced anywhere in the system.
Short Name: This name is referenced when we define the report and its parameters. This name is also referenced when we register XML report with Oracle. See below.
Application: Name of the application, preferably you should create a custom schema.
Execution Method: Oracle Reports
Executable File Name: The file name which is placed at server.


2) Navigation: System Administrator --> Concurrent --> Program --> Define

Program: Name of the concurrent program which will be shown to user, when one tries to run it.
Short Name: This name is not used anywhere for reference. so your choice. Usually we give it same as Executable short name.
Application: Name of Application.
Executable-> Name: Short Name of the Report Executable we defined in Step 1.
Output-> Format: XML if you want report in XML Format, else select any of your requirement.
Style: Portrait, Landscape, whichever is best suited to your report dimension.

Preferably we go with default values. If your requirement is different, select your relevant option. Save the form and press Parameters button.

Here is some detail before you define parameters.

Sequence

Choose the sequence numbers that specify the order in which your program receives parameter values from the concurrent manager.

Enabled

Disabled parameters do not display at request submission time and are not passed to your execution file.

Argument Detail

You specify information about your parameter almost exactly as you define a flexfield segment.

Value Set

Enter the name of the value set you want your parameter to use for validation. You can only select from independent, table, and non-validated value sets.

The maximum size of your value set is 240 characters.

Attention:  If you are using a value set of dates, this value set should have a format type of either Standard Date or Standard DateTime if you are using the Multilingual Request feature.

Default Type

If you want to set a default value for this parameter, identify the type of value you need.

• This default value for your parameter automatically appears when you enter your parameter window. 
• You determine whether the default value is a constant or a context-dependent value by choosing the default type.
• Your default value should be a valid value for your value set. Otherwise you see an error message when you enter your parameter window on the Run Request window and your default value does not appear.

Valid values for each default type include: 

Constant:    The default value can be any literal value.

Profile:        

• The default value is the current value in the user profile option defined in the Default Value field. 
• Use the profile option name, not the end-user name. You do not need to include $PROFILE$.

SQL Statement: 

        The default value is determined by the SQL statement you defined in the Default Value field.

Segment:  The default value is the value entered in a prior segment of the same parameter window.

Enable Security

If the value set for this parameter does not allow security rules, then this field is display only. Otherwise you can elect to apply any security rules defined for this value set to affect your parameter list.

Range

Choose either Low or High if you want to validate your parameter value against the value of another parameter in this structure.

Display

Indicate whether to display this parameter in the Parameters window when a user submits a request to run the program from the Submit Requests window.

Display Size

Enter the field length in characters for this parameter.

Description Size

Enter the display length in characters for the parameter value description.

Prompt

A user sees the prompt instead of the parameter name in the Parameters window of the Submit Requests window.

Concatenated Description Size

Enter the display length in characters for the parameter value description. 

The user sees the parameter value in the Parameter Description field of the Submit Requests and View Requests forms. 

The Parameter Description field concatenates all the parameter values for the concurrent program. 

Token

For a parameter in an Oracle Reports program, the keyword or parameter appears here. The value is case insensitive. For other types of programs, you can skip this field. 

At this point, no user will be able to execute this concurrent program request.

So what we need to do so is, to attach this report to a request group, which is specified on the responsibility. Eventually, Users to which responsibility is attached, will be able to run the report.

So navigate to

Navigation: System Administrator --> Security --> Responsibility --> Request

After doing this step, relevant users will be able to run the concurrent program request.

How to integrate XML Report with Oracle