Search Results cs_kb_set_platforms_n1

Overview

The CS_KB_SET_PLATFORMS table is a core linking table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 Customer Support (CS) Knowledge Base module. Its primary function is to manage the many-to-many relationship between Knowledge Base Solution Sets and Inventory Platforms. This table acts as a junction, storing the specific associations that determine which hardware or software platforms, as defined in Oracle Inventory, are applicable to a given solution or article. This linkage is critical for ensuring that support solutions and technical documentation are accurately filtered and presented to users based on the specific platform context of their service request or product configuration.

Key Information Stored

The table's structure is focused on establishing the relationship and maintaining audit trails. The key business columns are:

• SET_ID: A mandatory foreign key referencing the Knowledge Base Solution Set (CS_KB_SETS_B). This identifies the specific solution or article.
• PLATFORM_ID: The identifier for the platform item from Inventory (MTL_SYSTEM_ITEMS_B). This defines the specific hardware or software model.
• PLATFORM_ORG_ID: The inventory organization identifier for the platform, providing the necessary context for the PLATFORM_ID. This column is part of a non-unique index (CS_KB_SET_PLATFORMS_N1 and N3), highlighting its importance in queries filtered by organization.
• Standard Who Columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN): Provide full audit capability for tracking record creation and modifications.
• SECURITY_GROUP_ID: Supports data partitioning in multi-org hosted environments.

Common Use Cases and Queries

This table is central to platform-aware solution management. A primary use case is retrieving all platforms associated with a specific solution set for validation or display within the Knowledge Base interface. Conversely, administrators may query for all solutions applicable to a particular platform to manage associations. The following sample query demonstrates fetching the platform details for a given SET_ID, joining to inventory tables for descriptive information:

SELECT ckp.set_id, ckp.platform_id, ckp.platform_org_id, msi.concatenated_segments platform
FROM cs.cs_kb_set_platforms ckp,
     mtl_system_items_kfv msi
WHERE ckp.platform_id = msi.inventory_item_id
  AND ckp.platform_org_id = msi.organization_id
  AND ckp.set_id = :p_set_id
ORDER BY platform;

Another critical reporting use case involves analyzing solution coverage by platform to identify gaps or redundancies in the knowledge repository.

Related Objects

Based on the provided metadata, CS_KB_SET_PLATFORMS is a standalone table with no documented foreign key dependencies on other objects. However, it is referenced by its primary key constraint index, CS_KB_SET_PLATFORMS#. In practice, the SET_ID column logically references the primary key of the CS_KB_SETS_B table, while PLATFORM_ID and PLATFORM_ORG_ID together reference the unique item and organization combination in MTL_SYSTEM_ITEMS_B. The table's non-unique indexes (N1 on PLATFORM_ID, PLATFORM_ORG_ID; N2 on SET_ID; N3 on PLATFORM_ORG_ID) are optimized for queries filtering by these key relationship columns.