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);

---------