My Oracle Support Banner

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.