Search Results xdp_fe_sw_gen_lookup_uk1

Overview

The XDP_FE_SW_GEN_LOOKUP table is a core data repository within the Oracle E-Business Suite Provisioning (XDP) module, serving as a master lookup for software generic configurations. Its primary role is to define and manage the association between a specific Front-End (FE) type, a software generic identifier, and an adapter type. This association is critical for the provisioning engine to determine the correct software components and execution procedures required to fulfill a service order for a particular type of customer equipment or service. The table acts as a central reference point, linking technical configuration data to the procedural logic that orchestrates the provisioning workflow.

Key Information Stored

The table's structure is defined by its primary and unique keys, which enforce critical business rules. The primary technical identifier is the FE_SW_GEN_LOOKUP_ID column. The unique key (XDP_FE_SW_GEN_LOOKUP_UK1) enforces a one-to-one relationship based on the combination of FETYPE_ID, SW_GENERIC, and ADAPTER_TYPE. This ensures that for a given equipment type and adapter, a specific software generic is uniquely defined. Key functional columns include SW_START_PROC and SW_EXIT_PROC, which are foreign keys to the XDP_PROC_BODY table. These columns store references to the stored procedures that initiate and conclude the software provisioning process for the defined configuration, enabling a pluggable, procedure-driven architecture.

Common Use Cases and Queries

A primary use case is the runtime resolution of the correct software configuration during order fulfillment. The provisioning engine queries this table using the FE type and adapter context from the order line to retrieve the associated SW_GENERIC and the procedural hooks (start/exit procedures). Common queries include identifying all software configurations for a specific FE type or adapter. For example, to audit configurations for the 'DSLAM' FE type, one might execute: SELECT sw_generic, adapter_type, sw_start_proc FROM xdp_fe_sw_gen_lookup WHERE fetype_id = (SELECT fetype_id FROM xdp_fe_types WHERE name = 'DSLAM');. Another critical reporting use case involves analyzing the mapping completeness by joining to XDP_FE_TYPES to find FE types without a corresponding software generic lookup entry.

Related Objects

The XDP_FE_SW_GEN_LOOKUP table is a central node in the XDP schema's data model, with documented relationships to several key tables.

• Referenced Objects (Foreign Keys FROM this table):
  • XDP_PROC_BODY: Via SW_START_PROC and SW_EXIT_PROC columns. Links to the procedural logic.
  • XDP_FE_TYPES: Via FETYPE_ID column. Identifies the Front-End equipment type.
  • XDP_ADAPTER_TYPES_B: Via ADAPTER_TYPE column. Specifies the adapter interface.
• Dependent Objects (Foreign Keys TO this table):
  • XDP_FA_FULFILLMENT_PROC: Uses FE_SW_GEN_LOOKUP_ID. Part of the fulfillment procedure definition.
  • XDP_FE_ATTRIBUTE_DEF: Uses FE_SW_GEN_LOOKUP_ID. Defines attributes for this software generic.
  • XDP_FE_GENERIC_CONFIG: Uses FE_SW_GEN_LOOKUP_ID. Stores detailed configuration parameters.
  • XDP_FE_SW_GEN_LOOKUP_TL: Uses FE_SW_GEN_LOOKUP_ID. The Translation table for multilingual support.