Query to find the session details of running concurrent request using request ID

 

Use below query to find the session details of running concurrent request using concurrent request ID.

SELECT a.request_id, d.sid, d.serial# , c.SPID
 FROM apps.fnd_concurrent_requests a,
 apps.fnd_concurrent_processes b,
 gv$process c,
 gv$session d
 WHERE a.controlling_manager = b.concurrent_process_id
 AND c.pid = b.oracle_process_id
 AND b.session_id=d.audsid
 AND a.request_id = &Request_ID
 AND a.phase_code = 'R';

Pass the concurrent request ID when it prompts.

Thanks for going through the post................