R12: AP: Workarund to Avoid Deletion of a Credit Note / Invoice Matched to a Purchase Order (Doc ID 2785871.1)

Last updated on JUNE 19, 2021

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------

Issues with Quantity Received (Qty Rec) Holds being released by the system when not expected after the invoice was validated. A Credit Memo was created against the same Purchase Order (PO), but after the invoice validation, users discarded the lines and deleted the Credit Memo from the system.


EXPECTED BEHAVIOR
-----------------------
Expect the system do not to allow to delete an invoice matched to PO, having discarded lines.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
a).  Login in Oracle Applications
b).  Responsibility Payables
c).  (N) Invoice > Entry > Invoices
d).  Create an invoice with €100 (Qty 100 x price of 1.00) and match to a PO that has a Quantity Ordered (Qty Ord) of 50 and a Qty Rec of 50.
e).  The invoice is validated and goes on expected Qty Ord and Qty Rec holds.
f).   A Credit Note is entered for the quantity of 50 and matched to the same PO but not validated.
g).  Invoice already matched is validated and holds are released as the billed qty is now 50 and matches received and ordered quantity.
h).  The line can then be discarded on the Credit Note and the Credit Note deleted from the system. Now there is no record of how the holds on the Invoice got released as the Billed Qty is back to 100 and the Ord and Rec Qty are 50.
i).   This may be a loop-hole, as an invoice/credit note that has discarded lines that were previously matched to a PO should not allow deletion.

Cause

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