My Oracle Support Banner

SEARCHING IN MY APPLICANTS THROWS SQL ERROR WITH MICROSOFT SQL SERVER (Doc ID 2580362.1)

Last updated on MAY 13, 2020

Applies to:

PeopleSoft Enterprise HCM Talent Acquisition Manager - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Customer reports that the Search My Applicants feature produces SQL errors.  They state this problem happens on SQL Server and Tools 8.56.11 and does not happen on Oracle database on tools 8.57.07.

ERROR
-----------------------
SQL error. Function: SQLExec
Error Position: 0
Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]The batch could not be analyzed because of compile errors. (SQLSTATE 37000) 11501
Statement: SELECT COUNT(HRS_PERSON_ID) FROM PS_HRS_MY_APP_VW WHERE EMPLID = :1 AND (HRS_SUBMITTED_DTTM) >= :2AND (UPPER(NAME_DISPLAY) LIKE'%TEST%' OR HRS_PERSON_ID LIKE '%TEST%' OR
HRS_JOB_OPENING_ID LIKE '%TEST%' OR UPPER(POSTING_TITLE) LIKE '%TEST%' OR UPPER(EMAIL_ADDR) LIKE'%TEST%' OR UPPER(PHONE) LIKE '%TEST%')
Original Statement: select count(HRS_PERSON_ID from PS_HRS_MY_APP_VW WHERE EMPLID = :1 AND (HRS_SUBMITTED_DTTM) >=ÚteIn(:2)and(%UPPER(NAME_DISPLAY) LIKE'%TEST%' OR HRS_PERSON_ID like '%
TEST%' OR HRS_JOB_OPENING_ID LIKE '%TEST%' OR UPPER(POSTING_TITLE) LIKE '%TEST%' OR UPPER(EMAIL_ADDR) LIKE'%TEST%' OR UPPER(PHONE) LIKE '%TEST%')


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. From Recruiting Homepage click the My Applicants Tile
2. Use Search My Applicants
3. Receive error

Changes

 

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
Changes
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.