In Oracle E-Business Suite (EBS) Release 12, the FND_NODES table is a part of the Oracle Applications Technology Stack schema (APPS schema) and is used to store information about nodes in a multi-node EBS environment. A multi-node environment consists of multiple application servers that share the load of processing concurrent requests, managing forms sessions, and handling other application-related tasks.


FND_NODES table is present in the APPS schema.

In a muti-tier environment if we want to check the Application services which are running on different node then we can check from fnd_nodes table.

select NODE_NAME,SUPPORT_CP,SUPPORT_FORMS,SUPPORT_WEB,SUPPORT_ADMIN from FND_NODES;

NODE_NAME       SUPPORT_CP           SUPPORT_FORMS        SUPPORT_WEB          SUPPORT_ADMIN
---------------              -------------------                  --------------------                  --------------------                   --------------------
DEV01                          N                                  N                                    N                                         N
DEV02                          Y                                  Y                                     Y                                         Y


SUPPORT_CP: Concurrent Server
SUPPORT_FORMS: Form Server
SUPPORT_WEB: Apache Server
SUPPORT_ADMIN : Admin Server

Cleaning Of FND_NODES table

In the FND_NODES table at certain times we can find there useless entry present which may be the result of the cloning from production which may be the entry other than our present host. So we to need to clean up the FND_NODES table.

Steps:

1.Stop the application services.
2.Run EXEC FND_CONC_CLONE.SETUP_CLEAN; and issue commit after successful completion.
3.Now there must not be any entry present in FND_NODES table.
    select * from fnd_nodes;
    no row selected
4. Run autoconfig on DB_node.
    cd $ORACLE_HOME/appsutil/scripts
    adautocfg.sh
    It will prompts for the apps password.
5.Run autoconfig on Apps_node.
   cd $INST_TOP/admin/scripts
   adautocfg.sh
   It will prompts for the apps password.

This will populate the FND_NODES tables with the correct entry for the application and database node. 

  • The information in FND_NODES is crucial for the Concurrent Processing functionality in EBS, as it helps in load balancing and efficient processing of concurrent requests.
  • Changes to the FND_NODES table should be done cautiously.
  • The status of nodes can be managed through the EBS administrative interfaces, and manual updates to the database should be performed only when necessary and with proper authorization.
  • Always take necessary precautions and backups before making changes to any Oracle EBS tables