Search Results automatic_rollover




Overview
Explore in AI Chat

Overview

CSI_COUNTER_TEMPLATE_VL is a language-dependent (translated) view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the CSI – Install Base product. Its documented description is "Counter template view language." The view exposes counter template definitions used to configure meters, gauges, and other reading-based counters that are attached to installed base assets and their associated usage items.

Because counter template names and descriptions must be presented to end users in their own language, Oracle stores the language-neutral attributes in a base table and the translatable text in a translation table. CSI_COUNTER_TEMPLATE_VL joins these two sources and filters the translation rows so that only the appropriate language record is returned. This makes the view the standard access point for reporting, concurrent programs, and integration interfaces that need the user-visible name of a counter template without implementing their own translation logic. In both 12.1.1 and 12.2.2 the object remains valid and is defined with the same structure.

Underlying Base Objects

The view is defined over two documented base objects, both referenced through APPS synonyms:

  • CSI_COUNTER_TEMPLATE_B – the base (language-neutral) table holding the counter identifier, group, counter type, engineering attributes such as initial reading, step value and tolerances, derivation settings, rollover readings, usage item, date effectiveness, and the descriptive flexfield Attribute1 through AttributeN columns.
  • CSI_COUNTER_TEMPLATE_TL – the translation table supplying the language-specific NAME and DESCRIPTION, keyed by COUNTER_ID and the language context.

The view joins COUNTER_ID between the two tables and applies the standard _VL language filter, so that each counter template appears once, in the session's language (falling back to the base language when no translation exists).

Key Columns

Common Use Cases and Queries

The view is typically used to build LOVs, reports, and interfaces that list counter templates with their translated names, and to validate counter configuration before associating templates with instances. A representative query is:

  • SELECT counter_id, group_id, name, description, counter_type, uom_code, initial_reading, step_value FROM csi_counter_template_vl WHERE valid_flag = 'Y' AND TRUNC(SYSDATE) BETWEEN NVL(start_date_active, SYSDATE) AND NVL(end_date_active, SYSDATE) ORDER BY name;

Integration queries commonly restrict by group or usage item, for example WHERE group_id = :p_group_id, or join to CSI usage item tables on USAGE_ITEM_ID. Administrators use the view to audit derivation rules (WHERE derive_counter_id IS NOT NULL) or incomplete formulas (WHERE formula_incomplete_flag = 'Y'). Because NAME and DESCRIPTION are already language-resolved, the view should be preferred over querying the translation table directly.