HCM 9.1 Upgrade: "Task 5-11: Running Data Conversion" Error Step UPG_HC90.HCHCP02.Step01 (SQL) (Doc ID 1212898.1)

Last updated on OCTOBER 09, 2015

Applies to:

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

Symptoms

In initial pass of application only upgrade from HR88SP1/PT8.50.05 -> HCM91/PT8.50.05. "Task 5-11: Running Data Conversion" generates error:

UPG_FG88 FGHCI030 completed at 2010-02-18-17.47.56.000000 (18028,10002)

File: e:\pt85005c-retail\peopletools\src\psappeng\aedebug.hSQL
error. Stmt #: 1625 Error Position: 30
Return: 1407 - ORA-01407: 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)

Process 289606 ABENDED at Step UPG_HC90.HCHCP02.Step01 (SQL) -- RC = 1407 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

PSAESRV completed service request at 17.47.56 2010-02-18

The table ps_empl_checklist in our target database has the following distribution of values for checklist_cd (the second row value is a single space):

CHECKLIST_CD COUNT(*)
------------ --------
FNGPRT 1338
5760 

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