Already Matched Items Added Again Into Posting Tables While Online Matching Second Invoice (Doc ID 2168906.1)

Last updated on AUGUST 10, 2016

Applies to:

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

Symptoms

 

While doing online matching of second invoice, items from first invoice were added again into posting tables.

Already  matched items with first invoice are added again into  IM_RCPT_ITEM_POSTING_INVOICE, IM_RECEIPT_ITEM_POSTING tables while doing  online matching of second invoice. Thus gets the double records in  IM_RCPT_ITEM_POSTING_INVOICE, IM_RECEIPT_ITEM_POSTING tables.

Steps To Recreate:

  1. Create and Ship Purchase Order (PO).
  2. Create invoice for part of PO
  3. Match invoice.
  4. Check results in IM_PARTIALLY_MATCHED_RECEIPTS, IM_RCPT_ITEM_POSTING_INVOICE, IM_RECEIPT_ITEM_POSTING
  5. Create second invoice for rest part on PO.
  6. Go to Online matching.
  7. Select Invoice and receipt, note that there are no discrepancies.
  8. Click Online Match button.
  9. Notice that second invoice is matched.
  10. Note that records got created into posting tables  IM_PARTIALLY_MATCHED_RECEIPTS, IM_RCPT_ITEM_POSTING_INVOICE for the  items from first invoice also along with items from second invoice which  is leading to double quantity for items from first invoice. 

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