My Oracle Support Banner

During Bulk Replenishment, Inventory Adjustment Gets Created With Missing Adjustment Reason Code (Doc ID 1596515.1)

Last updated on APRIL 01, 2021

Applies to:

Oracle Retail Warehouse Management System - Version 13.1.3 and later
Information in this document applies to any platform.


When a Bulk Replenishment (BD) pick is dropped off at a staging location and the putaway screen is used to put it away, if a short is done at this time, an inventory adjustment record is being created, however the ADJUSTMENT_REASON_CODE is NULL and the upload flag is ‘N’. This causes stock misalignment between Retail Merchandising System (RMS) and Warehouse Management System (RWMS)

Steps to recreate

1. Generate a BD pick for an item.
2. Go to the Radio Frequency (RF) Bulk Replenishment screen and enter the zone, location and container details.
3. Click F4-Done. Receive the message to confirm the location has merchandise. Acknowledge the message.
4. Next, the user is taken to the drop-off screen, drop the pallet to a staging location.
5. Navigate to the RF Putaway Screen.
6. Enter the pallet ID and press enter.
7. The screen displays the CONTAINER_ID, ITEM and LOCATION_ID. Confirm the LOCATION_ID, which is the Forward Picking Location.
8. The case pack and the container quantity is displayed. In the 'Confirm Quantity' field, enter a value lesser than displayed, which makes it a short pick.
9. Click F4-Done, get the QTY MISMATCH message, acknowledge and re-enter the same shorted quantity as entered initially.
10. Click F4-Done again, and get the SUCCESSFUL OPERATION message.
11. Review the tables:
     The container is no longer in the CONTAINER table.
     The PICK_FROM_LOC location has the correct UNIT_QTY reflecting the shorted value, and the INBOUND_UNIT_QTY is correctly updated.
     The INV_ADJUSTMENT_TO_UPLOAD tables shows the record for the item that was shorted, with the correct UNIT_QTY being shorted, however, there is no ADJUSTMENT_REASON_CODE being captured.




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.