Search Results platform_org_id




Overview
Explore in AI Chat

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:

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.