Filter Condition string-length Function Causes The Subscriber To Not Pickup Events (Doc ID 2887456.1)

Last updated on NOVEMBER 16, 2023

Applies to:

Goal

One of the SOA subscriber has content based filtering applied and has multiple filter conditions and one of the filter condition is a string-length function, which is causing the subscriber to not pickup events.

The filter condition is as follows:
(/be:business-event/be:content/tns:IMSPersonEvent/tns:EventBody/tns:PersonEvent/tns:EventType = 'CREATE' and /be:business-event/be:content/tns:IMSPersonEvent/tns:EventBody/tns:PersonEvent/tns:TriggeringEntity/tns:EntityType = 'ALIAS')
or
(/be:business-event/be:content/tns:IMSPersonEvent/tns:EventBody/tns:PersonEvent/tns:EventType = 'DELETE' and string-length(/be:business-event/be:content/tns:IMSPersonEvent/tns:EventBody/tns:PersonEvent/tns:TriggeringEntity/tns:EntityType)=0)

If remove the last condition "string-length(/be:business-event/be:content/tns:IMSPersonEvent/tns:EventBody/tns:PersonEvent/tns:TriggeringEntity/tns:EntityType)=0", then the subscriber is working.
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.