My Oracle Support Banner

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.


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.

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


To view full details, 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 a vibrant support community of peers and Oracle experts.