Automatch Updates DETAIL_MATCHED Value to 'Y' for All Invoices of Same PO

(Doc ID 2036219.1)

Last updated on JULY 21, 2017

Applies to:

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

Symptoms

Automatch batch updates the DETAIL_MATCHED value to 'Y' for all invoices under the same Purchase Order (PO) even though only one of the invoices was matched to the receipt. Because of this, when the receipt happens for the other items, Automatch does not pick up the invoices for matching. It is expected that ReIM should wait the routing days for the other two invoices.

Steps to Reproduce:

  1. Create one order with 3 items.
  2. Create 3 different invoices for each item ReIM with details (or EDI invoice for each item).
  3. Receive one item in Store Inventory Management (SIM).  This will create one shipment record in Retail Merchandising System (RMS) for only one item.
  4. Run the Automatch batch.
  5. Notice that automatch is matching the item received and one invoice.  Other invoices are moved to 'URMTCH' but DETAIL_MATCHED is updated to 'Y', and quantity discrepancies are created.

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