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"
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.
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"
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms