E-QR: Left Outer Joins With Translates Fails With ON Clause Associated With a JOIN Operator Or In A MERGE Statement Is Not Valid.

(Doc ID 2086819.1)

Last updated on NOVEMBER 01, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.54 and later
Information in this document applies to any platform.

Symptoms

ISSUE STATEMENT
---------------
The issue is that Query Manager used to create a left outer joins with translate values now fail with DB2.
 
ERROR
---------------
A SQL error occurred. Please consult your system log for details.
Error in running query because of SQL Error, Code=8601, Message=[IBM][CLI Driver][DB2/AIX64] SQL0338N An ON clause associated with a JOIN operator or in a MERGE statement is not valid. SQLSTATE=42972 (SQLSTATE 42972) -338 (50,380)
 
ENVIRONMENT
---------------
Application & Version: PeopleTools 8.54.15
Bundle/Patch: N/A
Environment: Development
 
STEPS
---------------
The issue can be reproduced with the following steps:
1. Reporting Tools > Query > Query Manager
2. Create New Query
3. Create a PSQuery using a left outer joins with translate values
 
IMPACT
---------------
Significance to business operation is minor.

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