How to Enable FND debug log messages

What is  FND debug log messages

Sometimes, an Oracle application fails with an unexpected error, or a "silent" error or any other system failure and you need to get more information for Development to help troubleshoot an issue. In most cases you will be requested to provide an FND debug log. This note explains the steps needed to gather debug information from the FND debug tables, which you can then upload to a Service Request for review by Support or Development.

Step 1: Go to System Administrator responsibility

System Administratorà profileà System

Step 2:Select USER level and search profile option  FND: Debug%

Step 3: Enable FND:Debug log and save

Step 4: Note down the following

SELECT MAX(LOG_SEQUENCE) before_seq
FROM FND_LOG_MESSAGES;

SELECT MAX(LOG_SEQUENCE) after_seq
FROM FND_LOG_MESSAGES;

Step 5:  Otherwise, retrieve debug messages using a log_sequence range

SELECT module, message_text
FROM fnd_log_messages
WHERE log_sequence > &max_log_from_step2
ORDER BY log_sequence; 

Step 6:  Don't forget to turn OFF debugging, otherwise all your actions will be logged and this could impact performance of the application.

FND: Debug Log Enabled = NO 

Refer:

How to enable and retrieve FND debug log messages (Doc ID 433199.1)