Making the custom reports Oracle
Applications compliant
Before moving the reports to application do the following to make sure that the report is Oracle Applications compliant. 1. Remove the '_all' tables from the FROM clause. For instance instead of using PA_PROJECTS_ALL table use PA_PROJECTS (view). 2. Add a User Parameter P_CONC_REQUEST_ID. The datatype of this parameter is Number , Size is 15, initial value is 0 3. In the BEFORE REPORT Trigger add this piece of code to set the environment variables. SRW.USER_EXIT('FND SRWINIT'); 4. In the AFTER REPORT trigger add this piece of code to reset the environment variables. SRW.USER_EXIT('FND SRWEXIT');
Have a Oracle Question
Oracle Books
Oracle Application
Oracle Home
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
|