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