Page 1 of 1

Generating FND Logs?

Posted: Sat May 28, 2016 7:23 am
by admin
a) Enable FND Logging using system administrator responsibility by setting the following profiles at the USER Level.

FND: Debug Log Enabled = Yes
FND: Debug Log Level = Statement
FND: Debug Log Module = %

b) Reproduce the issue.

c) using toad get the results of the script after the request fails in an excel file and review data,

SELECT log_sequence,module,message_text,log_level
FROM fnd_log_messages
WHERE transaction_context_id =
(SELECT transaction_context_id
FROM fnd_log_transaction_context
WHERE transaction_id =:con_request_id)
ORDER by log_sequence;