Receiving SQL Errors When Attempting To Create New Applicant List in DB2 Database

(Doc ID 2416595.1)

Last updated on JULY 03, 2018

Applies to:

PeopleSoft Enterprise HCM Talent Acquisition Manager - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to create a new applicant list from the Manage Applicant page, the following error occurs:

PSAPPSRV.10596 (694) 1-505397 13.35.22 0.021000 SQL error. Function: SQLExec

 Error Position: 0

 Return: 8601 - [IBM][CLI Driver] CLI0113E SQLSTATE 22007: An invalid datetime format was detected; that is, an invalid string representation or value was specified. SQLSTATE=22007 (SQLSTATE 22007) -99999

 Statement: SELECT A.HRS_CNTCT_DT,A.HRS_OWNER_ID FROM PS_HRS_APPFWRD_VW A WHERE A.HRS_PERSON_ID=:1 AND A.HRS_ROW_ADD_DTTM > :2 AND A.HRS_ROW_ADD_DTTM = (SELECT MAX(B.HRS_ROW_ADD_DTTM) FROM PS_HRS_APP_FRWD B WHERE A.HRS_PERSON_ID=B.HRS_PERSON_ID)

 Original Statement: Select Úteout(A.HRS_CNTCT_DT),A.HRS_OWNER_ID from PS_HRS_APPFWRD_VW A where A.HRS_PERSON_ID=:1 and A.HRS_ROW_ADD_DTTM > :2 and A.HRS_ROW_ADD_DTTM = (Select Max(B.HRS_ROW_ADD_DTTM) from PS_HRS_APP_FRWD B where A.HRS_PERSON_ID=B.HRS_PERSON_ID)
PSAPPSRV.10596 (694) 1-505398 13.35.22 0.000000 ErrorReturn-> 280 - SQL error in Exec. (2,280) HRS_ARM.CMP_HRS_LIST.BUS.ListManager.OnExecute Name:getContactInformation PCPC:40047 Statement:603



The issue can be reproduced at will with the following steps:
1. Navigate to Main Menu >> Recruiting >> Search Applicants
2. Search for an applicant and open the applicant.
3. Click on "Add to List" icon on the Manage Applicant Page.
4. On the "Add to Applicant List" page click on the Create New List button.
5. Enter the required information on the Create New List page and click the Save button.
6. An error message is shown to the user.

Changes

 

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