E-QR Error: "ORA-25156: old style outer join (+) cannot be used with ANSI joins" Seen When Query Ran With Outer Joins and XLAT Values.
(Doc ID 2594434.1)
Last updated on JUNE 15, 2020
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.57 and later
Information in this document applies to any platform.
When attempting run any Query using old style outer join (+) and XLAT Value in any of the fields below error is seen:
The issue can be reproduced with the following steps:
1. Reporting Tools > Query > Query Manager
2. Search By = <query_name>
3. Select Query using Old style outer join (+) and XLAT Value in any of the fields
4. Edit > Run
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