Search Results csi_counter_relationships




Overview
Explore in AI Chat

Overview

CSI_COUNTER_RELATIONSHIPS is a table within the CSI (Install Base) product module of Oracle E-Business Suite, holding counter formula and counter configuration data. It resides in the CSI schema and is documented as VALID in both EBS 12.1.1 and 12.2.2 environments. In the Install Base model, counters represent measurable quantities associated with an installed asset — meter readings such as copies produced, hours operated, or units consumed. The CSI_COUNTER_RELATIONSHIPS table captures the mathematical and structural relationships between these counters, defining how one counter's value is derived from, bound to, or associated with another through formulas, factors, and bind variables.

From a data modeling perspective, the relationship table's heuristic Data Vault classification is standalone. Under this interpretation the table would function as a reference or configuration structure rather than a transactional hub, link, or satellite in a strict Data Vault sense. This classification reflects the absence of inbound foreign-key dependencies and the table's role as a controlled lookup of counter-to-counter associations rather than an event-bearing record.

Key Information Stored

The documented physical schema contains 33 columns. The most functionally significant are:

The tables' descriptive and audit columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, ATTRIBUTE_CATEGORY, and ATTRIBUTE1 through ATTRIBUTE15) follow the standard EBS WHO-column and DFF (descriptive flexfield) convention, supporting extensibility and change tracking.

Common Use Cases and Queries

Typical usage revolves around understanding how counters relate to one another for meter-based billing, warranty validation, or service entitlement calculations. A common reporting pattern joins source and object counter identifiers back to the counter definition table to resolve human-readable counter names:

  • Identifying all relationships where a given counter acts as the source, to trace downstream derived counters.
  • Querying active relationships effective as of a given date using ACTIVE_START_DATE and ACTIVE_END_DATE.
  • Examining FACTOR and BIND_VARIABLE_NAME values to audit formula configuration during counter reconciliation.
  • Filtering by RELATIONSHIP_TYPE_CODE to isolate formula versus configuration relationships.
  • Extracting MIGRATED_FLAG rows to validate post-conversion data quality.

Because the table is hidden behind the Install Base UI, direct SQL typically appears in diagnostics, extensions, or custom reporting rather than in supported application flows.

Related Objects

The documented foreign key links CSI_COUNTER_RELATIONSHIPS.SECURITY_GROUP_ID to FND_SECURITY_GROUPS, which governs data access visibility. The SOURCE_COUNTER_ID and OBJECT_COUNTER_ID columns reference counter definitions in the CSI counter tables (CSI_COUNTERS and its associated association tables), and CTR_ASSOCIATION_ID links to the counter association entity that groups counters for a given context. Additional dependencies include the standard EBS audit infrastructure implied by the WHO columns. Applications also reference CSI_INSTANCE_COUNTERS, CSI_ITEM_INSTANCES, and related Install Base public APIs, which evaluate counter relationships at runtime. Together these objects form the counter configuration layer of the CSI Install Base data model.