Search Results cs_kb_sets_b

Overview

The CS_KB_SETS_B table is the core base table for storing knowledge base set definitions within Oracle E-Business Suite Service (CS) modules, specifically for versions 12.1.1 and 12.2.2. It functions as the central repository for the metadata that defines a "set," which is a fundamental container for organizing knowledge content. A set can represent a solution, a collection of related articles, a FAQ library, or other structured information repositories. This table holds the foundational attributes of a set, while related tables manage multilingual descriptions, content, categories, and usage tracking. Its primary role is to establish the unique identity and core properties of a knowledge object, enabling the structured management, retrieval, and workflow processing of service knowledge.

Key Information Stored

While the provided ETRM metadata does not list specific columns beyond key identifiers, the structure and foreign key relationships indicate the critical data points stored. The primary key, SET_ID, is the unique identifier for every knowledge set. Other essential foreign key columns link a set to its defining characteristics: SET_TYPE_ID (references CS_KB_SET_TYPES_B) classifies the set's purpose; VISIBILITY_ID (references CS_KB_VISIBILITIES_B) controls access and viewing permissions; and FLOW_DETAILS_ID (references CS_KB_WF_FLOW_DETAILS) associates the set with an approval or publishing workflow process. Additional columns in the base table typically include creation dates, last update dates, created by, and last updated by user IDs, which are standard for EBS audit trails.

Common Use Cases and Queries

This table is central to knowledge management operations. Common use cases include administering the knowledge base catalog, generating reports on set utilization, and integrating set data with service requests. A frequent query pattern involves joining the base table with its translated descriptions (CS_KB_SETS_TL) to retrieve a list of sets for a specific language. For example, to find all active sets of a particular type, one might use a query such as: SELECT b.SET_ID, tl.NAME FROM CS_KB_SETS_B b, CS_KB_SETS_TL tl WHERE b.SET_ID = tl.SET_ID AND tl.LANGUAGE = USERENV('LANG') AND b.SET_TYPE_ID = <type_id>;. Reporting on set popularity often involves joining CS_KB_SETS_B with the usage summary table (CS_KB_SET_USED_SUMS). Implementation teams may also query this table to validate data integrity or to extract set metadata for migration or integration projects.

Related Objects

As evidenced by its extensive foreign key relationships, CS_KB_SETS_B is the hub for a significant portion of the Service Knowledge Base schema. Key related objects include: CS_KB_SETS_TL for translated set names and descriptions; CS_KB_SET_ELES for the actual content elements (articles, paragraphs) within a set; and CS_KB_SET_CATEGORIES, CS_KB_SET_PRODUCTS, and CS_KB_SET_PLATFORMS for classification. The tables CS_KB_SET_USED_SUMS and CS_KB_SET_USED_HISTS track usage metrics. Furthermore, CS_KB_SET_SETS manages hierarchical relationships between sets, and CS_KB_SET_CHG_HISTS logs modification history. The table is referenced by numerous child entities, including CS_KB_SET_ATTR_VALS, CS_KB_SET_LINKS, and CS_KB_SET_RECS, underscoring its pivotal role in the knowledge architecture.