How to clean FND_NODES table in Oracle Applications
Note: Remember That All the Latest Cloning Patches Should Be Applied to avoid Any Ambiguity.
Step 1: Login to Database with Apps User
$ sqlplus apps/apps
SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;
It will delete all old data from the table.
Step 2: Run AutoConfig on all tiers, first on the DataBase Tier and then on APPS Tier to repopulate the required system tables.