Home / APPS DBA / How to clean FND_NODES table in Oracle Applications

How to clean FND_NODES table in Oracle Applications

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;

SQL>COMMIT;

SQL>EXIT;

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.

 

........Subsribe OracleSolutions.pk........
OracleSolutions.pk is exclusively meant to guide the newbies to Learn and Share.

About oracle.solutions

Check Also

ORA-04063: package body “APPS.AP_ACCTG_DATA_FIX_PKG” has errors

ERROR ORA-04063: package body “APPS.AP_ACCTG_DATA_FIX_PKG” has errors ORA-06508: PL/SQL: could not find program unit being …

Leave a Reply