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

Last updated on OCTOBER 04, 2024

Applies to:

Goal

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.

Starting in 11.5.10, FND has incorporated a debugging technique to enable debug messages to get stored into the table FND_LOG_MESSAGES. This method was introduced in 11.5.10 and it is available in subsequent releases. This note gives simple steps on how to enable and retrieve the debug messages.

This method will pick up *all* debug messages from a particular log_sequence value. As such, it is particularly useful when you are having trouble retrieving the debug messages associated to a particular concurrent request, or user. However, if there are multiple users with FND debugging enabled running various processes, you could end up picking up debug messages pertaining to their activities.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.