GP BRA: ESOCIAL - DC23763331.sql Aborts When NATIONALITY_CD_BRA is Blank. (Doc ID 2276520.1)

Last updated on JUNE 13, 2017

Applies to:

PeopleSoft Enterprise HCM Global Payroll Brazil - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When running the data conversion DC23763331, the SQL fails with the following error:

ERROR
-----
PeopleTools 8.54.15 - Application Engine
Copyright (c) 1988-2017 Oracle and/or its affiliates.
All Rights Reserved
File: e:\pt85415b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1703 Error Position: 28 Return: 1407 - ORA-01407: cannot update ("SYSADM"."PS_PERS_DATA_BRA"."NATIONALITY_CD_BRA") to 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:\pt85415b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1703 Error Position: 28 Return: 1407 - ORA-01407: cannot update ("SYSADM"."PS_PERS_DATA_BRA"."NATIONALITY_CD_BRA") to 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 (200,0)
Process 306086 ABENDED at Step DC23763331.updOther.Step02 (SQL) -- RC = 1407 (108,524)
 Message Set Number: 108
 Message Number: 524
 Message Reason: Process 306086 ABENDED at Step DC23763331.updOther.Step02 (SQL) -- RC = 1407 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s



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