My Oracle Support Banner

QTY_RECEIVED and LAST_RECEIVED Columns in ORDLOC Table are Getting Updated as NULL Value when Trying to Receive More than One Item (Doc ID 2239440.1)

Last updated on MARCH 05, 2019

Applies to:

Oracle Retail Merchandising System - Version 14.0.2 and later
Information in this document applies to any platform.

Symptoms

QTY_RECEIVED And LAST_RECEIVED columns in ORDLOC table are getting updated as NULL value when trying to receive more than one item

Steps to Reproduce:

1. Create a Purchase Order (PO) with 2 items
2. Ship these 2 items (Go to menu: Inventory > Shipping > Order Shipment)
3. Receive these 2 items (Go to menu: Inventory > Receiving > Item Receiving)
4. Note QTY_RECEIVED And LAST_RECEIVED in ORDLOC screen is getting updated NULL value.

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.