Results for “csi_counter_associations_pk”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

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:

• INSTANCE_ASSOCIATION_ID — the surrogate primary key, defined by CSI_COUNTER_ASSOCIATIONS_PK and also carried by the unique index CSI_COUNTER_ASSOCIATIONS_U01.
• SOURCE_OBJECT_CODE and SOURCE_OBJECT_ID — identify the source entity to which the counter is associated (the object type code and its identifier).
• COUNTER_ID — the counter instance being associated with the source object.
• START_DATE_ACTIVE and END_DATE_ACTIVE — the effective date range during which the association is active.
• SECURITY_GROUP_ID — the foreign key to FND_SECURITY_GROUPS, controlling multi-organization visibility.
• MAINT_ORGANIZATION_ID — the maintenance organization responsible for the association.
• PRIMARY_FAILURE_FLAG — indicates whether the recorded association relates to a primary failure.
• MIGRATED_FLAG — marks records migrated into the table rather than created natively.
• OBJECT_VERSION_NUMBER — the optimistic locking column used by the Oracle Applications Framework (OAF).
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard flexible descriptive flexfield columns.

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.