Search Results cs_kb_attr_vals_b




Overview
Explore in AI Chat

Overview

The CS_KB_ATTR_VALS_B table is a core data structure within the Oracle E-Business Suite Service (CS) module, specifically designed for the Knowledge Base (KB) functionality. It serves as the base table for storing discrete attribute values that can be assigned to knowledge base elements and sets, enabling the categorization and detailed description of solution articles and other knowledge assets. However, a critical piece of information from the official documentation is that this table has been deprecated for a significant period. It is explicitly noted as "Not used since before 11.5.8," meaning it was rendered obsolete prior to the 11.5.8 release and remains in the schema primarily for legacy data reference or upgrade compatibility in releases 12.1.1 and 12.2.2. Its role in contemporary implementations is therefore historical rather than functional.

Key Information Stored

The table's primary purpose was to store the unique definitions of permissible values for knowledge base attributes. The central column is ATTRIBUTE_VAL_ID, which is the primary key (PK) and uniquely identifies each attribute value record. A crucial foreign key column is ATTRIBUTE_ID, which links the value to its parent attribute definition in the CS_KB_ATTRS_B table. While the full column list is not detailed in the provided excerpt, a base table in a multi-language architecture like Oracle EBS typically contains non-translatable columns such as creation date, created by, last update date, and last updated by. The translatable data, such as the display name of the attribute value, would be stored in the corresponding translation table, CS_KB_ATTR_VALS_TL.

Common Use Cases and Queries

Given its deprecated status, there are no active use cases for this table in standard Oracle EBS operations post-11.5.8. Any existing data is considered legacy. In the rare scenario of auditing historical data or managing a technical upgrade, queries would typically involve joining to its related tables. A sample query to retrieve legacy attribute value information would be:

SELECT b.ATTRIBUTE_VAL_ID, b.ATTRIBUTE_ID, tl.NAME
FROM CS.CS_KB_ATTR_VALS_B b,
     CS.CS_KB_ATTR_VALS_TL tl
WHERE b.ATTRIBUTE_VAL_ID = tl.ATTRIBUTE_VAL_ID
AND tl.LANGUAGE = USERENV('LANG');

Reporting or data extraction directly from this table is not part of standard business processes in supported versions.

Related Objects

The table maintains defined relationships with several other knowledge base objects, as per the foreign key metadata provided:

  • CS_KB_ATTRS_B: The parent table for attribute definitions. Joined via CS_KB_ATTR_VALS_B.ATTRIBUTE_ID = CS_KB_ATTRS_B.ATTRIBUTE_ID.
  • CS_KB_ATTR_VALS_TL: The translation table that stores language-specific names for the attribute values. Joined via CS_KB_ATTR_VALS_B.ATTRIBUTE_VAL_ID = CS_KB_ATTR_VALS_TL.ATTRIBUTE_VAL_ID.
  • CS_KB_ELE_ATTR_VALS: A table that historically assigned these attribute values to specific knowledge base elements. Joined via CS_KB_ATTR_VALS_B.ATTRIBUTE_VAL_ID = CS_KB_ELE_ATTR_VALS.ATTRIBUTE_VAL_ID.
  • CS_KB_SET_ATTR_VALS: A table that historically assigned these attribute values to knowledge base sets. Joined via CS_KB_ATTR_VALS_B.ATTRIBUTE_VAL_ID = CS_KB_SET_ATTR_VALS.ATTRIBUTE_VAL_ID.
  • Table: CS_KB_ATTR_VALS_B 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_ATTR_VALS_B,  object_name:CS_KB_ATTR_VALS_B,  status:VALID,  product: CS - Service ,  description: Knowledge base attribute values (base table). Not used since before 11.5.8 ,  implementation_dba_data: CS.CS_KB_ATTR_VALS_B , 

  • Table: CS_KB_ATTR_VALS_B 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_ATTR_VALS_B,  object_name:CS_KB_ATTR_VALS_B,  status:VALID,  product: CS - Service ,  description: Knowledge base attribute values (base table). Not used since before 11.5.8 ,  implementation_dba_data: CS.CS_KB_ATTR_VALS_B , 

  • View: CS_KB_ATTR_VALS_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_KB_ATTR_VALS_VL,  object_name:CS_KB_ATTR_VALS_VL,  status:VALID,  product: CS - Service ,  description: Multi-lingual view for CS_KB_ATTR_VALS_B and CS_KB_ATTR_VALS_TL tables. ,  implementation_dba_data: APPS.CS_KB_ATTR_VALS_VL , 

  • View: CS_KB_ATTR_VALS_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_KB_ATTR_VALS_VL,  object_name:CS_KB_ATTR_VALS_VL,  status:VALID,  product: CS - Service ,  description: Multi-lingual view for CS_KB_ATTR_VALS_B and CS_KB_ATTR_VALS_TL tables. ,  implementation_dba_data: APPS.CS_KB_ATTR_VALS_VL , 

  • Table: CS_KB_ATTR_VALS_TL 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_ATTR_VALS_TL,  object_name:CS_KB_ATTR_VALS_TL,  status:VALID,  product: CS - Service ,  description: Knowledge base attribute values (translation table). Not used since before 11.5.8 ,  implementation_dba_data: CS.CS_KB_ATTR_VALS_TL , 

  • Table: CS_KB_ATTR_VALS_TL 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_ATTR_VALS_TL,  object_name:CS_KB_ATTR_VALS_TL,  status:VALID,  product: CS - Service ,  description: Knowledge base attribute values (translation table). Not used since before 11.5.8 ,  implementation_dba_data: CS.CS_KB_ATTR_VALS_TL , 

  • Table: CS_KB_SET_ATTR_VALS 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SET_ATTR_VALS,  object_name:CS_KB_SET_ATTR_VALS,  status:VALID,  product: CS - Service ,  description: Knowledge base set attribute values. This table implements the many to many relationship between sets and attribute values. Not used since before 11.5.8 ,  implementation_dba_data: CS.CS_KB_SET_ATTR_VALS , 

  • Table: CS_KB_ELE_ATTR_VALS 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_ELE_ATTR_VALS,  object_name:CS_KB_ELE_ATTR_VALS,  status:VALID,  product: CS - Service ,  description: Knowledge base element attribute values. This table implements the many to many relationship between elements and attribute values. Not used since before 11.5.8 ,  implementation_dba_data: CS.CS_KB_ELE_ATTR_VALS , 

  • Table: CS_KB_ATTRS_B 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_ATTRS_B,  object_name:CS_KB_ATTRS_B,  status:VALID,  product: CS - Service ,  description: Knowledge base attributes (base table). Not used since before 11.5.8 ,  implementation_dba_data: CS.CS_KB_ATTRS_B , 

  • Table: CS_KB_ATTRS_B 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_ATTRS_B,  object_name:CS_KB_ATTRS_B,  status:VALID,  product: CS - Service ,  description: Knowledge base attributes (base table). Not used since before 11.5.8 ,  implementation_dba_data: CS.CS_KB_ATTRS_B , 

  • Table: CS_KB_ELE_ATTR_VALS 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_ELE_ATTR_VALS,  object_name:CS_KB_ELE_ATTR_VALS,  status:VALID,  product: CS - Service ,  description: Knowledge base element attribute values. This table implements the many to many relationship between elements and attribute values. Not used since before 11.5.8 ,  implementation_dba_data: CS.CS_KB_ELE_ATTR_VALS , 

  • Table: CS_KB_SET_ATTR_VALS 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SET_ATTR_VALS,  object_name:CS_KB_SET_ATTR_VALS,  status:VALID,  product: CS - Service ,  description: Knowledge base set attribute values. This table implements the many to many relationship between sets and attribute values. Not used since before 11.5.8 ,  implementation_dba_data: CS.CS_KB_SET_ATTR_VALS ,