EMEA A&C CCOE Partner Technology Cloud Engineering

Subscribe to business events in Fusion-based SaaS applications from Oracle Integration Cloud (OIC) - Part 2

Alexandru Dinea
Oracle EMEA A&C Cloud Adoption & Implementation Consultant

In order to successfully create your connection to business events from your Fusion-based SaaS application, you must first complete all the prerequisites listed in part 1 of this blog miniseries. Please make sure to check if you have done all the prerequisites otherwise your connection to business events will not work.

In this second part of the blog, I will show you how you can create a new connection in Oracle Integration Cloud (OIC) to your business events from your SaaS and use it in a new integration. I will also cover optional verification steps that you can follow to ensure that you are indeed connected to your business events from your SaaS.

Create a Connection from OIC to SaaS

Create a new connection using Oracle ERP Cloud Adapter or Oracle Sales Cloud Adapter.

  1. In the navigation pane, click Integrations, then click Connections.
  2. Click Create.
  3. Select an adapter from the dialog. You can also search for the type of adapter to use by entering a partial or full name in the Search field and clicking Search. In this case, select Oracle ERP Cloud Adapter or Oracle Sales Cloud Adapter.

The Create New Connection dialog is displayed.

  1. Enter the information to describe the connection.
    • Enter a meaningful name to help others find your connection when they begin to create their own integrations. The name you enter is automatically added in capital letters to the Identifier field. If you modify the identifier name, do not include a blank space (for example, Sales Opportunity).
    • Select the role (direction) in which to use this connection (trigger, invoke, or both). Only the roles supported by this adapter are displayed for selection. When you select a role, only the connection properties and security policies appropriate to that role are displayed on the Connections page. If you select an adapter that supports both invoke and trigger, but select only one of those roles, then try to drag the adapter into the section you did not select, you receive an error (for example, configure an Oracle Service Cloud (RightNow) Adapter as only an invoke, but drag the adapter to the trigger section).
    • Enter an optional description of the connection.


  1. Click Create button.

Your connection is created and you are now ready to configure connection details, such as email contact, connection properties and connection login credentials.


Add a Contact Email

From the Connection Administrator section of the connection, you can add a contact email address for notifications.

  1. In the Email Address field, enter an email address to receive email notifications when problems occur.
  2. In the upper right corner, click Save button.


Configure Connection Properties

Enter connection information so your application can process requests.

  1. Click Configure Connectivity button.

The Connection Properties dialog is displayed.

  1. In the Property Value field, specify the URL to use in this integration.
  • Service Catalog WSDL URL: this is the SOAP endpoint to retrieve all published SOAP web services
    • URL   <base_fa_url>/fscmService/ServiceCatalogService?WSDL
  • Event Catalog URL: this is a REST endpoint which exposes all available events. The adapter uses this to display a list of events which you can select from
    • URL   <base_fa_url>/soa-infra
  • Interface Catalog URL: this is the REST endpoint to retrieve all published REST web services
    • URL   <base_fa_url>/fscmRestApi/otherResources/latest/interfaceCatalogs

For connecting to your business events in your SaaS you only need to define the Service Catalog WSDL URL and Event Catalog URL. Interface Catalog URL is optional.

  1. Click OK button.

  1. Configure connection security.


Configure Connection Security

Configure security for your Oracle ERP Cloud Adapter or Oracle Sales Cloud Adapter connection with the user that you have previously configured with integration roles in your SaaS.

  1. Click Configure Credentials.
  2. Enter your login credentials:
    1. Enter a username and password. Enter the username and password of the user that you have previously configured with integration roles in your SaaS.
    2. Reenter the password a second time.
  3. Click OK button.



Test the Connection

Test your connection to ensure that it is successfully configured.

In the upper right corner of the page, click Test button.

  1. Test: Connects to the WSDL URL and performs a syntax check on the WSDL. No requests are sent to the operations exposed in the WSDL.

If successful, a message is displayed and the progress indicator shows 100%.

  1. If your connection was unsuccessful, an error message is displayed with details. Verify that the configuration details you entered are correct.
  2. When complete, click Save, then click Close.

If testing the connection works fine, then you can directly proceed with using your new connection in an integration of your choice.


Using the connection in an integration

Now that you have a connection created and tested, next step is to use it in a new integration.

1.In the upper left corner of the page, click Integrations.

  1. In the upper left corner of the page, click Create button to create a new integration.
  2. Select App Driven Orchestration from the new pop-up displayed.
  3. Give the integration a meaningful name (“Demo Integration” for example) and click Create button.

  1. In the new blank canvas drag and drop your connection or click on the “+” sign and select your connection. A new pop-up wizard for your connection should appear.
  2. In the Basic Info tab, provide a name to your endpoint(“SubscribeToBE” for example) and click Next button.
  3. In the Request tab, select the With Business Events option and choose one of the available Business Events (“Account Created Event” for example) and you can also provide a filter expression. Click Next button when you are done.

8.In the Response tab, select None and click Next button.

9.In the Summary tab, you can see an overview of the configuration you done to your connection. Click Done button when you are done.

10.Congratulations! You can now proceed to utilize the new business event that you subscribed to. Your Integration should look like this at this moment:


Test the Service Catalog WSDL, Event Catalog and Interface Catalog URLs

You can verify if you have the correct URLs by entering them in the following way into a web browser:

  • Service Catalog WSDL URL: Enter the complete URL like https://XYZ.em2.oraclecloud.com/fscmService/ServiceCatalogService?WSDL After entering the credentials of a SaaS user, a WSDL file should be displayed
  • Event Catalog URL: Enter the URL followed by "/PublicEvent/catalog" like https://XYZ.em2.oraclecloud.com/soa-infra/PublicEvent/catalog After entering credentials of a SaaS user, a JSON response with all events should be displayed
  • Interface Catalog URL: Enter the complete URL like https://XYZ.em2.oraclecloud.com/fcsmRestApi/otherResources/latest/interfaceCatalogs After entering the credentials of a SaaS user, a JSON file should be displayed

This is the example of our Item Creation Event (you don't need to know this details level - this is just to inform what happens under the covers):

{"documentService":{"outputXPath":null,"inputXSLT":"oramds:/oracle/apps/scm/productModel/items/findItemFromItemBE.xsl","keyMaps":[],"csfkey":null,"wsdlInterface":"http://xmlns.oracle.com/apps/scm/productModel/items/itemServiceV2/#wsdl.interface(ItemService)","wsdlPort":"http://xmlns.oracle.com/apps/scm/productModel/items/itemServiceV2/#wsdl.endpoint(ItemService/ItemServiceSoapHttpPort)","wsdlLocation":"${ORA_FSCM_SERVICESAPPProtocolToken}://${ORA_FSCM_SERVICESAPPHostToken}:${ORA_FSCM_SERVICESAPPPortToken}/fscmService/ItemServiceV2?WSDL","operation":"findItem"},"documentTransform":null,"customEvents":[],"name":"{/oracle/apps/scm/productModel/items/protectedModel/entity/events/edl/ItemEO}postItemCreate","id":"SCM_EGP_ITEM_CREATE","displayName":"Item Create Event","description":"This public event signals an item is created"}


Verification in Case of Issues

You can verify if the event subscription has been correctly registered in the FA Cloud instance by executing the following URL in a browser:

URL   <base_fa_url>/soa-infra/PublicEvent/subscriptions

This URL is secured by credentials of the Fusion Cloud instance.

You should get a list of subscriptions in JSON format:

{"csfKey":"XXXXX","endpointURL":"https://XXXXX/ic/ws/integration/v1/flows/erp/ERP_PO_EVENT_VBCS_96_06/1.0/","filter":"<xpathExpr xmlns:ns2='http://xmlns.oracle.com/apps/prc/po/editDocument/purchaseOrderServiceV2/types/' xmlns:ns0='http://xmlns.oracle.com/apps/prc/po/editDocument/purchaseOrderServiceV2/'>$eventPayload/ns2:result/ns0:Value/ns0:PurchaseOrderLine/ns0:ItemDescription=&quot;Lan Cable&quot;</xpathExpr>","name":"{http://xmlns.oracle.com/apps/prc/po/approval/PrcPoApprovalComposite/PurchaseOrder}PurchaseOrder","id":"XXXXX","state":true}


If you have successfully followed through this blog miniseries, you are connected to your business events in your SaaS from OIC. Congratulations!

Join the discussion

Comments ( 2 )
  • Anil Pujari Tuesday, October 15, 2019
    Thank you Alexandru Dinea!. It is very useful Info. Based on this ,we have developed the new Business event Integration.

    Thanks & Regards,
  • Alexandru Dinea Wednesday, October 16, 2019
    Glad to hear that the material was helpful, Anil Pujari!

    Good luck with your future projects.

    Have a nice day,
    Alexandru Dinea
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.