Search Results cs_kb_set_platforms




Overview
Explore in AI Chat

Overview

The CS_KB_SET_PLATFORMS table is a core linking table within the Oracle E-Business Suite Service (CS) module's knowledge base infrastructure. It functions as a junction table that establishes and manages the many-to-many relationship between knowledge base sets and the operational platforms on which they are deployed. Its primary role is to define and enforce the specific platform and organization contexts in which a given set of solution articles is valid and accessible, enabling precise content targeting and visibility control within the service application.

Key Information Stored

The table stores the minimal set of foreign key columns required to create the association, forming a composite primary key. The critical columns are:

  • SET_ID: References the unique identifier of a knowledge base set from the CS_KB_SETS_B table. This defines the specific collection of articles.
  • PLATFORM_ID: Identifies the platform (e.g., a specific product, technology, or system) for which the set is applicable.
  • PLATFORM_ORG_ID: Specifies the operating unit (organization) context for the platform association. This column is crucial for implementing multi-org security and ensuring that knowledge sets are only visible within their designated business units.
Together, these three columns uniquely define a valid set-platform-organization relationship.

Common Use Cases and Queries

A primary use case is determining which knowledge sets are available for a given platform within a specific organization, often for building dynamic user interfaces or content filters. For example, to list all knowledge sets applicable to a platform in a particular org, a query would join on CS_KB_SETS_B: 

SELECT s.name, s.description
FROM cs_kb_sets_b s, cs_kb_set_platforms p
WHERE s.set_id = p.set_id
AND p.platform_id = :p_platform_id
AND p.platform_org_id = :p_org_id;
Another common scenario is administrative reporting to audit platform assignments, using a query that joins the linking table to the set and organization tables to produce a human-readable report of all associations.

Related Objects

The table maintains a strict foreign key relationship with the base knowledge set table, as documented in the ETRM metadata:

  • CS_KB_SETS_B: The primary parent table. The foreign key constraint links CS_KB_SET_PLATFORMS.SET_ID to the primary key of CS_KB_SETS_B. This ensures that every platform association must reference a valid, existing knowledge set.
While not explicitly listed in the provided excerpt, the PLATFORM_ID and PLATFORM_ORG_ID columns would typically reference a platform master table (such as CS_PLATFORMS_B) and the HR_OPERATING_UNITS table, respectively, to maintain data integrity for those dimensions.