Search Results insert_rti

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.