Search Results cs_kb_set_types_b




Overview
Explore in AI Chat

Overview

The CS_KB_SET_TYPES_B table is a core data definition table within the Oracle E-Business Suite Service (CS) module, specifically for the Knowledge Base (KB) functionality. It serves as the base table for defining and storing the master list of set types available in the system. A set type is a fundamental classification that determines the structure, behavior, and permissible content of a knowledge set. The table's role is to establish the foundational metadata for organizing and categorizing knowledge artifacts, enabling the creation of a structured and searchable repository for service solutions, articles, and documentation. As a base table, it is primarily referenced by its corresponding translation table (CS_KB_SET_TYPES_TL) and numerous dependent configuration tables.

Key Information Stored

While the provided metadata does not list specific columns beyond the primary key, the structure and relationships indicate the critical data elements. The primary column is SET_TYPE_ID, a unique identifier for each set type definition. Based on standard Oracle EBS patterns and the table's purpose, it is logical to infer the table also stores columns for the set type's internal name or code, a start date for validity, and creation/modification metadata (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE). The table's definition drives the configuration of attributes, element types, and inter-set relationships permissible for any knowledge set categorized under a given type.

Common Use Cases and Queries

This table is central to administrative setup and reporting on the knowledge base's structure. Common use cases include generating a list of all configured set types for an administration UI, validating set type IDs during data migration or integration, and auditing configuration changes. A typical query would retrieve the master list of set types, often joined to the translation table for descriptive names in a specific language.

SELECT b.set_type_id, tl.name, tl.description
FROM cs_kb_set_types_b b,
     cs_kb_set_types_tl tl
WHERE b.set_type_id = tl.set_type_id
AND tl.language = USERENV('LANG')
ORDER BY tl.name;

Another critical use case involves understanding the full configuration of a specific set type by joining to its related attribute and element type tables, which define the detailed schema for sets of that type.

Related Objects

CS_KB_SET_TYPES_B acts as a parent table in several key relationships, as documented by its foreign keys. The primary key (SET_TYPE_ID) is referenced by the following objects:

  • CS_KB_SETS_B: The base table for actual knowledge sets. The column CS_KB_SETS_B.SET_TYPE_ID classifies each knowledge set into a specific type defined in this table.
  • CS_KB_SET_ELE_TYPES: Defines the types of elements (e.g., text, number, date) that can be used within sets of a given type, via CS_KB_SET_ELE_TYPES.SET_TYPE_ID.
  • CS_KB_SET_TYPES_TL: The translation table that provides the language-specific name and description for each set type, joined on CS_KB_SET_TYPES_TL.SET_TYPE_ID.
  • CS_KB_SET_TYPE_ATTRS: Stores the configurable attributes for a set type, linked by CS_KB_SET_TYPE_ATTRS.SET_TYPE_ID.
  • CS_KB_SET_TYPE_LINKS: Governs the allowable relationships or links between different set types, referenced by CS_KB_SET_TYPE_LINKS.SET_TYPE_ID.