Using FND Log

Set the following Profile Options at the User Level:

FND: Debug Log Enabled -> Yes
FND: Debug Log Level -> Statement
FND: Debug Log Module -> %

1) Run the following sql query:

Select max(log_sequence) from fnd_log_messages;

2) Simulate the error process.

3) Provide the log file using the following query:

Select module, message_text from fnd_log_messages
Where log_sequence > 'put max log_sequence from above'
order by log_sequence;