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:
Oracle Fusion Accounting Hub Reporting Cloud Service - Version 11.13.22.07.0 and laterInformation in this document applies to any platform.
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
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 |