Fusion Applications - OTBI - "General Ledger - Transactional Balances Real Time"."Currency"."Translation Status" - Change From Rel 11 To Rel 12 (Doc ID 2305450.1)

Last updated on SEPTEMBER 08, 2017

Applies to:

Oracle Fusion General Ledger Cloud Service - Version 11.12.1.0.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

 ACTUAL BEHAVIOR
---------------
In Rel 11, the column

        "General Ledger - Transactional Balances Real Time"."Currency"."Translation Status"

shows two records (i.e "Foreign Currency Balance - Not a Translated Amount"   and     ""Ledger Currency Balance - Not a Translated Amount").


In Rel 12, the column

       "General Ledger - Transactional Balances Real Time"."Currency"."Translation Status"

shows only one record (i.e "Foreign Currency Balance - Not a Translated Amount"). The other record is NULL

EXPECTED BEHAVIOR
-----------------------
This is an expected behavior

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Build a new analysis using the below column in Rel 11 and Rel 12 env's

     "General Ledger - Transactional Balances Real Time"."Currency"."Translation Status"

2. Check the output
3. We can see the below output in Rel 11

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