Search Results update_assetmeterassoc

Overview

EAM_METERASSOC_PUB is a public PL/SQL API package residing in the APPS schema within Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Enterprise Asset Management (EAM) product family and provides the supported, external entry point for creating and maintaining meter-to-asset associations. In EAM, meters are counters used to record cumulative usage such as run hours, cycles, or mileage, and the relationship between a meter and a specific asset instance is fundamental to preventive maintenance scheduling and condition-based maintenance strategies. This package encapsulates that relationship, allowing callers to register associations between asset instances and their assigned meters, and to modify existing associations when the configured meter changes. By exposing the logic through a public package rather than permitting direct table manipulation, Oracle enforces validation rules, maintains referential consistency across the counter association tables, and standardizes error signaling through the FND_API framework. The package is classified as a PUB API, meaning it is intended for invocation by other application modules and by customer extensions, and its signature is treated as an interface that Oracle supports across patch levels.

Key Procedures and Functions

The documented API surface comprises three procedures.

• INSERT_ASSETMETERASSOC — Creates a new meter-to-asset association record. This procedure is the primary mechanism for attaching a counter to an asset instance, establishing the record that subsequent meter readings and preventive maintenance programs reference.
• UPDATE_ASSETMETERASSOC — Modifies an existing meter-to-asset association. It is used when attributes of the association must be changed, such as reassigning the association to a different counter or item association context.
• RAISE_ERROR — A helper routine that surfaces errors encountered during processing. Consistent with Oracle's public API conventions and its dependency on FND_API, it raises the standard application error so that calling programs can detect and handle failures uniformly.

No parameter lists are documented in the ETRM metadata; callers should obtain exact signatures from the package specification in the database before coding against these procedures.

Tables Accessed

The package operates against the following tables, resolved through APPS synonyms.

• CSI_COUNTER_ASSOCIATIONS — The principal table holding counter association definitions. The insert and update procedures write to and read from this table.
• CSI_CTR_ITEM_ASSOCIATIONS — Stores the linkage between counters and item definitions, providing the item-level context for an asset meter association.
• CSI_ITEM_INSTANCES — The asset instance master. The package references it to validate that the asset instance being associated with a meter exists and is valid.
• DUAL — Used for singleton queries and PL/SQL expression evaluation.

Usage Notes

EAM_METERASSOC_PUB is typically invoked from EAM asset and meter maintenance forms, from concurrent programs that bulk-load or migrate meter associations, and from custom PL/SQL extensions that programmatically attach counters to assets. Because it is a PUB package depending on FND_API, standard practice applies: callers should check the returned API status, commit or roll back the transaction explicitly according to their own transaction boundaries, and treat the package as the supported interface rather than writing directly to the CSI counter association tables. The documented metadata records no other packages referencing EAM_METERASSOC_PUB, indicating it is a leaf-level API consumed by forms and external code rather than by peer PL/SQL packages.