E-QR: After Upgrading To PeopleTools 8.50 Or 8.51, Receive "ORA-00904 Invalid Identifier" On Custom Queries Using Older Outer Join Syntax, "(+)"
Last updated on JANUARY 03, 2017
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.
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