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.

About Syed Saad

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also

EBS_Latest_Configurations

Apply EBS AD-TXK Release 16 Update

Step By Step Guide to Apply Oracle E-Business Suite R12.2 ADTXK Update 16 Oracle Applications …

Leave a Reply