Query to find which Concurrent Manager Ran a Specific Concurrent Request

Query to find which Concurrent Manager Ran a Specific Concurrent Request

1. Get the request_id

2.  Log into SQL*Plus as the APPS user.

3.  Run one of the scripts below:

For Single Request ID

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;

 

For Multiple Request ID

select c.request_id, b.user_concurrent_queue_name, a.logfile_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 in (&request_id1,&request_id2,&request_id3);

If you like please follow and comment