Automatch Updates the DETAIL_MATCHED Value to 'Y' and Creates Invalid Discrepancies
Last updated on JULY 26, 2017
Applies to:Oracle Retail Invoice Matching - Version 12.0.12 and later
Information in this document applies to any platform.
The Automatch batch is updating the DETAIL_MATCHED flag to 'Y' and creating quantity discrepancies for invoices that have NOT met the routing days configuration for discrepancy routing.
Steps to Reproduce:
- Create one order with 3 items. (Example: Item1 - 280 Units; Item2 - 8000 Units; Item3 - 80 Units)
- Create 2 different invoices for two of the items. (Inv1: Item2 - 3900 Units; Inv2: Item3 - 80 Units)
- Receive one item. (Item2 - 2900, which is 1000 less then the invoice) This will create one shipment record in Retail Merchandising System (RMS) for only one item.
- Run the Automatch batch.
- Actual result: The invoices are moved to 'URMTCH' and DETAIL_MATCHED is updated to 'Y'. Quantity discrepancies are created. 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 invoices to create discrepancies.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms