My Oracle Support Banner

SHIPMENT.INVC_MATCH_STATUS Column Shows Status 'U' Even After All Items Matched (Doc ID 1603098.1)

Last updated on MARCH 05, 2019

Applies to:

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


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'. 


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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