How to Kill Long Running Concurrent Job in R12
Step 1) Find SID and Serial Number for Concurrent Job
Step 2) Kill the long running session
Step 3) Update fnd_concurrent_requests table to mark the request in error and completed
STEP1:
SELECT a.request_id, d.sid, d.serial# ,d.osuser,
d.process , c.SPID ,d.inst_id
FROM apps.fnd_concurrent_requests a,
apps.fnd_concurrent_processes b,
gv$process c,
gv$session d
WHERE a.controlling_manager = b.concurrent_process_id
AND c.pid = b.oracle_process_id
AND b.session_id=d.audsid
AND a.request_id = 344625347--------------req id
AND a.phase_code = 'R';
STEP2:
select ORACLE_PROCESS_ID from apps.fnd_concurrent_requests where REQUEST_ID=&REQUEST_ID;
select ORACLE_PROCESS_ID from apps.fnd_concurrent_requests where REQUEST_ID=&REQUEST_ID;
alter system kill session ‘sid,serial#’ immediate:
STEP3:
UPDATE fnd_concurrent_requests
SET phase_code = 'C', status_code = 'D'
WHERE Request_id=&request_id;
If this does not solve your problem then try restarting Standard Concurrent Manager and Output Post Processor Concurrent Manager.