How to collect log, SQL Trace, and FRD log for each EBS module

I usually contact the EBS module is mainly the following: PO, INV, OM. Therefore, it is often necessary to collect the relevant log information. If the interface is reported incorrectly, it is easy to see where the code executes the error from the log.

This blog summarizes the methods for collecting several of these logs, along with SQL Trace and FRD log.

1. OM Log

This main record is the log of the OM module. The code file for the OM module starts with OE, and the file contains a log statement: Oe_debug_pub.add (). The content written in this statement will be written to the log.

Set profile

Om:debug level = 5

Om:debug Log Directory =/usr/tmp

The log directory defaults to/dbfiles/applcsf/log, but this directory does not exist and cannot be created ... We had to go to the/usr/tmp directory. In fact, as long as the select value from v$parameter where name = ' Utl_file_dir ' get the directory can be.

Then open the Sales Order form, choose Menu, Tools, Debug

A window will pop up:

You can then find the log in the/usr/tmp directory.

2. INV Log

Set profile

3. RCV log--in patch 9184617:r12. PO. After a, the RCV log is printed in the Inv log. So as long as the R12 set the Inv and RCV profile, you can get RCV log inside the Inv log.

4. SQL Trace

Can be set on the form interface, but this can only be collected to SQL on the form interface, and subsequent calls to the concurrent use of SQL is not collected.

To collect all of the SQL Trace, set the following profile

"Initialization SQL Statement-custom" = "Begin fnd_ctl.fnd_sess_ctl (', ', '", ' true ', ' true ', ' LOG ', ' ALTER SESSION SET Tracefile_identifier= ' | | ' ' | | ' file_name ' | | ' ' | | ' events= ' | | ' ' | | ' 10046 TRACE NAME "CONTEXT FOREVER, Level 12 ' | | '); End; "

The file for SQL trace is in the directory of SELECT value from V$parameter where name = ' User_dump_dest ';

5. FRD Log

FRD log can record the trigger performed on the form interface. The method to collect is to set the profile:

"Icx:forms Launcher" = "Http://hostname.domain:port/forms/frmservlet?record=collect"

above hostname, domain, port to modify according to their own instance. Like mine: Http://bej301441.cn.oracle.com:8001/forms/frmservlet?record=collect

After saving logout login again, a window will pop up prompting FRD log to open.