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;

Thanks Yogesh

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s