PT-INST: While Creating HRMS 8.9 database on PeopleTools 8.51 Getting Error - Invalid Column Name 'QRYJOINOPTIMIZE' (Doc ID 1478655.1)

Last updated on JULY 19, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.51 to 8.53 [Release 8.4]
Information in this document applies to any platform.

Symptoms

While running the scripts in Datamover it is showing an error

Invalid column name 'QRYJOINOPTIMIZE'.

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