OTBI - "General Ledger - Journals Real Time" Subject Area does not show / missing Data - "Row Flattening" "Column Flattening" (Doc ID 1927199.1)

Last updated on JANUARY 27, 2016

Applies to:

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

Symptoms

On : 11.1.7.0.0 version and above, Technology Management - Reports/Analytics

ACTUAL BEHAVIOR
---------------
General ledger - Journals Real Time
We have created a value 8991 and create transactional data
included this value in hierarchy
published the hierarchy
When checking the OTBI reports we do not get the account 8991 in the account (Subjective) column.


EXPECTED BEHAVIOR
-----------------------
Data needs to be visible in the reports.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. created a value 8991 and create transactional data
included this value in hierarchy
published the hierarchy
When checking the OTBI reports we do not get the account 8991 in the account (Subjective) column.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot see the data

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