Search Results fe_attribute_id




Overview
Explore in AI Chat

Overview

The XDP_FE_ATTRIBUTE_VAL_TL table is a core data object within the Oracle E-Business Suite Provisioning (XDP) module, specifically for versions 12.1.1 and 12.2.2. It functions as a translation table, storing multilingual descriptions for the values assigned to Front-End (FE) attributes. These attributes are part of generic configuration definitions used to model and provision services. The table's primary role is to enable the user interface and reporting outputs to display attribute value descriptions in the language of the user's session, supporting global deployments of the application.

Key Information Stored

The table stores translated text for predefined attribute values. Its structure is defined by a composite primary key and language-specific data columns. The critical columns include the composite primary key components: FE_ATTRIBUTE_ID, which links to the specific attribute; FE_GENERIC_CONFIG_ID, which links to the generic configuration context; and LANGUAGE, which holds the language code (e.g., 'US', 'DE'). The core data column is typically a DESCRIPTION or NAME field (implied by the translation table convention), which holds the translated text for the attribute value. This design ensures that for each unique combination of attribute and configuration, multiple language entries can exist.

Common Use Cases and Queries

This table is primarily accessed by the application's runtime engine to present localized content. Common use cases involve retrieving the appropriate description for a service attribute value based on the user's session language during service design, order fulfillment, or provisioning tasks. A typical reporting query would join this table to its base table to extract human-readable descriptions. A sample SQL pattern is:

  • SELECT T.DESCRIPTION, B.* FROM XDP_FE_ATTRIBUTE_VAL B, XDP_FE_ATTRIBUTE_VAL_TL T WHERE B.FE_ATTRIBUTE_ID = T.FE_ATTRIBUTE_ID AND B.FE_GENERIC_CONFIG_ID = T.FE_GENERIC_CONFIG_ID AND T.LANGUAGE = USERENV('LANG');

Data in this table is typically maintained via the application's translation interface or seed data scripts, not via direct DML.

Related Objects

The table has a direct and fundamental relationship with its base table, as documented in the provided metadata. The primary foreign key relationship is:

  • Base Table: XDP_FE_ATTRIBUTE_VAL
  • Relationship: The columns XDP_FE_ATTRIBUTE_VAL_TL.FE_ATTRIBUTE_ID and XDP_FE_ATTRIBUTE_VAL_TL.FE_GENERIC_CONFIG_ID together reference the XDP_FE_ATTRIBUTE_VAL table. This enforces that every translation record must correspond to a valid attribute value record in the base table.

This table is also conceptually related to other XDP configuration objects like XDP_FE_ATTRIBUTES_B and XDP_FE_GENERIC_CONFIGS, which define the attributes and generic configurations themselves, though these relationships are mediated through the XDP_FE_ATTRIBUTE_VAL base table.