Multiple Refunds Are Issued On Cross Currency RMA (Credit Memo)

(Doc ID 1952923.1)

Last updated on JANUARY 22, 2016

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Receipts Related

In case of "Refund" processing for RMA "Credit Card" orders, there are cases where the refunds happen in non-functional currency and there is difference in exchange rates of sales orders and RMAs.
For these cases, duplicate miscellaneous receipts corresponding to the refunds are getting created multiple times.

Moreover, in "AR_CASH_RECEIPT_HISTORY_ALL" table, the "CONFIRMED" and "REMITTED" rows are taking the exchange rate of the sales order date whereas the "CLEARED" row is taking the exchange rate of system date.
However, if exchange rate is same then duplicate refund receipts are not getting created.

You already applied <Patch 18439546>, to get the latest file version, however the issue is still reproducible if exchange rate from the sales order receipt is different than the RMA refund receipt creation.
If the exchange rate is same, then refund receipt is not getting created duplicate times.

Steps to Reproduce:
Process the sales order from Order Management till settlement in IBY with one exchange rate.
Process the RMA till refund miscellaneous receipt is created with a different exchange rate.
In this case, multiple miscellaneous receipts are created for the same RMA order.

Business Requirement: In cases of different exchange rates, between initial sales order and RMA only, one miscellaneous receipt needs to be created for refund RMA functionality.

Due to this issue, users have to reverse the duplicate refund Receipts.

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