Error while migrating from 11.1.1.5 to 11.1.1.7.3: ORA-24173: Nested Query Not Supported For Rule Co (Doc ID 1969488.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle SOA Suite - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

After migrated from SOA 11.1.1.5 to SOA 11.1.1..7.3, while starting the SOA Server the below error is generated in the SOA Server logs for two composites: 

java.sql.SQLException: ORA-25448: rule MISC_SOAINFRA.IP_IN_QUEUE$765 has errors
ORA-24173: nested query not supported for rule condition
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 6274
ORA-06512: at "SYS.DBMS_AQADM", line 364
ORA-06512: at line 1


Before migrating to SOA 11.1.1..7.3, the error message was not seen.

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