Put all Concurrent Request on Hold for Server Migration

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Put all Concurrent Request on Hold for Server Migration

Susmit
We are doing a migration of our EBS instance from One Server to another(both database and application) using clone method. We want to keep all our Concurrent Request that's is running, scheduled intact. That means when clone completed in and we open application in New Server it should not have any concurrent request schedule lost.

How can this be achieved? Can the profile Concurrent:Hold be used in this purpose? Do we have to hold the request one by one? Is there any update sql script available that can be used?
Thanks and Regards,
Roy Susmit
Oracle Applications DBA
Reply | Threaded
Open this post in threaded view
|

Re: Put all Concurrent Request on Hold for Server Migration

ErmanArslansOracleBlog
Administrator
There is no API for that..
You may try by updating the fnd_concurrent_request table..
There is a column named hold_flag there..
However, this move will be unsupported and you may use it at your own risk.

you may also take a look at "FND_AMP_PRIVATE.toggle_request_hold"