Account Analysis Report Ending Balance Mismatch (Doc ID 2834029.1)

Last updated on JANUARY 20, 2022

Applies to:

Symptoms

On : 11.13.21.10.0 version, GL Reports & Inquire Screens

ACTUAL BEHAVIOR
---------------
When running the Account Analysis Report, there is a difference between the Journal lines period activity shown in the report and the Beginning and Ending Balances.

EXPECTED BEHAVIOR
-----------------------
The Beginning and Ending Balance needs to be aligned with the Period activity (Beginning  Balance + - Period Activity = Ending Balance)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the Account Analysis Report with the parameters below:
SLA: Assets
Ledger: ABC
From and to : NOV-21
Include Accounts with No Activity set to No
Account Filter: 1 , value 160110.
2. The report shows
Ledger ABC
Account 110.00000.160110.000.0000.0000 USD

Beginning Balance: 19,407,462.72 DR      0 CR  
Period Activity      : 5,825.80 DR              5,825.80 CR , 100 CR
Total Period          : 5,825.80 DR             5,925.80 CR
Ending Balance     :19,412,362.72 DR      0 CR

There is a difference of 4,900 and the expected Ending Balance should be 19,407,362.72 DR based on the Period Activity  of 100 CR

Cause

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