Receiving SQL Errors When Attempting To Create New Applicant List in DB2 Database
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.
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.
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