Search Results xdp_fe_attribute_def_tl




Overview
Explore in AI Chat

Overview

The XDP_FE_ATTRIBUTE_DEF_TL table is a core data object within the Oracle E-Business Suite Provisioning (XDP) module, specifically in versions 12.1.1 and 12.2.2. It functions as a translation table, storing multilingual descriptions and display names for Fulfillment Element (FE) attribute definitions. In the context of XDP's service fulfillment framework, a Fulfillment Element represents a configurable component or action within a service order workflow. This table enables the provisioning system to present attribute metadata, such as prompts and help text, in the user's preferred language, supporting global deployments.

Key Information Stored

The table's primary purpose is to hold language-specific textual data for attributes. Its structure is defined by a composite primary key and columns for translated content. The critical columns include:

  • FE_ATTRIBUTE_ID: A foreign key that uniquely identifies the base attribute definition in the XDP_FE_ATTRIBUTE_DEF table. This column links the translation to its source object.
  • LANGUAGE: The standard Oracle language code (e.g., 'US' for American English, 'D' for German). Together with FE_ATTRIBUTE_ID, it forms the table's primary key, ensuring a unique translation per attribute per language.
  • SOURCE_LANG: A system column indicating the original language in which the data was entered.
  • Translated Text Columns: Typically named columns such as DISPLAY_NAME, DESCRIPTION, or PROMPT. These store the actual translated strings that appear in the user interface. The exact names are inferred from standard EBS translation table patterns and the object's descriptive purpose.

Common Use Cases and Queries

This table is primarily accessed by the application runtime to display localized interface text and by administrative queries for managing multilingual content. A common reporting use case is to verify or audit translations for a set of fulfillment attributes. A typical query would join this table to its base table to retrieve both the internal identifier and its user-facing names in multiple languages.

Sample SQL Pattern:
SELECT b.ATTRIBUTE_NAME, t.DISPLAY_NAME, t.LANGUAGE
FROM XDP_FE_ATTRIBUTE_DEF b,
XDP_FE_ATTRIBUTE_DEF_TL t
WHERE b.FE_ATTRIBUTE_ID = t.FE_ATTRIBUTE_ID
AND b.ATTRIBUTE_NAME LIKE '%SERVICE%'
AND t.LANGUAGE IN ('US', 'D', 'F');
This query would return the display names for attributes containing "SERVICE" in American English, German, and French.

Related Objects

The table has a direct and singular foreign key relationship, as documented in the provided ETRM metadata. This defines its core dependency within the XDP schema.

  • Primary Key Constraint: XDP_FE_ATTRIBUTE_DEF_TL_PK on columns (FE_ATTRIBUTE_ID, LANGUAGE).
  • Foreign Key Relationship: The table XDP_FE_ATTRIBUTE_DEF_TL references the table XDP_FE_ATTRIBUTE_DEF. The join is made on the column XDP_FE_ATTRIBUTE_DEF_TL.FE_ATTRIBUTE_ID, which corresponds to the primary key column(s) in XDP_FE_ATTRIBUTE_DEF. This establishes that every translated record must correspond to a single, valid base attribute definition.