Search Results wms_putaway_utils

Overview

WMS_PUTAWAY_UTILS is an internal PL/SQL package owned by the APPS schema that supports the putaway and cross-docking flow within Oracle Warehouse Management (WMS) in Oracle E-Business Suite 12.1.1 and 12.2.2. Putaway is the process that determines the optimal final storage location for received material and generates the corresponding warehouse execution tasks. This utility package encapsulates the low-level validation, task creation, license plate number (LPN) handling, and Advanced Task Framework (ATF) interactions that the higher-level WMS and receiving APIs depend upon. Its documented status is VALID and its API classification is OTHER, indicating it is a supporting internal utility rather than a published integration API. The package exposes 24 documented procedures and functions spanning suggestion publishing, LPN manipulation, task grouping, and material status validation.

Key Procedures and Functions

The documented procedures address several functional clusters:

Task and group management: GET_SUBINVENTORY_TYPE, REMOVE_TASKS_IN_GROUP, UNLOAD_TASK, and CREATE_GROUPED_TASKS support identification of subinventory behavior and the creation, grouping, and removal of putaway tasks.
LPN handling: LOAD_LPN, DETACH_LOADED_LPNS, VALIDATE_INTO_LPN, CHECK_LPN_VALIDITY_WRAPPER, and TRANSFER_CONTENTS manage license plate loading, contents transfer, and validation of LPN structure.
ATF operations: ATF_FOR_MANUAL_DROP, COMPLETE_ATF_LOAD, ACTIVATE_PLAN_FOR_INSPECT, and CLEANUP_ATF drive Advanced Task Framework behavior for manual drops, load completion, and inspection.
Suggestion and cross-dock logic: SUGGESTIONS_PUB_WRAPPER, GET_CROSSDOCK_INFO, and UPDATE_LOC_SUGGESTED_CAPACITY publish location suggestions and manage cross-dock eligibility and suggested capacity.
Completion and validation: COMPLETE_PUTAWAY_WRAPPER, UPDATE_MO, VALIDATE_MATERIAL_STATUS, and INSERT_RTI finalize putaway, update move orders, and validate material status constraints.

Tables Accessed

The package reads and writes a range of inventory and warehouse tables through APPS synonyms:

Location and item definition: MTL_ITEM_LOCATIONS, MTL_SYSTEM_ITEMS, MTL_ITEM_REVISIONS, MTL_SECONDARY_INVENTORIES, and BOM_DEPARTMENTS supply physical locations, item attributes, revisions, and subinventory configuration.
Tracking and serialization: MTL_LOT_NUMBERS, MTL_SERIAL_NUMBERS, MTL_SERIAL_NUMBERS_TEMP, and MTL_SERIAL_NUMBERS_INTERFACE handle lot and serial control during load and validation.
Transaction staging: MTL_MATERIAL_TRANSACTIONS_S and MTL_MATERIAL_TRANSACTIONS_TEMP hold pending material transactions generated by putaway and cross-dock actions.
Supporting data: FND_USER, FND_NEW_MESSAGES, HR_ORGANIZATION_INFORMATION, and MO_GLOB_ORG_ACCESS_TMP provide user context, messages, organization access, and global organization filtering.

Usage Notes

WMS_PUTAWAY_UTILS is referenced by INV_RCV_STD_DELIVER_APIS, INV_RCV_STD_INSPECT_APIS, WMS_RCV_PUP_PVT, and WMS_TASK_DISPATCH_PUT_AWAY, confirming it is invoked during receiving delivery, inspection, putaway planning, and task dispatch. It also references WSH_UTIL_CORE for shipping utilities. Typical invocation occurs indirectly through the Warehouse Management mobile forms, putaway concurrent programs, and the receiving open interfaces rather than through direct custom calls. Because it is classified as OTHER and not a formal open API, customizations should avoid direct invocation and instead use the documented public wrappers that reference it, ensuring upgrade-safe behavior across 12.1.1 and 12.2.2.

PACKAGE: APPS.WMS_PUTAWAY_UTILS 12.1.1
owner:APPS, object_type:PACKAGE, object_name:WMS_PUTAWAY_UTILS, status:VALID,
PACKAGE: APPS.WMS_PUTAWAY_UTILS 12.2.2
owner:APPS, object_type:PACKAGE, object_name:WMS_PUTAWAY_UTILS, status:VALID,
PACKAGE BODY: APPS.WMS_PUTAWAY_UTILS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WMS_PUTAWAY_UTILS, status:VALID,
SYNONYM: APPS.WMS_PUTAWAY_GROUP_TASKS_GTMP 12.1.1
owner:APPS, object_type:SYNONYM, object_name:WMS_PUTAWAY_GROUP_TASKS_GTMP, status:VALID,
PACKAGE BODY: APPS.WMS_PUTAWAY_UTILS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WMS_PUTAWAY_UTILS, status:VALID,
SYNONYM: APPS.RCV_SERIALS_INTERFACE 12.2.2
owner:APPS, object_type:SYNONYM, object_name:RCV_SERIALS_INTERFACE, status:VALID,
PACKAGE: APPS.INV_UI_ITEM_SUB_LOC_LOVS 12.2.2
owner:APPS, object_type:PACKAGE, object_name:INV_UI_ITEM_SUB_LOC_LOVS, status:VALID,
SYNONYM: APPS.WMS_PUTAWAY_GROUP_TASKS_GTMP 12.2.2
owner:APPS, object_type:SYNONYM, object_name:WMS_PUTAWAY_GROUP_TASKS_GTMP, status:VALID,
PACKAGE: APPS.WMS_OP_INBOUND_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:WMS_OP_INBOUND_PVT, status:VALID,
PACKAGE: APPS.INV_UI_ITEM_SUB_LOC_LOVS 12.1.1
owner:APPS, object_type:PACKAGE, object_name:INV_UI_ITEM_SUB_LOC_LOVS, status:VALID,
SYNONYM: APPS.RCV_LOTS_INTERFACE 12.2.2
owner:APPS, object_type:SYNONYM, object_name:RCV_LOTS_INTERFACE, status:VALID,
PACKAGE: APPS.RCV_TRX_INTERFACE_INSERT_PKG 12.1.1
owner:APPS, object_type:PACKAGE, object_name:RCV_TRX_INTERFACE_INSERT_PKG, status:VALID,
PACKAGE: APPS.WMS_OP_RUNTIME_PVT_APIS 12.1.1
owner:APPS, object_type:PACKAGE, object_name:WMS_OP_RUNTIME_PVT_APIS, status:VALID,
PACKAGE: APPS.WMS_OP_RUNTIME_PVT_APIS 12.2.2
owner:APPS, object_type:PACKAGE, object_name:WMS_OP_RUNTIME_PVT_APIS, status:VALID,
PACKAGE: APPS.WMS_RE_CUSTOM_PUB 12.2.2
owner:APPS, object_type:PACKAGE, object_name:WMS_RE_CUSTOM_PUB, status:VALID,
PACKAGE: APPS.WMS_WIP_INTEGRATION 12.1.1
owner:APPS, object_type:PACKAGE, object_name:WMS_WIP_INTEGRATION, status:VALID,
PACKAGE: APPS.INV_RCV_MOBILE_PROCESS_TXN 12.1.1
owner:APPS, object_type:PACKAGE, object_name:INV_RCV_MOBILE_PROCESS_TXN, status:VALID,
PACKAGE: APPS.WMS_OP_INBOUND_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:WMS_OP_INBOUND_PVT, status:VALID,
SYNONYM: APPS.WMS_OP_OPERATION_INSTANCES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:WMS_OP_OPERATION_INSTANCES, status:VALID,
PACKAGE: APPS.INV_RCV_CACHE 12.1.1
owner:APPS, object_type:PACKAGE, object_name:INV_RCV_CACHE, status:VALID,
SYNONYM: APPS.WMS_OP_OPERATION_INSTANCES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:WMS_OP_OPERATION_INSTANCES, status:VALID,
PACKAGE: APPS.WMS_WIP_INTEGRATION 12.2.2
owner:APPS, object_type:PACKAGE, object_name:WMS_WIP_INTEGRATION, status:VALID,
PACKAGE: APPS.WMS_TASK_DISPATCH_GEN 12.2.2
owner:APPS, object_type:PACKAGE, object_name:WMS_TASK_DISPATCH_GEN, status:VALID,
SYNONYM: APPS.WMS_OP_PLAN_INSTANCES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:WMS_OP_PLAN_INSTANCES, status:VALID,
SYNONYM: APPS.WMS_OP_PLAN_INSTANCES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:WMS_OP_PLAN_INSTANCES, status:VALID,
PACKAGE: APPS.RCV_TRX_INTERFACE_INSERT_PKG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:RCV_TRX_INTERFACE_INSERT_PKG, status:VALID,
PACKAGE: APPS.INV_LOC_WMS_UTILS 12.2.2
owner:APPS, object_type:PACKAGE, object_name:INV_LOC_WMS_UTILS, status:VALID,
PACKAGE: APPS.WMS_TASK_DISPATCH_PUT_AWAY 12.1.1
owner:APPS, object_type:PACKAGE, object_name:WMS_TASK_DISPATCH_PUT_AWAY, status:VALID,
PACKAGE: APPS.WMS_ATF_RUNTIME_PUB_APIS 12.2.2
owner:APPS, object_type:PACKAGE, object_name:WMS_ATF_RUNTIME_PUB_APIS, status:VALID,
PACKAGE: APPS.WMS_MDC_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:WMS_MDC_PVT, status:VALID,
PACKAGE: APPS.INV_RCV_MOBILE_PROCESS_TXN 12.2.2
owner:APPS, object_type:PACKAGE, object_name:INV_RCV_MOBILE_PROCESS_TXN, status:VALID,
PACKAGE: APPS.WMS_MDC_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:WMS_MDC_PVT, status:VALID,
PACKAGE: APPS.WMS_TASK_DISPATCH_PUT_AWAY 12.2.2
owner:APPS, object_type:PACKAGE, object_name:WMS_TASK_DISPATCH_PUT_AWAY, status:VALID,
SYNONYM: APPS.RCV_SERIALS_SUPPLY 12.1.1
owner:APPS, object_type:SYNONYM, object_name:RCV_SERIALS_SUPPLY, status:VALID,
PACKAGE: APPS.WMS_ATF_RUNTIME_PUB_APIS 12.1.1
owner:APPS, object_type:PACKAGE, object_name:WMS_ATF_RUNTIME_PUB_APIS, status:VALID,
PACKAGE: APPS.INV_LOC_WMS_UTILS 12.1.1
owner:APPS, object_type:PACKAGE, object_name:INV_LOC_WMS_UTILS, status:VALID,
PACKAGE: APPS.INV_RCV_CACHE 12.2.2
owner:APPS, object_type:PACKAGE, object_name:INV_RCV_CACHE, status:VALID,
PACKAGE: APPS.WMS_TASK_DISPATCH_GEN 12.1.1
owner:APPS, object_type:PACKAGE, object_name:WMS_TASK_DISPATCH_GEN, status:VALID,
PACKAGE BODY: APPS.WMS_RCV_PUP_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WMS_RCV_PUP_PVT, status:VALID,
PACKAGE: APPS.WSH_DELIVERY_DETAILS_GRP 12.2.2
owner:APPS, object_type:PACKAGE, object_name:WSH_DELIVERY_DETAILS_GRP, status:VALID,
SYNONYM: APPS.RCV_SERIALS_SUPPLY 12.2.2
owner:APPS, object_type:SYNONYM, object_name:RCV_SERIALS_SUPPLY, status:VALID,
PACKAGE: APPS.WMS_CONTAINER_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:WMS_CONTAINER_PVT, status:VALID,
PACKAGE: APPS.INV_LPN_TRX_PUB 12.2.2
owner:APPS, object_type:PACKAGE, object_name:INV_LPN_TRX_PUB, status:VALID,
PACKAGE BODY: APPS.INV_RCV_STD_INSPECT_APIS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:INV_RCV_STD_INSPECT_APIS, status:VALID,
PACKAGE BODY: APPS.WMS_RCV_PUP_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WMS_RCV_PUP_PVT, status:VALID,
PACKAGE: APPS.INV_RCV_INTEGRATION_APIS 12.1.1
owner:APPS, object_type:PACKAGE, object_name:INV_RCV_INTEGRATION_APIS, status:VALID,
PACKAGE: APPS.WMS_GLOBALS 12.1.1
owner:APPS, object_type:PACKAGE, object_name:WMS_GLOBALS, status:VALID,
PACKAGE: APPS.INV_LPN_TRX_PUB 12.1.1
owner:APPS, object_type:PACKAGE, object_name:INV_LPN_TRX_PUB, status:VALID,
SYNONYM: APPS.MO_GLOB_ORG_ACCESS_TMP 12.2.2
owner:APPS, object_type:SYNONYM, object_name:MO_GLOB_ORG_ACCESS_TMP, status:VALID,
PACKAGE: APPS.WMS_CONTAINER_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:WMS_CONTAINER_PVT, status:VALID,