Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Integrations

Use the Oracle R12 trace file

To get the R12 trace file and FND debug messages:
  1. Go to
    Responsibility
    ,
    System Administrator
    ,
    Profile
    ,
    System
    , and then
    Query
    .
    1. User - User submitting the report
    2. Profile - Initialization SQL statement - custom
  2. Select the User column, edit the field, and enter.
    1. 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 this SQL command to locate the file:
    1. select value
    2. from v$parameter
    3. where name = 'user_dump_dest';
  5. Upload the output formatted in a Excel spreadsheet.
  6. Next go to
    Responsibility
    ,
    System Administrator
    ,
    Profile
    ,
    System
    , and then
    Query
    .
    1. User - User submitting the report
    2. Profile - FND:%Debug%
  7. Set these profile values at the user level:
    1. FND: Debug Log Enabled - Yes
    2. FND: Debug Log Filename - <empty>
    3. FND: Debug Log Level - STATEMENT
    4. FND: Debug Log Mode - Asynchronous with cross-tier sequencing
    5. FND: Debug Log Module - %
  8. Save
    .
  9. Go to
    Payables Responsibility
    ,
    Other
    ,
    Request
    ,
    Run
    , and select and submit the report.
  10. Disable Trace and FND Debug messages.
  11. Derive debug message using this query:
    1. SELECT substr(module,1,70), MESSAGE_TEXT, timestamp, log_sequence
    2. FROM fnd_log_messages msg, fnd_log_transaction_context tcon
    3. WHERE msg.TRANSACTION_CONTEXT_ID = tcon.TRANSACTION_CONTEXT_ID
    4. AND tcon.TRANSACTION_ID = <your child request ID>
    5. ORDER BY LOG_SEQUENCE
  12. Upload the output formatted in an Excel spreadsheet.
  13. Lastly, disable FND: Debug Log when you're done. If this isn't disabled, you could encounter tablespace issues.
  14. To capture FND debugging for Online Accounting (including accounting for a single document, set the profiles:
    1. FND: Debug Log Enabled - Yes
    2. FND: Debug Log Level - Statement
    3. FND: Debug Log Module - %
  15. Get the current log sequence in the FND table: select max(log_sequence_ from fnd_log_messages ; -- start.
  16. Run Online Accounting for 1 transaction/receipt/invoice/payment from the respective product workbench or screen.
  17. Get the log sequence in the FND table after online accounting completes: select max(log_sequence_ from fnd_log_messages ; -- end.
  18. Get the FND log data for Online Accounting: select * from fnd_log_messages where log_sequence between <start> and <end>;.
  19. Spool this into an Excel spreadsheet.
  20. And lastly, disable FND: Debug Log when you're done so you don't encounter tablespace issues.

This article applies to:

  • Product: ONESOURCE Determination, ONESOURCE Indirect Tax
  • Subject: Integration