How to get FND log messages extract for SR

How to get FND log messages extract for SR

  Please proivde FND logs as per below steps for reproducible case

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) Reproduce the issue

4) Get the log sequence in the FND table.
select max(log_sequence) from fnd_log_messages ; — end

5) Get the FND log data.
select * from fnd_log_messages where log_sequence between <start> and <end>;

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. 

  • September 25, 2018 | 18 views
  • Comments