Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
http://www.free-online-exams.com
Problem: How to generate FND Debug log
Solution:
FND Debug log:
1) Please set following profile options on user level, using responsibility System administrator:
FND: Debug Log Enabled YES
FND: Debug Log Filename NULL
FND: Debug Log Level STATEMENT
FND: Debug Log Module %
2) Note down current max value of log sequence retrieved as follows :
SELECT MAX(LOG_SEQUENCE)
FROM FND_LOG_MESSAGES
3) Run your test case, try to stay on track in reproducing the issue and leave out extraneous steps so that you don't end up with debug messages that are not relevant to your issue.
4) For ease of review spool the output of the following to a .xls spreadsheet :
SELECT module, message_text
FROM fnd_log_messages
WHERE log_sequence > &max_log_from_step2
ORDER BY log_sequence;
Solution:
FND Debug log:
1) Please set following profile options on user level, using responsibility System administrator:
FND: Debug Log Enabled YES
FND: Debug Log Filename NULL
FND: Debug Log Level STATEMENT
FND: Debug Log Module %
2) Note down current max value of log sequence retrieved as follows :
SELECT MAX(LOG_SEQUENCE)
FROM FND_LOG_MESSAGES
3) Run your test case, try to stay on track in reproducing the issue and leave out extraneous steps so that you don't end up with debug messages that are not relevant to your issue.
4) For ease of review spool the output of the following to a .xls spreadsheet :
SELECT module, message_text
FROM fnd_log_messages
WHERE log_sequence > &max_log_from_step2
ORDER BY log_sequence;
No comments:
Post a Comment