Account Financial History Current Balance VS Current Balance In The Dashboard DOES NOT MATCH (Doc ID 3031053.1)

Last updated on JUNE 26, 2024

Applies to:

Goal

On: 2.9.0.0.0 version, Framework

ACTUAL BEHAVIOR
---------------
Account Financial History Current Balance VS Current Balance in the Dashboard DOES NOT MATCH

Analysis, the Account Financial History limits up to 1000 records only. The Current balance was affected.
It started the computation on the record 1000 but did not consider the next record

EXPECTED BEHAVIOR
-----------------------
Account Financial History Current Balance VS Current Balance in the Dashboard SHOULD MATCH

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Account Financial History Current Balance VS Current Balance in the Dashboard DOES NOT MATCH
2. Account, the current balance is correct and the same with the dashboard
3. SA Financial History is correct
4. Analysis, the Account Financial History limits up to 1000 records only. The Current balance was affected.
5. It started the computation on the record 1000 but did not consider the next record
6. select * from ci_ft where sa_id in (select sa_id from ci_sa where acct_id = 'XXXXXXXXX') order by cre_dttm desc;

Row Count: 1421

Solution

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