Search Results cs_kb_cat_group_denorm




Overview
Explore in AI Chat

Overview

The CS_KB_CAT_GROUP_DENORM table is a core data structure within the Oracle E-Business Suite Service (CS) module, specifically supporting the Knowledge Base (KB) functionality. It serves as a denormalized mapping table that defines the hierarchical relationships between category groups and the individual solution categories they contain. Its primary role is to efficiently store and manage the parent-child associations within the knowledge categorization system, enabling rapid navigation, content filtering, and security enforcement based on category visibility. This table is critical for organizing and retrieving knowledge articles and solutions in applications such as Oracle iSupport and the Service Knowledge Portal.

Key Information Stored

The table's structure is designed to capture the essential links in the category hierarchy. The primary key is a composite of CATEGORY_GROUP_ID and CHILD_CATEGORY_ID, ensuring a unique mapping between each group and its constituent categories. The CHILD_CATEGORY_ID column, central to the user's search, identifies the specific solution category that is a member of a given category group. The CATEGORY_GROUP_ID column references the parent grouping entity. A third critical column, VISIBILITY_ID, links to a visibility profile that controls access rights, determining which users or responsibilities can view the categories within the group. This denormalized design optimizes performance for hierarchical queries common in knowledge base browsing.

Common Use Cases and Queries

A primary use case is generating navigational trees or breadcrumb trails within the knowledge base interface. Applications query this table to list all categories belonging to a selected group. Another key scenario is security validation, where the system checks if a user's visibility profile permits access to a specific category via its associated group. Common reporting needs include auditing category group composition and analyzing content distribution. A sample query to find all child categories for a specific group would be:

  • SELECT child_category_id FROM cs_kb_cat_group_denorm WHERE category_group_id = <GROUP_ID>;

Conversely, to find all groups containing a particular category:

  • SELECT category_group_id FROM cs_kb_cat_group_denorm WHERE child_category_id = <CATEGORY_ID>;

Related Objects

The CS_KB_CAT_GROUP_DENORM table is centrally connected to several foundational knowledge base tables via foreign key relationships, as documented in the ETRM metadata. These relationships enforce data integrity and are essential for accurate joins in queries.

  • CS_KB_CATEGORY_GROUPS_B: Linked via CATEGORY_GROUP_ID. This is the master table defining the category group entity itself.
  • CS_KB_SOLN_CATEGORIES_B: Linked via CHILD_CATEGORY_ID. This is the master table for solution categories, providing details about the child category referenced in the denorm table.
  • CS_KB_VISIBILITIES_B: Linked via VISIBILITY_ID. This table defines the visibility rules and profiles that govern access to the category group relationships.

These relationships form the backbone of the knowledge base's categorization and security model in Oracle EBS.