Search Results customer_view

Overview

CS_COUNTERS_V is a Service (CS) module reporting view that presents service counter definitions in a fully joined, denormalized form. Counters in Oracle EBS Service represent metered readings taken against customer products, service contracts, and installed base instances — for example meter readings on copiers, run-hours on machinery, or cycle counts on leased equipment. The base configuration is stored in CS_COUNTERS, but a counter record alone is of limited interpretive value: its unit of measure, counter group, derived values, source counter, usage item, and estimation method all reside in separate tables. CS_COUNTERS_V resolves those dependencies in a single query, exposing both the raw attributes and the descriptive names of the related entities.

The view is defined with outer joins to most of its lookup tables, meaning a counter row is returned even when the optional relationships are not populated. This makes it suitable for reporting over partially configured counters, particularly during implementation or data cleanup exercises. Note that in the reference ETRM environment, the view is documented as not implemented in the database; the definition below reflects the shipped Oracle EBS 12.1.1 / 12.2.2 form of the view.

Underlying Base Objects

The view is defined over eight objects:

• CS_COUNTERS A — the primary table holding counter definitions; drives the driving row and all outer joins.
• MTL_UNITS_OF_MEASURE B — joined on UOM_CODE to supply the reading unit of measure name (UNIT_OF_MEASURE).
• CS_COUNTERS C — self-join on DERIVE_COUNTER_ID to resolve the name of a counter from which this counter is derived.
• CS_COUNTER_PROPERTIES D — joined on DERIVE_PROPERTY_ID to obtain the derived property name.
• MTL_SYSTEM_ITEMS_KFV E — joined on USAGE_ITEM_ID to produce the concatenated segment name of the item being metered. The join further restricts ORGANIZATION_ID using CS_STD.GET_ITEM_VALDN_ORGZN_ID.
• CS_COUNTER_GROUPS F — the only inner join; supplies COUNTER_GROUP_NAME and COUNTER_GROUP_DESCRIPTION.
• MTL_UNITS_OF_MEASURE G — joined on DURATION_UOM to supply DURATION_UOM_NAME.
• CS_CTR_ESTIMATION_METHODS H — joined on ESTIMATION_ID to supply ESTIMATION_NAME.

Key Columns

• COUNTER_ID / COUNTER_GROUP_ID — primary key of the counter and its owning group; use for joins back to base tables and to counter reading tables.
• NAME / DESCRIPTION — counter identity as configured; COUNTER_GROUP_NAME and COUNTER_GROUP_DESCRIPTION provide the group context.
• TYPE — classification of the counter (for example manual, derived, or rollover), governing how readings are captured or computed.
• STEP_VALUE, TOLERANCE_PLUS, TOLERANCE_MINUS — validation tolerances applied to entered readings.
• UOM_CODE / UNIT_OF_MEASURE — code and descriptive name of the reading unit.
• INITIAL_READING, ROLLOVER_LAST_READING, ROLLOVER_FIRST_READING — starting value and rollover boundaries for cycle-based counters.
• FORMULA_TEXT, FORMULA_INCOMPL_FLAG, DERIVE_FUNCTION, DERIVE_PROPERTY_ID, DERIVE_COUNTER_ID, SOURCE_COUNTER_ID — derivation metadata for computed counters.
• USAGE_ITEM_ID / USAGE_ITEM_NAME — the inventory item whose usage is measured.
• CREATED_FROM_COUNTER_TMPL_ID — traceability to the originating counter template.
• CUSTOMER_VIEW, DURATION, DURATION_UOM, DURATION_UOM_NAME, DIRECTION, ESTIMATION_ID, ESTIMATION_NAME — extended attributes governing how the counter is presented to and estimated for customers.
• START_DATE_ACTIVE / END_DATE_ACTIVE, VALID_FLAG — date-range and enablement controls.
• ATTRIBUTE1–15, CONTEXT — the standard EBS descriptive flexfield columns.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER — standard auditing and optimistic-locking columns.

Common Use Cases and Queries

Typical scenarios include auditing counter configuration ahead of a rollout, validating that tolerances and units are populated correctly, listing derived counters and their formulas, and joining counter metadata to actual readings for usage-based billing or contract entitlement reporting. Because counters are frequently referenced from contract and installed base reporting, the view is a convenient single-source lookup for counter name and group.

List active counters with their group and unit of measure:

• SELECT counter_id, name, counter_group_name, unit_of_measure, type FROM cs_counters_v WHERE valid_flag = 'Y' ORDER BY counter_group_name, name;

Identify derived counters and their sources:

• SELECT counter_id, name, type, derive_counter_id, derive_function, formula_text FROM cs_counters_v WHERE derive_counter_id IS NOT NULL;

Join counters to items for metered-asset reporting:

• SELECT c.counter_id, c.name, c.usage_item_name, c.unit_of_measure FROM cs_counters_v c WHERE c.usage_item_id IS NOT NULL ORDER BY c.usage_item_name;

Report customer-facing and estimated counters:

• SELECT counter_id, name, customer_view, duration, duration_uom_name, direction, estimation_name FROM cs_counters_v WHERE customer_view = 'Y';