How to enable debug log in Oracle apps EBS

1--Run the below query before running test case and note down the sequence number
2
3SELECT MAX(LOG_SEQUENCE) before_seq
4FROM FND_LOG_MESSAGES;
5
6--Run your test case
7
8--Run the below query after running test case and note down the sequence number
9
10SELECT MAX(LOG_SEQUENCE) after_seq
11FROM FND_LOG_MESSAGES;
12
13-- Retrieve the debug messages for a concurrent REQUEST ID:
14
15SELECT log.module, log.message_text message
16FROM fnd_log_messages log,
17     fnd_log_transaction_context con
18WHERE con.transaction_id = &request_id
19AND con.transaction_type = 'REQUEST'
20AND con.transaction_context_id = log.transaction_context_id
21ORDER BY log.log_sequence; 
22
23-- Otherwise, retrieve debug messages using a log_sequence range:
24
25SELECT module, message_text
26FROM fnd_log_messages
27WHERE log_sequence between &before_seq and &after_seq
28ORDER BY log_sequence;