My Oracle Support Banner

Troubleshooting Currencies, Translation, Revaluation (Doc ID 120086.1)

Last updated on JUNE 01, 2023

Applies to:

Oracle General Ledger - Version 10.7 and later
Information in this document applies to any platform.
GLTTRN;GLCRVL;GLXFCRVL.FMB;GLXXTB.RDF


Purpose

When investigating problems in these areas the solution is often in the relevant Technical briefs which also provide a useful insight into the Topic. Please refer to the following Technical briefs:
<Note:187404.1> How does Revaluation Work?
<Note:139717.1> Translation
<Note:139718.1> Revaluation

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Troubleshooting Steps
 REVALUATION
 1. Revaluation fails with APP-1637, combination not defined.
 2. Revaluation creates journal entry for incorrect amount.
 3. APP-00251 when running revaluation process GLCRVLIS.
 4. Revaluation, SHRD0001 error in afpoget CRVL0011, ORA-00904 invalid column name.
 5. Revaluation goes to the wrong unrealized gain/loss account.
 6. What steps can be used to troubleshoot an incorrect Revaluation amount ?
 TRANSLATION
 7. Changed Translation Account and now Trial Balance is out of balance.
 8. FRM-40212 Running Translation for a period prior to first translation.
 9. SHRD0018 Oracle Database Error GET_SET_INFO_LABEL: 1403 running Translation.
 10. Cannot find currency in List of Values when running Trial Balance-Translation Report (GLXXTB).
 CONVERSION
 11. Journal Enter form the Converted amount cannot be changed.
References

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