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.
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
Range
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.
No comments:
Post a Comment