Cancel Concurrent Program From Back-end
1) First check status
select status_code,phase_code
from fnd_concurrent_requests
where request_id=:Concurrent_requesrt_id;
* Note: Update status and phase code to completed and
Phase Status to terminated if the request is running.
UPDATE apps.fnd_concurrent_requests
SET status_code='X',
phase_code='C'
WHERE status_code='Z'
and phase_code='P'
and requested_by=0
and REQUEST_DATE like '01-Jul-2018';
* If the Request not submitted yet make it complete ,
cancelled status.
UPDATE apps.fnd_concurrent_requests
SET status_code='D',
phase_code='C'
WHERE status_code='Z'
and phase_code='P'
and requested_by=0
and REQUEST_DATE like '01-Jul-2018';
Meaning of Status_Code and Phase_Code
STATUS_CODE Column: A Waiting B Resuming C Normal D Cancelled E Error F Scheduled G Warning H On Hold I Normal M No Manager Q Standby R Normal S Suspended T Terminating U Disabled W Paused X Terminated Z Waiting PHASE_CODE Column Meaning C Completed I Inactive P Pending R Running |