EAR 9.2 Performance Issue With Report AR30004 Aging Summary By Business Unit

(Doc ID 2055835.1)

Last updated on MARCH 09, 2017

Applies to:

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

Symptoms

On : 9.2 version, Performance Image 5

ACTUAL BEHAVIOR
---------------
We upgraded from 8.9 to 9.2 recently. AR30004 Aging Summary by Business Unit and it is taking two plus hours time to run.

EXPECTED BEHAVIOR
-----------------------
The same report with similar data was running within 5 minutes in 8.9

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. AR, Receivables, Aging, Aging Summary
2. Run Aging for 1 business Unit


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot produce the report on timely manner.

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