Monday, June 29, 2015

Bounce Concurrent Manager from backend or using SQL

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

NLS boot file not found or invalid opmnctl ping – EBS 12.2 ADCFGCLONE FAIL

Error: adcfgclone.pl failed while performing clone of EBS 12.2 instance. This occurred while ohsT2PApply is in progress. INST_TOP/adm...