Search Results cs_kb_sets_v




Overview
Explore in AI Chat

Overview

CS_KB_SETS_V is a valid, APPS-owned database view within the Oracle E-Business Suite Service (CS) product family, historically associated with the Knowledge Base (KB) feature set. In EBS 12.1.1 and 12.2.2, the Knowledge Base provides the repository for solutions, problem descriptions, and related knowledge articles used by service agents, field service personnel, and self-service channels. The set construct groups knowledge content, associations, and classifiers into logical collections used to drive search, filtering, and resolution workflows.

The view is documented in the ETRM metadata as "a view on top of CS_KB_SETS_VL and CS_KB_SET_TYPES_VL." Functionally, it presents a denormalized, language-aware projection of knowledge set definitions combined with their set type attributes. This makes it suitable for reporting, integration extracts, and custom inquiry screens where the base transactional tables would otherwise require multi-table joins and manual language handling. Because it exposes Oracle-standard WHO columns and fifteen developer attributes, it can be used for audit reporting and extension-aware queries.

Underlying Base Objects

The ETRM metadata lists three referenced base objects: CS_KB_SETS_B (SYNONYM), CS_KB_SETS_TL (SYNONYM), and CS_KB_SET_TYPES_VL (VIEW). The view text confirms this dependency structure:

  • CS_KB_SETS_B — the base table aliased as B, holding the primary set definition: SET_ID, SET_TYPE_ID, SET_NAME, GROUP_FLAG, STATUS, ACCESS_LEVEL, WHO columns, and ATTRIBUTE1 through ATTRIBUTE15.
  • CS_KB_SETS_TL — the translation table aliased as T, holding the language-specific NAME and DESCRIPTION. The join applies the condition T.LANGUAGE = USERENV('LANG'), so the view returns content in the session's current language.
  • CS_KB_SET_TYPES_VL — the validated (language view) set type reference, joined on B.SET_TYPE_ID = CS_KB_SET_TYPES_VL.SET_TYPE_ID. It contributes the set type NAME and the association index columns COMPOSITE_ASSOC_INDEX, POSITIVE_ASSOC_INDEX, and NEGATIVE_ASSOC_INDEX.

The joins on SET_ID and SET_TYPE_ID define the relational grain: one row per knowledge set per active session language.

Key Columns

  • ROW_ID — the ROWID of CS_KB_SETS_B, useful for identifying the physical base row.
  • SET_ID — primary identifier for the knowledge set.
  • SET_TYPE_ID and SET_TYPE_NAME — the set type identifier and its displayed name from CS_KB_SET_TYPES_VL.
  • SET_NAME — internal name of the set.
  • GROUP_FLAG, STATUS, ACCESS_LEVEL — control indicators for grouping behavior, lifecycle status, and access restrictions.
  • NAME and DESCRIPTION — language-specific set name and description from CS_KB_SETS_TL.
  • COMPOSITE_ASSOC_INDEX, POSITIVE_ASSOC_INDEX, NEGATIVE_ASSOC_INDEX — association indexing controls inherited from the set type definition.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit (WHO) columns.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield segments supporting customer extensions.

Common Use Cases and Queries

Typical uses include validating knowledge set configuration, auditing set definitions by status or access level, and extracting set metadata for integration with analytics platforms. The view is convenient because it eliminates the need to resolve the language join manually.

Example: list active knowledge sets by type

SELECT SET_ID, SET_NAME, NAME, SET_TYPE_NAME, GROUP_FLAG, ACCESS_LEVEL
FROM APPS.CS_KB_SETS_V
WHERE STATUS = 'A'
ORDER BY SET_TYPE_NAME, SET_NAME;

Example: locate a set by name in the current language

SELECT SET_ID, SET_NAME, DESCRIPTION, SET_TYPE_NAME
FROM APPS.CS_KB_SETS_V
WHERE UPPER(SET_NAME) LIKE 'ORDER%';

Example: audit recently modified sets

SELECT SET_ID, SET_NAME, LAST_UPDATED_BY, LAST_UPDATE_DATE
FROM APPS.CS_KB_SETS_V
WHERE LAST_UPDATE_DATE >= SYSDATE - 30;

Because USERENV('LANG') drives translation, sessions must set the correct language for multilingual reporting. Custom queries should use fully qualified APPS.CS_KB_SETS_V references to respect the APPS schema synonym convention.