Search Results csi_counter_associations




Overview
Explore in AI Chat

Overview

CSI_COUNTER_ASSOCIATIONS is a table in the CSI (Install Base) product schema of Oracle E-Business Suite, valid in both release 12.1.1 and 12.2.2. It holds the counter instance association data maintained by the Install Base module. In EBS, counters represent meters or usage measures attached to installed base instances — for example, the number of copies produced by a machine or the operating hours accumulated by an asset. This table records the association between a counter and the source object that owns or consumes that counter reading, making it the persistence layer behind counter-to-instance relationships in the Install Base data model.

From a modeling perspective, the ETRM metadata classifies this object with the heuristic Data Vault classification of standalone, mined from its foreign key structure. This suggests that the table is best modeled as an independent structure rather than as a strict hub, link, or satellite in a Data Vault sense; it carries its own primary key and a limited, single outbound foreign key to the security model, so it does not sit at the center of a dense referential network. The metadata also notes that no additional foreign keys beyond the security group reference are documented, consistent with a leaf-level association record.

Key Information Stored

The table is documented with 32 columns in the 12.2.2 physical schema. The most significant columns are:

The surrogate key INSTANCE_ASSOCIATION_ID is the documented business-key candidate via the unique index CSI_COUNTER_ASSOCIATIONS_U01; no separate composite alternate key is documented.

Common Use Cases and Queries

Typical reporting scenarios include listing all counters associated with a given source object, resolving which counters are currently active for an instance, and auditing security-group-scoped counter data.

  • Retrieve active counter associations for a source object: 
    SELECT COUNTER_ID, INSTANCE_ASSOCIATION_ID
FROM   CSI_COUNTER_ASSOCIATIONS
WHERE  SOURCE_OBJECT_CODE = :obj_code
AND    SOURCE_OBJECT_ID   = :obj_id
AND    TRUNC(SYSDATE) BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, SYSDATE);
  • Report counters by maintenance organization, grouped for workload analysis.
  • Filter migrated versus native records using MIGRATED_FLAG for data-conversion reconciliation.
  • Join to FND_SECURITY_GROUPS on SECURITY_GROUP_ID to enforce operating unit security in custom reports.

Related Objects

  • FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID; the documented foreign key relationship.
  • CSI_COUNTERS (or equivalent counter definition table) — joined on COUNTER_ID to resolve counter metadata.
  • CSI_ITEM_INSTANCES — the installed base instance store commonly joined through SOURCE_OBJECT_ID when SOURCE_OBJECT_CODE denotes an instance.
  • CSI_COUNTER_ASSOCIATIONS_PK and CSI_COUNTER_ASSOCIATIONS_U01 — the primary key constraint and unique index enforcing identity.
  • Install Base public APIs and concurrent programs that create or maintain counter associations, which write to this table through the CSI application layer.