Search Results cs_kb_category_groups_tl




Overview
Explore in AI Chat

Overview

The CS_KB_CATEGORY_GROUPS_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, language-specific names and descriptions for Knowledge Base category groups. Its primary role is to support the multilingual capabilities of Oracle EBS, enabling the display of category group information in the language of the user's session. This table works in conjunction with its base table, CS_KB_CATEGORY_GROUPS_B, which holds the language-independent attributes. This separation of translatable and non-translatable data is a standard architectural pattern in Oracle Applications.

Key Information Stored

The table's structure is defined by its primary key, which consists of the CATEGORY_GROUP_ID and LANGUAGE columns. The CATEGORY_GROUP_ID is a foreign key that links each translated row to its corresponding master record in the CS_KB_CATEGORY_GROUPS_B table. The LANGUAGE column holds the language code (e.g., 'US' for American English) for the translation. The most critical data columns are NAME and DESCRIPTION, which contain the translated text for the category group's label and explanatory text, respectively. Additional standard columns like CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN track the row's audit history.

Common Use Cases and Queries

The primary use case is retrieving the user-visible name of a category group for reporting, data extracts, or custom application logic within a specific language context. A typical query joins the translation table to its base table using the NLS_LANGUAGE session parameter to filter for the correct translation. For example, to list all category group names in the current session language, one would use:

  • SELECT b.CATEGORY_GROUP_ID, tl.NAME, tl.DESCRIPTION
  • FROM CS_KB_CATEGORY_GROUPS_B b,
  • CS_KB_CATEGORY_GROUPS_TL tl
  • WHERE b.CATEGORY_GROUP_ID = tl.CATEGORY_GROUP_ID
  • AND tl.LANGUAGE = USERENV('LANG');

Administrative use cases include seeding new translations or updating existing ones via direct SQL or through the standard Oracle Applications translation utilities.

Related Objects

This table has a direct and fundamental relationship with its base table, as documented in the provided metadata. The foreign key relationship is:

  • CS_KB_CATEGORY_GROUPS_B: This is the primary referenced table. The column CS_KB_CATEGORY_GROUPS_TL.CATEGORY_GROUP_ID is a foreign key to CS_KB_CATEGORY_GROUPS_B. This relationship ensures that every translation record is associated with a valid master category group record. The join condition for queries is typically CS_KB_CATEGORY_GROUPS_TL.CATEGORY_GROUP_ID = CS_KB_CATEGORY_GROUPS_B.CATEGORY_GROUP_ID.

This table is also integral to the overall Knowledge Base category hierarchy, which may involve other related entities like CS_KB_CATEGORIES_B and CS_KB_CATEGORIES_TL.