Search Results xdp_fes




Overview
Explore in AI Chat

Overview

The XDP_FES table is a core master data repository within the Oracle E-Business Suite Provisioning (XDP) module. It serves as the central registry for all Fulfillment Elements (FEs), which are the fundamental network or service components responsible for executing specific provisioning tasks. Examples of such elements include network switches, routers, service platforms, or any system that fulfills a service order. The table stores the essential definition of each FE, enabling the XDP engine to orchestrate and manage the flow of fulfillment requests across the correct network infrastructure. Its integrity is critical for the entire automated provisioning lifecycle.

Key Information Stored

While the provided metadata does not list all columns, the primary keys and foreign key relationships define its critical structure. The central identifier is the FE_ID, a unique numeric primary key for each fulfillment element. The table enforces uniqueness through two additional constraints: a unique combination of FE_ID and FETYPE_ID (linking to the XDP_FE_TYPES table to classify the element), and a unique constraint on the FULFILLMENT_ELEMENT_NAME itself. This name is the logical identifier used within processes. Other columns, inferred from standard practice and related objects, would typically store configuration parameters, status flags, version information, and descriptive attributes that define the element's operational behavior within the provisioning framework.

Common Use Cases and Queries

This table is primarily referenced for setup, configuration, and operational reporting. Common scenarios include validating FE setup before deploying new services, troubleshooting fulfillment errors by verifying an FE's existence and type, and generating master lists for administrative purposes. A typical query retrieves all active FEs with their associated types:

  • SELECT fe.fe_id, fe.fulfillment_element_name, ft.type_name FROM xdp_fes fe, xdp_fe_types ft WHERE fe.fetype_id = ft.fetype_id ORDER BY fe.fulfillment_element_name;

Another critical use case is tracing dependencies, such as identifying all adapter registrations or runtime entries for a specific FE by joining to related tables like XDP_ADAPTER_REG or XDP_FA_RUNTIME_LIST using the FE_ID.

Related Objects

As a central hub table, XDP_FES has extensive relationships across the Provisioning (XDP) and TeleService (XNP, XNS) modules. Key related objects include:

  • XDP_FE_TYPES: Master table for FE classification, linked via FETYPE_ID.
  • XDP_ADAPTER_REG, XDP_FA_RUNTIME_LIST: Operational tables tracking adapter instances and runtime states for each FE.
  • XDP_FES_TL: Translation table for multilingual support of FE names/descriptions.
  • XNP_NETWORK_MAPS: References XDP_FES twice (PARENT_FE_ID, CHILD_FE_ID) to define hierarchical network relationships.
  • XNP_SERVED_NUM_RANGES, XNP_SP_ADAPTERS, XNS_CP_FES: Various configuration and service-specific tables that associate services and components with a specific fulfillment element.
  • Table: XDP_FES 12.1.1

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FES,  object_name:XDP_FES,  status:VALID,  product: XDP - Provisioning ,  description: This table holds all the names of the Fulfillment Elements (Network Elements). This data contains the definition of a fulfillment element. ,  implementation_dba_data: XDP.XDP_FES , 

  • Table: XDP_FES 12.2.2

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FES,  object_name:XDP_FES,  status:VALID,  product: XDP - Provisioning ,  description: This table holds all the names of the Fulfillment Elements (Network Elements). This data contains the definition of a fulfillment element. ,  implementation_dba_data: XDP.XDP_FES , 

  • Table: XDP_FES_TL 12.2.2

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FES_TL,  object_name:XDP_FES_TL,  status:VALID,  product: XDP - Provisioning ,  description: Table to hold details of network element instances. ,  implementation_dba_data: XDP.XDP_FES_TL , 

  • View: XDP_ADAPTER_CONNS_COUNT_V 12.2.2

    product: XDP - Provisioning ,  implementation_dba_data: Not implemented in this database , 

  • Table: XDP_ADAPTER_REG 12.1.1

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_ADAPTER_REG,  object_name:XDP_ADAPTER_REG,  status:VALID,  product: XDP - Provisioning ,  description: Stores configuration data pertaining to all Adapters ,  implementation_dba_data: XDP.XDP_ADAPTER_REG , 

  • View: XDP_ADAPTER_CONNS_COUNT_V 12.1.1

    product: XDP - Provisioning ,  implementation_dba_data: Not implemented in this database , 

  • Table: XDP_FE_TYPES 12.1.1

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FE_TYPES,  object_name:XDP_FE_TYPES,  status:VALID,  product: XDP - Provisioning ,  description: Fulfillment Element Type definition ,  implementation_dba_data: XDP.XDP_FE_TYPES , 

  • Table: XDP_FA_RESUBMISSION_LOG 12.2.2

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FA_RESUBMISSION_LOG,  object_name:XDP_FA_RESUBMISSION_LOG,  status:VALID,  product: XDP - Provisioning ,  description: This table records the resubmission jobs for Oracle Service Fulfillment Manager. The fulfillment elements may be restarted in Order Resubmission mode to resubmit orders to the provisioning workflow. ,  implementation_dba_data: XDP.XDP_FA_RESUBMISSION_LOG , 

  • Table: XDP_FES_TL 12.1.1

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FES_TL,  object_name:XDP_FES_TL,  status:VALID,  product: XDP - Provisioning ,  description: Table to hold details of network element instances. ,  implementation_dba_data: XDP.XDP_FES_TL , 

  • Table: XDP_FA_RUNTIME_LIST 12.2.2

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FA_RUNTIME_LIST,  object_name:XDP_FA_RUNTIME_LIST,  status:VALID,  product: XDP - Provisioning ,  description: This table contains the list of the FAs which need to be executed for a workitem instance. ,  implementation_dba_data: XDP.XDP_FA_RUNTIME_LIST , 

  • Table: XDP_ADAPTER_REG 12.2.2

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_ADAPTER_REG,  object_name:XDP_ADAPTER_REG,  status:VALID,  product: XDP - Provisioning ,  description: Stores configuration data pertaining to all Adapters ,  implementation_dba_data: XDP.XDP_ADAPTER_REG , 

  • Table: XDP_FE_TYPES 12.2.2

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FE_TYPES,  object_name:XDP_FE_TYPES,  status:VALID,  product: XDP - Provisioning ,  description: Fulfillment Element Type definition ,  implementation_dba_data: XDP.XDP_FE_TYPES , 

  • Table: XDP_FE_GENERIC_CONFIG 12.2.2

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FE_GENERIC_CONFIG,  object_name:XDP_FE_GENERIC_CONFIG,  status:VALID,  product: XDP - Provisioning ,  description: Fulfillment Element Generic Config definition. ,  implementation_dba_data: XDP.XDP_FE_GENERIC_CONFIG , 

  • Table: XDP_FE_GENERIC_CONFIG 12.1.1

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FE_GENERIC_CONFIG,  object_name:XDP_FE_GENERIC_CONFIG,  status:VALID,  product: XDP - Provisioning ,  description: Fulfillment Element Generic Config definition. ,  implementation_dba_data: XDP.XDP_FE_GENERIC_CONFIG , 

  • Table: XDP_FA_RESUBMISSION_LOG 12.1.1

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FA_RESUBMISSION_LOG,  object_name:XDP_FA_RESUBMISSION_LOG,  status:VALID,  product: XDP - Provisioning ,  description: This table records the resubmission jobs for Oracle Service Fulfillment Manager. The fulfillment elements may be restarted in Order Resubmission mode to resubmit orders to the provisioning workflow. ,  implementation_dba_data: XDP.XDP_FA_RESUBMISSION_LOG , 

  • Table: XDP_FA_RUNTIME_LIST 12.1.1

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FA_RUNTIME_LIST,  object_name:XDP_FA_RUNTIME_LIST,  status:VALID,  product: XDP - Provisioning ,  description: This table contains the list of the FAs which need to be executed for a workitem instance. ,  implementation_dba_data: XDP.XDP_FA_RUNTIME_LIST , 

  • View: XDP_FES_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:XDP.XDP_FES_VL,  object_name:XDP_FES_VL,  status:VALID,  product: XDP - Provisioning ,  description: The XDP_FES_VL view will hold all the names of the Fulfillment Elements (Network Elements). This data contains the definition of a fulfillment element.Example: FE or NE is a DMS200, a Cisco CPC, HA Server. ,  implementation_dba_data: APPS.XDP_FES_VL , 

  • View: XDP_FES_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:XDP.XDP_FES_VL,  object_name:XDP_FES_VL,  status:VALID,  product: XDP - Provisioning ,  description: The XDP_FES_VL view will hold all the names of the Fulfillment Elements (Network Elements). This data contains the definition of a fulfillment element.Example: FE or NE is a DMS200, a Cisco CPC, HA Server. ,  implementation_dba_data: APPS.XDP_FES_VL ,