Wednesday, November 14, 2018
determine which concurrent manager ran a specific concurrent request?
Determine which concurrent manager ran a specific concurrent request?
login as apps/****
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 = '&Request_id';
References:
Concurrent Processing – ANALYZEREQ.SQL Detailed Analysis of One Concurrent Request (Release 11 and up) [ID 134035.1]
How to Determine Which Manager Ran a Specific Concurrent Request? [ID 343575.1]
How Do I Find Out Which Concurrent Manager Processed A Concurrent Request/Program [ID 344011.1]
Subscribe to:
Posts (Atom)