My Oracle Support Banner

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.