System Allows Deletion Of An Invoice With Matched Items (Doc ID 1953142.1)

Last updated on AUGUST 17, 2016

Applies to:

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

Symptoms


Find When an invoice with matched items is deleted, the items remain in matched status and cannot be corrected.


Steps
The issue can be reproduced at will with the following steps.
1. Create purchase order with 3 items.
2. Create shipment with one item from PO.
3. Receive shipment.
4. Create invoice for the PO with all items, ensure that Invoice doc date set more than 20 days prior to Vdate.
5. Run Automatch.
6. Inspect DB Table and note that:
IM_DOC_HEAD.STATUS ='URMTCH'
IM_INVOICE_DETAIL.STATUS='MTCH' ONLY for received item.
SHIPMENT.STATUS='M'
SHIPSKU.QTY_MATCHED='item's quantity'

7. Delete invoice from document maintenance
8. Inspect DB Table and note that:
IM_DOC_HEAD.STATUS ='DELETED'
IM_INVOICE_DETAIL.STATUS='MTCH' ONLY for received item.
SHIPMENT.STATUS='M'
SHIPSKU.QTY_MATCHED='item's quantity'

Expected behavior: SHIPMENT.STATUS should set back to 'U' and SHIPSKU.QTY_MATCHED should be in negative.



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