When Creating New Job Opening, SQL Error in Compile. (2,277) HRS_TOOLBAR.JobOpeningToolbar.OnExecute Name:JobCodeChange (Doc ID 2214526.1)

Last updated on JANUARY 06, 2017

Applies to:

PeopleSoft Enterprise HCM Talent Acquisition Manager - Version 9.2 to 9.2 [Release 9]
IBM z/OS on System z

Symptoms

 

When creating a Job Opening in DB2 environment, an SQL  error occurs:

There are two (2) scenarios:

 

SCENARIO #1
===================

1. Login as PS/PS
2. Navigate to Create Job Opening.
3. Enter required information in Primary Job Opening information page.
4. Click on Continue.
5. The following SQL error occurs.

 

ERROR
-----------------------

SQL Error in Compile. (2,277) HRS_TOOLBAR.JobOpeningToolbar.OnExecute Name:JobCodeChange
Called from: HRS_TOOLBAR.JobOpeningToolbar.OnExecute Name:Initialize
Called from: HRS_TOOLBAR.JobOpeningToolbar.OnExecute Name:PostBuild
Called from: HRS_JOB_OPENING.GBL.PostBuild

(From Trace File)
...[IBM] {CLI Driver] [DB2] SQL0401N The data types of the operands for the operation "" are not compatible or comparable.
SQLSTATE 42818) -401
(SQL statement listed above is indicated)

 

SCENARIO #2
===================

When upgrading to Tools 8.55 - receiving the following error in Appserver log when there is currentdatetime field.

 

ERROR
=======

PSAPPSRV.45792 (2878) [2016-06-28T09:05:25.849 0001085314@ps8smnmi101.domain.com (IE 11.0; WIN7) ICPanel] - - - (0) SQL error. Function: SQLExec
Error Position: 0
Return: 805 - [IBM][CLI Driver][DB2] SQL0401N The data types of the operands for the operation "" are not compatible or comparable. SQLSTATE=42818
(SQLSTATE 42818) -401

Original Statement: SELECT A.DESCR FROM PS_HRS_JOBCODE_I7 A WHERE A.SETID=:1 AND A.JOBCODE=:2 AND %Effdtcheck(HRS_JOBCODE_I7 B, A, %currentdatetimein)
PSAPPSRV.45792 (2878) [2016-06-28T09:05:25.850 0001085314@ps8smnmi101.domain.com (IE 11.0; WIN7) ICPanel] - - - (0) SQL Error in Compile. (2,277) HRS_TOOLBAR.JO360Toolbar.OnExecute Name:JobCodeChange PCPC:53767 Statement:858
Called from:HRS_TOOLBAR.JO360Toolbar.OnExecute Name:PositionChange Statement:847
Called from:HRS_JOB_OPENING_MANAGER.CMP_HRS_JOB_OPENING.BUS.JOMisc.OnExecute Name:setPositionAsPrimary Statement:710
Called from:HRS_JOB_OPENING_MANAGER.CMP_HRS_JOB_OPENING.BUS.JOMisc.OnExecute Name:fldChgJOPsnPrmFlag Statement:240
Called from:HRS_JOB_OPENING_MANAGER.CMP_HRS_JOB_OPENING.BUS.JOController.OnExecute Name:doFldAction State

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