My Oracle Support Banner

SHIPSKU Table Has Double Entries For Each Item One With QTY_RECEIVED = NULL And One With QTY_EXPECTED = NULL (Doc ID 2506460.1)

Last updated on AUGUST 16, 2022

Applies to:

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

Symptoms

SHIPSKU table has double entries for each item one with QTY_RECEIVED = NULL and one with QTY_EXPECTED = NULL

Steps to Recreate:

  1. Create a PO in Retail Merchandising System (RMS)
  2. Create a P type Advance Shipment Notification (ASN) from Warehouse Management System (WMS)
  3. Receive the item in WMS . Verify the SHIPSKU table data in RMS.

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


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