My Oracle Support Banner

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

Last updated on OCTOBER 16, 2019

Applies to:

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



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

There are two (2) scenarios:



1. Log in 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.



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)
[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)



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



PSAPPSRV 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 ifdtcheck(HRS_JOBCODE_I7 B, A, %currentdatetimein)
(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




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

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