Enable FND Debug and get log information from FND_LOG_MESSAGES table:
If the size of FND_LOG_MESSAGES table is too big? then
Considering running the concurrent request: “Purge Debug Log and System Alerts”.
Enable Debug mode:-
1)Log into system admin responsibility and set the following profile options
FND: Debug Log Enabled - Yes
FND: Debug Log Level - Statement (Consider other options from the drop down if needed)
FND: Debug Log Module - %
2)Capture the Max sequence number
SELECT MAX(log_sequence) b4seq# FROM fnd_log_messages;
3)Try to reproduce the issue with above user for which FND profile options are set.
4)Capture the Max sequence number again:
SELECT MAX(log_sequence) afterseq# FROM fnd_log_messages;
5)Run following select to get the log messages
SELECT LOG_SEQUENCE, MESSAGE_TEXT, USER_ID FROM fnd_log_messages WHERE
log_sequence > b4seq# -1 and b4seq#