How to capture the back-end FND debugging messages thrown when errors are thrown.
See the action plan below:
(a) Set the following profile options at your user level
FND: Diagnostics: Yes
FND: Debug Log Enabled: Yes
FND: Debug Log Level: Statement
FND: Debug Log Mode: Asynchronous with Cross-Tier Sequencing
FND: Debug Log Module to %
(b) Go to the form or prior step where the issue arises.
At this point, run the following SQL:
select max(log_sequence) from fnd_log_messages;
Note the max(log_sequence) value as &start
(c) Then proceed to replicate the error.
After clicking away the error, re-run the SQL:
select max(log_sequence) from fnd_log_messages;
Note the max(log_sequence) value as &end
(d) Then run
SELECT substr(module,1,70), MESSAGE_TEXT, timestamp, log_sequence
FROM fnd_log_messages msg
WHERE log_sequence between &start and &end
ORDER BY LOG_SEQUENCE
(e) REMOVE PROFILE OPTION VALUES AT YOUR USER LEVEL!!!!
No comments:
Post a Comment