Search Results cs_kb_used_sum_defs_b_pk

Overview

The CS_KB_USED_SUM_DEFS_B table is a core data structure within the Oracle E-Business Suite (EBS) Service (CS) module, specifically supporting the Knowledge Base functionality. As a base table, it stores the fundamental definitional data for "used summary" entities. In the context of service and support, these definitions are critical for configuring how the system tracks and summarizes the usage or consumption of knowledge articles, solutions, or other knowledge assets. The table acts as a master definition source, with its primary key being referenced by transactional and multilingual descriptive tables to maintain data integrity and support multiple languages.

Key Information Stored

The primary data element stored in this table is the definition identifier. Based on the provided metadata and standard EBS conventions, the key column is DEF_ID, which serves as the unique primary key for a used summary definition. While the full column list is not detailed in the excerpt, base tables like CS_KB_USED_SUM_DEFS_B typically contain columns for creation date, created by, last update date, last updated by, and other system control attributes. The DEF_ID column is the central piece of information, uniquely identifying each summary definition record and enabling foreign key relationships with dependent objects.

Common Use Cases and Queries

This table is primarily accessed for definitional lookups, integrity validation, and as part of broader queries on knowledge base usage analytics. Common operational and reporting scenarios include retrieving a specific definition's base attributes or joining with its transactional data. A typical query pattern involves selecting a definition by its identifier or joining with the related translated table to get language-specific descriptions.

• Retrieving base definition details for a specific ID: SELECT * FROM cs.cs_kb_used_sum_defs_b WHERE def_id = :1;
• Joining with the translated table for a user-facing report: SELECT b.def_id, tl.name, tl.description FROM cs.cs_kb_used_sum_defs_b b, cs.cs_kb_used_sum_defs_tl tl WHERE b.def_id = tl.def_id AND tl.language = USERENV('LANG');

Related Objects

The CS_KB_USED_SUM_DEFS_B table has defined relationships with several other objects in the schema, as indicated by its foreign key constraints. These related objects are essential for a complete functional implementation.

• CS_KB_SET_USED_SUMS: This table holds transactional or set-level data for used summaries and references CS_KB_USED_SUM_DEFS_B via the DEF_ID foreign key column, linking specific usage instances to their master definition.
• CS_KB_USED_SUM_DEFS_TL: This is the translated table (TL) that stores multilingual descriptions (e.g., NAME, DESCRIPTION) for the definitions in the base table. It shares the DEF_ID primary key-foreign key relationship, allowing a single base definition to have multiple translated rows for different languages.
• CS_KB_USED_SUM_DEFS_B_PK: This is the primary key constraint, enforcing uniqueness on the DEF_ID column and ensuring referential integrity for all dependent foreign keys.