RecUnitAdjCre Coming From RMS When Processed In SIM Does Not Update DSD_LINE_ITEM Table (Doc ID 2147045.1)

Last updated on JUNE 14, 2016

Applies to:

Oracle Retail Store Inventory Management - Version 14.1.2 and later
Information in this document applies to any platform.

Symptoms

The issue described in this document is known to Oracle, and a fix already scheduled for future release.
This article will be updated as official patch information becomes available.

When a RUA (RecUnitAdjCre) message come to SIM from RMS, we see that all the tables are updated expect the DSD_LINE_ITEM, due to which the quantity received still shows the old quantity instead of showing the adjusted quantity.

Steps to replicate:
1.Create a Purchase Order in RMS and allow to flow to SIM
2.Now create a ASN for this Purchase Order
3.Receive the DSD over this ASN in SIM.
4.Now adjust this delivery from RMS by performing a RUA (Receiver Unit Adjustment)
5.A RecUnitAdjCre message come to SIM and all the tables like PURCHASE_ORDER,PURCHASE_ORDER_LINE_ITEM, STORE_ITEM_STOCK, DSD are updated but DSD_LINE_ITEM table is not updated.

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