My Oracle Support Banner

Pick Result Messages Fail With 'Location/Item Relation Not Found' Error in RWMS (Doc ID 2021462.1)

Last updated on MARCH 03, 2019

Applies to:

Oracle Retail Warehouse Management System - Version 13.2 to 13.2.8 [Release 13.2]
Information in this document applies to any platform.


Forward Pick Location (FPL) management allowed to move an item to another FPL location when records still existed in ELIGIBLE_INVENTORY table causing pick result messages failing with "Location/Item relation not found" error in Oracle Retail Warehouse Management System (RWMS).

Steps to recreate the issue

1. Waved stock orders to generate Case Forward (CF) picks
2. Run distribution picks up the stock orders and calculates the eligible inventory based on the current pick face.
3. Once eligible inventory is calculated, the job starts the pick creation process.
4. In between eligible inventory calculation completion and pick creation, the user uses the FPL management screen to move the item to another Forward Case Pick Location (FCPL). The screen also de-associates the item-previous FCPL link.
5. Run distribution generates pick directives based on the old FCPL location. The picker won’t be able to find stock in the old FCPL location, so completes the pick with 0 units and sends the result back to WMS.
6. This pick result message will fail in WMS as the inbound package looks for item-FCPL association to process the pick message




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.