My Oracle Support Banner

ReIM RCA Resolution Updates Shipment And Order Tables But Does Not Create A Revision (Doc ID 2884265.1)

Last updated on JULY 20, 2022

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 and later
Information in this document applies to any platform.


On : 19.3 version, Integration

When resolving an invoice discrepancy in invoice matching, you observe that the RMS tables SHIPMENT and ORDLOC are updated with the new value
but ORDLOC_REV is not updated

You expect ORDLOC_REV to be updated

The issue can be reproduced at will with the following steps:1. create PO and shipment and receive it
 1. create invoice
 2. match invoice using a reason code where the invoice cost is correct over the PO cost
 3. complete the match process
 4. run all ReIM batches
 5. look at ORDLOC and see that the UNIT_COST is new cost and old cost in UNIT_COST_INT

Observe:  no ORDLOC_REV exists for this cost change




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.