Search Results get_previous_net_reading
Overview
CSI_COUNTER_READINGS_PVT is a private PL/SQL package in the APPS schema that forms the core processing engine for counter and meter reading management within Oracle Enterprise Asset Management (eAM) and the Oracle Installed Base / Enterprise Asset Management counter framework. Counter readings capture cumulative usage metrics such as odometer values, running hours, or cycle counts associated with an asset, and this package is responsible for capturing, validating, updating, estimating, and deriving those readings as they flow through the EBS application.
In EBS 12.1.1 and 12.2.2, counters underpin preventive maintenance scheduling, warranty and entitlement calculations, and condition-based maintenance. Because it is a PVT (private) package, CSI_COUNTER_READINGS_PVT is not intended to be called directly by customer code; instead it is wrapped by the public package CSI_COUNTER_READINGS_PUB and invoked internally by views, business components, and concurrent processes. The package follows the standard EBS API architecture, depending on FND_API for the common error-handling and message framework and on CSI_DATASTRUCTURES_PUB and CSI_CTR_DATASTRUCTURES_PUB for shared PL/SQL record types.
Key Procedures and Functions
The package exposes seventeen documented procedures and functions grouped into capture, computation, estimation, and lookup operations.
- CREATE_READING_TRANSACTION — creates the underlying CSI transaction record associated with a counter reading, providing the transactional context in which the reading is stored.
- CAPTURE_COUNTER_READING and CAPTURE_CTR_PROPERTY_READING — capture a new reading for a counter or for a specific counter property, applying validation and persisting the result.
- UPDATE_COUNTER_READING — modifies an existing counter reading, typically for corrections or adjustments.
- COMPUTE_FORMULA_COUNTERS, COMPUTE_TARGET_COUNTERS, COMPUTE_DERIVE_COUNTERS — evaluate formula-based, target-based, and derived counter definitions to produce calculated reading values from other readings or expressions.
- EST_DAILY_AVG, ESTIMATE_USAGE, ESTIMATE_COUNTER_READING, ESTIMATE_START_READINGS, EST_PERIOD_START_READINGS, ESTIMATE_FIXED_VALUES — implement the estimation framework, producing estimated readings and usage figures when actual readings are missing or when period-start values must be interpolated.
- TRANSACTION_ID_EXISTS — a validation function that checks whether a transaction identifier already exists, protecting against duplicate captures.
- GET_READING_BEFORE_RESET, GET_PREVIOUS_NET_READING, GET_LATEST_READING — retrieval functions returning prior, latest, or pre-reset readings to support net usage calculations and reset handling.
Tables Accessed
The package reads and writes the core counter schema, including CSI_COUNTERS_B and CSI_COUNTERS_TL for counter definitions and translations, CSI_COUNTER_PROPERTIES_B for property definitions, and CSI_COUNTER_RELATIONSHIPS and CSI_COUNTER_DERIVED_FILTERS for derivation logic. Reading data is persisted in CSI_COUNTER_READINGS, CSI_COUNTER_READINGS_S, and CSI_CTR_PROPERTY_READINGS with its _S sequence alias, while CSI_CTR_ESTIMATED_READINGS and its _S alias hold estimated values produced by the estimation routines. CSI_COUNTER_READING_LOCKS supports concurrency control during capture, and CSI_TRANSACTIONS, CSI_TRANSACTIONS_S, and CSI_TXN_TYPES supply the transaction framework under which readings are recorded.
Usage Notes
Because it is a private package, CSI_COUNTER_READINGS_PVT should not be called directly by customizations. It is referenced by sixteen dependent objects, including CSI_COUNTER_READINGS_PUB, CSI_CTR_INTERFACE_PUB, CSI_TIME_BASED_CTR_ENGINE_PKG, and CS_CTR_CAPTURE_READING_PUB. It also backs numerous views such as CSI_COUNTER_READINGS_V, CSF_M_COUNTER_VALUES_V, EAM_CFR_COUNTER_READINGS_V, OKX_COUNTER_VALUES_V, and JTM_CS_COUNTER_VALUES_V, which expose reading data to eAM, Service, and TeleService forms. Custom code requiring counter reading capture or estimation should call the public API CSI_COUNTER_READINGS_PUB, which internally delegates to this package and preserves the supported upgrade path across 12.1.1 and 12.2.2.