Before moving the developed oracle report to application, make sure to that the report is Oracle Applications compliant. perform the following steps:
1. Remove the '_all' tables from the FROM clause. For instance instead of using OE_ORDER_HEADERS_ALL table use OE_ORDER_HEADERS (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.
4. In the AFTER REPORT trigger add this piece of code to reset the environment variables.
