Currency Rounding Issue During Receipt Application in Foreign Currency
(Doc ID 1200154.1)
Last updated on APRIL 04, 2025
Applies to:
Oracle Receivables - Version 12 and laterInformation in this document applies to any platform.
Symptoms
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:
--------------
276338
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.
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |