Steps to Collect the FND Debug Log Messages

Detailed Steps to Collect the FND Debug Log Messages

1) Enable the FND debug log by the setting the FND debug profile as follows (at the User level is best where possible) -

        FND: Debug Log Enabled : Yes
        FND: Debug Log Filename : leave it as null
        FND: Debug Log Level : Statement
        FND: Debug Log Module : % 

2) Have the user login and move to the screen - just prior to testing a scenario for which you need the Debug Log Messages

3) Truncate the table APPLSYS.FND_LOG_MESSAGES or locate the max sequence for the user_name.
TRUNCATE TABLE applsys.fnd_log_messages; 
  
or
SELECT Max(log_sequence)
FROM   fnd_log_messages fnd,
       fnd_user fu
WHERE  fnd.user_id = fu.user_id
       AND fu.user_name = '&USER_NAME'
ORDER  BY log_sequence DESC;
Take note of the max(log_sequence) before the test case - if the table was not truncated. 

 4) Complete the Test Case

a) Provide the table dump of table APPLSYS.FND_LOG_MESSAGES in Excel sheet format if you Truncated the Table in Step3.

   b) If The Table is not truncated, capture the new max(log_sequence) after Test case


SELECT Max(log_sequence)
FROM   fnd_log_messages fnd,
       fnd_user fu
WHERE  fnd.user_id = fu.user_id
       AND fu.user_name = '&USER_NAME'
ORDER  BY log_sequence DESC;


5) Run the following sql - substituting the two log Sequence - Before the Test Case and after the test case.

SELECT   fnd.*
FROM     fnd_log_messages fnd,
         fnd_user fu
WHERE    fu.user_id = fnd.user_id
AND      fu.user_name = '&USER_NAME'
AND      fnd.log_sequence > &sequence_1
AND      fnd.log_sequence < &sequence_2
ORDER BY fnd.log_sequence ASC;
 
If the table was truncated, it should be fine to just pull all data.

SELECT fnd.*
FROM   fnd_log_messages fnd,
       fnd_user fu
WHERE  fu.user_id = fnd.user_id
       AND fu.user_name = '&USER_NAME'
ORDER  BY fnd.log_sequence ASC;