ReIM Invoice Remains in URMTCH Status After Detail Matching If Items With Zero Qty and Cost Are Present (Doc ID 1913418.1)

Last updated on FEBRUARY 20, 2023

Applies to:

Symptoms

In Oracle Retail Invoice Matching (ReIM), if we have items already matched with zero quantity in invoice details, it becomes impossible to complete the summary match process.

Steps to Reproduce:

1. Create 4 items: X,Y,Z,S
2. Create an order for these items; ship and receive.
3. Create an invoice that perfectly matches items X,Y but without Z,S.
4. Summary match the invoice.
5. Note that the invoice is in status MTCH.  Records for X,Y have been inserted into IM_PARTIALLY_MATCHED_RECEIPTS.
6. Create a second invoice.
7. In details, choose 'default from receipt'.  Items X,Y are inserted with qty zero. Items Z,S are inserted also.
8. Modify the invoice with cost discrepancy for items Z,S.
9. Summary match the second invoice.
10. Resolve the cost discrepancy for items Z,S.

Actual result:

• Items X,Y have no corresponding receipt records, and it is impossible to finish the summary match process.
• Records for Z,S have been inserted into IM_PARTIALLY_MATCHED_RECEIPTS.
• The shipment status now is matched, while the invoice still has the second invoice as unmatched.

Expected result:

• When editing invoices and adding items by clicking 'default from receipts', any items with qty of zero should not be copied. This will prevent this issue from recurring. The justification for this is that the customer may have a receipt with hundreds of items and it is not logical for them to choose each zero quantity and delete.
• Once the invoice discrepancies have been resolved, when exiting the invoice, detail matching should have automatically occurred to ensure all lines were matched.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.