Error while migrating from 126.96.36.199 to 188.8.131.52.3: ORA-24173: Nested Query Not Supported For Rule Co
Last updated on NOVEMBER 03, 2016
Applies to:Oracle SOA Suite - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
After migrated from SOA 220.127.116.11 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