Search Results ahl_osp_accomp_pvt




Overview
Explore in AI Chat

Overview

The APPS.AHL_OSP_ACCOMP_PVT package is a private (PVT-classified) PL/SQL API within the Oracle Enterprise Asset Management (eAM) and Enterprise Asset Management for Process Manufacturing modules of Oracle E-Business Suite. It belongs to the AHL schema family, which supports the Oracle Asset Lifecycle and Maintenance/Service applications. Specifically, this package handles the accomplishment of One-Stop Planning (OSP) maintenance work orders, providing the internal logic that records the completion of maintenance service requests and validates the receipt status of installed units. It is a "private" API, meaning it is intended to be invoked only by other EBS packages or internal processes rather than directly by end users or external integrations. The package is validated in both 12.1.1 and 12.2.2, and its counterpart APIs in the AHL_OSP_ACCOMP_PUB family typically wrap or delegate to this private implementation. As the name indicates ("ACCOMP" for accomplishment), it is a foundational component for closing out maintenance tasks and updating related asset, order, and transaction records.

Key Procedures and Functions

The documented package exposes two program units:

  • ACCOMPLISH_OSP_MRS — This procedure accomplishes (completes) an OSP maintenance service request or work order. It likely updates the accomplishment records, sets order statuses, and reconciles order line and transaction details. It is the primary business logic entry point for marking OSP work as complete.
  • IS_RECEIVED_INST_SAME — This function validates whether an installed unit's receipt instance matches the expected instance. It is used to confirm that the asset instance received corresponds to the asset instance referenced in the maintenance transaction, preventing mismatches during accomplishment processing.

No parameter lists are documented in the ETRM metadata; the descriptions above reflect their documented names and inferred business roles.

Tables Accessed

The package reads from and writes to several core EBS tables via APPS synonyms:

This table footprint confirms the package's role in tying maintenance accomplishment to inventory, asset instance, and order data.

Usage Notes

Because AHL_OSP_ACCOMP_PVT is a private API, it is not intended for direct invocation by end users, forms, or concurrent programs. It is referenced by 0 other packages per the metadata but is part of the same internal call chain as its public counterpart; typically the public package (e.g., AHL_OSP_ACCOMP_PUB) or the One-Stop Planning work order form or concurrent process invokes these private routines during work order completion. Customizations should avoid calling the PVT package directly and instead use the supported public API. The package depends on FND_API and SYS.STANDARD, and its implementation relies on underlying AHL_OSP tables and Oracle Inventory (CSI) and Order Management (OE) tables.