How to Kill Long Running Concurrent Job in R12

Step 1) Find SID and Serial Number for Concurrent Job

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
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 = 2063673
AND a.phase_code = 'R';

Step 2) Kill the long running session

1
2
--ALTER SYSTEM KILL SESSION 'SID, serial#' IMMEDIATE;
ALTER SYSTEM KILL SESSION '523, 4965' IMMEDIATE;

Step 3) Update fnd_concurrent_requests table to mark the request in error and completed

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
update fnd_concurrent_requests
   set status_code='X', phase_code='C'
   where request_id=2063673;
   
   
commit;   

update fnd_concurrent_requests
   set status_code='E', phase_code='C'
   where request_id=2063673;

commit;

 

If this does not solve your problem then try restarting Standard Concurrent Manager and Output Post Processor Concurrent Manager.

Thanks Yogesh

One thought on “How to Kill Long Running Concurrent Job in R12

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s