R12 When Upgrade Find Period End / Period Average Currency Rate Type For Translation Has Set_of_books_id Appended (Doc ID 1463136.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
Executable:GLTTRN - Translation

Symptoms

When upgrading from R11i to R12, the upgrade process creates a different Period End and Period Average rate type for each set of books upgraded to ledger and appends the ledger_id 
e.g. In R11i one Period End rate type called Period End becomes Period End1001

It does not create a single rate type although the same period rate and period average rate was used for Translation in all sets of books in R11i.

The “Balance level” reporting currency is the only one that will have the Default Period End Rate Type and Default Period Average Rate Type fields available.
The Subledger and Journal level reporting currencies do not have these.
The “Balance level” reporting currency is the one used for Translation.

Changes

 Upgrade from R11i to R12

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