Double Amount in Aging - 7 Buckets - By Account Report (Duplicate Entries for Reversed Receipts)

(Doc ID 1554273.1)

Last updated on FEBRUARY 07, 2018

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Reports Issues

Run Aging - 7 buckets by account report, observe duplicate records


The issue can be reproduced at will with the following steps:
1. Receipt created in SEP-12 

2. Receipt reversed in 2012 NOV

3. Run Aging - 7 buckets by account report
Data shows twice in the report.

Invoice Outstanding  1-30 Days 31-60 Days 61-90 Days 91-180 Days  181-360 Days 361+ Days  Number Type Due Date Amount Current
---------- ----------- --------- --------------- ----------------
ZD 274052 Risk 08-NOV-12 40,400,000.00 40,400,000.00 

ZD 274052 Risk 08-NOV-12 40,400,000.00 40,400,000.00

The issue has the following business impact:
Due to this issue, Aging Report shows wrong balances and totals.




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