R12: How to Get the R12 Trace and FND Debug File / FND Log for Payables Processes

R12: How to Get the R12 Trace and FND Debug File / FND Log for Payables Processes [ID 458371.1]
  Modified 11-MAR-2011     Type HOWTO     Status PUBLISHED
Applies to:

Oracle Payables - Version: 12.0.0 to 12.1.2 - Release: 12.0 to 12.1
Information in this document applies to any platform.
Goal


Join our growing Oracle Payables Community and learn from your peers and Oracle on how to address your unique issues in AP.

How can we obtain the R12 Trace or FND Debug Log Filefor a request or online transaction?
Solution

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';
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/Request

5. Once request has completed, disable Trace and FND Debug messages by setting the profiles back to their original values.

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 FND log

To capture FND Debugging for an Online action such as validation or Create Accounting), 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 process (Validation/Accounting) for one transaction (invoice/payment) from the
     respective workbench/screen.

4) Get the log sequence in the FND table after process completes.

select max(log_sequence) from fnd_log_messages ; -- end
5)  Get the FND log data for process

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.



@ R12 TRACE FILE, R12 TRACE FILE, R12 TRACE FILE, R12 TRACE FILE, R12 TRACE FILE
References

NOTE:417238.1 - How to obtain and read a debug logfile for R12 E-Business Tax (EBTAX)

 Related
Products
Oracle E-Business Suite > Financial Management > Procure to Pay > Oracle Payables
Keywords
FND_LOG_TRANSACTION_CONTEXT; FND_LOG_MESSAGES; TRACE; EXCEL; TIMESTAMP; R12

Back to top

 Rate this document