Search Results cs_kb_visibilities_tl




Overview
Explore in AI Chat

Overview

The CS_KB_VISIBILITIES_TL table is a translation table within the Oracle E-Business Suite (EBS) Service (CS) module, specifically for versions 12.1.1 and 12.2.2. Its primary role is to support the multilingual capabilities of the Knowledge Base (KB) by storing translated descriptions for visibility codes. In the context of Service Knowledge Management, a visibility defines the access level or audience for a piece of knowledge content (e.g., internal, customer-facing, partner-facing). This table enables the system to present these visibility classifications in the language of the end-user's session, which is a critical requirement for global deployments of Oracle EBS.

Key Information Stored

The table stores language-specific translations for visibility names or descriptions. Based on its structure as a translation table and standard Oracle EBS conventions, its critical columns include:

  • VISIBILITY_ID: The foreign key that links the translation to the base data record in the CS_KB_VISIBILITIES_B table. This is part of the table's primary key.
  • LANGUAGE: The ISO code for the language of the translated text (e.g., 'US' for American English). This is also part of the primary key, ensuring one translation per language per visibility ID.
  • SOURCE_LANG: A column typically present in EBS translation tables that indicates the original language of the source data.
  • DESCRIPTION (or a similarly named column): The column holding the actual translated text for the visibility name, which is displayed in the user interface.

The primary key constraint, CS_KB_VISIBILITIES_TL_PK, enforces uniqueness on the combination of VISIBILITY_ID and LANGUAGE.

Common Use Cases and Queries

The primary use case is retrieving a user-friendly visibility description in the current application session language for reporting or UI display. A common SQL pattern involves joining this table with its base table and filtering by the session language. For example, to list all visibilities with their translated descriptions:

SELECT b.VISIBILITY_CODE, tl.DESCRIPTION
FROM CS_KB_VISIBILITIES_B b,
    CS_KB_VISIBILITIES_TL tl
WHERE b.VISIBILITY_ID = tl.VISIBILITY_ID
AND tl.LANGUAGE = userenv('LANG');

This table is also central during the implementation of additional languages. Administrators or translators populate this table with new translations, which are then automatically served by the application's multilingual architecture. Reporting on knowledge article access controls by audience type across different regions would also rely on this table for accurate labeling.

Related Objects

CS_KB_VISIBILITIES_TL has a direct and critical relationship with its base table, as documented in the provided metadata.

  • CS_KB_VISIBILITIES_B: This is the base table that stores the core, language-independent attributes for a visibility (e.g., VISIBILITY_CODE). The foreign key relationship is defined from CS_KB_VISIBILITIES_TL.VISIBILITY_ID to CS_KB_VISIBILITIES_B. All translations are dependent on a corresponding record existing in this base table.

While not explicitly listed in the provided metadata, this visibility data is foundational to the Service Knowledge Base. It is likely referenced by other core knowledge objects, such as CS_KB_SETS_B (knowledge article sets) or CS_KB_ARTICLES_B, which would use the VISIBILITY_ID to control and categorize article access.