Oracle Application technical consultant - Reports

Report
------

1) What are the different types of triggers and their order of execution?
Before parameter form
After parameter form
Before Report
Between Pages
After report
2) Can you have more than one layout in the report?
Yes using the additional layout option in the layout editor
3) Are you familiar with the user exits that we normally use in reports?
srw.user_exit('FND SRWINIT');
srw.user_exit('FND SRWEXIT');
srw.user_exit('FND FLEXSQL CODE="GL#" OUTPUT=":P_FLEXDATA"
APPL_SHORT_NAME="SQLGL" MODE="SELECT" DISPLAY="ALL"
NUM=":C_CHART_OF_ACCOUNTS_ID"');
srw.user_exit('FND FORMAT_CURRENCY
srw.user_exit('FND FLEXIDVAL
4) What types of queries we can have in reports? SQL Query and
ref cursor query
When should we use the ref cursor query than the normal sql query?
A ref cursor query uses PL/SQL to fetch data.
* More easily administer SQL
* Avoid use of lexical parameters in reports
* Share datasources with other applications, such as Form builder
* Increase control and security
* Encapsulate logic within a subprogram
* Added benefits that go along with storing the program units in the
Oracle database.