Search Results fnd_conc_prog_onsite_info




Overview
Explore in AI Chat

Overview

The FND_CONC_PROG_ONSITE_INFO table is a core technical repository within the Oracle E-Business Suite Application Object Library (FND). It functions as a runtime configuration table, specifically storing on-site execution information for concurrent programs. Its primary role is to manage and record the node-specific runtime parameters and environment details required for a concurrent program to execute successfully on a particular application tier server (node) within a multi-node EBS environment. This table is essential for the Concurrent Manager architecture, enabling programs to be routed to and executed on designated nodes, which is critical for load balancing, specialized processing requirements, or accessing local resources.

Key Information Stored

The table's structure is designed to link a concurrent program with one or two specific execution nodes. While the full column list is not detailed in the provided metadata, the documented foreign keys reveal its core relationships. The key columns include the concurrent program identifier (likely CONCURRENT_PROGRAM_ID or APPLICATION_ID/CONCURRENT_PROGRAM_NAME combination) and the node specification columns. As per the foreign key constraints, NODE_NAME1 and NODE_NAME2 are critical fields that store the names of the execution nodes, referencing the FND_NODES table. These columns define the primary and optional secondary nodes where the program is permitted or configured to run. The table likely also contains other runtime parameters, such as environment variable settings or execution arguments specific to the on-site context.

Common Use Cases and Queries

This table is primarily accessed for administrative configuration and troubleshooting of concurrent processing. Common use cases include auditing program-to-node assignments, diagnosing "No Manager" request errors by verifying node configuration, and generating reports on execution node utilization. A typical query would join this table with FND_CONCURRENT_PROGRAMS_VL and FND_NODES to list program execution details.

  • Sample Query: To list all concurrent programs and their assigned execution nodes:
    SELECT cpv.USER_CONCURRENT_PROGRAM_NAME,
           n1.NODE_NAME AS primary_node,
           n2.NODE_NAME AS secondary_node
    FROM APPLSYS.FND_CONC_PROG_ONSITE_INFO oi,
         FND_CONCURRENT_PROGRAMS_VL cpv,
         FND_NODES n1,
         FND_NODES n2
    WHERE oi.CONCURRENT_PROGRAM_ID = cpv.CONCURRENT_PROGRAM_ID
    AND oi.APPLICATION_ID = cpv.APPLICATION_ID
    AND oi.NODE_NAME1 = n1.NODE_NAME(+)
    AND oi.NODE_NAME2 = n2.NODE_NAME(+);

Related Objects

The FND_CONC_PROG_ONSITE_INFO table has direct dependencies within the FND schema, as indicated by its foreign keys. The primary related object is the FND_NODES table, which defines all application tier nodes registered in the EBS system. This table is also intrinsically linked to the core concurrent program definition tables, such as FND_CONCURRENT_PROGRAMS and its views (FND_CONCURRENT_PROGRAMS_VL). It is referenced by the Concurrent Manager processes during job dispatching and may be accessed by administrative APIs within the FND_CONCURRENT package or related programs that manage concurrent processing setup.