Results for “xdp_fe_types_tl”

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

Overview

XDP_FE_TYPES_TL is the translation (language) table for Fulfillment Element Type definitions within the XDP – Provisioning module of Oracle E-Business Suite. In the Oracle EBS multilanguage architecture, the "_TL" suffix denotes a table that stores one row per translatable attribute per installed language, working in conjunction with a base table — here XDP_FE_TYPES — that holds the language-independent definition. The Fulfillment Element Type serves as a classification or template for fulfillment elements used in service provisioning and order fulfillment flows, allowing the provisioning engine to recognize and process different categories of fulfillment elements during the service delivery lifecycle.

The table resides in the XDP schema and is documented as VALID in both ETRM 12.1.1 and 12.2.2. Its primary key, XDP_FE_TYPES_TL_PK, is composed of FETYPE_ID and LANGUAGE, ensuring that exactly one translated record exists per element type per language. A unique index, XDP_FE_TYPES_TL_U1, adds ZD_EDITION_NAME to that combination, reflecting the editioning feature introduced in 12.2. From a Data Vault modeling perspective, the heuristic classification mints this object as satellite-leaning: it describes and contextualizes the XDP_FE_TYPES hub via descriptive, language-dependent attributes rather than defining new business entities or relationships.

Key Information Stored

The table contains twelve documented columns. The most consequential are:

• FETYPE_ID — surrogate identifier for the fulfillment element type; part of the primary key and the foreign key to XDP_FE_TYPES.
• LANGUAGE — the NLS language code; the second component of the primary key.
• ZD_EDITION_NAME — editioning column (12.2) that permits multiple editions of the same row; part of unique index XDP_FE_TYPES_TL_U1.
• SOURCE_LANG — the language in which the source (base) text was originally authored, used by the translation framework to track derivation.
• DISPLAY_NAME — the translated, user-facing name of the fulfillment element type.
• DESCRIPTION — the translated long description used in setup forms and reports.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enforcing multi-org / security group isolation at row level.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO audit columns recording insert and update provenance.

The surrogate primary key is (FETYPE_ID, LANGUAGE), while the business-key candidate identified by the unique index is (FETYPE_ID, LANGUAGE, ZD_EDITION_NAME). The surrogate design allows the same FETYPE_ID to persist across languages and editions without collision.

Common Use Cases and Queries

Functional consultants and developers query this table to retrieve localized labels for fulfillment element types when building provisioning setups, custom concurrent programs, or BI Publisher reports. A typical join retrieves the translated name for the current session language:

• SELECT ftl.fetype_id, ftl.display_name, ftl.description FROM xdp.xdp_fe_types_tl ftl WHERE ftl.language = USERENV('LANG') AND ftl.security_group_id = :sg_id;
• Joining base to translation: SELECT b.fetype_id, t.display_name FROM xdp.xdp_fe_types b, xdp.xdp_fe_types_tl t WHERE b.fetype_id = t.fetype_id AND t.language = 'US';
• Auditing translation completeness: comparing counts of XDP_FE_TYPES rows against XDP_FE_TYPES_TL for a given LANGUAGE to detect missing or stale translations.
• Extracting all language variants for a single element type: SELECT * FROM xdp_fe_types_tl WHERE fetype_id = :id ORDER BY language;

Because the table is translation-only, inserts and updates normally occur through the Fulfillment Element Type setup UI or the translation framework rather than direct DML.

Related Objects

The most significant related objects are:

• XDP_FE_TYPES — the base (untranslated) definition table; joined on FETYPE_ID. This is the parent in the FK relationship.
• FND_SECURITY_GROUPS — joined on SECURITY_GROUP_ID; controls which rows are visible to a given responsibility or organization.
• XDP_FE_TYPES_TL_PK — the primary key constraint enforcing uniqueness of (FETYPE_ID, LANGUAGE).
• XDP_FE_TYPES_TL_U1 — the unique index including ZD_EDITION_NAME.
• FND_LANGUAGES — implied reference for valid LANGUAGE values consumed by the NLS layer.
• FND_APPLICATION / XDP registration — the owning product metadata that governs the object's setup UI.

Together these objects form the fulfillment element type definition layer used throughout Oracle's provisioning and service fulfillment configuration.