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 APRIL 04, 2025
Applies to:
PeopleSoft Enterprise PT PeopleTools - Version 8.54 and laterInformation 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |