9.0 to 9.1 Upgrade Fails At Step Performing Data Conversion Concurrently AE_EOUFDATACONV - EMPL_CHECKLIST - 'ORA-01427: single-row subquery returns more than one row'
Last updated on AUGUST 16, 2017
Applies to:PeopleSoft Enterprise HCM Human Resources - Version 9.1 and later
Information in this document applies to any platform.
On : 8.49+ version, Upgrade
Performing Data Conversion Concurrently for the HCM 9.0 to 9.1 FP2 upgrade fails with the following error.
Failed SQL stmt: UPDATE PS_EMPL_CHKLST_ITM SET CHECKLIST_CD = ( SELECT A.CHECKLIST_CD FROM PS_EMPL_CHECKLIST A WHERE A.EMPLID=PS_EMPL_CHKLST_ITM.EMPLID AND A.EMPL_RCD=PS_EMPL_CHKLST_ITM.EMPL_RCD AND A.CHECKLIST_DT=PS_EMPL_CHKLST_ITM.CHECKLIST_DT AND A.CHECKLIST_CD <> ' ') WHERE EXISTS ( SELECT 'X' FROM PS_EMPL_CHECKLIST B WHERE B.EMPLID = PS_EMPL_CHKLST_ITM.EMPLID AND B.EMPL_RCD = PS_EMPL_CHKLST_ITM.EMPL_RCD AND B.CHECKLIST_DT = PS_EMPL_CHKLST_ITM.CHECKLIST_DT AND B.CHECKLIST_CD <> ' ')
Process 939914 ABENDED at Step UPG_HC90.HCHCP02.Step01 (SQL) -- RC = 1427 (108,524)
The issue can be reproduced at will with the following steps:
1. Run data conversion.
2. Observe the error
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