My Oracle Support Banner

XLAAARPT: Account Analysis Report (Subledger) Period Totals Show DR/CR Net Amount Not Column Sum Totals (Doc ID 2312352.1)

Last updated on AUGUST 17, 2023

Applies to:

Oracle General Ledger - Version 12.1 and later
Information in this document applies to any platform.
XLAAARPT - Account Analysis Report (Subledger Accounting)


Executing the Account Analysis Report (Subledger Accounting) it is noted that the Period Total for Debit (DR) and Credit (CR) do not sum.
Instead the Period Total is the net result of the DR/CR columns.

For example:

Source          Category                Debit          Credit
-----------     -----------             ----------     ----------

Payables       Invoice                 100.00
Payables       Payment                                  15.00
                                              ----------     ----------
                       Period Totals       85.00           0.00

Expect the Period Total of each column to equal the sum of DR/CR in that column, not the net amount.

For example:

Source          Category                Debit          Credit
-----------     -----------             ----------     ----------

Payables       Invoice                 100.00
Payables       Payment                                  15.00
                                              ----------     ----------
                       Period Totals      100.00         15.00

The issue can be reproduced at will with the following steps:
1. (N) Submit New Request > Account Analysis Report > Enter Parameters > Submit
2. Review output. Period Total equals the net result of DR/CR columns.

The issue has the following business impact:
Due to this issue, users unable to report accurate totals per period.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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