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

(Doc ID 2312352.1)

Last updated on OCTOBER 13, 2017

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
-----------------------
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

EXPECTED BEHAVIOR
-----------------------
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

STEPS
-----------------------
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.

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

Changes

N/A

Cause

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 hundreds of Community platforms