Kill concurrent request through database

Find the concurrent request:

SELECT ses.sid,
ses.serial#
FROM v$session ses,
v$process pro
WHERE ses.paddr = pro.addr
AND pro.spid IN (SELECT oracle_process_id
FROM fnd_concurrent_requests
WHERE request_id =<request_id>); 

Kill the database session

SQL> ALTER SYSTEM KILL SESSION ' <sid>, <serial>' IMMEDIATE;

Terminate the request

update fnd_concurrent_requests set status_code='X', phase_code='C' where request_id=<request_id>;
commit;

Change the status to Completed

update fnd_concurrent_requests set status_code='E', phase_code='C' where request_id=<request_id>;
commit;

Status Codes
E -  Error
X -  Terminate
G -  Warning


cancel all scheduled concurrent programs

sqlplus apps/apps
UPDATE fnd_concurrent_requests
SET phase_code = 'C', status_code = 'X'
WHERE status_code IN ('Q','I')
AND requested_start_date > SYSDATE
AND hold_flag = 'N';
COMMIT;

Cancel all running concurrent programs.

sqlplus apps/apps
UPDATE fnd_concurrent_requests
SET phase_code = 'C', status_code = 'X'
WHERE status_code IN ('R','I');
commit;

To Cancel Specific request:

sqlplus apps/apps
update fnd_concurrent_requests
set status_code='D', phase_code='C'
where request_id=<request id>;
commit;