Find out completed concurrent request of SID
Script for find out completed concurrent request of particular SID
SELECT ( select USER_CONCURRENT_PROGRAM_NAME from Fnd_Concurrent_Programs_tl where LANGUAGE=’US’ and CONCURRENT_PROGRAM_ID=a.CONCURRENT_PROGRAM_ID)prog_name
,a.phase_code,a.status_code,a.request_id, d.sid, d.serial# ,d.osuser,d.process , c.SPID
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 d.sid= 242
order by a.REQUEST_DATE
DBA 
Trackbacks & Pingbacks