After Upgrade To R12 Upgraded Translation Rate Types Cannot Be Updated

(Doc ID 752682.1)

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.

Symptoms

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.

ERROR
-----------------------
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.

STEPS
-----------------------
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.
Click Apply.

Changes

Upgrade from 11.5.8 to release 12

Cause

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