To find the sid and serial# of a Concurrent Request in Oracle Financials R 11i and R12

Objective: Some times we need to kill a hang concurrent request, and to kill it, we need to find the sid and serial# of that concurrent request. Cookbook: Following SQL query can be run with APPS user on APPS Database , it will need to provide the concurrent request id, and then it will give the sid and serial# of that concurrent requests, more information can also be obtained from v$session and v$sqlarea views. Following is the SQL query ---------- SELECT ses.sid, ses.serial# FROM v$session ses, v$process pro WHERE ses.paddr = pro.addr AND pro.spid IN (SELECT oracle_process_id FROM fnd_concurrent_requests WHERE request_id = &request_id); ---------