HR_PERORGASN Abending At Step HR_PERORGASN.INC_FTCH.CUR_JOB (SQL) On DB2 Database With Error "SQL0206N "NULL" is not valid in the context where it is used."
(Doc ID 2893856.1)
Last updated on JANUARY 26, 2024
Applies to:
PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
AE HR_PERORGASN process is abending at Step HR_PERORGASN.INC_FTCH.CUR_JOB (SQL) for DB2 databases.
aedebug.hSQL error. Stmt #: 1738 Error Position: 0 Return: 8603 - [IBM][CLI Driver][DB2] SQL0206N "NULL" is not valid in the context where it is used. SQLSTATE=42703
(SQLSTATE 42S22) -206
Failed SQL stmt: INSERT INTO PS_HR_PORG_TMP (EMPLID, EMPL_RCD, JOB_EFFDT, POSITION_NBR, BUSINESS_TITLE, POSITION_PHONE, AE_PROCESS_STATUS, ERROR_TEXT) SELECT J.EMPLID, J.EMPL_RCD, J.EFFDT, J.POSITION_NBR, ' ', ' ', 'N', NULL FROM PS_JOB J WHERE J.EFFDT = :1 AND J.EFFSEQ = ( SELECT MAX(J2.EFFSEQ) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCD = J.EMPL_RCD AND J2.EFFDT = J.EFFDT) AND J.POSITION_NBR <> ' ' AND J.HR_STATUS = 'A' AND J.POSITION_OVERRIDE = 'N'
Process 3603951 ABENDED at Step HR_PERORGASN.INC_FTCH.CUR_JOB (SQL) -- RC = 8603 (108,524)
(SQLSTATE 42S22) -206
Failed SQL stmt: INSERT INTO PS_HR_PORG_TMP (EMPLID, EMPL_RCD, JOB_EFFDT, POSITION_NBR, BUSINESS_TITLE, POSITION_PHONE, AE_PROCESS_STATUS, ERROR_TEXT) SELECT J.EMPLID, J.EMPL_RCD, J.EFFDT, J.POSITION_NBR, ' ', ' ', 'N', NULL FROM PS_JOB J WHERE J.EFFDT = :1 AND J.EFFSEQ = ( SELECT MAX(J2.EFFSEQ) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCD = J.EMPL_RCD AND J2.EFFDT = J.EFFDT) AND J.POSITION_NBR <> ' ' AND J.HR_STATUS = 'A' AND J.POSITION_OVERRIDE = 'N'
Process 3603951 ABENDED at Step HR_PERORGASN.INC_FTCH.CUR_JOB (SQL) -- RC = 8603 (108,524)
Steps to reproduce the issue:
1. Navigate to Set Up HCM > System Administration > Database Processes > Refresh Person Org Assignments >Refresh PersonOrg AssignmentsImage:
2. Run the processes in Incremental mode
3. Error will occur during process run.
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 |