Showing posts with label FND_LOG_MESSAGES. Show all posts
Showing posts with label FND_LOG_MESSAGES. Show all posts

Tuesday, 26 May 2015

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

Oracle Fusion SQL Queries to get Sales Person/Sales Representative information for an Order

1) Get sales person details if the Sales Person ID is known SELECT  jrs.SALESREP_NUMBER  ,         jrs.status           ,         jrs.START_...