Search Results xdp_fe_generic_config




Overview
Explore in AI Chat

Overview

The XDP_FE_GENERIC_CONFIG table is a core data definition table within the Oracle E-Business Suite Provisioning (XDP) module. It serves as the central repository for defining configuration rules and parameters for Fulfillment Elements (FEs). A Fulfillment Element represents a discrete, configurable unit of work or a resource within a service order fulfillment process. This table enables the association of generic, reusable software logic and procedural hooks to specific FEs, allowing for the dynamic customization and control of fulfillment workflows without hard-coding business rules into the application.

Key Information Stored

The table's structure is designed to link Fulfillment Elements with executable logic and lookup definitions. Its primary identifier is the FE_GENERIC_CONFIG_ID. The FE_ID column is a foreign key that ties the configuration to a specific Fulfillment Element defined in the XDP_FES table. The FE_SW_GEN_LOOKUP_ID links to a generic software lookup code in the XDP_FE_SW_GEN_LOOKUP table, which categorizes the type of configuration or the software module to invoke. Crucially, the SW_START_PROC and SW_EXIT_PROC columns store references to stored procedure bodies (in the XDP_PROC_BODY table) that are executed at the start and exit points of the FE's processing, respectively. The START_DATE manages the effective dating of the configuration rule.

Common Use Cases and Queries

This table is primarily accessed during the runtime execution of service fulfillment orders. When the provisioning engine processes an FE, it queries this table to determine if any generic software configurations, start procedures, or exit procedures are attached. A common administrative query is to list all active configurations for an FE to audit or troubleshoot workflow behavior. For example:

  • To find all configurations for a specific Fulfillment Element: SELECT * FROM xdp_fe_generic_config WHERE fe_id = <FE_ID> AND SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE);
  • To identify FEs configured with a specific software lookup type: SELECT fe_id FROM xdp_fe_generic_config WHERE fe_sw_gen_lookup_id = <LOOKUP_ID>;

Reporting often focuses on understanding the mapping between FEs and their associated procedural logic to document customizations.

Related Objects

The XDP_FE_GENERIC_CONFIG table is a nexus within the XDP schema, maintaining several critical relationships:

  • References (Foreign Keys):
    • XDP_FES via FE_ID: The parent Fulfillment Element definition.
    • XDP_FE_SW_GEN_LOOKUP via FE_SW_GEN_LOOKUP_ID: The generic software lookup type.
    • XDP_PROC_BODY via SW_START_PROC and SW_EXIT_PROC: The stored procedure bodies for start and exit hooks.
  • Referenced By (Foreign Key):
    • XDP_FE_ATTRIBUTE_VAL via FE_GENERIC_CONFIG_ID: Attribute values can be stored at this configuration level, allowing for parameterized behavior specific to this FE-configuration combination.