My Oracle Support Banner

HCM 9.1 To 9.2 Upgrade Task 6-10-3: Performing Data Conversion Failed.Error : File: e:\pt85515b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723 Error Position: 30 Return: 1407 - ORA-01407: cannot update ("SYSADM"."PS_HRS_APP_CL_ITEM". (Doc ID 2351387.1)

Last updated on SEPTEMBER 25, 2018

Applies to:

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

Symptoms



When attempting to run the data conversion process,,
the following error occurs.

ERROR
-----------------------
ile: e:\pt85515b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723 Error Position: 30 Return: 1407 - ORA-01407: cannot update ("SYSADM"."PS_HRS_APP_CL_ITEM"."CHECKLIST_CD") to NULL
Failed SQL stmt: UPDATE PS_HRS_APP_CL_ITEM SET PS_HRS_APP_CL_ITEM.CHECKLIST_CD = ( SELECT PS_HRS_APP_CHKLST.CHECKLIST_CD FROM PS_HRS_APP_CHKLST WHERE PS_HRS_APP_CL_ITEM.HRS_PERSON_ID = PS_HRS_APP_CHKLST.HRS_PERSON_ID AND PS_HRS_APP_CL_ITEM.HRS_PROFILE_SEQ = PS_HRS_APP_CHKLST.HRS_PROFILE_SEQ AND PS_HRS_APP_CL_ITEM.CHECKLIST_DT = PS_HRS_APP_CHKLST.CHECKLIST_DT) WHERE PS_HRS_APP_CL_ITEM.CHECKLIST_CD = ' '

Process 579154 ABENDED at Step UPG_ER91.HCERA13.Step002 (SQL) -- RC = 1407 (108,524)

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


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Upgrade data conversion process.



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.