My Oracle Support Banner

After Upgrade To R12 Upgraded Translation Rate Types Cannot Be Updated (Doc ID 752682.1)

Last updated on MARCH 09, 2019

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 many subsidiaries.

The issue can be reproduced at will with the following steps:
Open Accounting Setup Manager 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.
Click Apply.


Upgrade from 11.5.8 to release 12


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

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