Search Results cs_kb_element_types_tl




Overview
Explore in AI Chat

Overview

The CS_KB_ELEMENT_TYPES_TL table is a core translation table within the Oracle E-Business Suite Service (CS) module, specifically for the Knowledge Base (KB) functionality. It stores the translated names and descriptions for element types, which are fundamental categories used to classify and organize content within the knowledge repository. This table enables the support of multiple languages in a single EBS installation, allowing user-facing element type labels to be displayed in a user's preferred language. Its role is to provide the multilingual layer for the base data stored in the CS_KB_ELEMENT_TYPES_B table, a critical component for global deployments of Oracle Service.

Key Information Stored

The table's primary purpose is to hold language-specific translations. Its structure is defined by a composite primary key consisting of ELEMENT_TYPE_ID and LANGUAGE. The ELEMENT_TYPE_ID column is a foreign key that links each translation row to its corresponding base record in CS_KB_ELEMENT_TYPES_B. The LANGUAGE column identifies the language code (e.g., 'US' for American English) for the translation, referencing the FND_LANGUAGES table. A critical column is SOURCE_LANG, which indicates the original language in which the data was entered; this is also a foreign key to FND_LANGUAGES and is used by the Oracle translation architecture to identify seed data. The table's key translatable columns typically include NAME and DESCRIPTION, which store the translated text for the element type's label and explanatory text, respectively.

Common Use Cases and Queries

This table is primarily accessed by the application's user interface logic to render language-appropriate labels for knowledge element types. A common reporting use case involves extracting a list of all available element types with their translations for a specific language to support content management audits. For technical troubleshooting, one might query to identify missing translations for a newly installed language. A typical SQL pattern joins the translation table with its base table and the languages table:

  • SELECT b.element_type_id, tl.name, tl.description, tl.language FROM cs_kb_element_types_b b, cs_kb_element_types_tl tl WHERE b.element_type_id = tl.element_type_id AND tl.language = USERENV('LANG');
  • SELECT * FROM cs_kb_element_types_tl WHERE element_type_id = <ID> ORDER BY language;

Related Objects

CS_KB_ELEMENT_TYPES_TL has defined foreign key relationships with several key EBS objects, as documented in the provided metadata. Its primary relationship is with the base table CS_KB_ELEMENT_TYPES_B via the ELEMENT_TYPE_ID column. This is a one-to-many relationship where one base record can have multiple translation records. Furthermore, it has two distinct foreign key relationships with the foundational FND_LANGUAGES table. The first links the LANGUAGE column to FND_LANGUAGES to validate the translation language code. The second links the SOURCE_LANG column to FND_LANGUAGES to validate the code for the original source language of the data. These relationships ensure referential integrity and proper functioning of the Oracle Applications translation mechanism.