SQL script to Cancel Pending Request from a particular user in Oracle Apps

SQL script to Cancel Pending Request from a particular user in Oracle Apps

Script:

UPDATE fnd_concurrent_requests

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

WHERE request_id in (select cwr.request_id FROM apps.fnd_concurrent_worker_requests cwr, apps.fnd_concurrent_queues_tl cq, apps.fnd_user fu

WHERE (cwr.phase_code = 'P')   AND cwr.hold_flag != 'Y'   

--AND cwr.requested_start_date <= SYSDATE

AND cwr.concurrent_queue_id = cq.concurrent_queue_id   AND cwr.queue_application_id = cq.application_id  and cq.LANGUAGE='US'

AND cwr.requested_by = fu.user_id and fu.user_name='&username'

and cwr.user_concurrent_program_name='&user_concurrent_program_name')

If you like please follow and comment