E-QR: After Upgrading To PeopleTools 8.50 Or 8.51, Receive "ORA-00904 Invalid Identifier" On Custom Queries Using Older Outer Join Syntax, "(+)"
(Doc ID 1365933.1)
Last updated on DECEMBER 07, 2019
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.50 to 8.51 [Release 8.4]
Information in this document applies to any platform.
***Currency Checked November 2013***
***Currency checked May 2015***
***Currency checked January 2017***
After upgrading to 8.51.11, a few custom queries that have joins defined throw error:
"File: E:\pt85111b-retail\peopletools\src\pssys\qpm.cppSQL error. Stmt #: 6302 Error Position: 1566 Return: 904 - ORA-00904: "A"."COMPANY": invalid identifier"
This error can be reproduced using these steps:
1. Run a Query that uses older outer join syntax, "(+)".
2. Observe the Query fails with the above error.
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