How to hold concurrent program in oracle apps from backend

How to hold concurrent program in oracle apps from backend

In this post , We will be discuss about how to hold concurrent program in oracle apps from backend. We will share the sample plsql script which can hold all concurrent program running in oracle apps. This script , we can run from backend which helps to put concurrent program in hold status. This script helps , when we need to down the application and don't want to error out the running concurrent programs so we can use this script to hold all the running concurrent program in oracle apps from backend. Here below is the detail about how to hold concurrent program in oracle apps from backend.

How to hold concurrent program in oracle apps from backend

Important Script to hold concurrent program in oracle apps from backend

Here below is the script , which can hold all concurrent program in oracle apps from backend.

update applsys.fnd_concurrent_requests set hold_flag = ‘Y’,
last_update_date = sysdate,
last_updated_by = -1
where phase_code = ‘P’;

Important Script to release concurrent program hold in oracle apps from backend

Here below is the script , which can release all concurrent program hold in oracle apps from backend.

update applsys.fnd_concurrent_requests a set a.hold_flag = ‘N’ , last_update_date = sysdate, last_updated_by = -1 where phase_code = ‘P’and a.hold_flag = ‘Y’and last_updated_by = -1and last_update_date > sysdate-1;

How to hold concurrent program in oracle apps from backend

How to hold concurrent program in oracle apps from backend