Search Results ahl_ump_util_pkg




Overview
Explore in AI Chat

Overview

APPS.AHL_UMP_UTIL_PKG is a utility package within the Oracle E-Business Suite Enterprise Asset Management (EAM) and Asset Lifecycle Management (ALM) modules, specifically belonging to the AHL (Asset Lifecycle) schema family used by Oracle Enterprise Asset Management and Complex Maintenance, Repair and Overhaul (cMRO). The package resides in the APPS schema, is classified under ETRM as an "OTHER" API, and is reported with a VALID status in both Oracle EBS 12.1.1 and 12.2.2. As its name implies, AHL_UMP_UTIL_PKG is a shared helper or utility package rather than a standalone business API. It provides reusable PL/SQL procedures and functions that support Unit Maintenance Processing (UMP) functionality, including unit effectivity handling, visit reconciliation, service request detail retrieval, and the population of Applicable Maintenance Requirement Setup (MRS) records. Because it aggregates low-level queries and data resolution logic, the package is consumed by many higher-level private APIs across the AHL module.

The package references the SYS.STANDARD package only, confirming it is a pure PL/SQL utility with no dependency on Oracle Forms built-ins or external toolkit libraries. The ETRM documentation notes an important circular-style reference: AHL_UMP_UTIL_PKG is referenced by AHL_UMP_UTIL_GRP (its wrapper group), and AHL_UMP_UTIL_GRP in turn references AHL_UMP_UTIL_PKG. This structure is common in EBS where a group package exposes the individual utility routines.

Key Procedures and Functions

The ETRM metadata documents thirteen callable members in AHL_UMP_UTIL_PKG. These are described only by name and purpose below; parameter lists are not published in the source metadata and should not be assumed.

  • GET_UNITNAME — Resolves and returns the display name of a unit, typically used when presenting unit identifiers in UMP screens and reports.
  • GETCOUNT_CHILDUE — Returns a count of child Unit Effectivities (UE) associated with a given parent unit effectivity, supporting hierarchy navigation.
  • GET_LAST_ACCOMPLISHMENT — Retrieves the most recent accomplishment (completion) record for a unit or task, used to derive maintenance history.
  • GET_FIRST_ACCOMPLISHMENT — Returns the earliest accomplishment record, enabling age or duration calculations.
  • GET_VISIT_DETAILS — Retrieves detailed information about a visit, drawing from visit header and task tables.
  • GET_VISIT_STATUS — Returns the current status of a visit, used to drive workflow and UI state.
  • IS_UE_IN_EXECUTION — A boolean-style check that determines whether a given Unit Effectivity is currently in execution, gating further processing.
  • GET_SERVICEREQUEST_DETAILS — Returns service request attributes, likely used to correlate maintenance work with Service/CRM requests.
  • POPULATE_APPL_MRS — Populates applicable maintenance requirements, a core step in determining which MRs apply to a unit.
  • PROCESS_GROUP_MRS — Processes a group of MRS records as a batch, likely iterating across applicable MRS rows.
  • PROCESS_GROUP_MR_INSTANCE — Processes a maintenance requirement instance within a group context.
  • GET_ASSOCIATED_FLEET — Returns the fleet (or fleets) associated with a unit, linking unit maintenance to fleet management.

These routines collectively cover unit identity resolution, effectivity hierarchy traversal, accomplishment history, visit management, MRS population, and fleet association — the data-gathering foundation for UMP processing.

Tables Accessed

The package reads and writes a defined set of AHL tables (accessed through APPS synonyms), covering configuration, effectivity, visits, MRS, and fleet domains:

Usage Notes

AHL_UMP_UTIL_PKG is not typically invoked directly by end users or via standalone concurrent programs. It is a dependency consumed by thirteen other AHL packages, including AHL_FMP_PVT, AHL_MC_ITEMGROUP_PVT, AHL_PRD_PARTS_CHANGE_PVT, AHL_UMP_PROCESSUNIT_PVT, AHL_UMP_PROCESSUNIT_EXTN_PVT, AHL_UMP_SMRINSTANCE_PVT, AHL_UMP_SR_PVT, AHL_UMP_UNITMAINT_PVT, AHL_UMP_UNPLANNED_PVT, and AHL_UMP_UTIL_GRP. It is also referenced by the view AHL_UNIT_EFFECTIVITIES_V, indicating it underpins unit effectivity reporting.

Because it is documented as an OTHER-class API, Oracle does not publish a formal public API contract for it; customization should therefore avoid direct calls where possible and favor the wrapping group or the higher-level private APIs. When troubleshooting UMP behavior — improper visit status, missing accomplishments, or unpopulated applicable MRS — AHL_UMP_UTIL_PKG and its dependent routines are primary diagnostic points. Always verify object validity after patches or upgrades, since the package must be VALID for the many dependents to compile and function correctly.