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

Last updated on AUGUST 26, 2016

Applies to:

Oracle Sales - Version 11.5.10.0 and later
Oracle Service Contracts - Version 11.5.10 and later
Oracle TeleSales - Version 11.5.10.0 and later
Oracle Marketing - Version 11.5.10.0 and later
Oracle Trade Management - Version 11.5.10 and later
Information in this document applies to any platform.

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.

Please note that FND debug information in itself will not provide a solution to your issue. Instead it is a tool that developers or support can use, to better understand the error you have encountered, and to help provide you with an action plan.

 

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms