Results for “xdp_fe_attribute_def_tl”
49 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
XDP_FE_ATTRIBUTE_DEF_TL is a translation (TL) table within the XDP – Provisioning module of Oracle E-Business Suite, documented as valid in both 12.1.1 and 12.2.2. It stores the language-dependent descriptive text for Fulfillment Element Attribute Definitions, which describe the configurable attributes that fulfillment elements use during service provisioning and order fulfillment. The base, language-independent definition resides in XDP_FE_ATTRIBUTE_DEF; this TL table carries the translated display names and descriptions keyed by language.
From a Data Vault modeling perspective, the mined FK structure suggests a satellite-leaning classification. The table's primary key of FE_ATTRIBUTE_ID and LANGUAGE is anchored to the parent definition via a foreign key, and the descriptive columns are non-key, mutable attributes — the classic satellite pattern for storing descriptive context around a hub or link. This is a heuristic suggestion for analysts mapping XDP objects into a Data Vault model, not an Oracle-delivered classification.
The table is owned by the XDP schema and holds 12 documented columns in the 12.2.2 physical schema. Oracle's standard multi-language architecture applies: one row exists per installed or activated language for each fulfillment element attribute definition.
Key Information Stored
The two columns forming the primary key, XDP_FE_ATTRIBUTE_DEF_TL_PK, are the most significant. FE_ATTRIBUTE_ID is the surrogate foreign key to the parent definition in XDP_FE_ATTRIBUTE_DEF; it is not a business key in its own right but rather the join anchor that ties the translated text to its base record. LANGUAGE identifies the NLS language of the row and combines with FE_ATTRIBUTE_ID to guarantee one translation per attribute per language.
The business-key candidate is documented through the unique index XDP_FE_ATTRIBUTE_DEF_TL_U1, which covers FE_ATTRIBUTE_ID, LANGUAGE, and ZD_EDITION_NAME. The inclusion of ZD_EDITION_NAME indicates edition-based redefinition (EBR) awareness for online patching in 12.2.2; in a 12.1.1 context this column does not participate in the logical key. This composite is the closest analogue to a natural business key.
The payload columns are DISPLAY_NAME and DESCRIPTION, which hold the user-visible label and the longer explanatory text shown to provisioning administrators and end users. SOURCE_LANG records the language from which a translation was originally derived, supporting the standard Oracle translation-source workflow. The standard audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — record who inserted or last modified each translation and when. SECURITY_GROUP_ID supports Oracle's multi-tenant / security group partitioning, restricting visibility of translation rows to the appropriate operating unit or group context.
Common Use Cases and Queries
Typical usage centers on retrieving translated attribute labels for provisioning configuration screens, order fulfillment diagnostics, and reporting that must render in the user's session language. A common pattern joins the base definition to its translation, filtering to the caller's language, for example:
- SELECT b.fe_attribute_id, t.display_name, t.description FROM xdp_fe_attribute_def b, xdp_fe_attribute_def_tl t WHERE b.fe_attribute_id = t.fe_attribute_id AND t.language = USERENV('LANG');
- Identify attributes lacking a translation in a specific language by outer-joining the TL table and testing for NULL display_name.
- Audit translation currency using LAST_UPDATED_BY and LAST_UPDATE_DATE to find stale rows prior to a localization release.
- Restrict by SECURITY_GROUP_ID where multi-org data security applies to provisioning metadata.
Related Objects
The most significant related objects, based on the documented referential structure, are:
- XDP_FE_ATTRIBUTE_DEF — the base language-independent definition table; joined on FE_ATTRIBUTE_ID and the definitive parent of this TL row.
- FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID, providing the security group context for the translation.
- XDP_FE_ATTRIBUTE_DEF_TL_PK and XDP_FE_ATTRIBUTE_DEF_TL_U1 — the primary key and unique index that enforce row identity and the logical business key.
- XDP – Provisioning fulfillment element definition tables that consume FE_ATTRIBUTE_ID values for configuring attribute behavior.
- Oracle FND translation infrastructure tables and the NLS language registry that govern the LANGUAGE and SOURCE_LANG values.
Because the table is DELIVERED as an XDP-owned object, direct DML should be avoided; modifications are normally made through the provisioning setup UI or supported concurrent programs that maintain the parent definition and its translations together.
-
Fulfillment Element Attribute Definition
-
Fulfillment Element Attribute Definition
-
This View shows all the Fulfillment Element Attribute Definitions
APPS.XDP_FE_ATTRIBUTE_DEF_VL·↳ XDP_FE_ATTRIBUTE_DEF·↳ XDP_FE_ATTRIBUTE_DEF_TL·Explore XDP module →
-
This View shows all the Fulfillment Element Attribute Definitions
APPS.XDP_FE_ATTRIBUTE_DEF_VL·↳ XDP_FE_ATTRIBUTE_DEF·↳ XDP_FE_ATTRIBUTE_DEF_TL·Explore XDP module →
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
eTRM - XDP Tables and Views 12.2.2
Fulfillment Worklist Details
-
eTRM - XDP Tables and Views 12.1.1
Fulfillment Worklist Details
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
eTRM - XDP Tables and Views 12.2.2
Fulfillment Worklist Details
-
eTRM - XDP Tables and Views 12.1.1
Fulfillment Worklist Details
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1