1. Create a custom application directory structure in $APPL_TOP.
   It is good to have a separate subdirectory for each module. This custom directory structure also needs to be
   added to your APPLSYS.env as well.

2. Make a copy of the report that needs to be changed in the appropriate subdirectory under the directory created
   above.(e.g., $XXXX_TOP)

3. Open the copied file in Report Designer and make the desired changes.

4. Create a custom Application within the Oracle Applications and reference the $XXXX_TOP variable you defined in  step
    2.

5. Now register the report executable, the program, and any parameters in Application Object Library under the  custom
   Application.

6  Add the custom report/program to the appropriate Report Security Group so that is accessible to the appropriate
    Responsibility.

Return to : Oracle Database, SQL, Application, Programming Tips