EPY: Budget Actuals and Valid Combo Data Conversion Performance Issue (UPG_PY90.HCPYxxxx)
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.
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.
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?
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms