Where is Extended Precision or Non-Rounded Values Stored for General Ledger (GL) Translated Values? (Doc ID 2799243.1)

Last updated on APRIL 04, 2025

Applies to:

Goal

At Translation the General Ledger Translation process calculates the translated currency value using GL Rates, rounds value to precision, and store the value to the GL_BALANCES table.   

Where can users find the non-rounded or extended precision value?

Ex. 

During translation Oracle GL is calculating translated balances from Local Currency (USD) to Foreign Currency (Eg CAD) using formula of 

    Local Amount * GL Exchange Rate.

Sample:  Amount 63537.87 * Rate 0.761411657212472 = $48,378.47489245060831464.

System precision is 2, so the GL_BALANCES Table stores the rounded value as $48,378.47

Solution

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