In_Transit Quantity is Negative After the Allocation Receipt with Container_id Null

(Doc ID 2325525.1)

Last updated on NOVEMBER 27, 2017

Applies to:

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

Symptoms

In_Transit quantity is negative after the allocation receipt with CONTAINER_ID is Null.

Steps To Recreate:

  1. Create allocation for UNIT_QTY  10.
  2. Shipped the same with container_id "1234" and receive the same with CONTAINER_ID NULL.
  3. Check ITEM_LOC_SOH table, IN_TRANSIT_QTY is "-10".(negative)

    Check ALLOC_DETAIL table , QTY_RECEIVED is  20

    Check SHIPSKU table ,QTY_RECEIVED is still zero.

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