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

4. We can see the below output in Rel 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