Oracle Reports generates static reports. Parameters can be defined by the developer at the time of development and cannot be added at run time unlike the Discoverer Report. Discoverer generates a much more interactive report. In Discoverer, the end user can define parameters at run time and also add mathematical calculations to the report.
It is easier to develop reports with graphs in Discoverer than in Oracle Reports.
So if the requirement is to provide an interactive report, we would go for Discoverer Report and if the requirement is to provide a static report we would be going for Oracle Report.
The SRW.USER_EXIT(‘FND SRWINIT’) is used in AOL report and is used to setup your user profile. If you are in a muilti_org environment, this ensures that your report display data from the user’s organization and this is set in Before Report Trigger.
You call SRW.USER_EXIT(‘FND SRWEXIT’) in after report trigger to make sure that all the memory allocated for AOL is freed up
Note: You Must define P_CONC_REQUEST_ID Paremeter.
After parameter Trigger: It will fire after the parameter form is displayed.Here we can do validation on parameter values.
Before Report Trigger: It will fire before the report is executed and after the query is parsed and date is fetched.