My Oracle Support Banner

E-QR: ORA-01799: A Column May Not be Outer-joined to a Subquery (50,380) (Doc ID 2143271.1)

Last updated on AUGUST 16, 2018

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.

Symptoms

When attempting to run a query which contains a left outer join and XLAT values,
the following error occurs.

ERROR
-----------------------
"A SQL error occurred. Please consult your system log for details.
Error in running query because of SQL Error, Code=1799, Message=ORA-01799: a column may not be outer-joined to a subquery (50,380) "


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log in to PIA
2. Navigate to Reporting Tools > Query > Query Manager
3. Create a query containing left outer join and XLAT values
4. Run the query
5. Notice the 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.