Cancelling Concurrent Request From Backend

Concurrent Request Phase Codes:

SQL> SELECT LOOKUP_CODE, MEANING

  FROM FND_LOOKUP_VALUES

 WHERE LOOKUP_TYPE = 'CP_PHASE_CODE' AND LANGUAGE = 'US'

       AND ENABLED_FLAG = 'Y';

Concurrent Request Status Codes:-

SQL> SELECT LOOKUP_CODE, MEANING

  FROM FND_LOOKUP_VALUES

 WHERE LOOKUP_TYPE = 'CP_STATUS_CODE' AND LANGUAGE = 'US'

       AND ENABLED_FLAG = 'Y';

Note:

Check the concurrent request Status and Phase codes before proceeding further.

To Cancel Specific request:

SQL> update fnd_concurrent_requests

set status_code='D', phase_code='C'

where request_id=:request_id;

SQL> commit;

Life cycle of a concurrent request:

A concurrent request proceeds through three, possibly four, life cycle stages or phases:

Within each phase, a request's condition or status may change. The following table shows a listing of each phase and the various states that a concurrent request can go through.

Use below query to cancel all scheduled concurrent programs:

SQL> 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';

SQL> COMMIT;

To cancel all running concurrent programs:

SQL> UPDATE fnd_concurrent_requests

SET phase_code = 'C', status_code = 'X'

WHERE status_code IN ('R','I');

SQL> Commit;