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

Last updated on MAY 08, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Reports Issues

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

 

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



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

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