Search Results cs_kb_sets_tl

Overview

The CS_KB_SETS_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 multilingual descriptions and names for Knowledge Base Sets, which are logical groupings of articles, solutions, and other content used to organize and partition a knowledge repository. This table enables the support of multiple languages within a single EBS instance, allowing set descriptions to be presented in a user's preferred language. Its role is to provide the translated, user-facing text that corresponds to the base definition data stored in its parent table, CS_KB_SETS_B.

Key Information Stored

The table's primary purpose is to hold language-specific textual attributes. Its structure is defined by a composite primary key and foreign key relationships that enforce data integrity. The critical columns include:

• SET_ID: The foreign key linking the translation to the base record in CS_KB_SETS_B. It is part of the primary key.
• LANGUAGE: The code (e.g., 'US', 'DE') identifying the language of the translated row, sourced from FND_LANGUAGES. It is part of the primary key.
• SOURCE_LANG: Indicates the original language in which the data was created, also sourced from FND_LANGUAGES. This is used by the Oracle translation architecture to identify rows needing translation.
• NAME: The translated name of the Knowledge Base Set as displayed in the application interface.
• DESCRIPTION: The detailed, translated description of the set's purpose and content.

Common Use Cases and Queries

This table is primarily accessed for user interface rendering and multilingual reporting. A common operational query retrieves the set name in a user's session language for display in forms or search results. For example, to fetch the translated set details for a specific ID in the current session language, a query would join with FND_LANGUAGES and filter on the language code. Reporting use cases often involve extracting a consolidated list of all set names and descriptions across multiple installed languages for translation audits or content management. Database administrators may query this table to identify sets missing translations in key languages by checking for rows where the SOURCE_LANG equals the LANGUAGE, indicating they have not yet been translated from the seed data.

Related Objects

The CS_KB_SETS_TL table has integral relationships with several key EBS objects. Its primary dependency is on CS_KB_SETS_B, the base table that holds the non-translatable attributes and operational data for Knowledge Base Sets. The foreign key on SET_ID enforces this relationship. For language code validation and reference, it depends on the FND_LANGUAGES table twice: once for the LANGUAGE column and once for the SOURCE_LANG column. In application logic, this table is typically accessed via views that automatically handle language filtering, and it is maintained through the standard Oracle Application Object Library (AOL) translation utilities and forms within the Service Knowledge Base setup.