Search Results xdp_fe_attribute_val




Overview
Explore in AI Chat

Overview

The XDP_FE_ATTRIBUTE_VAL table is a core data repository within the Oracle E-Business Suite Provisioning (XDP) module, specifically for versions 12.1.1 and 12.2.2. It functions as the central store for the runtime values of Front-End (FE) attributes. These attributes are user-defined, configurable fields that extend the functionality of provisioning service items and workflows. The table's primary role is to persistently associate specific attribute values with a given generic configuration instance, thereby enabling the dynamic and customizable behavior of provisioning processes.

Key Information Stored

The table's structure is defined by a composite primary key and stores the linkage between attribute definitions and their assigned values. The most critical columns are the primary key components: FE_ATTRIBUTE_ID and FE_GENERIC_CONFIG_ID. The FE_ATTRIBUTE_ID is a foreign key referencing the XDP_FE_ATTRIBUTE_DEF table, which holds the metadata definition for the attribute (e.g., name, data type, default value). The FE_GENERIC_CONFIG_ID is a foreign key referencing the XDP_FE_GENERIC_CONFIG table, which represents a specific instance of a configured service or workflow. While the provided metadata does not list all value columns, the table typically contains columns to store the actual attribute value (such as VARCHAR2, NUMBER, or DATE types) corresponding to the definition referenced by FE_ATTRIBUTE_ID.

Common Use Cases and Queries

This table is essential for retrieving the complete runtime configuration of a provisioning service. A common use case involves generating a report of all attribute values for a specific service order or configuration. For troubleshooting, queries often join this table with its definition table to validate data integrity or audit value changes. A typical SQL pattern to fetch attribute details for a configuration would be:

  • SELECT def.ATTRIBUTE_NAME, val.ATTRIBUTE_VALUE
  • FROM XDP_FE_ATTRIBUTE_VAL val,
  • XDP_FE_ATTRIBUTE_DEF def
  • WHERE val.FE_ATTRIBUTE_ID = def.FE_ATTRIBUTE_ID
  • AND val.FE_GENERIC_CONFIG_ID = :config_id;

Data maintenance tasks, such as updating or clearing attribute values for a batch of configurations, also directly target this table, using the FE_GENERIC_CONFIG_ID as the key filter.

Related Objects

The XDP_FE_ATTRIBUTE_VAL table sits at the center of a key data model for FE attributes, with documented relationships to several other XDP tables.

  • Parent Tables (Referenced by Foreign Keys):
    • XDP_FE_ATTRIBUTE_DEF: Joined via XDP_FE_ATTRIBUTE_VAL.FE_ATTRIBUTE_ID. This provides the descriptive metadata for the stored value.
    • XDP_FE_GENERIC_CONFIG: Joined via XDP_FE_ATTRIBUTE_VAL.FE_GENERIC_CONFIG_ID. This identifies the specific service or workflow configuration to which the attribute value belongs.
  • Child Table (References this table):
    • XDP_FE_ATTRIBUTE_VAL_TL: Joined via the columns FE_ATTRIBUTE_ID and FE_GENERIC_CONFIG_ID. This Translation table stores the language-specific versions of the attribute values, supporting multilingual implementations.