ORA-01719 Error or Wrong Result is Reported for a Query After Upgrade to 19c (Doc ID 2856485.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

After updating a database from 12.1.0.2 to 19.14, the applications gets the error "ORA-01719: outer join operator (+) not allowed in operand of OR or IN" for certain selects.

-  As per the details in <Note 2740441.1> - ORA-01719 Error for a Select Query in 19c Database, attempting to use the suggested workaround:

alter system set "_fix_control" = '28012754:0';

    But this does not fix the error.

-  Setting optimizer_features_enable to 12.1.0.2, helps to avoid the error. Any value for OFE above 12.1.0.2 reports the same error.

-  Applying <Patch 32786308> does not help.

-  Setting the below fix_control also does not help:

alter session set "_fix_control"="31009032:on";

-  Stack trace from the error trace file lists the below functions:

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.