GLXRTDLY: How To Control The Precision Of Conversion Rates In General Ledger

(Doc ID 135725.1)

Last updated on APRIL 22, 2018

Applies to:

Oracle General Ledger - Version 11.0 to 11.5.10.2 [Release 11 to 11.5.10]
Information in this document applies to any platform.
GLXRTDLY

Goal

Responsibility: General Ledger Super User
Navigation: Setup/Currencies/Rates/Daily
Form: Daily Rates (GLXRTDLY)

You are trying to define conversion rates (either update existing rates or enter new rates) on the Daily Rates form in General Ledger.
 
You query an existing currency conversion (for example, From = CAD and To = USD) for a particular Date and Type.  You modify an already defined conversion rate (in the CAD to USD column), but the 2nd column (USD to CAD) is automatically recalculated. The same thing happens when you enter a new record.

When you look at the column conversion_rate on the GL_DAILY_RATES table, the calculation may be for a large precision, for example .02006823198876179008629339755167569737.  You would like the conversion rate to be exactly what you enter for both rates on this form.

Solution

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