Currency Rounding Issue During Receipt Application in Foreign Currency
Last updated on JUNE 21, 2016
Applies to:Oracle Receivables - Version 12 and later
Information in this document applies to any platform.
***Checked for relevance on 24-Apr-2012***
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms