Currency Rounding Issue During Receipt Application in Foreign Currency (Doc ID 1200154.1)

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***

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.

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