Container Units Changes To Negative When Doing Bulk Pick And Wrong Adjustment Generated With Reason Code 99. (Doc ID 2130328.1)

Last updated on APRIL 14, 2017

Applies to:

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

Symptoms

In RWMS(Retail Warehouse Management System) application after splitting a container into another container that is present in the PICK_DIRECTIVE table and with pick type 'B' and then perform picking on the Pick Directive container
Negative inventory adjustment can be seen in the table CONTAINER_ITEM fir the UNIT_QTY & DISTRIBUTED_QTY

Steps to recreate
1 Create a stock order
2 Distribute it ( make sure pick type should be B_PICK)
3 After generation of picks, confirm the PICK_FROM_CONTAINER& PICK_TO_CONTAINER having proper records.
4 split any 'I' status container in generatedPICK_FROM_CONTAINER, make sure split quantity must be grater than the distributed quantity.
5 perform Bulk pick operation
6 confirm requested quantity.
7 A message pop-up (i.e. Quantity differs from pick directive)
8 Click "Ok"
9 system will ask adjustment code '99', pass the adjustment for remaining quantity in PICK_FROM_CONTAINER, because it was having more units then pick units generated.
10 check STOCK_ALLOCATION, CONTAINER_ITEM.UNIT_QTY and CONTAINER_ITEM.DISTRIBUTED_UNIT_QTY negative quantity populated .

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms