Canceling Refund Payment Request Does Not Unapply The Refund Application In AR

Applies to:

Oracle Payables - Version: 12.0.0 to 12.1.0 - Release: 12.0 to 12.0
Information in this document applies to any platform.
Symptoms

AP Periods : JAN-10, FEB-10 open.
AR Periods : JAN-10 open. FEB-10 never open.

1. Created a receipt for amount 100 and dated '30-JAN-2010'.
2. Created a refund against the receipt with Apply date '30-JAN-2010'.
3. AP invoice is created for the refund with date '30-JAN-2010'.
4. Canceled the invoice on date '02-FEB-2010' in AP.
5. Queried the receipt in AR. The refund application line is not unapplied and the receipt still shows as applied.

Cause

Bug 9226008

++ 1) Bug Summary
++ A. Functional
++ 1. Description
-> Refund is not being unapplied in Receivables (when AR
-> Period is closed) when
-> the corresponding AP Invoice is canceled in Payables.

fixed on ARXGREFB.pls 120.0.12000000.2
Solution

Code Fix
=======
Please apply one-off patch <<9226008:R12.AR.B>> to have the code fix.

Data Fix
=======
Please get reverse_receipt_refund_app.sql from Oracle Support.

Metalink Note: [ID 1066223.1]