Hold Pending Concurrent Requests and release them

Here is an easy way to put all the Pending Concurrent requests in hold, if we are going through any situation(Mostly any Production Cutover/Go live scenarios).

1. First create a backup table and record all the information of the pending con reqs,

SQL> CREATE TABLE table_name_sample1 AS SELECT * FROM fnd_concurrent_requests WHERE phase_code = ‘P’ AND NVL (hold_flag, ‘N’) <> ‘Y’;

2. Then put the reqs on hold using the following query,

SQL> UPDATE fnd_concurrent_requests SET hold_flag = ‘Y’ WHERE request_id IN ( SELECT request_id FROM table_name_sample1);
SQL> Commit;

3. Then to release the hold use the following query,
SQL> UPDATE fnd_concurrent_requests SET hold_flag = ‘N’ WHERE request_id IN ( SELECT request_id FROM table_name_sample1);
SQL> Commit;