Search Results cs_kb_set_eles




Overview
Explore in AI Chat

Overview

The CS_KB_SET_ELES table is a fundamental junction table within the Oracle E-Business Suite (EBS) Service (CS) module, specifically supporting the knowledge base functionality. Its primary role is to implement a many-to-many relationship between knowledge base sets (CS_KB_SETS_B) and knowledge base elements (CS_KB_ELEMENTS_B). This structure is critical for organizing and categorizing reusable content, such as solutions, articles, or diagnostic steps, allowing a single element to belong to multiple logical sets and a single set to contain numerous elements. The table is essential for the underlying data model that powers the knowledge management and service resolution capabilities in Oracle EBS versions 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is concise, designed specifically to manage the associative relationship. The two primary columns form a composite primary key. The SET_ID column stores the unique identifier of a knowledge base set, linking to the CS_KB_SETS_B table. The ELEMENT_ID column stores the unique identifier of a knowledge base element, linking to the CS_KB_ELEMENTS_B table. Together, each row in this table represents a single membership link, documenting that a specific element is included within a specific set. The integrity of these relationships is enforced by the primary key constraint (CS_KB_SET_ELES_PK) and the two documented foreign key constraints.

Common Use Cases and Queries

This table is central to queries that retrieve all elements belonging to a particular knowledge set or to find all sets that contain a given element. A common reporting use case involves listing the complete hierarchy of content for a service category. For instance, support analysts may run queries to fetch all solution elements for a product family defined by a set. A typical SQL pattern to retrieve all elements for a specific set name would involve joining the three core tables:

  • SELECT ele.element_number, ele.title FROM cs_kb_elements_b ele, cs_kb_set_eles se, cs_kb_sets_b s WHERE se.set_id = s.set_id AND se.element_id = ele.element_id AND s.name = '&SET_NAME';

Data maintenance operations, such as adding an element to multiple sets or purging links for an obsolete set, are also performed directly on this table, often via custom scripts or administrative interfaces.

Related Objects

The CS_KB_SET_ELES table has direct, integral dependencies with two key base tables, as defined by its foreign keys. The SET_ID column references the CS_KB_SETS_B table, which stores the definition and metadata for knowledge sets. The ELEMENT_ID column references the CS_KB_ELEMENTS_B table, which is the master repository for knowledge element content. This table is a core component of the CS knowledge base schema; therefore, any application forms, reports, or public APIs that manage set-element relationships (such as the CS_KB_SET_PUB package or the Solution Manager user interface) will ultimately perform DML operations on this junction table. It sits at the intersection of the two primary content organization entities in the knowledge base.

  • 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_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_SET_ELEMENTS_V 12.1.1

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

  • View: CS_KB_SET_ELEMENTS_V 12.2.2

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

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

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

  • Table: CS_KB_SETS_B 12.1.1

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