How to get the SID and OS process for a running CR

- Run the below SQL statement to get the SID and OS procedd ID for a running request.

- The statement will ask for the Request ID

set pages 1000 lin 300
SELECT a.request_id, d.sid, d.serial# ,d.osuser,d.process , c.SPID "OS Process", d.STATUS, d.username
FROM apps.fnd_concurrent_requests a,
apps.fnd_concurrent_processes b,
v$process c,
v$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';

Regards,

Mohamed