My Oracle Support Banner

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 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***

Symptoms

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.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.