My Oracle Support Banner

EAR9.2: AR30006 Aging Report When Downloaded To CSV Format Total Due Column Does Not Equal Sum Of Sub-Totals By Chart fields (Doc ID 2833479.1)

Last updated on JANUARY 12, 2022

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms



When running the Aging Report AR30006 the totals per customer doesn't add upto the sub-total by each chartfield. This can be repeated by running the aging report for any chartfield or chartfield range and when the report is downloaded to CSV format.

Here is example of the mismatch

Cust Id Total Receivables Due         Chartfield           Chartfiled wise Sub total
A          $93,081.63                          C1                      $57,779.91
B          $9,618.33                            C2                      $361,242.60
C          $30.78                                 C3                      $42,874.84
D          $4,450.00                            C4                      $30.78
E          $44,293.21                           C5                      $15,455.00
F          $30,936.42                           C6                      $66,965.83
G          $411,774.29                         C7                      $47,211.70
H          $15,013.91                           C8                      $16,038.88

Total      $609,198.57                                                  $607,599.54




The issue can be reproduced at will with the following steps:
1. Run Aging report by chartfields AR30006 in the CSV format

Due to this issue, users have wrong report total by chartfield does not equal the total amount selected

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


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