Search Results xdp_fe_attribute_def




Overview
Explore in AI Chat

Overview

The XDP_FE_ATTRIBUTE_DEF table is a core data definition table within the Oracle E-Business Suite Provisioning (XDP) module. It serves as the master repository for defining the attributes of Fulfillment Elements. A Fulfillment Element represents a configurable component or service within a provisioning workflow, such as a DSL line or a software license. This table stores the metadata that defines the characteristics (attributes) of these elements, including data type, validation rules, and display properties. Its primary role is to provide a structured framework for capturing and validating the specific data required to fulfill a service order, enabling the dynamic and configurable nature of the XDP engine in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is centered on uniquely identifying and describing each attribute. The primary identifier is the FE_ATTRIBUTE_ID, a system-generated unique key. The FE_ATTRIBUTE_NAME column stores the internal name of the attribute, which is used for programmatic reference. A critical column is FE_SW_GEN_LOOKUP_ID, which forms a unique key constraint (XDP_FE_ATTRIBUTE_DEF_UK1) in conjunction with the attribute name. This foreign key links to the XDP_FE_SW_GEN_LOOKUP table, associating the attribute definition with a specific software-generated lookup context, which is essential for controlling where and how the attribute is used within the provisioning system. While the provided metadata does not list all columns, typical attribute definition tables also include fields for data type (e.g., VARCHAR2, NUMBER, DATE), default values, mandatory flags, and display sequences.

Common Use Cases and Queries

This table is fundamental for setup, reporting, and data integrity within provisioning flows. A common administrative task is querying all attributes defined for a specific type of Fulfillment Element or lookup context. For example, to list all attribute definitions associated with a particular software module, one might join on FE_SW_GEN_LOOKUP_ID. Developers and integrators query this table to understand the data model when building custom interfaces or extensions to the provisioning engine. A typical diagnostic query would join XDP_FE_ATTRIBUTE_DEF with its translation table (XDP_FE_ATTRIBUTE_DEF_TL) to retrieve user-friendly attribute names for reporting purposes. Furthermore, any process that creates or validates instances of attribute values (stored in XDP_FE_ATTRIBUTE_VAL) must first reference the definitions in this table to enforce data type and business rules.

Related Objects

The XDP_FE_ATTRIBUTE_DEF table sits at the center of a key definitional hierarchy in the XDP schema, as evidenced by its foreign key relationships.

  • Referenced Object (Parent): The table references XDP_FE_SW_GEN_LOOKUP via the column FE_SW_GEN_LOOKUP_ID. This links the attribute to its controlling lookup context.
  • Dependent Objects (Children):
    • XDP_FE_ATTRIBUTE_DEF_TL: The Translation table. It references the primary key FE_ATTRIBUTE_ID to store multilingual descriptions of the attribute.
    • XDP_FE_ATTRIBUTE_VAL: The instance value table. It references FE_ATTRIBUTE_ID to store the actual data values for attributes as they are applied to specific fulfillment orders or entities. This is the most critical runtime dependency.