Results for “csi_ctr_est_ctr_reading_grp”
24 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The APPS.CSI_CTR_EST_CTR_READING_GRP package is a public Oracle EBS API belonging to the Enterprise Asset Management (eAM) and Customer Service Intelligence (CSI) counter functionality. Its core business purpose is to estimate counter readings and usage quantities for meters and counters when actual readings are unavailable, incomplete, or span a defined period. The package name combines "CSI" (the schema/product family for counters and installation data), "CTR" (counter), "EST" (estimate), and "READING" — reflecting a grouping (_GRP suffix, API classification GRP) package that exposes one or more estimation entry points to consumers.
The header signature, AUTHID CURRENT_USER, indicates the package executes with the privileges of the calling user rather than the definer, which is a common pattern for CSI APIs invoked from forms, workflow, or other packages where the caller's security context and schema access must be preserved.
Key Procedures and Functions
One documented procedure is exposed by this package:
estimate_counter_reading— Estimates a counter/meter reading and related usage quantities over a specified estimation period. It accepts parameters including the API version number, standard FND API message-list and commit flags, a validation level, the counter identifier, estimation period start and end dates, an average calculation start date, and the number of readings. It returns output parameters for the estimated usage quantity, the estimated meter reading, the estimated period-start reading, plus the standardX_Return_Status,X_Msg_Count, andX_Msg_DataOUT parameters used to convey processing status and message information to the caller.
The procedure adheres to the standard Oracle EBS API conventions (version number, message-list initialization, commit flag, validation level, and return status/message outputs), which makes it suitable for invocation within larger transactional flows.
Tables Accessed
The provided ETRM metadata does not explicitly enumerate the tables referenced via APPS synonyms. Based on the CSI counter data model, the procedure would typically read from and write to counter and counter-reading base tables such as CSI_COUNTERS, CSI_COUNTER_READINGS, and related counter-association tables, in order to derive the estimation period average and compute the projected meter reading. Authoritative table lineage should be confirmed through the package body or the CSI data model documentation, as the summary metadata omits this detail.
Usage Notes
This package is referenced by one other package, indicating it forms part of a dependent call chain within the CSI counter estimation subsystem. Typical invocation points include eAM/counter maintenance forms, concurrent programs that batch-estimate readings, and custom PL/SQL that needs estimated usage for billing, maintenance forecasting, or meter analytics.
Because the procedure follows FND API patterns, callers should set P_Init_Msg_List, manage the commit flag appropriately within their own transaction boundaries, choose a validation level consistent with the data quality required, and always inspect X_Return_Status and the message outputs before committing. The package was shipped at version 120.0.12010000.1 (2008), and behaves consistently across EBS 12.1.1 and 12.2.2 since it relies on the stable CSI and FND API foundations rather than UI-specific structures.
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2