FAH Subledger Accounting Supporting Reference Balances not Same with GL balances XLA_AC_BALANCES (Doc ID 2904812.1)

Last updated on JANUARY 17, 2024

Applies to:

Symptoms

On : 11.13.22.07.0 version, Capture Transactions-Post Journal Entries and Update Ledger Balances

ACTUAL BEHAVIOR
---------------
Subledger Accounting Supporting reference balances is not consistent with GL balances (XLA_AC_BALANCES)

EXPECTED BEHAVIOR
-----------------------
Supporting reference balance should reconcile with GL balances XLA_AC_BALANCES table

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. import the SLA entries using spreadsheet i.e. "Create Subledger Journals in Spreadsheet" with 5492 lines
2. run Update Subledger Accounting Balances process
3. transfer to general ledger and post the entries
4. check the data in XLA_AE_LINES versus XLA_AC_BALANCES

The GL balance is showing the correct total. However, the AHCS balance is only showing the value from some of the lines.
the line with the Amount that is missing from the balance - has a blank value in the ANALYTICAL_BALANCE_FLAG field.

There are multiple rows in XLA_AE_LINES table where ANALYTICAL_BALANCE_FLAG is set to null and the row is mapped to supporting reference columns.

Since ANALYTICAL_BALANCE_FLAG is null, these lines are not considered for balance calculation as expected and consequently are missing from XLA_AC_BALANCES table.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users reconcile subledger accounting FAH entries with gl_balances

Cause

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