Query to Cancel Scheduled Concurrent Program

This Query helps you to cancel scheduled concurrent program/programs from backend

Step 1. Execute Given Query for Specific Request Id or for all requests which are scheduled

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'
AND CONCURRENT_PROGRAM_ID in (select CONCURRENT_PROGRAM_ID from fnd_concurrent_programs where CONCURRENT_PROGRAM_NAME='Your Program Short Name')
and REQUEST_ID =:p_req_id ---- If you want to cancel all scheduled request then comment this line and execute the query

Step 2. Excute Commit to save the changes

COMMIT;