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' (Doc ID 2297899.1)

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.

Symptoms

On :  8.49+ version, Upgrade

Performing Data Conversion Concurrently for the HCM 9.0 to 9.1 FP2 upgrade fails with the following error.

ERROR

File: e:\pt85328c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1625  Error Position: 47  Return: 1427 - ORA-01427: single-row subquery returns more than one row
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)


STEPS

The issue can be reproduced at will with the following steps:
1. Run data conversion.
2. Observe the error


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