EAR9.0+: AR30006 [Aging by ChartField Report] Shows Item Balances as $0 When Items are Paid and Closed After the Report Run Control As Of Date (Doc ID 1214524.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

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

Symptoms

Issue / Errors
-------------------
AR30006 [Aging by ChartField Report] shows item balances as $0 (not the correct balance) when items are paid and closed after the report Run Control As Of Date, even if they were open at the As Of Date.

Environment
------------------
FMS release/bundle level 9.0 B#29 Production database.

Expected Result
----------------------
AR30006 should always show the correct item balance at the time of the report run control As Of Date, regardless whether the item was still open or closed at the time of running the report.

What is Working
---------------------
AR30006 will show the correct balances if the items are still open.

Business Impact
------------------------
Due to this issue the users cannot use the report information, as relevant items are shown with $0 balance and hence the report totals and integrity are in doubt.

Steps/Sequence of Events
--------------------------------------
By following these steps the issue has been produced on-site:
1. Post item 22-Jun-2010
2. Run AR30006 > Item shown with correct balance
3. Pay and close the item
4. Run AR30006 with same parameters > item shown with $0 balance

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