Container Units Changes To Negative When Doing Bulk Pick And Wrong Adjustment Generated With Reason Code 99.
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.
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 .
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