Search Results disable_counter_hierarchy




Overview
Explore in AI Chat

Overview

The APPS.EAM_METERREADING_UTILITY_PVT package is a private PL/SQL utility within Oracle Enterprise Asset Management (eAM). It provides the low-level, internal logic used to persist meter and counter readings that are captured against assets, work orders, and rebuild activities. Meter readings in eAM represent the measured usage of an asset—such as hours of operation, cycles, or volume consumed—and are essential for preventive maintenance scheduling and condition-based maintenance triggers. This package supports the write side of the meter reading process, handling row insertion, last-service-reading maintenance, source meter enablement, counter hierarchy manipulation, and work order/genealogy updates. It is classified as a PVT (private) API, meaning it is not intended for direct customer invocation but rather is called by the public eAM work order processing APIs and forms.

Key Procedures and Functions

  • PERFORM_WRITES — Orchestrates the persistence of an eAM meter reading record. It acts as the coordinating entry point that drives the downstream insert and update operations for a given meter reading request.
  • INSERT_ROW — Inserts new meter reading and counter property rows into the appropriate base tables, returning the resulting table structures and return status to the caller.
  • UPDATE_LAST_SERVICE_READING — Updates the last service reading value associated with an asset or counter, ensuring subsequent maintenance calculations reference the most recent measurement.
  • ENABLE_SOURCE_METER — Enables the source meter configuration for work order component meter reads, controlling whether a given meter is treated as the authoritative source.
  • DISABLE_COUNTER_HIERARCHY — Disables or deactivates the counter hierarchy relationship, typically used when restructuring how counters are associated.
  • UPDATE_ACTIVITY — Updates activity records linked to the meter reading process, reflecting that a reading-related activity has been performed.
  • UPDATE_GENEALOGY — Maintains genealogy (parent-child component) relationships impacted by rebuild or meter reading operations.
  • UPDATE_REBUILD_WORK_ORDER — Updates the rebuild work order to reflect meter reading outcomes and associated state changes.

Tables Accessed

  • CSI_COUNTER_ASSOCIATIONS — Stores associations between counters and the items or instances they measure; read and written during source meter enablement and counter hierarchy changes.
  • CSI_COUNTER_RELATIONSHIPS — Defines hierarchical relationships between counters; central to the DISABLE_COUNTER_HIERARCHY logic.
  • CSI_ITEM_INSTANCES — Holds installed base instance records for assets; referenced to link readings to the correct asset instance.
  • WIP_DISCRETE_JOBS — Provides work order context, particularly for the rebuild work order update procedure.
  • PLITBLM — A generic PL/SQL index-by table structure used internally for parameter/collection handling.

Usage Notes

This package is invoked indirectly through the public eAM work order processing API, EAM_PROCESS_WO_PUB, which defines the record and table types (such as eam_meter_reading_rec_type, eam_meter_reading_tbl_type, and eam_counter_prop_tbl_type) passed into these procedures. Its documented procedures are called during work order completion, meter reading entry, and rebuild processing within the eAM forms and concurrent programs. Because it is a PVT package, customizations should not call it directly; developers should use the supported public APIs instead. The package is referenced by one other package within the eAM schema, consistent with its role as an internal utility layer. Error handling is returned through the standard EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type token table and an x_return_status flag.