E-QR: PS Queries With Outer Join (+) And Also Have Translate Values Set As Short Or Long Fail With Error: "ORA-25156: Old Style Outer Join (+) Cannot Be Used With ANSI Joins" (Doc ID 2060662.1)

Last updated on JUNE 26, 2017

Applies to:

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

Symptoms

When attempting to run queries with outer join (+) and also have translate values set as short or long do not work and receive the following error:

“ORA-25156: old style outer join (+) cannot be used with ANSI joins"

Steps
--------
The issue can be reproduced at will with the following steps:
1. Login to PIA
2. Navigate to Reporting Tools > Query > Query Manager
3. Create a new PS Query using fields with translate values
4. From the filed properties select the Short or Long
5. Run the Query
6. The error occurs

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