|
Reports in Oracle EBS can be created in two ways. One is the traditional Oracle Reports, and the other is BI Publisher Reports.
Using the SQL Scripts, and shell scripts are also used to create the output.
Most of the interface and conversion programs create the output from the stored procedures.
Oracle Reports
- To build the Oracle Reports, the Developer Suite is needed. Please install the corresponding version of the Developer Suite for the Oracle EBS.
Oracle Reports can have Program Units, Libraries, and Parameters.
Report Triggers
- Before Parameter trigger used to set the required initial values
- After Parameter trigger used to add dynamic conditions, set the initial variables
- Before Report trigger fires after queries are parsed, but before the report is executed.
This is also used to set the dynamic values, and dynamic conditions before the report generated
- Between Pages used to set the content in the report changes between pages
- After Report trigger fires after the report completed. The examples of usage of this query are to clear the staging tables used in the report,
and clearing the session level values.
The regular triggers used are Before Parameter, Before Report, and the After Report Triggers.
Good example for the triggers is BOM listing. Standard public package is called to generate the staging tables, generate the report, and exit from the report.
Note: Before installing the Developer Suite, make sure that System Properties - Advanced - Virtual Memory is set to
Initial Size(MB)2046, and Maximum Size(MB)4092.
If your computer have 8GB RAM, then you may set Initial Size(MB): 2046, and Maximum Size(MB): 8103. Minimum Initial Size required is 256MB.
|