HC_HR_JOB_DATA Index Issue "Error Position: 0 Return: 8603 - [IBM][CLI Driver][DB2] SQL0338N An ON clause associated with a JOIN operator or in a MERGE statement is not valid. SQLSTATE=42972 (SQLSTATE 42972) -338" (Doc ID 2165018.1)

Last updated on AUGUST 16, 2016

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Environment Details
------------------------------------
PeopleSoft HCM 9.2 Image 17
PeopleTools 8.55.07
Platform: DB2

When creating the search index for search definition HC_HR_JOB_DATA, the following SQL error occurs:

ERROR
-----------------------
Error Position: 0 Return: 8603 - [IBM][CLI Driver][DB2] SQL0338N An ON clause associated with a JOIN operator or in a MERGE statement is not valid. SQLSTATE=42972
 (SQLSTATE 42972) -338


REPLICATION STEPS
-----------------------

1. Main Menu > PeopleTools > Search Framework > Schedule Search Index for HC_HR_JOB_DATA
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