Search Results counter_group_description




Overview
Explore in AI Chat

Overview

CSI_COUNTERS_BCV_V is a backward-compatible view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the CSI – Install Base product family. In ETRM 12.1.1 and 12.2.2, the view is documented as a compatibility layer for CS_COUNTERS_V, preserving the historical column names and shape that legacy forms, reports, and custom integrations relied upon prior to the refactoring of the counters data model. Counters in Oracle Install Base represent the metrics captured against installed base instances — accumulated usage, cyclical readings, formula-derived values, and rollover-based measurements. CSI_COUNTERS_BCV_V exposes these counter definitions together with their counter group, unit of measure, derivation lineage, and usage item context, allowing reporting tools and concurrent programs to retrieve counter metadata without binding directly to the newer underlying structures. The status of the object is VALID, and it is populated by a single SELECT statement that joins several counter, property, group, and inventory item objects.

Underlying Base Objects

The documented dependencies for CSI_COUNTERS_BCV_V are CSI_COUNTERS_BC_V, CSI_CTR_ESTIMATE_METHODS_VL, CSI_CTR_PROPERTIES_BC_V, CS_CSI_COUNTER_GROUPS, CS_STD, MTL_SYSTEM_ITEMS_KFV, and MTL_UNITS_OF_MEASURE. The primary source is CSI_COUNTERS_BC_V (aliased CCTB in the view text), which supplies counter identifiers, names, formulas, tolerances, rollover settings, descriptive flexfield attributes, and audit columns. CSI_CTR_PROPERTIES_BC_V (CCPB) contributes derivation property names, while CSI_CTR_ESTIMATE_METHODS_VL and related counter references (CCPT) provide estimate method and derive-counter names. CS_CSI_COUNTER_GROUPS (CCG) supplies group name and description, MTL_UNITS_OF_MEASURE (MUM) resolves the unit of measure description, and MTL_SYSTEM_ITEMS_KFV (MSI) provides the concatenated segment name for the usage item. CS_STD is the standard CSI utility package invoked during resolution. This composition mirrors the structure of the modernization views and confirms that the backward-compatible view is a thin projection rather than an independent data store.

Key Columns

The view returns the core counter definition columns COUNTER_ID, COUNTER_GROUP_ID, NAME, DESCRIPTION, and TYPE, along with measurement attributes STEP_VALUE, TOLERANCE_PLUS, TOLERANCE_MINUS, UOM_CODE, UNIT_OF_MEASURE, INITIAL_READING, and VALID_FLAG. Derivation behavior is represented by FORMULA_TEXT, DERIVE_FUNCTION, DERIVE_PROPERTY_ID and DERIVE_PROPERTY_NAME, DERIVE_COUNTER_ID and DERIVE_COUNTER_NAME, and SOURCE_COUNTER_ID, with FORMULA_INCOMPL_FLAG indicating an incomplete formula definition. Rollover logic is captured through ROLLOVER_LAST_READING and ROLLOVER_FIRST_READING. Usage context is exposed by USAGE_ITEM_ID and USAGE_ITEM_NAME (the concatenated system item segments), and originating template references appear in CREATED_FROM_COUNTER_TMPL_ID. Standard audit and effective-dating columns include CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, START_DATE_ACTIVE, and END_DATE_ACTIVE, followed by fifteen descriptive flexfield ATTRIBUTE columns and the CONTEXT, OBJECT_VERSION_NUMBER, CUSTOMER_VIEW, and DIRECTION columns.

Common Use Cases and Queries

Typical scenarios include reporting counter definitions by counter group, tracing formula and derivation dependencies, and reconciling counters against the usage item and unit of measure masters. The view is also used when migrating legacy extensions that still reference CS_COUNTERS_V. A representative query lists counters with their group and UOM, filtering on effective dates:

  • SELECT counter_id, name, counter_group_name, uom_code, type, formula_text, valid_flag FROM csi_counters_bcv_v WHERE TRUNC(SYSDATE) BETWEEN NVL(start_date_active, SYSDATE) AND NVL(end_date_active, SYSDATE);
  • SELECT counter_id, name, derive_property_name, derive_counter_name, formula_incompl_flag FROM csi_counters_bcv_v WHERE formula_incompl_flag = 'Y';
  • SELECT usage_item_name, COUNT(*) FROM csi_counters_bcv_v GROUP BY usage_item_name;

Because the view is a read-only compatibility projection, it is suitable for querying and extraction but must not be used for DML; inserts and updates belong to the base counter tables and their supporting APIs.