Search Results csi_counter_pub




Overview
Explore in AI Chat

Overview

CSI_COUNTER_PUB is a public PL/SQL API package in the APPS schema that belongs to Oracle's Converged Services Infrastructure (CSI) product family, the same foundation used by Oracle Installed Base and enterprise asset management. Its purpose is to provide a controlled, programmatic interface for creating and maintaining counters and their associated metadata: the counter definition itself, counter properties, associations between counters and the objects they measure, meter readings, and derived usage or reading-lock data. In Oracle EBS 12.1.1 and 12.2.2, counters underpin usage-based and preventive-maintenance business processes, including meter-based service billing and asset utilization tracking. Because the package is classified as a PUB (public) API, it is the sanctioned entry point for external or custom code that must manipulate counter data without writing directly to the underlying CSI tables, thereby preserving the integrity rules enforced by the CSI data model.

Key Procedures and Functions

The ETRM metadata documents eight procedures and functions in this package. Their names and purposes are as follows:

  • CREATE_COUNTER — Creates a new counter definition, establishing the fundamental counter record used for subsequent readings and associations.
  • CREATE_CTR_PROPERTY — Creates a property (attribute) attached to a counter, allowing flexible, attribute-based extension of the counter definition.
  • CREATE_CTR_ASSOCIATIONS — Creates the association between a counter and the entity it measures, effectively binding the counter to an item instance, asset, or similar object.
  • CREATE_READING_LOCK — Creates a reading lock, which governs whether a given counter period or reading may be modified, supporting controlled correction of meter data.
  • CREATE_DAILY_USAGE — Creates daily usage records derived from counter readings, providing the consumption figures used downstream by billing and settlement processes.
  • UPDATE_COUNTER — Modifies an existing counter definition.
  • UPDATE_CTR_PROPERTY — Modifies the value or attributes of an existing counter property.
  • UPDATE_CTR_ASSOCIATIONS — Modifies an existing counter-to-object association.

No parameter lists are reproduced here; callers should inspect the package specification in the EBS instance or the published API documentation for exact signatures.

Tables Accessed

The documented tables referenced through APPS synonyms are CSI_COUNTER_PROPERTIES_B and PLITBLM. CSI_COUNTER_PROPERTIES_B is the base table storing counter property definitions and is the principal persistent target of the CREATE_CTR_PROPERTY and UPDATE_CTR_PROPERTY routines. PLITBLM is a standard Oracle Applications PL/SQL table type used internally for bulk or in-memory processing within the package. The package also depends on CSI_CTR_DATASTRUCTURES_PUB, which supplies shared PL/SQL record and collection type definitions for counter data structures, and on the SYS.STANDARD package.

Usage Notes

CSI_COUNTER_PUB is referenced by seven other packages, including CSI_COUNTER_PUB_W (the wrapper used by concurrent and form-driven processing), CSI_ITEM_INSTANCE_PVT, EAM_METERASSOC_PUB and EAM_METER_PUB (Enterprise Asset Management meter integration), and the Oracle Service (OKS) packages OKS_BILLING_PUB, OKS_USAGE_SETTLE_PUB, and OKL_UBB_INTEGRATION_PVT. This reference pattern confirms that the package is invoked from multiple EBS application flows — asset meter setup and reading capture, service contract billing and usage settlement, and lease/usage-based billing integration — in addition to direct calls from custom code. Customers extending or integrating counter functionality in 12.1.1 or 12.2.2 should invoke the public procedures rather than inserting into CSI tables directly, and should account for the dependency on CSI_CTR_DATASTRUCTURES_PUB when constructing the record arguments expected by the API.