R12 – Oracle EBS How to Get the Trace and FND Debug File


To get the R12 Trace:

1. Navigate Responsibility: System Administrator > Profile > System > Query

User: User submitting the Report
Profile: Initialization SQL Statement – Custom

2. Click on User column – Edit Field and enter

begin fnd_ctl.fnd_sess_ctl('','','TRUE','TRUE','LOG','ALTER SESSION SET tracefile_identifier=999999999 EVENTS='||''''||'10046 TRACE NAME CONTEXT FOREVER,LEVEL 12'||''''); end;

Note: For tracefile_identifier you can change from 999999999 to whatever value you want to see in the trace file name to help identify the file created by this trace.

3. Save.

4. Upload the raw and tkprof'd trace file created. Use the following SQL to locate the file:

 

select value
from v$parameter
where name = 'user_dump_dest';

To get the FND debug messages:

1. Navigate Responsibility: System Administrator > Profile > System > Query

User: User submitting the Report
Profile: FND:%Debug%

2. Set the following Profile values at the user level

FND: Debug Log Enabled Yes
FND: Debug Log Filename <empty>
FND: Debug Log Level STATEMENT
FND: Debug Log Mode Asynchronous with Cross-Tier Sequencing
FND: Debug Log Module %

3. Save.

4. Navigate: Payables Responsibility > Other > Request > Run > Select and Submit the Report

5. Disable Trace and FND Debug messages

6.  Derive debug message using the following query


SELECT substr(module,1,70), MESSAGE_TEXT, timestamp, log_sequence
FROM fnd_log_messages msg, fnd_log_transaction_context tcon
WHERE msg.TRANSACTION_CONTEXT_ID = tcon.TRANSACTION_CONTEXT_ID
AND tcon.TRANSACTION_ID = <your child request ID>
ORDER BY LOG_SEQUENCE

7. Please upload the output formatted in an Excel file.

8.  Lastly, remember to disable FND: Debug Log after you are done; otherwise, you could encounter  tablespace issues.

 

Advertisements

Want to give some comment to author ( Shivmohan Purohit )

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s