How to terminate concurrent program in backend

 

Check the status and process id for the concurrent request

select oracle_process_id ,decode(status_code,'R','Running','D','Canceled','E','Error','X','Terminated','G','Warning','T','Terminating')"Status_code",phase_code,to_char(actual_start_date,'DD-MON-YYYY=>hh24:mi:ss') "Login Time" from apps.fnd_concurrent_requests where request_id='&Enter_conn_req_id'

 

Collect SID and serial# from process id

select s.sid,s.serial#,module,s.status from v$session s,v$process p where s.paddr=p.addr and p.spid=&oracle_process_id

 

Backup from fnd_consurrent_requests table and run the update command and please make sure database session for the request id is killed

SQL> update apps.fnd_concurrent_requests set status_code='X',Phase_code='C' where request_id=’1234567’; 1 row updated. SQL> commit;

 

Terminating request from user

update apps.fnd_concurrent_requests set phase_code='C' , status_code='X' where request_id in ('select substr(fcrv.request_id,1,10)REQUEST from apps.fnd_conc_req_summary_v fcrv,apps.fnd_concurrent_requests fcr where fcrv.requestor = '<Requester_ID>');

Terminating pending concurrent programs

update apps.fnd_concurrent_requests set status_code='X', phase_code='C' where request_id in ( select distinct request_id from APPS.FND_CONC_REQ_SUMMARY_V where program = '<Program_NAME>' and phase_code = 'P' and status_code = 'Q' );