Disabling Concurrent Managers and Check Internal concurrent manager status.
Sometimes we have to disable some Concurrent Managers.
we are create a new single instance CLONE from a E-Business Suite.
We can do it from the forms of the application,
a) How to find if Concurrent managers are enabled:
SELECT CONCURRENT_QUEUE_NAME, enabled_flag, node_name
WHERE CONCURRENT_QUEUE_NAME LIKE ‘%<<Concurrent manager name>>%’ AND enabled_flag = ‘Y’;
b) To disable one Concurrent manager using UPDATE query.
UPDATE applsys.FND_CONCURRENT_QUEUES SET enabled_flag = ‘N’
WHERE CONCURRENT_QUEUE_NAME = ‘<<Concurrent manager name>>’;
2.Internal Concurrent Manager status.
We can find the status of Internal Concurrent Manager status with this script.
If it is down, then we need to take steps to turn it back on.
You must run it as user applsys or sys.
a) Query for check Internal concurrent manager status.
SELECT DECODE(RUNNING_PROCESSES, 1, ‘UP’, ‘DOWN’) STATUS
WHERE CONCURRENT_QUEUE_NAME = ‘FNDICM’;