After Upgrade To R12 Upgraded Translation Rate Types Cannot Be Updated
Last updated on FEBRUARY 12, 2018
Applies to:Oracle General Ledger - Version 12.0.5 and later
Information in this document applies to any platform.
This problem can occur on any platform.
After upgrade from 11.5.8 to R12, it is not possible to change the translation rate types.
When try to change the Currency Translation Options of period end and period average rates from the converted rate types to new rate types, the following error occurs.
You cannot update the period end or average rate type after running translation. You must purge translated balances first.
It is not possible for the historic translation balances to be purged.
However it is impractical to maintain a rate type for each ledger in a multi-org environment with more than 15 subsidiaries.
The issue can be reproduced at will with the following steps:
Open ASM with the relevant ledger.
Click on the Update sign for Reporting Currencies.
Click on Update.
The Currency Translation Options block holds the “New” R12 rate types for Period End & Period Average (with the ledger id suffix).
Choose the new for the Period End Rate Type.
Upgrade from 11.5.8 to release 12
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