Results for “xdo_templates_tl”

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

Overview

XDO_TEMPLATES_TL is the translation (language) table for XDO_TEMPLATES_B in the XML Publisher (XDO) product family within Oracle E-Business Suite 12.1.1 and 12.2.2. In Oracle EBS, translation tables follow the standard multilanguage "TL" convention: the "_B" table stores language-independent (base) rows, while the "_TL" table stores the translated descriptive attributes for each supported language (LANGUAGE) and, in 12.2.2 with the ZD_EDITION_NAME column, per-edition variations. The table is owned by the XDO schema and holds the user-facing template name and description associated with each registered XML Publisher template.

From a data-modeling perspective, the metadata provides a heuristic Data Vault classification of "standalone" based on the mined foreign key structure. This is a modeling suggestion rather than an enforced constraint: there is no FK captured in the documentation, but functionally the table behaves like a satellite hanging off the XDO_TEMPLATES_B base entity, keyed by the same business identifiers plus LANGUAGE (and ZD_EDITION_NAME). The base key columns (APPLICATION_SHORT_NAME, TEMPLATE_CODE, LANGUAGE) act as the natural link to the parent template definition.

Key Information Stored

XDO_TEMPLATES_TL contains 12 documented columns. The most significant are:

• APPLICATION_SHORT_NAME — the short name of the owning application; part of the primary key and of both unique business-key candidate indexes.
• TEMPLATE_CODE — the internal code that identifies the template; part of the primary key XDO_TEMPLATES_TL_PK and of XDO_TEMPLATES_TL_U1.
• TEMPLATE_NAME — the localized, user-facing template name; part of the unique index XDO_TEMPLATES_TL_U2.
• LANGUAGE — the language of the translated row; part of the primary key and both unique indexes.
• DESCRIPTION — the localized description of the template.
• SOURCE_LANG — indicates the source language from which the translation was derived.
• ZD_EDITION_NAME — the edition discriminator used in the 12.2.2 editioning model; included in XDO_TEMPLATES_TL_U1 and XDO_TEMPLATES_TL_U2.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS WHO columns capturing audit and login context.

The surrogate primary key XDO_TEMPLATES_TL_PK is (APPLICATION_SHORT_NAME, TEMPLATE_CODE, LANGUAGE). The business-key candidates are XDO_TEMPLATES_TL_U1 (APPLICATION_SHORT_NAME, TEMPLATE_CODE, LANGUAGE, ZD_EDITION_NAME) and XDO_TEMPLATES_TL_U2 (APPLICATION_SHORT_NAME, TEMPLATE_NAME, LANGUAGE, ZD_EDITION_NAME).

Common Use Cases and Queries

Typical uses include localizing template names for a specific language, auditing which templates have translated rows, and reporting template inventories by application. Because the base name lives in the transla