Terminate runway process of cancel concurrent request

Even after cancel concurrent request, Resource related concurrent request process may not be released such processes are called RUNWAY processes. So we need to manually kill the processes from database.

Concurrent request id:

Find OS Process id:

Select request_id,os_process_id from fnd_concurrent_requests where request_id=’3574145′;
REQUEST_ID   OS_PROCESS_ID
———-               ————
3574145                162

 Check runways:

select s.sid , s.serial# from v$session s , v$process p where s.paddr = p.addr and s.process =’162′;
SID    SERIAL#
—    ——-
46    1742

KILL RUNWAY PROCESS:

ALTER SYSTEM KILL SESSION ‘46,1742’;