Process to Debug a Concurrent Request

Posted by Apurva at 11:22 PM Read our previous post

If the program fails then set the following profiles at User level and rerun the program. Locate the Log and review for errors: 

FND: Debug Log Enabled to 'YES' 
FND: Debug Log Level to 'Statement' 
FND: Debug Log Module to '%'

Run the following query in Toad or SQLPLUS to review the request_id which failed:

SELECT to_char (timestamp,'DD-MON-YY HH24:MI:SS') "TIMESTAMP",  
       module, message_text, log_sequence 
FROM fnd_log_messages  
WHERE trunc(timestamp) = trunc(sysdate)  
AND process_id = (SELECT os_process_id  
                  FROM fnd_concurrent_requests  
                  WHERE request_id = &request_id)  
AND module not like 'fnd%'  
ORDER BY log_sequence;


You may also like to read      Find Profile Option values using SQL queries
                                             Checking the File Versions with SQL Query
                                             Sending Email using PL/SQL Procedure
                                             Find Trace File location using SQL