Results for “xdp_services_tl”

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

Overview

XDP_SERVICES_TL is a translation (TL) table in the XDP schema, belonging to the Provisioning (XDP) product family within Oracle E-Business Suite 12.1.1 and 12.2.2. Translation tables in EBS follow a standardized pattern: a base table stores language-independent attributes, and a companion "_TL" table stores the language-dependent descriptive columns keyed by a LANGUAGE code. In this case, XDP_SERVICES holds the primary service definition, and XDP_SERVICES_TL carries the translatable display text associated with each service record. The ETRM metadata describes the table's description field as "Not used," indicating that the object is internally referenced by provisioning logic rather than exposed directly to end users through standard application windows.

From a data-modeling perspective, the mined heuristic classification for XDP_SERVICES_TL is satellite-leaning. This suggests the table is best understood as a satellite that hangs off a parent hub or master entity (XDP_SERVICES), carrying descriptive, language-scoped attributes rather than defining independent business keys. Analysts modeling provisioning data into a warehouse or Data Vault should treat XDP_SERVICES as the driving entity and XDP_SERVICES_TL as the descriptive satellite keyed by service and language.

Key Information Stored

The table contains 11 documented columns. The composite primary key XDP_SERVICES_TL_PK is formed by SERVICE_ID and LANGUAGE, which together uniquely identify each translated row. A parallel unique index, XDP_SERVICES_TL_U1, is defined on the same pair (SERVICE_ID, LANGUAGE), confirming this combination as the effective business-key candidate. SERVICE_ID is the surrogate foreign key pointing back to the parent XDP_SERVICES record, while LANGUAGE identifies the locale of the translated text.

• SERVICE_ID — Foreign key to XDP_SERVICES; identifies the provisioning service being described.
• LANGUAGE — Language/locale code (for example, US or DE), part of the primary key.
• SOURCE_LANG — The source language from which the translation was derived, used by the EBS translation framework.
• DISPLAY_NAME — The user-facing, translatable name of the service.
• DESCRIPTION — The translatable descriptive text for the service.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS WHO columns for audit and concurrency tracking.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, supporting multi-org/security-group data filtering.

Common Use Cases and Queries

Because XDP_SERVICES_TL is a translation table, the most common requirement is resolving a language-specific display name for a given service. A typical query joins the base table to the _TL table filtered on the desired LANGUAGE:

• Retrieve translated service names: SELECT s.service_id, t.display_name, t.description FROM xdp_services s, xdp_services_tl t WHERE s.service_id = t.service_id AND t.language = USERENV('LANG').
• Audit translations for completeness: identify services in XDP_SERVICES that lack a row in XDP_SERVICES_TL for a required language.
• Report on the relationship between source and target languages using SOURCE_LANG.
• Filter by SECURITY_GROUP_ID when integrating with multi-org provisioning reporting.

Reporting against this table is typically confined to technical or provisioning-focused extracts rather than standard EBS operational reports, given its internal nature.

Related Objects

The following objects have direct or implied relationships with XDP_SERVICES_TL based on documented foreign keys and standard EBS translation patterns:

• XDP_SERVICES — Parent master table; joined via XDP_SERVICES_TL.SERVICE_ID = XDP_SERVICES.SERVICE_ID.
• FND_SECURITY_GROUPS — Referenced through XDP_SERVICES_TL.SECURITY_GROUP_ID.
• FND_LANGUAGES — Supplies the valid LANGUAGE and SOURCE_LANG values.
• XDP_SERVICES_TL_PK / XDP_SERVICES_TL_U1 — Primary key and unique indexes enforcing the service/language uniqueness.
• Related XDP provisioning tables — Other XDP objects referencing XDP_SERVICES indirectly inherit this translation context.