Unable To Resolve An Invoice With An Item Which Is Now Deleted From RMS (Doc ID 2880032.1)

Last updated on JUNE 30, 2022

Applies to:

Goal

Unable to resolve an invoice with an item which is now deleted from RMS.

Steps to Recreate

1.Create PO "PO1' for 3 items ('ITEM1','ITEM2','ITEM3') , ship
and receive it.

2.Create an invoice "INVC1" for above 3 items and add another item which is
not part of PO "ITEM4"

3.Delete the Item "ITEM4" in RMS .

4.No receipts exists with that item hence, not able to match it against the
respective order shipment receipt.

5.Tried to substitute a different item in place of deleted item in Invoice.
But the respective item_parent is not showing up in UI (Summary Match).

However, the item still exists in UNMTCH status in IM_INVOICE_DETAIL
Table
 

Solution

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