Terminating Report From Backend, We should use data dictionary views v$session and v$process.
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 = ‘RequestID’
SELECT s.sid,
s.serial#,
module,
s.status
FROM v$session s,
v$process p
WHERE s.paddr = p.addr
AND p.spid = ‘Process_ID’
##Please Enter Your Process id
UPDATE fnd_concurrent_requests
SET phase_code = C,
status_code = ‘X’
WHERE request_id = ‘RequestID’;
##Please Enter The Request ID from Request Form
COMMIT;