My Oracle Support Banner

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 SEPTEMBER 12, 2022

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)

 

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


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