Search Results cs_kb_soln_categories_b




Overview
Explore in AI Chat

Overview

The CS_KB_SOLN_CATEGORIES_B table is a core data structure within the Oracle E-Business Suite Service (CS) module, specifically for the Knowledge Base (KB) functionality in releases 12.1.1 and 12.2.2. It serves as the foundational repository for the hierarchical classification system used to organize solution content. The table stores the non-translated, base-language definition of categories and subcategories, forming a self-referencing, one-to-many tree structure. This hierarchical model enables logical grouping and navigation of knowledge solutions, which are linked to these categories through the intersection table CS_KB_SET_LINKS. As a base table, it is central to the administration, discovery, and reporting of knowledge assets.

Key Information Stored

The table's primary purpose is to define the category tree's structure and metadata. The most critical columns include the CATEGORY_ID, which is the table's primary key and unique identifier for each category node. The PARENT_CATEGORY_ID is a foreign key referencing the CATEGORY_ID of the parent node, enabling the self-referential hierarchy; a null value in this column typically indicates a top-level category. The VISIBILITY_ID is a foreign key linking to CS_KB_VISIBILITIES_B, controlling access and visibility rules for the category. Additional columns, not detailed in the excerpt but standard in such structures, would include creation and last update dates, the user who performed the action, and other descriptive attributes that define the category's non-translated properties.

Common Use Cases and Queries

This table is essential for building category trees, managing knowledge taxonomies, and generating reports on solution coverage. Common operational and reporting scenarios include querying the full hierarchy of categories, finding all subcategories under a specific parent, and listing categories with their associated visibility rules. A typical hierarchical query to traverse the category tree would utilize a CONNECT BY clause on the PARENT_CATEGORY_ID and CATEGORY_ID columns. Administrators frequently query this table to audit category usage or to identify orphaned categories (those with no linked solutions). Furthermore, integration points and data loads must populate this table to establish the category framework before linking solutions.

Related Objects

The CS_KB_SOLN_CATEGORIES_B table is a central hub with multiple documented relationships, as per the provided metadata. It is referenced by several key objects in the Knowledge Base schema:

  • CS_KB_SOLN_CATEGORIES_TL: The Translation table, linked via CATEGORY_ID, stores the translated names and descriptions for each category.
  • CS_KB_SET_CATEGORIES: Links categories to solution sets (knowledge articles), using CATEGORY_ID.
  • CS_KB_CAT_GROUP_MEMBERS and CS_KB_CAT_GROUP_DENORM: These tables manage category grouping and denormalized hierarchy data, referencing CATEGORY_ID and CHILD_CATEGORY_ID respectively.
  • CS_KB_SOLN_CATEGORIES_B (Self-Reference): The PARENT_CATEGORY_ID column creates the internal hierarchical relationship.
  • CS_KB_VISIBILITIES_B: Referenced by the VISIBILITY_ID foreign key to enforce security and visibility policies on categories.