Search Results eam_meter_pub




Overview

APPS.EAM_METER_PUB is a public PL/SQL package belonging to the Enterprise Asset Management (EAM) module of Oracle E-Business Suite. Its name reflects its role as a public API surface for meter (counter) definition logic within the EAM application. A meter, in the EAM functional model, is a named counter attached to an asset that records usage, production, or condition-based readings such as odometer mileage, hours run, or cycle counts. These readings drive preventive maintenance scheduling, condition-based maintenance triggers, and asset lifecycle decisions.

The package is classified as PUB, indicating that it forms part of the supported programmatic interface for creating and maintaining meter definitions rather than being a purely internal implementation object. It is built on the standard Oracle EBS API framework, as evidenced by its dependency on APPS.FND_API, which supplies the common error-handling and return-status conventions (such as the standard x_return_status and x_msg_count/x_msg_data parameters) used across EBS public APIs. The package status is VALID in the ETRM documentation, confirming it is a compiled, active database object in the APPS schema.

Key Procedures and Functions

ETRM documents two public program units within this package:

  • CREATE_METER — Creates a new meter (counter) definition within EAM. This is the entry point used when a new usage or measurement counter must be established and made available for association with assets, asset groups, or counter templates.
  • UPDATE_METER — Modifies an existing meter definition. It supports maintenance of meter attributes after initial creation, such as descriptive or configuration changes to the counter record.

Both procedures follow the FND_API conventions for returning status and messages, meaning callers must inspect the returned status value and message stack rather than relying on unhandled exceptions. No parameter signatures are asserted here beyond what the metadata supports.

Tables Accessed

The documented table references, all reached through APPS synonyms, center on the CSI counter model:

  • CSI_COUNTERS_B — The base table storing meter/counter definitions; CREATE_METER and UPDATE_METER operate on this entity.
  • CSI_COUNTER_TEMPLATE_B — Provides counter template definitions used to standardize meter creation.
  • CSI_COUNTER_ASSOCIATIONS — Records the association between counters and the entities (assets, groups) they measure.
  • CSI_COUNTER_RELATIONSHIPS — Captures relationships between counters, such as rollover or derived counter links.
  • PLITBLM — A standard EBS PL/SQL table type used internally for message and error stack handling in API processing.

Usage Notes

EAM_METER_PUB is not normally called directly by end users. It is typically invoked from EAM setup forms and from other programmatic layers, most notably APPS.EAM_METERREADING_UTILITY_PVT, which the ETRM dependency report identifies as a referencing object. Customizations and integrations that need to create or amend meter definitions in a supported manner should call CREATE_METER and UPDATE_METER rather than performing direct DML on the CSI counter tables. Because the package participates in the FND_API framework, callers should always validate the returned status and propagate messages appropriately, and should respect the standard EBS concurrency and validation expectations when invoking these APIs.