Error for UPD773982_12.dms/dat From HRMS 9.0 Bundle #9 on PT 8.53: "ORA-01400: CANNOT INSERT NULL INTO ("SYSADM"."PSOPRDEFN"."OPERPSWDSALT"). " (Doc ID 1965768.1)

Last updated on APRIL 22, 2015

Applies to:

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

Symptoms

When attempting to apply HRMS 9.0 Bundle #9, the following error occurs.

ERROR

Started: Wed Apr 30 10:34:09 2014
Data Mover Release: 8.53.10
Database: CS9TRY (DUT)
SQL Successful - DELETE FROM PSOPRDEFN WHERE OPRID = 'HCRARG'
SQL Successful - DELETE FROM PSOPRALIAS WHERE OPRID = 'HCRARG'
SQL Successful - DELETE FROM PSROLEUSER WHERE ROLEUSER = 'HCRARG'
SQL Successful - DELETE FROM PSUSERATTR WHERE OPRID = 'HCRARG'
SQL Successful - DELETE FROM PSUSEREMAIL WHERE OPRID = 'HCRARG'
SQL Successful - DELETE FROM PSUSERPRSNLOPTN WHERE OPRID = 'HCRARG'
SQL Successful - DELETE FROM PS_ROLEXLATOPR WHERE OPRID = 'HCRARG'
SQL Successful - DELETE FROM PS_RTE_CNTL_RUSER WHERE ROLEUSER = 'HCRARG'
SQL Successful - DELETE FROM PSROLEDEFN WHERE ROLENAME = 'HR Administrator ARG'
SQL Successful - DELETE FROM PSROLECLASS WHERE ROLENAME = 'HR Administrator ARG'
SQL Successful - DELETE FROM PSROLECANGRANT WHERE ROLENAME = 'HR Administrator ARG'
Indexing export file d:\upgrade\staging\softwareupdatePRJ772857ML{ce9813f0-447f-11de-95a2-f171e278a23b}\scripts\data\upd773982_12.dat
Input file: d:\upgrade\staging\softwareupdatePRJ772857ML{ce9813f0-447f-11de-95a2-f171e278a23b}\scripts\data\upd773982_12.dat (ENG)
Commit done at end of record
Importing PSOPRDEFN
File: Data MoverSQL-fout. opdrachtnr:0 Foutpositie:0 Terug:1400 - ORA-01400: CANNOT INSERT NULL INTO ("SYSADM"."PSOPRDEFN"."OPERPSWDSALT").
Failed SQL stmt: INSERT INTO PSOPRDEFN (OPRID, VERSION, OPRDEFNDESC, EMPLID, EMAILID, OPRCLASS, ROWSECCLASS, OPERPSWD, ENCRYPTED, SYMBOLICID, LANGUAGE_CD, MULTILANG, CURRENCY_CD, LASTPSWDCHANGE, ACCTLOCK, PRCSPRFLCLS, DEFAULTNAVHP, FAILEDLOGINS, EXPENT, OPRTYPE, USERIDALIAS, LASTSIGNONDTTM, LASTUPDDTTM, LASTUPDOPRID, PTALLOWSWITCHUSER) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, TO_DATE(:14,'YYYY-MM-DD'), :15, :16, :17, :18, :19, :20, :21, TO_TIMESTAMP(:22,'YYYY-MM-DD-HH24.MI.SS.FF'), TO_TIMESTAMP(:23,'YYYY-MM-DD-HH24.MI.SS.FF'

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