Oracle SOA Suite - Finding the Composite Instances waiting for callback

Oracle SOA Suite - Finding the Composite Instances waiting for callback:-

The below query can be used to identify the Composite instances waiting for the callback.

Select * from SOA_SOAINFRA.dlv_subscription where composite_name = ‘xxxxxxxxx’ and operation_name = 'xxxxxxxxxx' and state = 0 and properties like ‘#CorrelationString’

#CorrelationString –The correlation id used for the call back. This condition can be ignored if there is no correlation used.

Follow @albinsblog