Concurrent Manager shows its Status as "Target node/queue unavailable" after Cloning Oracle EBS R12

Environment
-----------------
Oracle E-Business Suite 12.1 to upwards.

Problem 
-----------
FastFormula Transaction Manager,
Transportation Manager,
Inventory Manager,
Standard Manager status is (Target node/queue unavailable)

Solution
-----------

1. Down the Application Tier
2. Login DB as Apps user and execute the followings,

Old_Node   : Old Server Host Name (Source Node)
New_Node : New Server Host Name (Destination Node)


SQL> select node_name,target_node,control_code from fnd_concurrent_queues;
SQL> update apps.fnd_concurrent_queues set node_name = 'New_Node' where node_name='Old_Node';
SQL> select NODE_NAME,NODE_MODE,STATUS from fnd_nodes;
SQL> select control_code,target_node,node_name,CONCURRENT_QUEUE_NAME from fnd_concurrent_queues;
SQL> UPDATE fnd_concurrent_queues set control_code = null;
SQL> select TARGET_NODE,NODE_NAME from fnd_concurrent_queues where node_name='Old_Node';
SQL> select TARGET_NODE,NODE_NAME from fnd_concurrent_queues where TARGET_NODE='Old_Node';
SQL> update fnd_concurrent_queues set NODE_NAME='New_Node' where NODE_NAME='Old_Node';
SQL> update fnd_concurrent_queues set TARGET_NODE='New_Node' where TARGET_NODE='Old_Node';
SQL> UPDATE fnd_concurrent_queues set target_node = 'New_Node';
SQL> UPDATE fnd_concurrent_queues set node_name = 'New_Node';
SQL> Commit;

3. Bounce the Database Tier.
4. Run Autoconfig on DB and APPS Tier
5. Start APPS Tier.

 That's all

Thanks,
Kaziul Islam Bulbul.
Dhaka, Bangladesh