Steps to Clean Nonexistent Nodes or IP Addresses from FND_NODES

After completing the ADCLONE process, or implementing Autoconfig,
the FND system tables have incorrect values

SQL> select node_name, node_mode, support_cp,
support_web, support_admin, support_forms
from FND_NODES;

NODE_NAME N S S S S
------------------ - - - - -
TESTSERVER O N Y N Y
APPSTEST01 O N Y N Y
APPSDEVP01 O N Y N Y
DEVP O Y Y Y Y
AUTHENTICATION O N N N N
GOLD_UAT O
GOLDTS O Y Y Y Y

7 rows selected.


NOTE:

Do not directly Delete from FND_NODES table because the
'support_' columns will be affected and will not
incorporate the correct information througout in OAM


Run The following Script.

SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;
COMMIT;

After Commit check the following Scripts. Now you got output no rows.
Then you run Autuconfig both Tiers

SQL> select node_name, node_mode, support_cp,
support_web, support_admin, support_forms
from FND_NODES;

no rows selected


Run AutoConfig on all tiers, firstly on the DB tier and then the APPS tiers,
to repopulate the required system tables.

SQL> select node_name, node_mode, support_cp,
support_web, support_admin, support_forms
from FND_NODES;


NODE_NAME N S S S S
-------------------- - - - - -
AUTHENTICATION O N N N N
GPLDTS O Y Y Y Y


Note:260887.1