SOA Fails to Pick Up Events Generated from EDN when using PL/SQL API (Doc ID 1340978.1)

Last updated on JANUARY 04, 2017

Applies to:

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

Symptoms


In SOA 11.1.1.4.0, when generating an EDN event from database using the PL/SQL API edn_publish_event available in SOA schema as mentioned below :

DECLARE
  NAMESPACE VARCHAR2(200);
  LOCAL_NAME VARCHAR2(200);
  PAYLOAD CLOB;
BEGIN
  NAMESPACE := 'http://schema.emerson.com/eth/events/edl/Event_TransactionSubmission';
  LOCAL_NAME := 'EMR240_TransactionSubmission1';
  PAYLOAD := to_clob('<business-event xmlns:ns1="http://schema.emerson.com/eth/events/edl/Event_TransactionSubmission" xmlns="http://oracle.com/fabric/businessEvent"><name>ns1:EMR240_TransactionSubmission1</name><content><ns0:TransactionSubmission1 xmlns:ns0="http://schema.emerson.com/eth/events"><ns0:tradingPartnerSystemID>DB240</ns0:tradingPartnerSystemID></ns0:TransactionSubmission1></content></business-event>');
  SOA_SOAINFRA.edn_publish_event(NAMESPACE => NAMESPACE, LOCAL_NAME => LOCAL_NAME, PAYLOAD => PAYLOAD);
END;

SOA does not pick up or subscribe to the event.
After executing the code, you can see a new row inserted in the EDN_EVENT_QUEUE_TABLE, but still SOA does not pick up the event and generate a mediator or composite instance.

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