Search Results cs_kb_attrs_b




Overview
Explore in AI Chat

Overview

The CS_KB_ATTRS_B table is a core data structure within the Oracle E-Business Suite (EBS) Service (CS) module, specifically designed for the Knowledge Base functionality. It serves as the base table for storing metadata definitions of attributes that can be associated with knowledge base elements. These attributes allow for the categorization, classification, and detailed description of knowledge content, enabling structured search and retrieval. Critically, the official ETRM documentation 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, its active role in the application's business logic was deprecated in a prior version (11i). It remains in the database primarily for referential integrity with other legacy objects and to support potential data migration paths, but it is not part of the current application's operational data model.

Key Information Stored

As the base table, CS_KB_ATTRS_B holds the primary, language-independent information for each attribute definition. The central column is ATTRIBUTE_ID, which is the unique primary key identifier for an attribute record. While the full column list is not detailed in the provided metadata, typical columns in such a base table would include technical metadata such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY for auditing, and likely columns defining the attribute's data type (e.g., VARCHAR2, NUMBER, DATE), maximum length, and whether it is mandatory. Descriptive, translatable information like the attribute's name and description would be stored in the corresponding translation table, CS_KB_ATTRS_TL, linked via the ATTRIBUTE_ID.

Common Use Cases and Queries

Given its deprecated status, there are no standard application use cases for this table in releases 12.1.1 or 12.2.2. Direct interaction is strongly discouraged as it is not part of the supported data model. However, it may be referenced in legacy data analysis or cleanup scripts. A typical query to identify any residual data and its relationships would be investigative in nature:

  • Identifying Existing Records: SELECT attribute_id, creation_date FROM cs.cs_kb_attrs_b;
  • Checking for Dependencies: A join to the translation table to see if any descriptive text remains: SELECT b.attribute_id, tl.name FROM cs.cs_kb_attrs_b b, cs.cs_kb_attrs_tl tl WHERE b.attribute_id = tl.attribute_id AND tl.language = USERENV('LANG');

Any operational reporting or integration must utilize the current, supported APIs and public views, not this deprecated table.

Related Objects

The ETRM metadata clearly outlines the foreign key relationships that define this table's legacy schema dependencies. The primary key (ATTRIBUTE_ID) is referenced by several other tables, indicating it was once part of a broader knowledge base attribute model:

  • CS_KB_ATTRS_TL: The translation table that holds the language-specific names and descriptions for the attribute.
  • CS_KB_ATTR_VALS_B: Likely stored the permissible values or instance values for list-type attributes.
  • CS_KB_ELE_TYPE_ATTRS: Served as a junction table associating attributes with specific element types.
  • CS_KB_SET_TYPE_ATTRS: Served as a junction table associating attributes with specific set types.

These related tables share the same deprecated status. Developers and DBAs should be aware of these relationships during schema analysis but must not build new functionality upon them.

  • 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_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 , 

  • View: CS_KB_ATTRS_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_KB_ATTRS_VL,  object_name:CS_KB_ATTRS_VL,  status:VALID,  product: CS - Service ,  description: Multi-lingual view for CS_KB_ATTRS_B and CS_KB_ATTRS_TL tables. ,  implementation_dba_data: APPS.CS_KB_ATTRS_VL , 

  • View: CS_KB_ATTRS_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_KB_ATTRS_VL,  object_name:CS_KB_ATTRS_VL,  status:VALID,  product: CS - Service ,  description: Multi-lingual view for CS_KB_ATTRS_B and CS_KB_ATTRS_TL tables. ,  implementation_dba_data: APPS.CS_KB_ATTRS_VL , 

  • 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_ATTRS_TL 12.2.2

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

  • Table: CS_KB_ATTRS_TL 12.1.1

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

  • 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 , 

  • Table: CS_KB_ELE_TYPE_ATTRS 12.1.1

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

  • Table: CS_KB_SET_TYPE_ATTRS 12.1.1

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

  • Table: CS_KB_SET_TYPE_ATTRS 12.2.2

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

  • Table: CS_KB_ELE_TYPE_ATTRS 12.2.2

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