Search Results cs_kb_elements_b




Overview
Explore in AI Chat

Overview

The CS_KB_ELEMENTS_B table is the core base table for storing knowledge base elements within Oracle E-Business Suite Service (CS) module, versions 12.1.1 and 12.2.2. It serves as the central repository for all discrete pieces of knowledge content, forming the foundational data layer for the application's knowledge management capabilities. An element represents a single, reusable unit of information, such as a solution article, a troubleshooting step, a definition, or a FAQ. The table's role is to maintain the essential metadata and structural definition for each element, enabling the creation, linking, categorization, and retrieval of knowledge to support service resolution and customer self-service.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the primary and foreign key relationships define the critical attributes. The primary key, ELEMENT_ID, uniquely identifies every knowledge element in the system. The foreign key relationship to CS_KB_ELEMENT_TYPES_B via the ELEMENT_TYPE_ID column categorizes each element (e.g., Solution, Problem, Cause). Other essential columns typically found in such a base table include creation and last update dates (CREATION_DATE, LAST_UPDATE_DATE), the user IDs responsible for those actions (CREATED_BY, LAST_UPDATED_BY), and a status flag to manage the element's lifecycle (e.g., DRAFT, PUBLISHED, ARCHIVED). The table structure is designed for transactional integrity and efficient access to the element's core attributes.

Common Use Cases and Queries

This table is central to numerous knowledge management operations. Common use cases include generating reports on the knowledge base inventory, tracking the creation and modification of content, and building interfaces for searching and linking elements. A frequent query pattern involves joining with the translated table (CS_KB_ELEMENTS_TL) to retrieve element titles and content in a specific language. For example, to list all published solution elements, a query might be: SELECT b.element_id, tl.title FROM cs_kb_elements_b b, cs_kb_elements_tl tl WHERE b.element_id = tl.element_id AND b.element_type_id = (SELECT element_type_id FROM cs_kb_element_types_b WHERE name = 'SOLUTION') AND b.status = 'PUBLISHED' AND tl.language = USERENV('LANG');. Another common scenario is analyzing element relationships by joining with CS_KB_ELE_ELES to understand how solutions link to problems or causes.

Related Objects

CS_KB_ELEMENTS_B has extensive relationships within the knowledge base schema, as documented by its foreign keys. Key related objects include:

  • CS_KB_ELEMENTS_TL: The translated table that holds language-specific titles and content for each ELEMENT_ID.
  • CS_KB_ELEMENT_TYPES_B: Provides the type classification for an element via ELEMENT_TYPE_ID.
  • CS_KB_ELE_ATTR_VALS: Stores extended attribute values defined for an element.
  • CS_KB_ELEMENT_LINKS & CS_KB_ELE_ELES: Manage associations between elements (e.g., linking a solution to a problem). CS_KB_ELE_ELES references the table twice (ELEMENT_ID_1, ELEMENT_ID_2) to model bidirectional relationships.
  • CS_KB_SET_ELES: Associates elements with categorization sets or folders.
  • CS_KB_ELE_CHG_HISTS: Tracks the audit history of changes made to each element.
These relationships illustrate that CS_KB_ELEMENTS_B is the central hub from which all descriptive data, categorization, linking, and history for a knowledge element radiate.

  • Table: CS_KB_ELEMENTS_B 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_ELEMENTS_B,  object_name:CS_KB_ELEMENTS_B,  status:VALID,  product: CS - Service ,  description: Knowledge base elements (base table). ,  implementation_dba_data: CS.CS_KB_ELEMENTS_B , 

  • Table: CS_KB_ELEMENTS_B 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_ELEMENTS_B,  object_name:CS_KB_ELEMENTS_B,  status:VALID,  product: CS - Service ,  description: Knowledge base elements (base table). ,  implementation_dba_data: CS.CS_KB_ELEMENTS_B , 

  • Table: CS_KB_ELE_ELES 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_ELE_ELES,  object_name:CS_KB_ELE_ELES,  status:VALID,  product: CS - Service ,  description: Knowledge base element elements. This table implements the many to many relationship among the elements. ,  implementation_dba_data: CS.CS_KB_ELE_ELES , 

  • Table: CS_KB_ELE_ELES 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_ELE_ELES,  object_name:CS_KB_ELE_ELES,  status:VALID,  product: CS - Service ,  description: Knowledge base element elements. This table implements the many to many relationship among the elements. ,  implementation_dba_data: CS.CS_KB_ELE_ELES , 

  • View: CS_KB_ELEMENTS_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_KB_ELEMENTS_VL,  object_name:CS_KB_ELEMENTS_VL,  status:VALID,  product: CS - Service ,  description: Multi-lingual view for CS_KB_ELEMENTS_B and CS_KB_ELEMENTS_TL tables. ,  implementation_dba_data: APPS.CS_KB_ELEMENTS_VL , 

  • View: CS_KB_ELEMENTS_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_KB_ELEMENTS_VL,  object_name:CS_KB_ELEMENTS_VL,  status:VALID,  product: CS - Service ,  description: Multi-lingual view for CS_KB_ELEMENTS_B and CS_KB_ELEMENTS_TL tables. ,  implementation_dba_data: APPS.CS_KB_ELEMENTS_VL , 

  • Table: CS_KB_ELEMENTS_TL 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_ELEMENTS_TL,  object_name:CS_KB_ELEMENTS_TL,  status:VALID,  product: CS - Service ,  description: Knowledge base elements (translation table). ,  implementation_dba_data: CS.CS_KB_ELEMENTS_TL , 

  • Table: CS_KB_ELE_CHG_HISTS 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_ELE_CHG_HISTS,  object_name:CS_KB_ELE_CHG_HISTS,  status:VALID,  product: CS - Service ,  description: Knowledge base element change histories. Not used since before 11.5.8 ,  implementation_dba_data: CS.CS_KB_ELE_CHG_HISTS , 

  • Table: CS_KB_ELEMENT_TYPES_B 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_ELEMENT_TYPES_B,  object_name:CS_KB_ELEMENT_TYPES_B,  status:VALID,  product: CS - Service ,  description: Knowledge base element types (base table). ,  implementation_dba_data: CS.CS_KB_ELEMENT_TYPES_B , 

  • 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_SET_ELES 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SET_ELES,  object_name:CS_KB_SET_ELES,  status:VALID,  product: CS - Service ,  description: Knowledge base set elements. This table implements the many to many relationship between sets and elements. ,  implementation_dba_data: CS.CS_KB_SET_ELES , 

  • Table: CS_KB_ELEMENT_LINKS 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_ELEMENT_LINKS,  object_name:CS_KB_ELEMENT_LINKS,  status:VALID,  product: CS - Service ,  description: Knowledge base element links. This table implements the one to many relationship between an element and external entities. ,  implementation_dba_data: CS.CS_KB_ELEMENT_LINKS , 

  • Table: CS_KB_ELEMENT_TYPES_B 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_ELEMENT_TYPES_B,  object_name:CS_KB_ELEMENT_TYPES_B,  status:VALID,  product: CS - Service ,  description: Knowledge base element types (base table). ,  implementation_dba_data: CS.CS_KB_ELEMENT_TYPES_B , 

  • Table: CS_KB_ELEMENTS_TL 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_ELEMENTS_TL,  object_name:CS_KB_ELEMENTS_TL,  status:VALID,  product: CS - Service ,  description: Knowledge base elements (translation table). ,  implementation_dba_data: CS.CS_KB_ELEMENTS_TL , 

  • Table: CS_KB_ELEMENT_LINKS 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_ELEMENT_LINKS,  object_name:CS_KB_ELEMENT_LINKS,  status:VALID,  product: CS - Service ,  description: Knowledge base element links. This table implements the one to many relationship between an element and external entities. ,  implementation_dba_data: CS.CS_KB_ELEMENT_LINKS , 

  • Table: CS_KB_ELE_CHG_HISTS 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_ELE_CHG_HISTS,  object_name:CS_KB_ELE_CHG_HISTS,  status:VALID,  product: CS - Service ,  description: Knowledge base element change histories. Not used since before 11.5.8 ,  implementation_dba_data: CS.CS_KB_ELE_CHG_HISTS , 

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

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SET_ELES,  object_name:CS_KB_SET_ELES,  status:VALID,  product: CS - Service ,  description: Knowledge base set elements. This table implements the many to many relationship between sets and elements. ,  implementation_dba_data: CS.CS_KB_SET_ELES , 

  • View: CS_KB_ELEMENTS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_KB_ELEMENTS_V,  object_name:CS_KB_ELEMENTS_V,  status:VALID,  product: CS - Service ,  description: A view on top of CS_KB_ELEMENTS_VL and CS_KB_ELEMENT_TYPES_VL. ,  implementation_dba_data: APPS.CS_KB_ELEMENTS_V , 

  • View: CS_KB_ELEMENTS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_KB_ELEMENTS_V,  object_name:CS_KB_ELEMENTS_V,  status:VALID,  product: CS - Service ,  description: A view on top of CS_KB_ELEMENTS_VL and CS_KB_ELEMENT_TYPES_VL. ,  implementation_dba_data: APPS.CS_KB_ELEMENTS_V , 

  • View: CS_SR_KB_NOTE_LINKS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_KB_NOTE_LINKS_V,  object_name:CS_SR_KB_NOTE_LINKS_V,  status:VALID,  product: CS - Service ,  description: This view combines JTF notes with knowledge management element links and set links. Used by Oracle Support for integration from Service Requests to Knowledge Management. ,  implementation_dba_data: APPS.CS_SR_KB_NOTE_LINKS_V , 

  • View: CS_KB_INTEGRATION_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_KB_INTEGRATION_V,  object_name:CS_KB_INTEGRATION_V,  status:VALID,  product: CS - Service ,  description: View combines JTF notes with knowledge management element links and set links. Used by Knowledge Management for integration from any application module. ,  implementation_dba_data: APPS.CS_KB_INTEGRATION_V , 

  • View: CS_SR_KB_NOTE_LINKS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_KB_NOTE_LINKS_V,  object_name:CS_SR_KB_NOTE_LINKS_V,  status:VALID,  product: CS - Service ,  description: This view combines JTF notes with knowledge management element links and set links. Used by Oracle Support for integration from Service Requests to Knowledge Management. ,  implementation_dba_data: APPS.CS_SR_KB_NOTE_LINKS_V , 

  • View: CS_KB_INTEGRATION_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_KB_INTEGRATION_V,  object_name:CS_KB_INTEGRATION_V,  status:VALID,  product: CS - Service ,  description: View combines JTF notes with knowledge management element links and set links. Used by Knowledge Management for integration from any application module. ,  implementation_dba_data: APPS.CS_KB_INTEGRATION_V ,