My Oracle Support Banner

DMS Error When Attempting To Check Stock Order Status Inquiry Screen For A Stock Order Having STOCK_ALLOCATION.REQUESTED_UNIT_QTY As Zero (Doc ID 2294376.1)

Last updated on FEBRUARY 02, 2021

Applies to:

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


If a stock order has STOCK_ALLOCATION.REQUESTED_UNIT_QTY set to 0, DMS error occurs when searching for the same in stock order status inquiry screen.


Steps To Recreate:

1. SCP parameter BACK_ORDER_FLAG in  Retail Warehouse Management System(RWMS) is set to 'N'.
2. Create transfer for 1 item and 1 unit in Retail Merchandising System(RMS) .Transfer has flown to RWMS as stock order.
3. Perform stock adjustment for this item in RWMS so that there is no stock available.
4. Assign wave to the stock order in Manual Wave Review Screen.
5. Check No Inventory(NI) SO status message has been generated.A record has been inserted in STOCK_ORDER_INFO_UPLOAD table for NI SO Status message.
6. In GUI ,Navigate to Distribution Planning > STOCK ORDER STATUS INQUIRY.
7. Enter customer order and distro_nbr. 
8. Press Search > DMS ERROR appears


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.