12c EDN Subscriber Filter Condition Issue (Doc ID 2255612.1)

Last updated on SEPTEMBER 10, 2017

Applies to:

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

Symptoms

Facing issue while creating the durable subscriber for EDN Subscriber with filter condition. The filter condition should be like ((A and B) or (C and D)). The same filter condition workis in 11g EDN subsriber but in 12c the durable subscriber is not visible.

Error/Exception:

Caused By: javax.jms.InvalidSelectorException: weblogic.messaging.kernel.InvalidExpressionException: Expression : "(JMS_WL_Forwarded IS NULL OR (NOT JMS_WL_Forwarded)) AND EDN$namespace = 'http://schemas.oracle.com/events/EventDefinitionV2' AND EDN$localName = 'EventDefinitionV2' AND (() OR (EDN$ns0_5229756$ns0_OutboundEvent$ns0_eventType_P IS NULL OR EDN$ns0_5229756$ns0_OutboundEvent$ns0_eventType LIKE '%MERGE%'))"

 

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