Search Results update_utilization

Overview

APPS.AHL_UC_UTILIZATION_PUB is a public API package in the Oracle E-Business Suite Enterprise Asset Management (EAM) / Asset Lifecycle product family. The "AHL" prefix identifies it as part of the complex maintenance, repair, and overhaul (MRO) schema, specifically the utilization and counter management sub-component denoted by "UC." This package exposes the business logic that maintains utilization counters for configured assets and item instances.

Its core purpose is to update utilization records based on the counter rules defined in the master configuration. Counters represent measurable usage metrics — cycles, hours, miles, or other units of measure — tracked against a physical asset or configuration. The package accepts identifying details of an item, counter identifier, counter name, or unit of measure code, and applies the appropriate update. Where a configuration hierarchy exists, the package can cascade an update down to all child item instances when the cascade flag is provided. This makes it the central programmatic entry point for propagating counter readings across an installed base structure.

Key Procedures and Functions

The package body exposes a single documented public procedure:

• UPDATE_UTILIZATION — Updates utilization based on the counter rules defined in the master configuration, given the details of an item, counter id, counter name, or UOM code. The procedure requires a utilization table parameter as input, where each record identifies the target item instance through one of several mutually exclusive combinations: (1) organization id together with inventory item id and serial number, which identifies the part number and serial number of a configuration; (2) counter id, which updates a specific counter only, regardless of the cascade flag; or (3) CSI item instance id, which updates that item instance and, depending on the cascade flag, items further down the hierarchy. The type of counters to be updated is likewise identified by one of two values: UOM code or counter name. The procedure observes Oracle's standard API parameter conventions, including an API version, an initialization message list flag defaulting to FND_API.G_FALSE, a commit flag defaulting to FND_API.G_FALSE, and a validation level defaulting to FND_API.G_VALID_LEVEL_FULL, returning the standard x_return_status, x_msg_count, and x_msg_data outputs.

Tables Accessed

The ETRM metadata for this package records no tables accessed through APPS synonyms. This indicates that the package body relies on the input utilization table structure and calls into underlying private or dependent packages rather than directly querying or mutating base tables through documented synonyms. Consumers should treat the utilization input table as the primary data contract and should not assume direct DML behavior against any particular base table by this package.

Usage Notes

This API is typically invoked from Oracle EBS forms, concurrent programs, or custom PL/SQL integrations that need to post counter readings for installed assets. Because it is classified as a public API, it is the supported interface for external callers; direct manipulation of utilization base tables is discouraged. Callers should supply p_api_version and inspect x_return_status after every invocation. When populating the utilization table parameter, care must be taken to provide only one of the valid identifying combinations per record, since combining them is not supported. Cascade behavior should be requested explicitly via the cascade flag, except where a counter id is supplied, in which case the cascade flag is ignored and only that counter is updated. The package is referenced by no other documented packages, so it functions as a leaf-level public entry point rather than an internal utility invoked elsewhere in the schema.