FND DEBUG LOG is a standard feature provided by Oracle to point out the root casue of error in Standard oracle code. It allows the debug messages to be stored in a centralized table called FND_LOG_MESSAGES. It is a centralized table as for all king of technology whether it be report,forms,pl/sql or java concurrent program the debug message gets stored in FND_LOG_MESSAGES.
In order to get the log messages from Oracle applications we can do the following
Navigate
System Administrator-->Profile-->System
Now in the Find System Profile Values page
Select User and provide value as SYSADMIN
Again in the profile
provide value as FND%DEBUG%
Click on find
In the System profile values page put in the values as shown in the diagram below
Save the changes
Now navigate to the following page
System Administrator-->Oracle Application Manager-->Logs
Now select the start and end date, you can also select for other combination of data and search for the errors.
You can also search out for the logs directly in the backend table
select * from fnd_log_messages
For a concurrent program you can use the concurrent program request id to for REQUEST_ID parameter in the table and search for exact details on the error.
No comments:
Post a Comment