GLXRTDLY: How To Control The Precision Of Conversion Rates In General Ledger
(Doc ID 135725.1)
Last updated on DECEMBER 04, 2019
Applies to:Oracle General Ledger - Version 11.0 to 126.96.36.199 [Release 11 to 11.5.10]
Information in this document applies to any platform.
Responsibility: General Ledger Super User
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!