My Oracle Support Banner

Balances Amounts Incorrect at the Parent Level Using GL Balances Real Time (Doc ID 2289647.1)

Last updated on NOVEMBER 20, 2019

Applies to:

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

Symptoms

On :  N/A version, Financial Reporting and Analysis

ACTUAL BEHAVIOR  
---------------
When using General Ledger - Balances Real Time to generate a report the Ending Balance is incorrect for parent accounts

EXPECTED BEHAVIOR
-----------------------
All Ending Balances should be correct

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an OTBI report using  General Ledger - Balances Real Time.

2. Filters were assigned to:
COA
Ledger
Name
Currency
Period: Jan-17; Feb-17; Mar-17
Currency Type: Entered
Scenario:Actual
Sub Scenario: Actual
Account Tree: Account XYZ COA-Account Current  XYZ COA Current

3. Run the report.

The report shows:

                                        Jan-17                                              Feb-17
                 End Bal      Beg Bal       PNETA            End Bal        Beg Bal            PNETA

Income  -45514591.0    0           -8665401.5    -59675864.8   -8665401.1   -14161273.8

Only one children under Income
40900    -8665401.5      0          -8665401.5    -22826675.3   -8665401.1    -14161273.8

 

The ending balance for the Parent account is incorrect.



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users do not rely in the OTBI balances results.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.