Results for “fe_attribute_value”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

XDP_FE_ATTRIBUTE_VAL is a table in the XDP (Provisioning) schema of Oracle E-Business Suite, documented as valid in both 12.1.1 and 12.2.2. Its description, "FE Attribute Values," identifies it as the persistence layer for values assigned to configurable front-end attributes. In the provisioning model, XDP_FE_ATTRIBUTE_DEF defines the available attributes, XDP_FE_GENERIC_CONFIG defines the configuration containers, and XDP_FE_ATTRIBUTE_VAL stores the actual value that each attribute assumes within a given configuration context. The table therefore acts as the associative bridge between attribute definitions and configuration instances.

Under the heuristic Data Vault classification derived from its foreign-key structure, this table is satellite-leaning. The composite primary key of FE_ATTRIBUTE_ID and FE_GENERIC_CONFIG_ID behaves as a link-style composite business key, while the descriptive payload column FE_ATTRIBUTE_VALUE holds the measured attribute. This classification is a modeling suggestion rather than a documented Oracle design statement; treat it as guidance for downstream ETL and reporting design.

Key Information Stored

The table contains ten documented columns. The two foreign-key columns, FE_ATTRIBUTE_ID and FE_GENERIC_CONFIG_ID, together form the primary key XDP_FE_ATTRIBUTE_VAL_PK. FE_ATTRIBUTE_ID references the attribute definition in XDP_FE_ATTRIBUTE_DEF, and FE_GENERIC_CONFIG_ID references the configuration row in XDP_FE_GENERIC_CONFIG. These are the business-key columns and, critically, are the surrogate identifiers used by the dependent translation table XDP_FE_ATTRIBUTE_VAL_TL.

• FE_ATTRIBUTE_ID — Identifies which front-end attribute the row describes; foreign key to XDP_FE_ATTRIBUTE_DEF.
• FE_GENERIC_CONFIG_ID — Identifies the owning configuration; foreign key to XDP_FE_GENERIC_CONFIG.
• FE_ATTRIBUTE_VALUE — The assigned value for the attribute within that configuration; the principal descriptive payload.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing multi-tenant / operating-unit data isolation, a standard EBS pattern.
• ZD_EDITION_NAME — Editioning column supporting EBS 12.2 online patching and edition-based redefinition; also part of unique index XDP_FE_ATTRIBUTE_VAL_U1.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns recording who created and last modified the row and when.

A second unique index, XDP_FE_ATTRIBUTE_VAL_U1, extends the primary key with ZD_EDITION_NAME, making it the edition-aware business-key candidate. The translation table XDP_FE_ATTRIBUTE_VAL_TL carries the same two identifying columns, so attribute values can be presented in multiple languages.

Common Use Cases and Queries

Typical scenarios include reporting all attribute values for a configuration, resolving an attribute definition to its configured value, and auditing configuration changes. A representative join is:

• SELECT v.FE_ATTRIBUTE_ID, d.ATTRIBUTE_NAME, v.FE_ATTRIBUTE_VALUE FROM XDP_FE_ATTRIBUTE_VAL v JOIN XDP_FE_ATTRIBUTE_DEF d ON v.FE_ATTRIBUTE_ID = d.FE_ATTRIBUTE_ID WHERE v.FE_GENERIC_CONFIG_ID = :config_id;

Because SECURITY_GROUP_ID participates in the FK to FND_SECURITY_GROUPS, custom queries should filter on the appropriate security group to respect data segregation. Under 12.2 edition-based redefinition, queries against the base table normally resolve through the editioning view, so custom code should avoid hard-coding ZD_EDITION_NAME unless performing edition-aware reconciliation.

Related Objects

• XDP_FE_ATTRIBUTE_DEF — parent attribute definition; joined via FE_ATTRIBUTE_ID.
• XDP_FE_GENERIC_CONFIG — parent configuration; joined via FE_GENERIC_CONFIG_ID.
• XDP_FE_ATTRIBUTE_VAL_TL — translation table; references FE_ATTRIBUTE_ID and FE_GENERIC_CONFIG_ID.
• FND_SECURITY_GROUPS — security isolation; joined via SECURITY_GROUP_ID.

Collectively these objects form the provisioning front-end attribute layer, with XDP_FE_ATTRIBUTE_VAL as the central value store linking definitions, configurations, translations, and security groups.