Oracle apps: Cancel a concurrent request manually database side

First get the sid and serial# from the v$session view:
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 = 983785
AND a.phase_code = 'R';

Issue the kill session:
alter system kill session '1143,7' immediate;

Update the concurrent request status:
UPDATE fnd_concurrent_requests
SET phase_code = 'C', status_code = 'X'
WHERE request_id = '983785';