ORACLE APPLICATION REPORTS
There are basically 3 types of report generation.
1. Using Report Builder which can publish report as
a. Text
b. PDF
c. HTML
d. XML
2. Using XML Templates
a. PDF
b. XLS
c. RTF
3. Using Oracle Discoverer. (It won’t create any printable output. But it can be viewed. These kind of reports mostly use0d for business analysis)
Report Builder Reports
1. Create the .RDF file
2. Place the .RDF file in the specific application directory
For Order Management
D:\oracle\prodappl\ont\11.5.0\reports\US\OEXVBBKSS.rdf
3. Register Executables in sysadmin
Change the responsibility to SYSTEM ADMINISTRATOR
# CONCURRENT : PROGRAM : EXECUTABLE:
File name should be the name of the file saved in the corresponding directory.
1. Create Concurrent Program
# CONCURRENT: PROGRAM : DEFINE :
1. Register with responsibility specific request group.
# SECURTIY : RESPONSIBILITY : DEFINE:
Query the corresponding responsibility
Order Management Super User, Vision Operations (USA)
Note the Request Group: OM Concurrent Programs
1. Add the report to the corresponding request group
# SECURTIY : RESPONSIBILITY : REQUEST:
Query the corresponding request group
Add a new line
1. Run the report from the corresponding responsibility.