How to get debug messages from FND_LOG_MESSAGES table

1)Log into system admin responsibility and set the following profile options

FND: Debug Log Enabled - Yes

FND: Debug Log Level - Statement

FND: Debug Log Module - %

[ set at user level ]

2)Run the below select in sqlplus ::

SELECT MAX(log_sequence) FROM fnd_log_messages;

Take the max of log sequence and use it as log_seq1 in step#5

3)Try to reproduce the issue with above user for which FND profile options are set.

4)Run the below select in sqlplus ::

SELECT MAX(log_sequence) FROM fnd_log_messages;

Take the max of log sequence and use it as log_seq2 in step#5

5)Run following select to get the log messages

SELECT LOG_SEQUENCE, MESSAGE_TEXT, USER_ID FROM fnd_log_messages WHERE

log_sequence > log_seq1-1 and log_sequence <>