Data Conversion Error In Package DC25750800 From PUM Image 23

(Doc ID 2316113.1)

Last updated on OCTOBER 16, 2017

Applies to:

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

Symptoms

On :  9.2 version, HR Maintenance

Data Conversion error in Package DC25750800 from PUM Image 23  

PeopleTools 8.55.15 - Application Engine

File: e:\pt85515b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723  Error Position: 28  Return: 1407 - ORA-01407: não é possível atualizar (""."PS_PERS_DATA_BRA"."NATIONALITY_CD_BRA") para NULL
Failed SQL stmt: UPDATE PS_PERS_DATA_BRA SET PS_PERS_DATA_BRA.NATIONALITY_CD_BRA = ( SELECT BIRTHCOUNTRY FROM PS_PERSONAL_DATA P WHERE P.EMPLID = PS_PERS_DATA_BRA.EMPLID ) WHERE PS_PERS_DATA_BRA.NATIONALITY_CD_BRA NOT IN ( SELECT ESC.COUNTRY FROM PS_ES_COUNTRY_BRA ESC WHERE ESC.EFFDT =( SELECT MAX (ESC2.EFFDT) FROM PS_ES_COUNTRY_BRA ESC2 WHERE ESC2.COUNTRY = ESC.COUNTRY AND ESC2.EFFDT <= TO_DATE(TO_CHAR(SYSDATE,'YYYY-MM-DD'),'YYYY-MM-DD')))
 Message Set Number: 200

 Message Number: 0
 Message Reason: File: e:\pt85515b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723  Error Position: 28  Return: 1407 - ORA-01407: não é possível atualizar ("<ownerid"."PS_PERS_DATA_BRA"."NATIONALITY_CD_BRA") para NULL
Failed SQL stmt: UPDATE PS_PERS_DATA_BRA SET PS_PERS_DATA_BRA.NATIONALITY_CD_BRA = ( SELECT BIRTHCOUNTRY FROM PS_PERSONAL_DATA P WHERE P.EMPLID = PS_PERS_DATA_BRA.EMPLID ) WHERE PS_PERS_DATA_BRA.NATIONALITY_CD_BRA NOT IN ( SELECT ESC.COUNTRY FROM PS_ES_COUNTRY_BRA ESC WHERE ESC.EF (200,0)
Process 13033582 ABENDED at Step DC25750800.updOther.Step02 (SQL) -- RC = 1407 (108,524)
 Message Set Number: 108
 Message Number: 524
 Message Reason: Process 13033582 ABENDED at Step DC25750800.updOther.Step02 (SQL) -- RC = 1407 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s


ERROR
-----------------------
ORA-01407


STEPS
-----------------------
The issue can be reproduced at will with the following steps:


1. Create a Change Package from PUM Image 23
2. Error was Generated with Data Conversion and was Unable to Create Change Package


Changes

 

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