Search Results csi_counter_pub_w




Overview
Explore in AI Chat

Overview

CSI_COUNTER_PUB_W is a public API package in the Oracle E-Business Suite Applications (APPS) schema that belongs to the Enterprise Install Base (CSI) product family. Its role is to provide a programmatic interface for the creation and maintenance of counters and their associated attributes within the Install Base repository. In Oracle EBS, a counter represents a measurable usage or consumption metric attached to an installed asset, such as meter readings, copy volumes, or cycle counts used for billing, warranty tracking, and preventive maintenance scheduling. Rather than writing directly to the underlying CSI tables, external modules, forms, and concurrent programs call this package to create counters, define counter properties, associate counters to eligible objects, record daily usage values, and update existing counter records. The "_PUB_" suffix indicates that this is a published, supported interface intended for external consumption, as opposed to internal helper routines. According to the supplied Express Tracking and Reporting Metadata (ETRM), the package is classified with an API type of OTHER and is documented as VALID at release levels 12.1.1 and 12.2.2.

Key Procedures and Functions

The ETRM metadata documents seven procedures, organised into create and update families:

  • CREATE_COUNTER — Establishes a new counter definition in the Install Base. This is the primary entry point for registering a counter type against an installed item or instance.
  • CREATE_CTR_PROPERTY — Creates a property (attribute) record associated with a counter, allowing flexible, extensible descriptive metadata to be attached to a counter definition.
  • CREATE_CTR_ASSOCIATIONS — Defines the associations between a counter and the objects or relationships to which it applies, governing where the counter may be used.
  • CREATE_DAILY_USAGE — Records periodic (daily) usage or reading values for a counter, supporting the accumulation of consumption history used by billing and analytics processes.
  • UPDATE_COUNTER — Modifies an existing counter definition, such as its descriptive attributes or status.
  • UPDATE_CTR_PROPERTY — Amends a previously created counter property record.
  • UPDATE_CTR_ASSOCIATIONS — Adjusts the associations established for a counter.

No parameter lists are documented in the ETRM extract, and none are reproduced here.

Tables Accessed

The supplied metadata does not enumerate base tables; the "Tables referenced" section is empty. However, the dependency list shows that the package relies on the standard JTF collection types — JTF_DATE_TABLE, JTF_NUMBER_TABLE, JTF_VARCHAR2_TABLE_100, JTF_VARCHAR2_TABLE_200, and JTF_VARCHAR2_TABLE_300 — which are Oracle Application Framework (JTF) PL/SQL index-by tables used to pass array-based (bulk) parameter sets into public APIs. In practice, CSI_COUNTER_PUB_W reads and writes the CSI counter tables (such as the CSI_COUNTER and associated property, association, and usage tables) through APPS synonyms, with the JTF tables used to marshal multi-row input.

Usage Notes

CSI_COUNTER_PUB_W is typically invoked from Oracle Install Base forms, from concurrent programs that load or reconcile counter data, and from custom extensions that need to create or maintain counters programmatically. The presence of CREATE_DAILY_USAGE indicates use by periodic usage-collection or billing-interface processes. Because it is a published interface, custom code should call this package rather than inserting into CSI tables directly, ensuring validation logic and audit columns are populated correctly. The ETRM metadata records that no other packages reference CSI_COUNTER_PUB_W (referenced by 0 packages), confirming it acts as a top-level entry point rather than an internal dependency.