Search Results gmi_om_utilities_pkg




Overview
Explore in AI Chat

Overview

GMI_OM_UTILITIES_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that provides utility processing for the Oracle Process Manufacturing (OPM/GMI) order management and inventory transaction flow. Its documented purpose centres on managing allocation and backorder relationships between pending inventory transactions, move order lines, and outbound delivery details within the shipping and warehouse execution process.

In the context of EBS 12.1.1 and 12.2.2, the package operates at the intersection of OPM inventory (IC) and Oracle Shipping Execution (WSH). It is classified as an "OTHER" API type within the ETRM repository, indicating it is an internal supporting utility rather than a formally published public API. Its status is VALID, confirming the compiled package is present and available in the APPS schema. The package depends on SYS.STANDARD and is referenced only by itself (its own package body), which is consistent with a self-contained private utility used by other OPM order management modules rather than one exposing a broad integration surface.

Key Procedures and Functions

The ETRM metadata documents a single procedure:

  • DELETE_ALLOC_BACKORDER_MO_LINE — Removes the allocation and backorder association tied to a move order line. The name indicates it handles the cleanup of linkage records created during allocation, allowing the move order line to be released or reassigned without lingering backorder and allocation references.

No parameter lists are published in the documented metadata, so only the functional intent is described here. The procedure should be regarded as an internal helper rather than an end-user callable routine.

Tables Accessed

The package reads and writes the following tables through APPS synonyms, which together describe the shipping and inventory execution chain:

  • WSH_DELIVERY_DETAILS — Oracle Shipping Execution's delivery detail table, storing the association between delivery assignments and source order or move order lines. The package reconciles or removes detail records when allocation and backorder references are deleted.
  • IC_TXN_REQUEST_LINES — The OPM inventory transaction (move order) request lines. This is the parent record whose allocation/backorder data the procedure purges.
  • IC_TRAN_PND — The OPM pending transaction table that holds inventory transactions awaiting processing; allocation and backorder movements pass through this staging area and must be cleared consistently.

The presence of these three tables confirms the package's role in keeping OPM move order processing synchronised with Oracle Shipping Execution and the pending inventory transaction queue.

Usage Notes

Because GMI_OM_UTILITIES_PKG is referenced by no other APPS packages and is not exposed as a public API, it is typically invoked indirectly. Common invocation paths include:

  • OPM order management and shipping forms that allow users to cancel, release, or modify move order lines, where backorder and allocation records must be cleaned up.
  • Concurrent programs or workflow processes that process OPM move orders and require the removal of stale allocation/backorder relationships.
  • Custom extensions or corrective scripts that need to clear a move order line's allocation and backorder state programmatically.

When calling or relying on this package, developers should verify the existence of related delivery detail, transaction request line, and pending transaction records before and after execution, since the procedure removes linkage rows rather than the parent move order line. Direct modification of the underlying tables without invoking the packaged logic risks inconsistency between OPM inventory and Oracle Shipping Execution. Given the limited ETRM documentation, the package should be treated as internal infrastructure, and any change control should account for its undocumented parameters and its tight coupling to the IC and WSH data model.