Integration

Get Involved. Join the Conversation.

Topic

    Nagesh Manda
    Account Updates - Business Event in OIC
    Topic posted March 17, 2019 by Nagesh MandaSilver Medal: 2,000+ Points, tagged ERP Cloud, Events, Integration 
    261 Views, 12 Comments
    Title:
    Account Updates - Business Event in OIC
    Summary:
    Business Events
    Content:

    Hi All,

    I am using publish integration pattern in OIC to get the details when an account is updated or created in ERP Cloud.  When i update an account in ERP Cloud i am able to see the message coming through to OIC But the payload content doesn't show any details. I am attaching the payload for your reference.

    <ns01:onEvent xmlns:ns01="http://xmlns.oracle.com/cloud/adapter/erp/AccountUpdates_REQUEST/types"><ns0:getAccountResponse xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" xmlns:wsa="http://www.w3.org/2005/08/addressing" xmlns:ns0="http://xmlns.oracle.com/cloud/adapter/erp/AccountUpdates_REQUEST/types" xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"/></ns01:onEvent>

    Appreciate if you could provide some inputs around how to resolve this issue.

    Thanks,

    Nagesh.

    Version:
    19.1.5.0.0

    Comment

     

    • Vijay Guda

      Hi Nagesh

      Currently there are no business events defined in ERP cloud for the operations on Accounts.

      Need to take a closer look at your integration. Please attach your IAR file  (or paste the contents of the JCA file  of the trigger endpoint).

      Also please paste the contents of the Public Event catalog from <yourERPCloud>/soa-infra/PublicEvent/catalog

      thanks

      Vijay

    • Nagesh Manda

      Hi Vijay,

      As per the article below i can see that the Account object can send these business events.

      http://www.ateam-oracle.com/using-business-events-with-integration-cloud-part-1/

      End Point Details

      -------------------------

      <adapter-config xsdTargetNamespace="http://xmlns.oracle.com/cloud/adapter/erp/AccountUpdates_REQUEST_FoundationParties_Organization_Updated/types" name="AccountUpdates_REQUESTPortType" adapter="erp" wsdlLocation="AccountUpdates_REQUEST.wsdl" xmlns="http://platform.integration.oracle/blocks/adapter/fw/metadata">
        <connection-factory location="cloud/CloudAdapter">
          <non-managed-connection managedConnectionFactoryClassName="oracle.cloud.connector.fa.FAConnectionFactory">
            <property name="targetWSDLURL" value="%%ERP_TEST_targetWSDLURL"/>
            <property name="SubscribeEventName" value="{http://xmlns.oracle.com/apps/cdm/foundation/parties/publicModel/CompEventComposite}UpdateOrganization"/>
            <property name="cloud.adapter.plugin.version" value="18.4.3"/>
            <property name="eventCatalogURL" value="%%ERP_TEST_eventCatalogURL"/>
            <property name="SubscribeEvent" value="FoundationParties_Organization_Updated"/>
            <property name="csfkey" value="9c45adfb52adeed35735df05b37c4b9536fafc171dc3e3e2de7d3b651469ac98"/>
            <property name="cloud.adapter.sdk.version" value="18.4.3"/>
            <property name="configureOption" value="events"/>
            <property name="csfMap" value="oracle.cloud.adapter"/>
            <property name="applicationVersion" value="1.0"/>
          </non-managed-connection>
        </connection-factory>
        <endpoint-activation portType="AccountUpdates_REQUESTPortType" operation="onEvent">
          <activation-spec className="oracle.tip.adapter.cloud.CloudActivationSpec">
            <property name="targetOperation" value="onEvent"/>
            <property name="operationPath" value="http://xmlns.oracle.com/fa/event/onEvent"/>
            <property name="operationPath" value="http://xmlns.oracle.com/fa/event/onEvent"/>
            <property name="targetOperation" value="onEvent"/>
          </activation-spec>
        </endpoint-activation>
      </adapter-config>

      I am unable to access public event catalog because of the security restrictions.

      Kindly let me know if you need any more details.

      Thanks,

      Nagesh.

      • Vijay Guda

        Hi Nagesh

        From the JCA file of your's , the event subscribed to is "FoundationParties_Organization_Updated". 

        This event is corresponding Oracle Sales Cloud's  'Account Created Event'  . (This is the same event that is referred to  in the a-team's blog too. ) . This  events gets triggered when an account is created in the sales cloud. 

        thanks

        Vijay

        • Nagesh Manda

          Hi Vijay,

          I have tried with both Account Create and Update events they both have the same issue.

          Thanks,

          Nagesh.

          • Vijay Guda

            Both events are on Sales cloud as they correspond to Sales Account. 

            In ERP cloud , there is no business event for account yet.

            • Nagesh Manda

              Thanks Vijay.

              If thats the case how are we receiving events in OIC when an account is created or updated. We are not using sales cloud as such but using Receivables module to manage customer. Is there anyway we can achieve this using ERP Adapter?

              Thanks,

              Nagesh.

              • Vijay Guda

                Nagesh, Currently there are no business events in Oracle Fusion Receivables .

                Can you please elaborate how exactly are you creating accounts in ERP so as to help investigate why OSC events are getting fired.

                • Nagesh Manda

                  Hi Vijay,

                  Customers are being created / updated in Receivables module and we want to make use of the business events and sync these changes to Oracle Commerce Cloud. Currently when i make any changes to the Customers in Receivable module the ERP Adapter is able to receive these events but the i am seeing the underlying account data.

                  <ns01:onEvent xmlns:ns01="http://xmlns.oracle.com/cloud/adapter/erp/AccountUpdates_REQUEST/types"><ns0:getAccountResponse xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" xmlns:wsa="http://www.w3.org/2005/08/addressing" xmlns:ns0="http://xmlns.oracle.com/cloud/adapter/erp/AccountUpdates_REQUEST/types" xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"/></ns01:onEvent>

                  Thanks,

                  Nagesh.

    • Vijay Guda

      Hi Nagesh

      There are no Biz events in Receivables modules for Customers, addresses, Sites, Accounts, Contacts, Relationships, Profiles.

      We need to check with FA Receivables teams on guidelines for integrating above objects.

      thanks

      Vijay

    • Sanin Thulapparumban

      Hi,

      If the above approach doesn't work then you can develop a BIP report to get the daily changes done on customer account and call that report from ICS and do the required action.

      Thanks,

      Sanin

      • Nagesh Manda

        Thanks Sanin.

        That would be our last option but we would like make use of the standard business events functionality.

        Regards,

        Nagesh.