SHIPMENT.INVC_MATCH_STATUS Column Shows Status 'U' Even After All Items Matched

(Doc ID 1603098.1)

Last updated on FEBRUARY 16, 2017

Applies to:

Oracle Retail Invoice Matching - Version 13.0.5.6 to 13.1 [Release 13.0 to 13.1]
Information in this document applies to any platform.

Symptoms

The SHIPMENT.INVC_MATCH_STATUS column shows status 'U' even after all items are matched.


Steps to Reproduce:

  1. Create a Purchase Order (PO) with 7 items. (Vdate = 20th Nov 2012)
  2. Create one new invoice using Document Maintenance screen, for 4 items and where only item3 has a higher cost on the invoice.
  3. Create receipt1 for item1 and item2.
  4. On same day, create receipt2 for item3.
  5. Run Automatch batch.
  6. Note that the invoice is now in URMTCH status.  Change the Vdate to next date (i.e., 21st Nov 2012).
  7. Create receipt3 for item4.
  8. Use Summary Match screen to resolve cost discrepancy. Say order is correct and invoice is wrong.
  9. Check the SHIPMENT table.  Status of item3 is still in ‘U’ status; it should be updated to 'M'. 

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