Upgrade 9 To 9.2 - Data Conversion Performance Issue - UPG_PY90.HCPYL00.Step15 (Doc ID 2249289.1)

Last updated on MARCH 29, 2017

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9 and later
Information in this document applies to any platform.

Symptoms

Running the initial upgrade pass for a PS9 PT8.51 --> PS9.2 PT8.54 upgrade

Performance issue on the data conversion step.

PTIAANALYSYS ran to success and then spawned 3 more AE batch jobs which have been running for over 48 hours.
The third step (UPG_PY90.HCPYL00.Step15) has been doing inserts into PS_VALID_COMBO_TBL for over 48 hours with no sign of completion.

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