EPY: Budget Actuals and Valid Combo Data Conversion Performance Issue (UPG_PY90.HCPYxxxx) (Doc ID 1485104.1)

Last updated on MARCH 17, 2016

Applies to:

PeopleSoft Enterprise HCM Payroll for North America - Version 9 and later
Information in this document applies to any platform.

Symptoms

Issue #1:

During the HCM upgrade from 8.9 to 9.1 FP10.  The data conversion step UPG_PY90.HCPYP10C is processing the BUDGET_ACTUALS table for over 24 hours.

 

Issue #2:

The UPG_PY90 program from the HR8.9 to HR9.1 upgrade executed for over 31 hours. The steps that executed the longest according to the statement timings report were the following: HCPYM01C.Step02.S : 40 minutes HCPYM01C.Step06.S : 31 minutes HCPYM01F.Step01.S : 1875 minutes (31 hours) Obviously, we are most concerned with HCPYM01F.Step01.S. This step is an insert statement into table PS_VALID_COMBO_TBL from data in tables PS_UPG_VALCMBO_TBL and PS_UPG_PCS_VCB_TAO. Are there any tuning recommendations?

Issue 3:

Upgrading HCM 9.1 to 9.2 and using MTP template.  Tools 8.54.14

Conversion AE program - UPG_PY90, HCPYL10 took more than 8 hours to complete.

 

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