Search Results cs_kb_set_products




Overview
Explore in AI Chat

Overview

The CS_KB_SET_PRODUCTS table is a core data structure within the Oracle E-Business Suite (EBS) Service (CS) module, specifically supporting the Knowledge Base functionality. It functions as a linking or intersection table, establishing a many-to-many relationship between knowledge base sets and products. Its primary role is to define the product and organizational scope for a knowledge base set, thereby controlling which products and inventory organizations a given set of knowledge articles is applicable to. This scoping is essential for ensuring that service agents and end-users access only the relevant knowledge content based on the product they are servicing.

Key Information Stored

The table stores the minimal set of columns required to define the relationship, with its three columns collectively forming the primary key. The SET_ID column is a foreign key referencing a specific knowledge base set (CS_KB_SETS_B). The PRODUCT_ID column identifies the inventory item (product) to which the set is linked. The PRODUCT_ORG_ID column specifies the inventory organization context for that product, as a single product can be defined across multiple organizations. This three-part key ensures a unique linkage between a knowledge set, a specific product, and the organization that owns the product master definition.

Common Use Cases and Queries

A primary use case is the dynamic filtering of knowledge articles presented in the Service application's knowledge base interface. When a user searches for solutions, the application queries this table to restrict the search to sets linked to the product associated with the service request. Common queries involve joining this table to the knowledge set and article tables. For instance, to list all knowledge sets applicable to a specific product in a given organization, one might use: SELECT s.name FROM cs_kb_sets_b s, cs_kb_set_products sp WHERE s.set_id = sp.set_id AND sp.product_id = :p_product_id AND sp.product_org_id = :p_org_id;. Reporting on knowledge coverage by product or validating setup data are other typical scenarios.

Related Objects

  • CS_KB_SETS_B: This is the primary parent table for knowledge base sets. The CS_KB_SET_PRODUCTS.SET_ID column is a foreign key referencing CS_KB_SETS_B.SET_ID. This relationship enforces that a product linkage can only exist for a valid, defined knowledge set.
  • MTL_SYSTEM_ITEMS_B (implied): While not listed in the provided metadata, the PRODUCT_ID and PRODUCT_ORG_ID columns typically reference the MTL_SYSTEM_ITEMS_B table (on INVENTORY_ITEM_ID and ORGANIZATION_ID), which is the master table for inventory items. This links knowledge scope to the product catalog.
  • Table: CS_KB_SET_PRODUCTS 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SET_PRODUCTS,  object_name:CS_KB_SET_PRODUCTS,  status:VALID,  product: CS - Service ,  description: Knowledge base set-product linking table ,  implementation_dba_data: CS.CS_KB_SET_PRODUCTS , 

  • Table: CS_KB_SET_PRODUCTS 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SET_PRODUCTS,  object_name:CS_KB_SET_PRODUCTS,  status:VALID,  product: CS - Service ,  description: Knowledge base set-product linking table ,  implementation_dba_data: CS.CS_KB_SET_PRODUCTS , 

  • 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 , 

  • 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 ,