X

@OracleIMC Partner Resources & Training: Discover your Modernization options + Reach new potential through Innovation

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

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

For integration with all Oracle Fusion based Cloud services - like Oracle Sales Cloud and Oracle ERP Cloud - each service provides Business Events which external applications or integrations can subscribe to.

Oracle Integration Cloud (OIC) allow very easily to receive (subscribe) to these events and forward them, for example, to external applications. The easiest way of subscribing to business events is by using the Oracle Sales Cloud Adapter or Oracle ERP Cloud Adapter in Oracle Integration Cloud (OIC).

In the prior release of FA-based solutions - Release 12 - you had to create separate connections for each pillar (CRM, SCM, ERP). This has changed with R13 or later - now there is a single Service Catalog WSDL URL, a single Events Catalog URL and a single Interface Catalog URL - which simplifies creation of event subscriptions.

In this miniseries of our blog, I will show how to subscribe to these business events in R13 or later versions of Fusion-based SaaS application from Oracle Integration Cloud (OIC). In the first part, I will go in detail into mandatory prerequisites that you must meet in order to successfully subscribe to your business events in your SaaS.

Prerequisite: Create an integration account in SaaS

To successfully subscribe to business events in your SaaS from OIC you must first create an integration account in your SaaS. You can create a new user or select an existing user (DO NOT SELECT THE USER THAT YOU HAVE RECEIVED WHEN PROVISIONING YOUR SaaS ACCOUNT), to which you add the following roles:

Integration Specialist

  1. From the Home Page, select Tools -> Security Console.
  2. On the Users tab, search for and select the user you want to give the role.
  3. Click on the user and a User Account Details page is going to be opened for that specific user.
  4. Click on the Edit button on the top right.
  5. Scroll down and click on the Add Role button.
  6. A new pop-up named Add Role Membership should appear. Search for the Integration Specialist role.
  7. Click on the Add Role Membership button.
  8. A confirmation should appear that the role has been successfully added. Click OK.

  1. Click the Save and Close button to save the changes.

 

Attachments User

  1. From the Home Page, select Tools -> Security Console.
  2. On the Users tab, search for and select the user you want to give the role.
  3. Click on the user and a User Account Details page is going to be opened for that specific user.
  4. Click on the Edit button on the top right.
  5. Scroll down and click on the Add Role button.
  6. A new pop-up named Add Role Membership should appear. Search for the Attachments User role.
  7. Click on the Add Role Membership button.
  8. A confirmation should appear that the role has been successfully added. Click OK.

  1. Click the Save and Close button to save the changes.

 

FND_MANAGE_CATALOG_SERVICE_PRIV

(Privilege needs to be added in Custom role ex: OIC_INTEGRATION_ROLE)

In many cases, you will have to create this custom role and then assign it to your user of choice.

  1. From the Home Page, select Tools -> Security Console.
  2. Click on the Create Role button on the top right.
  3. In the Basic Information screen, the Role Name has the value of “OIC INTEGRATION ROLE”, the Role Code has the value of “OIC_INTEGRATION_ROLE” and the Role Category has the value of “SCM – Job Roles”. Click Next button.

  1. In the Function Security Policies screen, click on Add Function Security Policy and search for “Manage Webservices catalog”
  2. Click on Add Privilege to Role button

  1. A Confirmation pop-up should appear. Click OK button.
  2. Leave the rest as defaults and finish the wizard by clicking on Save and Close button.

  1. On the Users tab, search for and select the user you want to give the role.
  2. Click on the user and a User Account Details page is going to be opened for that specific user.
  3. Click on the Edit button on the top right.
  4. Scroll down and click on the Add Role button.
  5. A new pop-up named Add Role Membership should appear. Search for the FND_MANAGE_CATALOG_SERVICE_PRIV role.
  6. Click on the Add Role Membership button.
  7. A confirmation should appear that the role has been successfully added. Click OK.

  1. Click the Save and Close button to save the changes.

 

Prerequisite: Register CSF Key in SaaS

In a FA-based SaaS instance, the outbound call of a webservice uses a OWSM security policy which retrieves the credentials for the call from a CSF Key. This means that you need to register a CSF key for every connection to an external system.

  • The name of the CSF key must match the concatenation between OIC Identity Domain and OIC Service Instance
    • concat(Identity Domain, Service Instance)
    • These details can be found easily by clicking on the username on the up-right side of the OIC page and selecting “About”

  • The user must be an OIC user
  • The password must be the password of this OIC user

You create this CSF key via SOA composer - accessible through the URL   <base_fa_url>/soa/composer

Click on the Manage Security button.

Enter the details and press Register button.

This is the only step required for a R13 or later GSI cloud instance. If you still have a R12 instance, then additional steps may be required.

 

Now that all prerequisites have been met, please go to part 2 where I will showcase how you can create a connection in OIC and use it in an integration. I will also cover some optional verification cases to ensure that you are indeed subscribed to your business events in your SaaS.

Join the discussion

Comments ( 4 )
  • Madhava Friday, July 19, 2019
    Hi Alexandru Dinea GoodDay,

    We have followed this blog and configured same steps in my OIC and ERP Dev instance.But still we couldn't able subscribes the events from ERP to OIC.
    Even we couldn't see the entry in https://URL/soa-infra/PublicEvent/subscriptions after CSF entry soa composer of my OIC instance.

    Could you please help us on this.

    Thanks,
    Madhava,
    98903244868.
  • Alexandru Dinea Friday, July 19, 2019
    Hello Madhava,

    Please make sure that you have followed through the steps described correctly.

    Also, I hope you have checked the part 2 of this blog miniseries : https://blogs.oracle.com/imc/subscribe-to-business-events-in-fusion-based-saas-applications-from-oracle-integration-cloud-oic-part-2

    What is the version of your ERP? Also, what is the version of your OIC?

    Have you tried to create a connection in OIC following the steps described in part 2? What error have you encountered?

    I have sent you an email as well. Please make sure to check it and let us move our discussion in private in order to help you connect to your business events in your ERP.

    Have a nice day,
    Alexandru Dinea
  • Nagesh Saturday, July 20, 2019
    Hi Alexandru,

    Is it possible to configure SaaS cloud to send these business events to External System like Mulesoft.

    Thanks,
    Nagesh.
  • Alexandru Dinea Tuesday, July 23, 2019
    Hello Nagesh,

    It is possible to send these business events to External System, only if you have OIC (Oracle Integration Cloud) in the middle.
    OIC will listen to these events and send them to the External System of you choice by using one of the adapters available in the platform.
    The external system must have an interface in SOAP or REST which you can connect to by using one of OIC's general REST or SOAP adapter.

    You cannot send these business events directly to an External System.

    So, in order to send business events from SaaS to Mulesoft, you must have OIC configured in the middle.

    Let me know if you have any other questions.

    Best regards,
    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.