Valid Discrepancies Cannot Be Resolved in ReIM (Doc ID 2265497.1)

Last updated on MAY 16, 2017

Applies to:

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

Symptoms


An open cost discrepancy exists on the invoice and cannot be resolved as the shipment is closed.

Steps to Reproduce:

1. Create multiple new items.
2. Create a new order with the quantities below for the mulitple items.


Item_1   3
Item_2   3
Item_3   2
Item_4   8
Item_5   3
Item_6   3
Item_7   2
Item_9   8
Item_10  2
Item_11  4
Item_12  4

3. Increment vdate by one day.

4. Ship and receive the quantities below
Item_1   3
Item_2   3
Item_3   2
Item_4   8
Item_5   3
Item_11  1
Item_12  3

5. Additional smaller shipments are received for remaining open quantities.
Item_6   1
Item_6   1
Item_8   1
Item_8   1
Item_9   1
Item_9   1

6. Cancel the outstanding open PO line quantities that have not been received.

ITEM     QTY_CANCELLED
Item_6   1
Item_9   6
Item_10  2
Item_11  3
Item_12  1

7. Run docclose to close PO.

8. Increment vdate by one day.

9. Create 2 new invoices with the following quantities.

DOC_ID ITEM       INVOICE_QTY
530004 Item_6     2
530004 Item_8     2
530004 Item_9     2
530005 Item_3     1
530005 Item_4     8
530005 Item_5     3
530005 Item_12    3

10. Run reimautomatch, reimrollup, reimposting.

Both documents are matched and posted.

11. Increment vdate by one day.

12. Create a third invoice with the following quantities.

DOC_ID ITEM          UNIT_COST INVOICE_QTY
535002 Item 1         10        3
535002 Item 2         10        3
535002 Item 3         10        1
535002 Item_11        10        1

13. In the nightly batch run reimdiscrepancypurge , reimautomatch, reimrollup, and reimposting.
- Ensure parameters for reimdiscrepancypurge are as indicated below:
reimdiscrepancypurge <alias> PURGE ALL COMMIT
Observe that SHIPMENT.invc_match_status = 'M'.
Observe quantity discrepancy is created for 3rd Invoice.


14. Increment vdate by one day.

16. Attempt to resolve the quantity discrepancy by manually matching invoice to receipts.
Observation: Unable to Match invoice - Even though receipt quantity for unmatched invoice line is present, it doesn't show up in manual matching.

Changes

 

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