Results for “activated_flag”

4 results




Overview
Explore in AI Chat

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

Overview

The CS_KB_USED_SUM_DEFS_B table is a Service (CS) module base table that stores the definitions governing how knowledge base usage summaries are calculated and presented. In Oracle EBS 12.1.1 and 12.2.2, this table acts as the master definition repository for "used summary" configurations, which control aggregation windows, activation state, and default behavior for knowledge base usage statistics. Each row represents one summary definition that can be associated with knowledge base sets and exposed through translated (TL) descriptive data.

From a Data Vault modeling perspective, the metadata heuristic classifies this object as hub-leaning. The presence of a surrogate primary key (DEF_ID) with dependent translated and cross-reference tables, but no direct business transaction columns beyond configuration attributes, suggests the table functions as a hub of definition identities, with ZD_EDITION_NAME participating as a business-key discriminator alongside the surrogate key.

Key Information Stored

The primary key is enforced through CS_KB_USED_SUM_DEFS_B_PK on the column DEF_ID, a system-generated surrogate identifier. A unique index, CS_KB_USED_SUM_DEFS_B_U1, is defined on the composite (DEF_ID, ZD_EDITION_NAME), identifying ZD_EDITION_NAME as a business-key candidate used for edition-aware lookups in 12.2.x environments.

Among the 27 documented columns, the most functionally significant are:

  • DEF_ID — surrogate primary key identifying each summary definition.
  • DAYS — the interval or lookback window (in days) used when computing usage summaries.
  • DEFAULT_FLAG — indicates whether the definition is applied by default when no explicit selection is made.
  • ACTIVATED_FLAG — controls whether the definition is currently enabled for use.
  • SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enforcing row-level security and multi-tenant partitioning.
  • ZD_EDITION_NAME — edition identifier supporting Edition-Based Redefinition (EBR) in 12.2.x.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard Who-column audit attributes.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the DFF (Descriptive Flexfield) columns enabling customer-specific extensibility.

Common Use Cases and Queries

Typical usage involves retrieving active summary definitions for a given security group, joining to the translated table for user-facing names, and linking to set-level usage data.

Listing active default definitions:

  • SELECT DEF_ID, DAYS, DEFAULT_FLAG FROM CS_KB_USED_SUM_DEFS_B WHERE ACTIVATED_FLAG = 'Y' AND SECURITY_GROUP_ID = :sgid;

Joining to translated names for reporting:

  • SELECT b.DEF_ID, t.NAME FROM CS_KB_USED_SUM_DEFS_B b, CS_KB_USED_SUM_DEFS_TL t WHERE b.DEF_ID = t.DEF_ID AND t.LANGUAGE = USERENV('LANG');

Locating definitions used within knowledge base sets:

These queries support reporting on knowledge base utilization metrics, auditing configuration drift across editions, and validating which definitions drive usage-summary dashboards.

Related Objects

The following objects are directly related through documented foreign keys and primary-key relationships:

  • CS_KB_USED_SUM_DEFS_TL — translation table keyed on DEF_ID, supplying language-specific names and descriptions.
  • CS_KB_SET_USED_SUMS — set-level usage summary table whose DEF_ID references this base table, associating definitions with knowledge base sets.
  • FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID, enforcing organizational data segregation.

Together these objects form the configuration backbone for knowledge base usage summarization within the Service module, with the base table serving as the authoritative definition hub and its TL and set-level companions providing presentation and assignment context respectively.