Friday, July 8, 2011

How to stop concurrent requests

How to stop concurrent requests
How to Terminate running Concurrent Requests->

Set Terminating or Running to Completed/Terminated
UPDATE fnd_concurrent_requests
SET phase_code = 'C', status_code = 'X'
WHERE status_code ='T'
OR phase_code = 'R'

commit

How to set pending jobs on Hold->

Place Pending/(Normal/Standby) to On Hold
UPDATE fnd_concurrent_requests
SET hold_flag = 'Y'
WHERE phase_code = 'P'
AND status_code in ('Q','I')

commit

The above two queries are generally used if you don't want to run the requests which are copied from source system to target system during cloning. The above can be executed before making the CM up.

No comments:

Post a Comment