Wednesday, May 13, 2020

Target node/queue unavailable in R12

Shutdown application tier;

select control_code from FND_CONCURRENT_QUEUES WHERE concurrent_queue_name='OAMGCS_ARTEMIS';

select target_node from FND_CONCURRENT_QUEUES where concurrent_queue_name='OAMGCS_ARTEMIS';

update FND_CONCURRENT_QUEUES
      set control_code = null
      where concurrent_queue_name ='OAMGCS_ARTEMIS';
     
update FND_CONCURRENT_QUEUES set control_code=null where concurrent_queue_name ='OAMGCS_ARTEMIS';

update FND_CONCURRENT_QUEUES
           set TARGET_NODE='ARTEMIS.ECP.PRIV'
           where CONCURRENT_QUEUE_NAME='OAMGCS_ARTEMIS';

No comments:

Post a Comment