Results for “gmi_shipping_util”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GMI_SHIPPING_UTIL is a private utility package in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, owned by the APPS schema and classified as a UTIL API within the ETRM framework. Its documented purpose is to contain private utilities relating to Oracle Process Manufacturing (OPM) shipping. The package header copyright notice and header block indicate it originated in the OPM development group (TVP, Reading, England) and was last updated in the 11.5.x source line, but it continues to be deployed and referenced in both 12.1.1 and 12.2.2 instances that have OPM and the Oracle Shipping Execution modules installed.

Key Procedures and Functions

The package exposes 15 documented procedures and functions. GMI_CREATE_BACKORDER_TXN and GMI_APPLY_BACKORDER_UPDATES manage backorder transaction creation and the application of resulting quantity updates during the shipping flow. GMI_UPDATE_SHIPMENT_TXN writes shipment-level transaction data. UPDATE_OPM_TRANSACTION and UPDATE_OPM_IC_TRAN_PND update the OPM inventory and inter-company pending transaction tables. CREATE_RCV_TRANSACTION generates receiving transactions from shipping activity. PROCESS_OPM_ORDERS drives the processing of OPM orders through the shipping pipeline. MATCH_LINES reconciles shipping lines against source order lines. UNRESERVE_INV and UNRESERVE_DELIVERY_DETAIL release inventory reservations against inventory and delivery detail records respectively. SPLIT_OPM_TRANS and SPLIT_TRANS create split delivery transactions, typically using the SplitDetailRecType record type declared in the header (modelled on WSH_DELIVERY_DETAILS columns). CHECK_NON_CTL validates non-controlled lot items. UPDATE_NEW_LINE_DETAIL_ID reassigns the line detail identifier after splits. PRINT_DEBUG is a diagnostic utility for tracing execution.

Tables Accessed

The package reads and writes the core Oracle Shipping Execution tables WSH_DELIVERY_DETAILS, WSH_DELIVERY_ASSIGNMENTS, and WSH_TRIP_STOPS, which hold delivery line, assignment, and trip stop data. It reads OPM master and inventory tables including IC_ITEM_MST, IC_LOCT_INV, IC_LOCT_MST, IC_LOTS_MST, IC_TRAN_PND, IC_TXN_REQUEST_LINES, and IC_WHSE_MST, which store OPM item, location, lot, pending transaction, transfer request, and warehouse information. It also references MTL_INTERORG_PARAMETERS, MTL_ITEM_LOC_DEFAULTS, MTL_ITEM_SUB_DEFAULTS, and MTL_PARAMETERS for inter-org transfer and defaulting rules, and FND_ORACLE_USERID for session/application context.

Usage Notes

GMI_SHIPPING_UTIL is not a public API; it is invoked internally by OPM shipping and Oracle Shipping Execution processes. It is referenced by two other packages, indicating it is called during delivery confirmation, backorder processing, split shipment handling, and OPM transaction posting. In EBS 12.1.1 and 12.2.2, customizations and extensions to OPM shipping should not call this package directly where a public API exists, but any custom code that must integrate with OPM shipping logic may reference the documented procedures. Because it uses AUTHID CURRENT_USER, it executes with the privileges of the calling user, and its behavior is typical of a low-level utility rather than a business-facing interface.