Purchase Order Delivery Dates In NON_CONTENTS_ORDER Do Not Match The Dates In PO_MFQUEUE (Doc ID 2198628.1)

Last updated on OCTOBER 29, 2016

Applies to:

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

Symptoms

During the overnight batch, Purchase Orders are generated from the batch and populate the NON_CONTENTS_ORDER table. As part of the base batch, these purchase orders are sent through to the PO_MFQUEUE table as well in order to get sent to downstream systems (RIB, RMS).

We noticed there was a discrepancy between the orders in NON_CONTENTS_ORDER and those going through RIB.
We have now investigated this during the overnight batch process by pausing RIB and monitoring the PO_MFQUEUE table. We found that the the DELIVERY_DATE column in NON_CONTENTS_ORDER does not match NOT_BEFORE_DATE in PO_MFQUEUE in all cases.

This happens during every overnight batch or purchase orders.
Interestingly, the date mismatch does not appear to be entirely random. We can clearly see that the orders in PO_MFQUEUE do have the same dates as the orders in NON_CONTENTS_ORDER, but they have been mixed up.

For example if this is non contents order:

Order number Delivery Date
1234 2016-09-20
1235 2016-10-05
1236 2016-10-18

Then this will be PO_MFQUEUE:
Order Number Not_Before_Date
1234 2016-09-20
1235 2016-10-18
1236 2016-10-05

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