EAR9.2: Performance Issue while Running The AR Data Archival Process
(Doc ID 2824354.1)
Last updated on SEPTEMBER 26, 2023
Applies to:
PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
As part of Data Archival analysis, when analyzing and testing the delivered data archival process for AR Items, the process runs very slow.
Archive object - AR_ARCH_ITEMS
Archive Template - AR_ARCH_ITEM
The issue can be reproduced at will with the following steps:
1. Go to Peopletools/Data Archive Manager/Archive Data to History- Process Type is Selection, Selective Query is AR_ARCH_ITEM
Archive Template – ARITEM
Archive Object – AR_ARCH_ITEMS
PS Query – AR_ARCH_ITEM
Date used for archival - 31-DEC-1995 (for example);
2. Application Engine PSARCHIVE is successfully run;
3. Go to Process monitor page - shows that there is a performance issue as the process ran for 3 hours for very small set of data (25 rows).
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |