Status code and Phase code in fnd_concurrent_requests We always keep getting confused about the meanings of status_code and phase_code columns in fnd_concurrent_requests table. Here is the brief descriptions of statuses columns in the table. Table […]
Step 1) Find SID and Serial Number for Concurrent Job 1 2 3 4 5 6 7 8 9 10 11 SELECT a.request_id, d.sid, d.serial# ,d.osuser, d.process , c.SPID ,d.inst_id FROM apps.fnd_concurrent_requests a, apps.fnd_concurrent_processes b, […]
Source: http://shaikoracleappsdba.blogspot.in/2013/09/long-running-concurrent-requests.html 1.How to Determine Which Manager Ran a Specific Concurrent Request? col USER_CONCURRENT_QUEUE_NAME for a100 select b.USER_CONCURRENT_QUEUE_NAME from fnd_concurrent_processes a, fnd_concurrent_queues_vl b, fnd_concurrent_requests c where a.CONCURRENT_QUEUE_ID = b.CONCURRENT_QUEUE_ID and a.CONCURRENT_PROCESS_ID = c.controlling_manager and c.request_id […]
a) 1.Run the script for any concurrent request which is going into pending/running status and upload the output to SR. Note 134033.1 ANALYZEPENDING.sql Script for Analyzing all Pending Requests or Note 134035.1 ANALYZEREQ.SQL – Detailed […]
Enterprise Resource Planning and Integrations BlogSpot 