Wednesday, April 3, 2013

Process to Debug a Concurrent Request

Posted by 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

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer
    LinkedIn profile -
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at | +91 - 9581017828.


© Oracle Apps CRM is powered by Blogger - Template designed by Stramaxon - Best SEO Template