EAR9.0+: AR30006 [Aging by Chartfield] Incorrect Total Amounts When Billing Inovice Number Of Distribution Lines Is Greater Than 40 (Doc ID 1142952.1)

Last updated on SEPTEMBER 22, 2016

Applies to:

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

Symptoms

STATEMENT OF ISSUE
-------
Aging by Chartfield [AR30006] report generates incorrect total amounts for Bills with Multiple Items that came from inside Contracts and then posted to AR under circumstance where Setup Financials > Installation Options - Billing GL-AR Options > AR Level is set to "Header AR Open Item" and AR Option is set to "Use Line for Distribution".

ENVIRONMENT
--------
V9.0 Production MP8 through bundle 25.

EXPECTED BEHAVIOR
---------
Aging by Chartfield [AR30006] report should show the correct total amount of the invoice that's posted.

ACTUAL BEHAVIOR
--------
The report shows an incorrect total amount for the bill.

ERROR
--------
No error message.

LOSS OF FUNCTIONALITY
--------
Report is not reliable to work on.

WHAT IS WORKING
--------
For some bills that have just a few items, the report generates the correct total amount.

STEPS TO REPLICATE
--------
1. Setup Financials > Installation Options - Billing GL-AR Options
Set AR Level:Header is AR Open Item
Set AR Option:Use Line for Distribution
2. A bill passed to Billing from Contracts with more than 40 line items
3. Post the bill to AR
4. Run AR Update
5. Run Aging Process
6. Run Aging by Chartfield [AR30006] report From Account to Account


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