My Oracle Support Banner

GLXRTDLY: How To Control The Precision Of Conversion Rates In General Ledger (Doc ID 135725.1)

Last updated on DECEMBER 04, 2020

Applies to:

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


NOTE: In the images/examples above or below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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.


To view full details, 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 a vibrant support community of peers and Oracle experts.