Query To Check List Of Running Requests
SELECT q.concurrent_queue_name
qname,
f.user_name,
a.request_id
“Req Id”,
Decode(a.parent_request_id, –1, NULL,
a.parent_request_id)
“Parent”,
a.concurrent_program_id
“Prg Id”,
a.phase_code,
a.status_code
— ,b.os_process_id “OS”
— ,vs.sid
— ,vs.serial# “Serial#”
— ,vp.spid
,
a.oracle_process_id
“spid”,
( Nvl(a.actual_completion_date, SYSDATE) – a.actual_start_date ) * 1440
“Time”,
c.concurrent_program_name
|| ‘ – ‘
|| c2.user_concurrent_program_name
|| ‘ ‘
|| a.description
“Program”
FROM applsys.fnd_concurrent_requests a,
applsys.fnd_concurrent_processes b,
applsys.fnd_concurrent_queues q,
applsys.fnd_concurrent_programs_tl c2,
applsys.fnd_concurrent_programs c,
applsys.fnd_user f
— ,v$session vs
— ,v$process vp
WHERE a.controlling_manager = b.concurrent_process_id
AND a.concurrent_program_id = c.concurrent_program_id
AND a.program_application_id = c.application_id
AND c2.concurrent_program_id = c.concurrent_program_id
AND c2.application_id = c.application_id
AND a.phase_code IN ( ‘I’, ‘P’, ‘R’, ‘T’ )
AND a.requested_by = f.user_id
AND b.queue_application_id = q.application_id
AND b.concurrent_queue_id = q.concurrent_queue_id
AND c2.LANGUAGE = ‘US’
— and vs.process (+) = b.os_process_id
— and vs.paddr = vp.addr (+)
ORDER BY 9 DESC;