EAM: Performance issues upgrading DEPR_RPT table (Doc ID 653501.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 8.4 and later
Information in this document applies to any platform.

This document was previously published as Customer Connection Solution 201036702
***Checked for relevance on 25-Feb-2013***


Symptoms

If there is a large amount of data on PS_DEPR_RPT, then when an upgrade occurs (e.g. from release 8.4 to 8.9) this can take several days, or the process can even error (see <Note 637298.1> and <Note 650232.1> for specific errors).

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