FA920 Query and Report Fails with Error ORA-01799: a column may not be outer-joined to a subquery

(Doc ID 2360695.1)

Last updated on FEBRUARY 13, 2018

Applies to:

PeopleSoft Enterprise CS Financial Aid - Version 9 and later
Information in this document applies to any platform.

Symptoms

On : CS 9 Bundle 48 or CS 9.2 PUM Image 8, Tools 8.55, Oracle 11G

When attempting to run the FA920 Fund roster report
the following error occurs.

ERROR
-----------------------
ORA-01799: a column may not be outer-joined to a subquery
01799. 00000 - "a column may not be outer-joined to a subquery"
*Cause: (+) () is not allowed.
*Action: Either remove the (+) or make a view out of the subquery.
In V6 and before, the (+) was just ignored in this case.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the report

WHAT IS WORKING
------------------
The issue does not usually occur on Oracle 12 DB Version

Cause

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