0 Replies Latest reply: Nov 25, 2011 8:14 AM by saurav2 RSS

    Facing issues with Oracle11i and SOA 10g integration using Business events.

    saurav2
      Hi ,

      I have created a custom business event and have added subscription for the same.
      When i am triggering a business event, event is raised and the event data is getting inserted in the Queue (AQ).

      In SOA i have created an OracleApps adapter that is listening to the queue ,
      but the Oracleapps adapter is not getting started even though there are data in the queue.

      I checked the WSDL file of Oracleapps adapter and there i can see there is field Consumer with some code.

      I have added the code snippet from Oracleapps adapter wsdl.

      <pc:inbound_binding />
      <operation name="DEQUEUE">
      <jca:operation
      ActivationSpec="oracle.tip.adapter.apps.AppsWFBesQueueDequeueActivationSpec"
      QueueName="WF_BPEL_Q"
      DatabaseSchema="APPS"
      Consumer="ORA_88p3cd9o74pj2cpg6p13cdhp75"
      MessageSelectorRule="tab.user_data.event_name = &apos;xxc.oracle.apps.soa.demo&apos;" >
      </jca:operation>

      I have checked the connection factory set up at loaction (application-deployments\default\AppsAdapter/oc4j-ra.xml)too and found it is correct.
      code snippet from oc4j-ra.xml:-

           <connector-factory location="eis/Apps/Apps" connector-name="AppsAdapter">
                <config-property name="xADataSourceName" value="jdbc/EBSDataSource"/>
                <config-property name="dataSourceName" value=""/>
                <connection-pooling use="none">
                </connection-pooling>
                <security-config use="none">
                </security-config>
                <connectionfactory-interface>javax.resource.cci.ConnectionFactory</connectionfactory-interface>
           </connector-factory>.

      Can anyone tell me where consumer for an event/queue is being defined in the Oracle apps.


      Thanks & Regards
      Saurav Kumar