Search Results eam_meterreading_pub




Overview
Explore in AI Chat

Overview

The APPS.EAM_METERREADING_PUB package body is a public PL/SQL API within Oracle Enterprise Asset Management (EAM) that manages meter readings for enterprise assets. Meter readings capture cumulative or periodic usage measurements — such as operating hours, odometer values, or cycle counts — against an asset, its associated counters, and, where relevant, the work orders or discrete jobs attached to that equipment. The package bridges the EAM application layer with the Oracle Complex Maintenance, Repair, and Overhaul (CSI) counter infrastructure, which stores the authoritative definitions of counters, counter readings, and counter-to-asset associations. This package is classified with the PUB (public) API designation, meaning it is intended for supported external invocation by forms, concurrent programs, and custom extensions rather than being restricted to internal use. As a public API, it adheres to the standard Oracle Application Object Library conventions of parameter validation, error handling via FND_MSG_PUB, and API-level status returns.

Key Procedures and Functions

The ETRM metadata documents the following procedures and functions within this package:

  • CREATE_METER_READING — Creates a new meter reading record for an asset counter. This is the primary entry point for capturing a usage measurement and persisting it against the relevant counter reading structure so that preventive maintenance, condition-based monitoring, and asset utilization reporting operate on current data.
  • DISABLE_METER_READING — Disables an existing meter reading, logically removing it from active use without physically deleting the underlying record. This supports data corrections and lifecycle management of counter readings while preserving the audit trail.

The metadata reports a total of three documented procedures or functions; the remaining member is not enumerated in the excerpt and should be confirmed through the live data dictionary using DBA_OBJECTS and ALL_PROCEDURES when a full inventory is required.

Tables Accessed

The package operates against the following tables through APPS synonyms:

  • CSI_COUNTER_ASSOCIATIONS — Defines which counters apply to which assets or entities; read to validate that a submission targets a valid counter.
  • CSI_COUNTER_READINGS — Stores the individual meter reading values; the principal insert and update target.
  • CSI_COUNTER_RELATIONSHIPS — Captures hierarchical or dependency relationships between counters, used to enforce referential consistency.
  • WIP_DISCRETE_JOBS — Links meter readings to discrete manufacturing jobs where equipment usage must be attributed to production activity.
  • PLITBLM — A standard Oracle tool-support table used indirectly for message and handler infrastructure.

The package also depends on CSI_COUNTER_READINGS_PUB, CSI_CTR_DATASTRUCTURES_PUB, and CSI_DATASTRUCTURES_PUB, delegating core counter-reading persistence to those CSI public APIs rather than performing all DML directly. Standard framework dependencies include FND_API, FND_MESSAGE, FND_MSG_PUB, and FND_LOG.

Usage Notes

Typical invocation occurs from the EAM meter reading entry forms, from concurrent programs that import readings from external systems or shop-floor devices, and from custom PL/SQL integrations. All calls must supply the standard API initialization and validation sequence using FND_API.G_MISS_* conventions and should inspect the returned API status before committing. Because the package is not referenced by any other database object, it functions as a top-level integration surface. Error diagnostics are surfaced through FND_MSG_PUB and optionally traced via FND_LOG for debugging. In version 12.1.1 and 12.2.2 the object is reported VALID in the APPS schema.