FND Debug Logging

1. In the System Profile Options screen, query all FND: Debug Log profile options and set the following at user-level:

FND: Debug Log Enabled = ‘Yes’
FND: Debug Log Level = ‘Statement’
FND: Debug Log Module = ‘%’   (or limit the string to your conc program name, for example)

2. Save these changes and run your process in Oracle Applications.

3. When the process completes, interrogate the log messages table:

SELECT log_sequence
,      module
,      message_text
FROM   fnd_log_messages
WHERE  user_id = 13334
ORDER BY log_sequence ASC

4. In order to write to the log messages table from a PL/SQL program, use:

fnd_log.STRING (fnd_log.level_statement,MODULE NAME,MESSAGE TEXT);

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s