Search Results xdo_templates_tl




Overview
Explore in AI Chat

Overview

The XDO_TEMPLATES_TL table is a core data object within the XML Publisher (XDO) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It functions as a translation table, storing multilingual descriptions and names for report templates defined in the base table, XDO_TEMPLATES_B. This structure is a standard Oracle Applications pattern, enabling the support of multiple languages in a global deployment. The table is critical for the user interface and administration of XML Publisher, as it allows template metadata, such as the display name, to be presented in a user's preferred language, facilitating accurate template selection and management across diverse locales.

Key Information Stored

The table holds the translated, language-specific attributes for XML Publisher templates. Its structure is defined by two key unique constraints. The primary key (XDO_TEMPLATES_TL_PK) consists of APPLICATION_SHORT_NAME, TEMPLATE_CODE, and LANGUAGE, ensuring a unique translation entry for each template in each language. A second unique key (XDO_TEMPLATES_TL_UK1) enforces uniqueness on the combination of APPLICATION_SHORT_NAME, TEMPLATE_NAME, and LANGUAGE, preventing duplicate template display names within the same application and language. While specific column details beyond the keys are not enumerated in the provided metadata, translation tables typically include columns for the translated name (TEMPLATE_NAME) and description, along with standard WHO columns (CREATION_DATE, CREATED_BY, etc.) for auditing.

Common Use Cases and Queries

This table is primarily accessed for reporting on template availability by language and for data fixes related to template labels. A common administrative query is to identify templates missing translations for a specific language or to verify template names across locales. For example, to list all templates for the 'SQLAP' application with their English and French names, a developer might use a query such as:

  • SELECT b.template_code, en.template_name en_name, fr.template_name fr_name FROM xdo_templates_b b, xdo_templates_tl en, xdo_templates_tl fr WHERE b.application_short_name = en.application_short_name AND b.template_code = en.template_code AND en.language = 'US' AND b.application_short_name = fr.application_short_name AND b.template_code = fr.template_code AND fr.language = 'F' AND b.application_short_name = 'SQLAP';

Direct data manipulation (DML) on this table is not standard practice; template translations are typically managed through the XML Publisher Administrator responsibility or related APIs to maintain data integrity.

Related Objects

XDO_TEMPLATES_TL has a direct and mandatory relationship with its base table, XDO_TEMPLATES_B. The integrity between these tables is maintained by the shared primary key columns (APPLICATION_SHORT_NAME, TEMPLATE_CODE). The table is integral to the XML Publisher data model and is referenced by various internal APIs and seed data scripts within the XDO product. Any process or interface that retrieves a template's user-facing name for display will join to this translation table based on the user's session language.

  • Table: XDO_TEMPLATES_TL 12.1.1

    owner:XDO,  object_type:TABLE,  fnd_design_data:XDO.XDO_TEMPLATES_TL,  object_name:XDO_TEMPLATES_TL,  status:VALID,  product: XDO - XML Publisher ,  description: XDO_TEMPLATES_TL is a translation table for XDO_TEMPLATES_B. ,  implementation_dba_data: XDO.XDO_TEMPLATES_TL , 

  • Table: XDO_TEMPLATES_TL 12.2.2

    owner:XDO,  object_type:TABLE,  fnd_design_data:XDO.XDO_TEMPLATES_TL,  object_name:XDO_TEMPLATES_TL,  status:VALID,  product: XDO - XML Publisher ,  description: XDO_TEMPLATES_TL is a translation table for XDO_TEMPLATES_B. ,  implementation_dba_data: XDO.XDO_TEMPLATES_TL , 

  • View: XDO_TEMPLATES_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:XDO.XDO_TEMPLATES_VL,  object_name:XDO_TEMPLATES_VL,  status:VALID,  product: XDO - XML Publisher ,  description: XDO_TEMPLATES_VL is a view to join XDO_TEMPLATES_B and XDO_TEMPLATES_TL. ,  implementation_dba_data: APPS.XDO_TEMPLATES_VL , 

  • View: XDO_TEMPLATES_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:XDO.XDO_TEMPLATES_VL,  object_name:XDO_TEMPLATES_VL,  status:VALID,  product: XDO - XML Publisher ,  description: XDO_TEMPLATES_VL is a view to join XDO_TEMPLATES_B and XDO_TEMPLATES_TL. ,  implementation_dba_data: APPS.XDO_TEMPLATES_VL ,