How to Get the R12 Trace/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 EVENTS=''''''10046 TRACE NAME CONTEXT FOREVER,LEVEL 12'''''); end;

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';
Please upload the output formatted in an Excel file.

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 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 = 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.
Online Accounting FND log

To capture FND Debugging for Online Accounting (i.e., accounting for single document), complete the steps below:

1) Set the Profiles
FND: Debug Log Enabled : Yes
FND: Debug Log Level : Statement
FND: Log Module : %

2) Get the current log sequence in the FND table.
select max(log_sequence) from fnd_log_messages ; -- start

3) Run Online Accounting for one transaction/receipt/invoice/payment from the respective product workbench/screen.

4) Get the log sequence in the FND table after online accounting completes.
select max(log_sequence) from fnd_log_messages ; -- end

5) Get the FND log data for Online Acocunting.
select * from fnd_log_messages where log_sequence between and ;

6) Spool this into an xls file.

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