HC_HRS_APPLICATION_CONTENT Fails Crawl With Sql Syntax Error On SQL SERVER (Doc ID 2257774.1)

Last updated on APRIL 21, 2017

Applies to:

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

Symptoms

HC_HRS_APPLICATION_CONTENT fails crawl with sql syntax error

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

SQL error. Function: SQLExec

Error Position: 0

Return: 0 - [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near the keyword 'SELECT'.
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near ')'.
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Statement(s) could no

Statement:

Original Statement: INSERT INTO PS_HRS_STG_APPCTNT( SELECT A.HRS_PERSON_ID, A.HRS_PROFILE_SEQ, B.JPM_CAT_TYPE, B.JPM_CAT_ITEM_ID,'COUNTRY',COUNTRY FROM PS_HRS_APPLCANT_VW A, PS_HRS_APP_ITEM_VW B WHERE A.HRS_PERSON_ID = B.HRS_PERSON_ID AND A.HRS_PROFILE_SEQ = B.HRS_PROFILE_SEQ AND HRS_ROW_UPD_DTTM > %DATETIMEIN('2016-12-10-08.54.39.000000') AND B.JPM_CAT_TYPE='DEG')

SQL Error in Compile. (2,277) HRS_STG_ACNT.STGACTNT.GBL.default.1900-01-01.Step02.OnExecute PCPC:3319 Statement:42

Process 913177 ABENDED at Step HRS_STG_ACNT.STGACTNT.Step02 (PeopleCode) -- RC = 24 (108,524)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Crawl HC_HRS_APPLICATION_CONTENT
2. Receive error.


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