Oracle Applications Concurrent Requests and Concurrent processing.

Posted by Jiltin     Tags: , 16 March, 2009    8,443 views    (2) Comment

The Concurrent Requests window displays a phase and status summary for each concurrent request listed A concurrent request has a life cycle consisting of the following phases: pending, running, completed, and inactive. During each phase, a concurrent request has a specific condition or status. lists each phase/status combination and describes its meaning in relation to a request. If a request is pending, you can determine when it will start by using the Concurrent Managers For the Request Read Full Article (Click here)...

Categories : Oracle AOL, Oracle Applications Tags : ,

Pending normal jobs running (oracle 11i) in oracle applications

Posted by Jiltin     Tags: , , , , 10 November, 2008    1,073 views    (1) Comment

/* Description: This script will all the pending normal jobs running (oracle 11i) in oracle applications Backend query is always faster than front end query Author:      Jay Gopal / Jiltin Input:       none */ Download the Code SELECT fcr.REQUEST_ID, fu.user_name, fcr.PHASE_CODE, fcr.STATUS_CODE, (fcr.ACTUAL_COMPLETION_DATE –   fcr.ACTUAL_START_DATE) * 24 * 60 Read Full Article (Click here)...

Categories : 11i Scripts Tags : , , , ,