How to enable debug log in Oracle apps EBS

How to enable debug log in Oracle apps EBS
fnd debug log enabled
How to enable debug mode in Oracle Apps R12
How to enable Debug for Concurrent program in Oracle apps
Debug profile option in Oracle apps

Set below profile option values to debug everything :

FND: Debug Log Enabled YES
FND: Debug Log Filename NULL
FND: Debug Log Level STATEMENT
FND: Debug Log Module %

Set below profile option values to debug ONLY Receivables :

FND: Debug Log Enabled YES
FND: Debug Log Filename NULL
FND: Debug Log Level STATEMENT
FND: Debug Log Module ar%

--Run the below query before running test case and note down the sequence number

SELECT MAX(LOG_SEQUENCE) before_seq
FROM FND_LOG_MESSAGES;

--Run your test case

--Run the below query after running test case and note down the sequence number

SELECT MAX(LOG_SEQUENCE) after_seq
FROM FND_LOG_MESSAGES;

-- Retrieve the debug messages for a concurrent REQUEST ID:

SELECT log.module, log.message_text message
FROM fnd_log_messages log,
     fnd_log_transaction_context con
WHERE con.transaction_id = &request_id
AND con.transaction_type = 'REQUEST'
AND con.transaction_context_id = log.transaction_context_id
ORDER BY log.log_sequence; 

-- Otherwise, retrieve debug messages using a log_sequence range:

SELECT module, message_text
FROM fnd_log_messages
WHERE log_sequence between &before_seq and &after_seq
ORDER BY log_sequence;
Related posts: Upload your own post and refer it anywhere anytime:

Leave a Reply

%d bloggers like this: