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 03, 2017

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.

Changes

 

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