My Oracle Support Banner

Quantity Not Updating In Invoice Head And Detail Tables After Adjusting Delivery In SIM For DSD's. (Doc ID 2317881.1)

Last updated on DECEMBER 04, 2019

Applies to:

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


After performing Direct Store Delivery (DSD) for an On Fly Purchase Order (PO) in Store Inventory Management (SIM), data is coming to Retail Merchandising System (RMS) and Stock On Hand (SOH) is updated in both SIM and RMS tables, records are written in INVC_HEAD and INVC_DETAIL tables.

When performing Adjust Delivery in SIM for the DSD PO, the SOH is updated in both SIM and RMS but no record is updated in INVC_HEAD and INVC_DETAIL tables, because of this, invoice is not created for the adjusted quantity by the edidlinv batch and the same is processed in Retail Invoice Matching (ReIM).

Can you please clarify current behavior?


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

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