My Oracle Support Banner

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

Last updated on MARCH 18, 2019

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

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
Symptoms
Cause
Solution
References


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