REIM Using Invoice Cost Wrongly For Receipt / PO Cost Resolution For 0 Receipt (Doc ID 3081775.1)

Last updated on APRIL 15, 2025

Applies to:

Symptoms

When resolving an invoice with no receipt, REIM is allowing users to detail match and offers resolution at both units and at cost level. If the user chooses to resolve by receipt, quantity resolution is showing whatever the receipt (0 qty) - invoice cost showing the -ve value of the invoice.

However, for cost resolution, the label shows Receipt(Order) Unit cost and even offers Reason code that says Purchase Order Cost Difference - Debit Memo. If there is no receipt, will it take then the PO cost from ORDLOC and deduct this from the invoice cost to get the difference.
It clearly says in the label as Purchase Order Cost difference but what happens behind the scene is that it takes 0 as the receipt cost (and not the PO cost) - invoice cost which then shows -ve of the invoice cost in the resolution action.

Steps To Recreate :

1. Create a PO. Do NOT ship/receive.
2. Create an invoice with at least cost for one of the item in the invoice doesn't match the PO.
3. Summary Match the invoice (receipt should not show in REIM since there isn't any).
4. Perform detail match to attempt resolution.
5. Resolve the invoice accepting receipt qty as the Quantity Resolution and Receipt(Order) Unit cost as the Unit Cost Resolution.
  Provide the resolution reason. For QTY, choose 03D - which says Purchase Order Cost difference - Debit Memo
6. Query the item in question (with cost difference) in IM_RESOLUTION_ACTION. Notice it has -ve of the invoice unit cost and not the difference between the PO cost
  and the invoice cost even if the label and same purchase order cost in the reason for the resolution.

Cause

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