Oracle Apps Tracing Session and Process

The purpose of this post is to bring together methods to active and retrieve trace when executing forms, reports, executables, and others involved in Oracle Applications v. 11.x. There are several notes on this subject; however they are not quite complete or clear for end users.

SCOPE & APPLICATION:Trace files are often needed for support purpose. Customers don't always know how to active trace and retrieve trace file.  

Sample FNDLOAD Scripts for AOL Objects

1 - Printer Styles

FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt STYLE PRINTER_STYLE_NAME=”printer style name”

Concurrent Program Monitoring Scripts

Most frequently in support projects we need to monitor and track the concurrent programs. Here are some the important queries to track the status of concurrent program. These are also very useful for the oracle apps system administrator

Enable trace file for a concurrent program

Log on to oracle application

      1.    Go to System Administrator -> Concurrent -> Program -> Define.

      2.    Query the concurrent program for which you want to enable the trace.

      3.    Enable the check box “Enable Trace” and save it.

      4.    Now from the appropriate responsibility, run the concurrent program.