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 indexCS_KB_SET_TYPES_B_U1.SECURITY_GROUP_ID— the foreign key toFND_SECURITY_GROUPS, controlling row-level access and multi-organization visibility.START_DATE_ACTIVEandEND_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_CATEGORYandATTRIBUTE1throughATTRIBUTE15— 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_BonSET_TYPE_ID. - Security-restricted reporting filtered by
SECURITY_GROUP_IDto 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 viaSET_TYPE_ID; holds individual knowledge base set instances of a given type.CS_KB_SET_ELE_TYPES— referencesSET_TYPE_ID; defines element types permitted within the set type.CS_KB_SET_TYPES_TL— referencesSET_TYPE_ID; the translated (language) table for set type names and descriptions.CS_KB_SET_TYPE_ATTRS— referencesSET_TYPE_ID; holds the attribute definitions associated with the set type.CS_KB_SET_TYPE_LINKS— referencesSET_TYPE_ID; stores relationships between set types.FND_SECURITY_GROUPS— referenced bySECURITY_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.
-
Knowledge base set types (base table).
-
Knowledge base set types (base table).
-
TABLE: CS.CS_KB_SET_TYPES_B 12.2.2
-
TABLE: CS.CS_KB_SET_TYPES_B 12.1.1
-
View: CS_KB_SET_TYPES_VL 12.1.1
Multi-lingual view for CS_KB_SET_TYPES_B and CS_KB_SET_TYPES_TL tables.
APPS.CS_KB_SET_TYPES_VL·↳ CS_KB_SET_TYPES_B·↳ CS_KB_SET_TYPES_TL·Explore CS module →
-
VIEW: CS.CS_KB_SET_TYPES_B# 12.2.2
-
View: CS_KB_SET_TYPES_VL 12.2.2
Multi-lingual view for CS_KB_SET_TYPES_B and CS_KB_SET_TYPES_TL tables.
APPS.CS_KB_SET_TYPES_VL·↳ CS_KB_SET_TYPES_B·↳ CS_KB_SET_TYPES_TL·Explore CS module →
-
12.2.2 DBA Data 12.2.2
-
VIEW: CS.CS_KB_SET_TYPES_B# 12.2.2
-
12.2.2 DBA Data 12.2.2
-
View: CS_KB_INTEGRATION_V 12.2.2
View combines JTF notes with knowledge management element links and set links. Used by Knowledge Management for integration from any application module.
APPS.CS_KB_INTEGRATION_V·↳ CS_KB_ELEMENTS_B·↳ CS_KB_ELEMENTS_TL·↳ CS_KB_ELEMENT_LINKS·Explore CS module →
-
View: CS_KB_INTEGRATION_V 12.1.1
View combines JTF notes with knowledge management element links and set links. Used by Knowledge Management for integration from any application module.
APPS.CS_KB_INTEGRATION_V·↳ CS_KB_ELEMENTS_B·↳ CS_KB_ELEMENTS_TL·↳ CS_KB_ELEMENT_LINKS·Explore CS module →
-
Knowledge base set types (translation table).
-
Knowledge base set types (translation table).
-
Knowledge base set element types. This table implements the many to many relationship between set types and element types.
-
Knowledge base set type attributes. This table implements the many to many relationship between set types and attribute types. Not used since before 11.5.8
-
Knowledge base set type attributes. This table implements the many to many relationship between set types and attribute types. Not used since before 11.5.8
-
12.2.2 DBA Data 12.2.2
-
Knowledge base set element types. This table implements the many to many relationship between set types and element types.