General Ledger - Transactional Balances Real Time : Base Equivlent versus BEQ Balances Are Not Matching when Figures Have More than 15 Digits (Doc ID 2876844.1)

Last updated on JUNE 14, 2022

Applies to:

Symptoms

In the Oracle seeded subject area "General Ledger - Transactional Balances Real Time" for the columns "Entered"."Entered Period Net Activity DR" and "Entered"."Entered Period Net Activity CR" were not matching between Database values.

For example : Here is the SQL to populate the Period Net Activity DR and Period Net Activity CR from DB.

You can see different number if you build analysis using subject area "General Ledger - Transactional Balances Real Time".

What is causing the difference?

Cause

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