Search Results cs_tp_templates_tl




Overview
Explore in AI Chat

Overview

The CS_TP_TEMPLATES_TL table is a core translation table within the Oracle E-Business Suite (EBS) Service (CS) module, specifically supporting the Template Driven Service Request (SR) functionality. Its primary role is to store the language-specific, translatable attributes of Service Request templates. This table enables the multi-language support (MLS) capability for template definitions, allowing organizations to maintain template names, descriptions, and other user-facing text in multiple installed base languages. It operates in conjunction with its base table, CS_TP_TEMPLATES_B, which holds the non-translatable, language-independent template data.

Key Information Stored

The table stores the translated text for each Service Request template across different languages. Its structure is defined by a composite primary key consisting of TEMPLATE_ID and LANGUAGE. The TEMPLATE_ID column is a foreign key that uniquely links each row to a master template record in the CS_TP_TEMPLATES_B table. The LANGUAGE column holds the language code (e.g., 'US' for American English) for the translation. The most critical data columns typically include TEMPLATE_NAME and DESCRIPTION, which contain the translated, user-visible name and explanatory text for the template. Additional columns may exist for other translatable attributes, following the standard EBS Translation Table (TL) naming and design conventions.

Common Use Cases and Queries

This table is central to any process that displays or reports on Service Request templates in a multi-lingual environment. Common scenarios include generating localized template picklists within the SR creation UI, producing translated template documentation, and auditing template translations. A fundamental query involves joining this table with its base table to retrieve a complete template definition for a session's current language. For example:

  • SELECT b.template_id, tl.template_name, tl.description FROM cs_tp_templates_b b, cs_tp_templates_tl tl WHERE b.template_id = tl.template_id AND tl.language = USERENV('LANG');

Another common pattern is to query for templates missing translations in a specific target language by performing an outer join between the base table and the TL table filtered for that language.

Related Objects

The CS_TP_TEMPLATES_TL table has a direct and singular dependency relationship with its corresponding base table, as documented in the provided metadata.

  • Primary Key: CS_TP_T_TL_PK on columns (LANGUAGE, TEMPLATE_ID).
  • Foreign Key (References): The table contains a foreign key where CS_TP_TEMPLATES_TL.TEMPLATE_ID references CS_TP_TEMPLATES_B. This enforces referential integrity, ensuring every translation record is associated with a valid master template.

All transactional and reporting logic for template-driven Service Requests will ultimately reference this translation table via its base table to present localized content to the user.