Search Results cs_kb_set_types_tl




Overview
Explore in AI Chat

Overview

The CS_KB_SET_TYPES_TL table is a core translation table within the Oracle E-Business Suite (EBS) Service (CS) module, specifically for the Knowledge Base (KB) functionality. It stores the multilingual descriptions and names for knowledge base set types, enabling the application to support a global user base. Its primary role is to separate translatable user-facing text from the base transactional data, which resides in the CS_KB_SET_TYPES_B table. This architecture is a standard Oracle EBS design pattern, allowing for the independent maintenance of language-specific content without affecting the core business logic or relationships defined in the base table.

Key Information Stored

This table holds the language-specific textual attributes for each knowledge base set type. The critical columns, as indicated by the primary and foreign key constraints, are SET_TYPE_ID, LANGUAGE, and SOURCE_LANG. The SET_TYPE_ID is the foreign key linking each translation row to its corresponding master record in CS_KB_SET_TYPES_B. The LANGUAGE column stores the language code (e.g., 'US', 'FR') and is a foreign key to FND_LANGUAGES, identifying the language of the translated text for that row. The SOURCE_LANG column, also a foreign key to FND_LANGUAGES, typically indicates the original language in which the data was entered. Other columns, common to EBS translation tables, would include user-descriptive fields like NAME and DESCRIPTION, which contain the actual translated text, and standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN).

Common Use Cases and Queries

The primary use case is retrieving set type descriptions in a user's session language for UI display, reports, and integrations. A common SQL pattern joins this table to its base table and filters by the current session language using the FND_GLOBAL.APPS_INITIALIZE function or the USERENV('LANG') context. For example, to list all active set types in the current language:

  • SELECT sttl.name, sttl.description FROM cs_kb_set_types_b stb, cs_kb_set_types_tl sttl WHERE stb.set_type_id = sttl.set_type_id AND sttl.language = USERENV('LANG') AND stb.start_date_active < SYSDATE AND (stb.end_date_active IS NULL OR stb.end_date_active > SYSDATE);

Another critical use case is data migration or setup, where scripts must populate this table with translated values for each implemented language. Reporting on the availability of translations for audit purposes is also a common administrative task.

Related Objects

This table has defined foreign key relationships with several key EBS objects, as documented in the metadata:

  • CS_KB_SET_TYPES_B: The base transactional table. The relationship is defined on CS_KB_SET_TYPES_TL.SET_TYPE_ID = CS_KB_SET_TYPES_B.SET_TYPE_ID. This is the most critical join for any operational query.
  • FND_LANGUAGES: The application's language master table. Two separate foreign keys exist:
    • On CS_KB_SET_TYPES_TL.LANGUAGE: Validates the language code of the translation.
    • On CS_KB_SET_TYPES_TL.SOURCE_LANG: Validates the code for the source language of the record.

This table is also referenced by any EBS forms, APIs, or views that present knowledge base set type information in a multilingual context, such as the CS_KB_SET_TYPES_VL view (if it exists), which would perform a standard join between the _B and _TL tables.