Results for “cs_kb_set_types_b”

50+ results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CS_KB_SET_TYPES_B is the base (non-translated) table that defines the knowledge base set types used by the Service (CS) module in Oracle E-Business Suite 12.1.1 and 12.2.2. A knowledge base set is a logical grouping of knowledge base articles, elements, and structures that share a common classification, security profile, and set of configurable attributes. The set type record acts as the master definition and control record that governs which attributes, element types, and related set instances are permitted within a given knowledge base configuration.

The table resides in the CS schema and is documented as a valid object. In the ETRM 12.2.2 physical schema it contains 27 columns. Its surrogate primary key is CS_KB_SET_TYPES_B_PK, defined on SET_TYPE_ID. A secondary unique index, CS_KB_SET_TYPES_B_U1, is defined on (SET_TYPE_ID, ZD_EDITION_NAME), which supports edition-based redefinition. Based on the foreign key structure—where this table is referenced by five child tables and itself references only FND_SECURITY_GROUPS—a Data Vault modeling heuristic classifies the table as hub-leaning. This should be treated as a modeling suggestion rather than a functional designation.

Key Information Stored

The table stores the identity, descriptive, audit, and security attributes of each knowledge base set type. The most significant columns include:

  • SET_TYPE_ID — the surrogate primary key and the value propagated to all child tables.
  • SET_TYPE_NAME — the internal name of the set type, used as the primary business identifier.
  • ZD_EDITION_NAME — the edition name, part of the unique business-key index CS_KB_SET_TYPES_B_U1.
  • SECURITY_GROUP_ID — the foreign key to FND_SECURITY_GROUPS, controlling row-level access and multi-organization visibility.
  • START_DATE_ACTIVE and END_DATE_ACTIVE — the effective date range that determines when the set type is active and available for use.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the flexible descriptive flexfield (DFF) columns available for customer-specific extension data.

The surrogate key SET_TYPE_ID should be distinguished from the business-key candidate pair (SET_TYPE_ID, ZD_EDITION_NAME) enforced by CS_KB_SET_TYPES_B_U1.

Common Use Cases and Queries

Typical usage includes validating which set types are active for a given date, resolving the set type name for reporting, and identifying which set instances and element types belong to a set type. A common lookup pattern resolves active set types as follows:

  • SELECT SET_TYPE_ID, SET_TYPE_NAME, START_DATE_ACTIVE, END_DATE_ACTIVE FROM CS_KB_SET_TYPES_B WHERE SYSDATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, SYSDATE);
  • Joining to the translated table for a language-specific name: SELECT B.SET_TYPE_ID, T.SET_TYPE_NAME FROM CS_KB_SET_TYPES_B B, CS_KB_SET_TYPES_TL T WHERE B.SET_TYPE_ID = T.SET_TYPE_ID AND T.LANGUAGE = USERENV('LANG');
  • Aggregating child records, for example counting set instances per set type by joining to CS_KB_SETS_B on SET_TYPE_ID.
  • Security-restricted reporting filtered by SECURITY_GROUP_ID to enforce organization-level access.

Related Objects

The table participates in a well-defined parent-child hierarchy. The documented foreign key relationships are:

  • CS_KB_SETS_B — references this table via SET_TYPE_ID; holds individual knowledge base set instances of a given type.
  • CS_KB_SET_ELE_TYPES — references SET_TYPE_ID; defines element types permitted within the set type.
  • CS_KB_SET_TYPES_TL — references SET_TYPE_ID; the translated (language) table for set type names and descriptions.
  • CS_KB_SET_TYPE_ATTRS — references SET_TYPE_ID; holds the attribute definitions associated with the set type.
  • CS_KB_SET_TYPE_LINKS — references SET_TYPE_ID; stores relationships between set types.
  • FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID; the parent table for security group definitions.

Together these tables form the core knowledge base set type model within the CS - Service module.