Currency Rounding Issue During Receipt Application in Foreign Currency
(Doc ID 1200154.1)
Last updated on JANUARY 05, 2021
Applies to:Oracle Receivables - Version 12 and later
Information in this document applies to any platform.
When exchange rate is calculated, the Accounted Amounts rounding is not done correct.
For example, in AR_DISTRIBUTIONS_ALL table, when the Receipt is created with Exchange Rate set to 1135 and an UNAPP line has AMOUNT_CR = 243.47, the ACCTD_AMOUNT_CR is getting calculated to 276339.
But as per the rounding calculation, it should be 276338. See the below calculation:
SELECT round(243.47/13668.83*15514122,0) FROM dual;
1 Row is returned:
Also when on observation we see ACCTD_AMOUNT_DR is 276338, which seems to be correct.
Also because of this difference, CURR_ROUND Line is also generated for ACCTD_AMOUNT_DR = 1 to balance the ACCTD_AMOUNT_DR and ACCTD_AMOUNT_CR.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document