Search Results cs_kb_attr_vals_tl




Overview
Explore in AI Chat

Overview

The CS_KB_ATTR_VALS_TL table is a translation table within the Oracle E-Business Suite Service (CS) module, specifically designed for the knowledge base functionality. Its primary role is to store translated versions of the descriptive content for knowledge base attribute values, enabling the support of multiple languages within the application. This allows service-related knowledge articles and their attributes to be presented in a user's preferred language. Crucially, the provided ETRM documentation explicitly states this table has been "Not used since before 11.5.8." This indicates that while the table structure exists in schemas for releases 12.1.1 and 12.2.2, it is a legacy artifact and is not actively populated or utilized by the application code in these versions. Its presence is maintained for potential upgrade compatibility but holds no operational data in a standard implementation.

Key Information Stored

As a translation table, CS_KB_ATTR_VALS_TL is structured to hold language-specific versions of text from its corresponding base table. The key columns, as defined by its primary and foreign keys, are:

  • ATTRIBUTE_VAL_ID: The unique identifier linking each row to its corresponding master record in the base table CS_KB_ATTR_VALS_B.
  • LANGUAGE: The code (e.g., 'US', 'DE', 'JA') representing the language of the translated text in this row. This column references the FND_LANGUAGES table.
  • SOURCE_LANG: Indicates the original language in which the data was entered. This also references FND_LANGUAGES and helps identify the source record for subsequent translations.

Typically, a translation table would also include descriptive columns like DESCRIPTION or MEANING to store the translated text itself, though the specific column names are not detailed in the provided metadata. The primary key combination of ATTRIBUTE_VAL_ID and LANGUAGE ensures only one translation per attribute value per language exists.

Common Use Cases and Queries

Given its deprecated status, there are no active application use cases for this table in Oracle EBS 12.1.1 or 12.2.2. Technical consultants or DBAs might encounter it only in specific legacy data analysis or during schema investigations. Sample queries would be purely diagnostic. For instance, checking if any data remains in the table would involve a simple count: SELECT COUNT(*) FROM cs.cs_kb_attr_vals_tl;. A query to examine its structure and potential leftover data might join to the base table and language table: SELECT tl.attribute_val_id, tl.language, l.language_name, b.meaning FROM cs.cs_kb_attr_vals_tl tl LEFT JOIN apps.fnd_languages l ON tl.language = l.language_code LEFT JOIN cs.cs_kb_attr_vals_b b ON tl.attribute_val_id = b.attribute_val_id WHERE ROWNUM < 10;. In any functional reporting or integration, this table should be ignored as it is not part of the active data model.

Related Objects

The ETRM metadata defines clear foreign key relationships for CS_KB_ATTR_VALS_TL, linking it to core application tables. These relationships are architectural, defining the table's intended role in the schema even though it is unused.

  • CS_KB_ATTR_VALS_B: This is the base table for knowledge base attribute values. The foreign key CS_KB_ATTR_VALS_TL.ATTRIBUTE_VAL_ID references the primary key in this table, establishing the master-detail relationship.
  • FND_LANGUAGES: The table is referenced twice. The LANGUAGE column is a foreign key to FND_LANGUAGES, validating the language code of the translation. The SOURCE_LANG column is also a foreign key to FND_LANGUAGES, identifying the original language of the source data.

The primary key constraint CS_KB_ATTR_VALS_TL_PK on (ATTRIBUTE_VAL_ID, LANGUAGE) enforces data integrity for the translation records. No other tables are documented as having foreign keys referencing this translation table, consistent with its deprecated state.