How to clean FND_NODES table in Oracle Applications

Step 1: Always apply the latest cloning patches to avoid all the bugs and fixes

Step 2: SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;
COMMIT;
EXIT;
It will delete all old data from the table.

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