AIP: Fully Received/Closed Orders Are Still Showing Outstanding Quantity in AIP

(Doc ID 2307861.1)

Last updated on DECEMBER 04, 2017

Applies to:

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

Symptoms

Fully received orders are closed in source application (RMS) and received_qty.dat / closed_order.dat are being interfaced to Advanced Inventory Planning (AIP). However in AIP, it was noticed that quantities are not getting updated correctly by RETL_LOAD package (retlload.pkb) due to which end-users can see outstanding quantity of such orders in the Order Management online, even though they are fully received.  Further NON_CONTENTS_ORDER.RECEIVED_QTY is shown as 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