Concurrent Managers Status shows ”Target node/queue unavailable”

Issue: Concurrent Managers Status shows  ”Target node/queue unavailable”  in Concurrent–>Manager–>Administer Screen form.

Solution:
Ensure Database is Running and Middle Tier Services are down.

Connect sqlplus as apps user and run the following :
EXEC FND_CONC_CLONE.SETUP_CLEAN;
commit;


Run AutoConfig on all tiers, firstly on the DB tier and then the APPS tiers and webtier to repopulate the required systemtables

Run the CMCLEAN.SQL script from the referenced note below (don’t forget to commit).

Note.134007.1 – ‘CMCLEAN.SQL – Non Destructive Script to Clean Concurrent  Manager Tables‘

Start the middle tier services including your concurrent manager.

Retest the issue.