Receivables Aging By General Ledger Account Report Duplicates Transactions When Override Account Used

(Doc ID 2092942.1)

Last updated on SEPTEMBER 26, 2017

Applies to:

Oracle Fusion Receivables Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.9.2.0 version, Manage Accounts Receivable Balances-Process Statements

ACTUAL BEHAVIOR
---------------
When Override Account has been used on an invoice to change the receivables
account, the invoice is duplicated on the Receivables Aging by General Ledger
Account Report and open receivables is overstated.

It shows up once under the new receivables account (which is correct) but
then it shows up twice under the original receivables account instead of
netting to 0. The Invoice distributions still show the original receivables
account, but View Accounting for the invoice is correct.

Also the total outstanding for the customer is incorrect.

EXPECTED BEHAVIOR
-----------------------
The Receivables Aging by General Ledger Account shows balance against correct account and correct customer's balance.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Create and account a Receivables Invoice.
2.Use Actions > Review Distributions.
3.Click on Override account and give a new account for the receivables account.
4.Submit the Receivables Aging by General Ledger Account report.

BUSINESS IMPACT
-----------------------
The issue has the following business impact: The aging report is wrong and cannot be used to reconcile AR with GL

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