Error while migrating from to 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 and later
Information in this document applies to any platform.


After migrated from SOA 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.


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