Search Results cs_kb_cat_group_members




Overview
Explore in AI Chat

Overview

The CS_KB_CAT_GROUP_MEMBERS table is a core data structure within the Oracle E-Business Suite Service (CS) module, specifically supporting the Knowledge Base (KB) functionality. As a linking or junction table, its primary role is to manage the many-to-many relationship between Knowledge Base Category Groups and individual Solution Categories. This table enables the logical grouping of categories, which is essential for organizing, securing, and presenting knowledge articles within the EBS application. It acts as a critical bridge, ensuring that category hierarchies and access controls defined within the Knowledge Base are properly enforced and maintained across releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is minimal, designed solely for establishing relationships. Its two columns constitute a composite primary key, directly referencing the primary keys of the parent tables. The CATEGORY_GROUP_ID column stores the unique identifier for a defined category group, linking to the CS_KB_CATEGORY_GROUPS_B table. The CATEGORY_ID column stores the unique identifier for a specific solution category, linking to the CS_KB_SOLN_CATEGORIES_B table. Each row in this table represents a single membership assignment, declaring that a specific category belongs to a particular group. No other descriptive data is stored here, adhering to standard normalization principles for a junction table.

Common Use Cases and Queries

This table is central to operations involving the categorization and access control of knowledge solutions. A primary use case is determining all categories available within a specific group for user interface filtering or security validation. Conversely, administrators use it to find all groups to which a particular category belongs for maintenance purposes. Common reporting needs include listing category-group associations and validating data integrity. Sample SQL patterns include:

  • Retrieving all categories for a specific group:
    SELECT cat.category_name FROM cs_kb_soln_categories_b cat, cs_kb_cat_group_members mem WHERE mem.category_id = cat.category_id AND mem.category_group_id = :group_id;
  • Finding all groups containing a specific category:
    SELECT grp.name FROM cs_kb_category_groups_b grp, cs_kb_cat_group_members mem WHERE mem.category_group_id = grp.category_group_id AND mem.category_id = :category_id;

Related Objects

The functionality of CS_KB_CAT_GROUP_MEMBERS is defined entirely by its relationships with two key master tables, as documented in the provided ETRM metadata.

  • CS_KB_CATEGORY_GROUPS_B: This table defines the category group entities. The CS_KB_CAT_GROUP_MEMBERS.CATEGORY_GROUP_ID column is a foreign key referencing this table's primary key.
  • CS_KB_SOLN_CATEGORIES_B: This table defines the solution category entities. The CS_KB_CAT_GROUP_MEMBERS.CATEGORY_ID column is a foreign key referencing this table's primary key.

Any application logic, API, or user interface function that manages category group membership will directly interact with this junction table to create, read, or delete the associations between these two parent entities.

  • Table: CS_KB_CAT_GROUP_MEMBERS 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_CAT_GROUP_MEMBERS,  object_name:CS_KB_CAT_GROUP_MEMBERS,  status:VALID,  product: CS - Service ,  description: Knowledge Base Category Group Members (Linking Table) ,  implementation_dba_data: CS.CS_KB_CAT_GROUP_MEMBERS , 

  • Table: CS_KB_CAT_GROUP_MEMBERS 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_CAT_GROUP_MEMBERS,  object_name:CS_KB_CAT_GROUP_MEMBERS,  status:VALID,  product: CS - Service ,  description: Knowledge Base Category Group Members (Linking Table) ,  implementation_dba_data: CS.CS_KB_CAT_GROUP_MEMBERS , 

  • Table: CS_KB_CATEGORY_GROUPS_B 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_CATEGORY_GROUPS_B,  object_name:CS_KB_CATEGORY_GROUPS_B,  status:VALID,  product: CS - Service ,  description: Knowledge Base Category Groups (Base Table) ,  implementation_dba_data: CS.CS_KB_CATEGORY_GROUPS_B , 

  • Table: CS_KB_CATEGORY_GROUPS_B 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_CATEGORY_GROUPS_B,  object_name:CS_KB_CATEGORY_GROUPS_B,  status:VALID,  product: CS - Service ,  description: Knowledge Base Category Groups (Base Table) ,  implementation_dba_data: CS.CS_KB_CATEGORY_GROUPS_B , 

  • Table: CS_KB_SOLN_CATEGORIES_B 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SOLN_CATEGORIES_B,  object_name:CS_KB_SOLN_CATEGORIES_B,  status:VALID,  product: CS - Service ,  description: This table stores non-translated data defining a category for solutions. This is a self referencing, one to many, tree structure of categories and subcategories. Solutions are linked to categories via CS_KB_SET_LINKS. ,  implementation_dba_data: CS.CS_KB_SOLN_CATEGORIES_B , 

  • Table: CS_KB_SOLN_CATEGORIES_B 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SOLN_CATEGORIES_B,  object_name:CS_KB_SOLN_CATEGORIES_B,  status:VALID,  product: CS - Service ,  description: This table stores non-translated data defining a category for solutions. This is a self referencing, one to many, tree structure of categories and subcategories. Solutions are linked to categories via CS_KB_SET_LINKS. ,  implementation_dba_data: CS.CS_KB_SOLN_CATEGORIES_B ,