When Upgrading from HRMS 9.0/PT 8.48 to HRMS 9.2/PT 8.53, Error with EMPL_CHECKLIST And EMPL_CHKLST_ITM Data Conversion SQL at UPG_HC90.HCHCL12.Step01 9.2 (Doc ID 1667932.1)

Last updated on NOVEMBER 07, 2014

Applies to:

PeopleSoft Enterprise HRMS Human Resources - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : Initial pass of upgrade from HRMS 9.0/PT 8.48 to HRMS 9.2/PT 8.53.

In Task 5-11: Running Data Conversion" generates error in logs. Issue with EMPL_CHECKLIST and EMPL_CHKLST_ITM data conversion SQL - UPG_HC90.HCHCL12.Step01 9.2

ERROR
-----------------------
cannot update ("SYSADM"."PS_EMPL_CHKLST_ITM"."CHECKLIST_CD") to NULL
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)
 or single subquery is returning multiple rows.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
During the initial pass of HCM 9.2 upgrade from HRMS 90/PT8.50.24 to HCM92/PT8.53.03. While running "Task 5.11: Performing Data Conversion Concurrently" the above error occurs.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot proceed the upgrade process.

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