Results for “xdp_fe_attribute_val_tl”

49 results




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

Overview

XDP_FE_ATTRIBUTE_VAL_TL is a translation (TL) table in the XDP Provisioning schema of Oracle E-Business Suite, holding the language-dependent, user-facing text associated with Front End (FE) attribute values. In EBS, Provisioning supports service fulfillment and configuration-driven provisioning flows, where attribute values drive how generic configurations are rendered and resolved. The base identity of each attribute value resides in the parent table XDP_FE_ATTRIBUTE_VAL; the TL table supplies the display name and description for each supported language, enabling multilingual presentation of provisioned attributes without duplicating structural data.

Because the table stores descriptive, translatable columns keyed back to a parent entity, the supplied metadata classifies it heuristically as satellite-leaning under a Data Vault-style model. This classification is presented as a modeling suggestion only: the table behaves as an attribute satellite attached to the XDP_FE_ATTRIBUTE_VAL anchor, carrying context-dependent text rather than independent business events. The table is owned by XDP, is marked VALID, and contains 13 documented columns. Records are secured through a SECURITY_GROUP_ID reference into FND_SECURITY_GROUPS, consistent with multi-org and data-security patterns common across EBS.

Key Information Stored

The table’s identity is defined by its composite primary key constraint XDP_FE_ATTRIBUTE_VAL_TL_PK, covering FE_ATTRIBUTE_ID, FE_GENERIC_CONFIG_ID, and LANGUAGE. These three columns are foreign-keyed to XDP_FE_ATTRIBUTE_VAL, establishing the parent attribute value and its owning generic configuration context. LANGUAGE identifies the translation row, with SOURCE_LANG recording the original language from which the translation derives.

  • FE_ATTRIBUTE_ID — foreign key to XDP_FE_ATTRIBUTE_VAL; identifies the provisioning attribute being described.
  • FE_GENERIC_CONFIG_ID — foreign key to XDP_FE_ATTRIBUTE_VAL; identifies the generic configuration the attribute belongs to.
  • LANGUAGE — the language of the translated text; part of the primary key.
  • SOURCE_LANG — the source language of the base attribute value.
  • DISPLAY_NAME — the translated, user-facing label for the attribute value.
  • DESCRIPTION — the translated descriptive text for the attribute value.
  • SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS; controls row-level access.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns capturing who created and last modified each translation row and when.
  • ZD_EDITION_NAME — editioning column supporting EBS online patching and edition-based redefinition.

A unique index, XDP_FE_ATTRIBUTE_VAL_TL_U1, covers FE_ATTRIBUTE_ID, FE_GENERIC_CONFIG_ID, LANGUAGE, and ZD_EDITION_NAME, representing the business-key candidate that guarantees one translation row per attribute, configuration, language, and edition. The surrogate-style primary key should not be confused with this business key, which governs translation uniqueness.

Common Use Cases and Queries

Typical uses include retrieving localized attribute labels for provisioning user interfaces, auditing translation coverage across languages, and joining translated text back to provisioning configuration data for reporting. A common pattern restricts to a language and excludes stale editions:

  • Retrieving a localized label: SELECT display_name, description FROM xdp_fe_attribute_val_tl WHERE fe_attribute_id = :id AND fe_generic_config_id = :cfg AND language = USERENV('LANG');
  • Identifying missing translations by comparing LANGUAGE values against the parent table.
  • Joining to XDP_FE_ATTRIBUTE_VAL on FE_ATTRIBUTE_ID and FE_GENERIC_CONFIG_ID to combine structural and translated data.
  • Security-filtered reporting using SECURITY_GROUP_ID joined to FND_SECURITY_GROUPS.

Related Objects

  • XDP_FE_ATTRIBUTE_VAL — parent table; join on FE_ATTRIBUTE_ID and FE_GENERIC_CONFIG_ID.
  • FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID for row-level security.
  • XDP_FE_ATTRIBUTE_VAL_TL_PK — primary key constraint on FE_ATTRIBUTE_ID, FE_GENERIC_CONFIG_ID, LANGUAGE.
  • XDP_FE_ATTRIBUTE_VAL_TL_U1 — unique index adding ZD_EDITION_NAME to the business key.
  • Associated XDP provisioning configuration and fulfillment views that consume translated attribute text.