I have a requirement to bounce Receiving Transaction Manager everyday. So, I was trying to automate this activity. I found below way to bounce it from backend using a script. I had put all the below statements in a script and scheduled in cron.
Find out the short name of the concurrent manager to be bounced, in my case it is Receiving Transaction Manager
SQL> select CONCURRENT_QUEUE_NAME from apps.fnd_concurrent_queues_tl where USER_CONCURRENT_QUEUE_NAME='Receiving Transaction Manager'; CONCURRENT_QUEUE_NAME --------------------- RCVOLTM
Check the status of the concurrent manager before bouncing it.
SQL>select control_code,running_processes,MAX_PROCESSES from fnd_concurrent_queues where concurrent_queue_name='RCVOLTM';
Deactivating the concurrent manager:When you deactivate a manager all requests (concurrent programs) currently running are allowed to complete before the manager(s) shut down.
SQL>update fnd_concurrent_queues set control_code='D' where concurrent_queue_name='RCVOLTM';
Set max and target processes to 0
SQL>update fnd_concurrent_queues set running_processes=0,MAX_PROCESSES=0 where concurrent_queue_name='RCVOLTM'; commit;
see the status of the Manager
SQL>select control_code,running_processes,MAX_PROCESSES from fnd_concurrent_queues where concurrent_queue_name='RCVOLTM';
Activating the concurrent manager:
SQL>update fnd_concurrent_queues set control_code='R' where concurrent_queue_name='RCVOLTM'; commit;
See the status of the Manager
SQL>select control_code,running_processes,MAX_PROCESSES from fnd_concurrent_queues where concurrent_queue_name='RCVOLTM';
Click here for status code meaning
No comments:
Post a Comment