How to Get the Debug Log information in R12

1. To get the FND debug messages for a request:

1. Enable FND Debug messages:
-> Navigate Responsibility: System Administrator > Profile > System -> Query for:
User: User submitting the Report
Profile: FND:%Debug%

2. Set the following Profile values at the user level:
FND: Debug Log Enabled Yes
FND: Debug Log Filename <empty>
FND: Debug Log Level STATEMENT
FND: Debug Log Module %
At site level set:
FND: Debug Log Mode Asynchronous with Cross-Tier Sequencing

3. Save.

4. Run the request (eg. Depreciation).

5. Disable FND Debug messages by setting Profile value
FND: Debug Log Enabled No.

6. Run SQL command bellow to get debug message:
  SELECT SUBSTR (module, 1, 70),

         MESSAGE_TEXT,

         timestamp,

         log_sequence

    FROM fnd_log_messages msg, fnd_log_transaction_context tcon

   WHERE     msg.TRANSACTION_CONTEXT_ID = tcon.TRANSACTION_CONTEXT_ID

         AND tcon.TRANSACTION_ID = &child_request_ID_with_problem

ORDER BY LOG_SEQUENCE;

To get child_request_ID_with_problem, just check Request Id from application.

7. Export the output formatted in an Excel file and upload it to Oracle Support Team.

2. To get the FND debug messages for online work (eg. Form error):

1. Enable FND Debug messages:
-> Navigate Responsibility: System Administrator > Profile > System -> Query for:
User: User submitting the Report
Profile: FND:%Debug%

2. Set the following Profile values at the user level:
FND: Debug Log Enabled Yes
FND: Debug Log Filename <empty>
FND: Debug Log Level STATEMENT
FND: Debug Log Module %
At site level set:
FND: Debug Log Mode Asynchronous with Cross-Tier Sequencing.

3. Save.

4. Run the following SQL query to get the current log sequence in the FND table, and note the result as before_value:
SELECT MAX (log_sequence)

  FROM fnd_log_messages

WHERE user_id = (SELECT user_id

                    FROM fnd_user

                   WHERE user_name = '&USER');

5. Login with user, and reproduce the issue.
Once this is reproduced, log out, to avoid unnecessary information in logs.

6. Run the following SQL query to get the current log sequence in the FND table, and note the result as after_value:
SELECT MAX (log_sequence)

  FROM fnd_log_messages

WHERE user_id = (SELECT user_id

                    FROM fnd_user

                   WHERE user_name = '&USER');

7. Disable FND Debug messages by setting Profile value
FND: Debug Log Enabled to No.

8. Replace in the following query before_value with before_value result from Step 4 and after_value with after_value result from Step 6:
SELECT log_sequence, module, MESSAGE_TEXT

  FROM fnd_log_messages

WHERE log_sequence > before_value AND log_sequence < after_value;

9. After modifying the above query run it, export the output in an Excel file, and upload it to Oracle Support Team.