Using Business Events in Fusion-based SaaS with Oracle Integration Cloud Service – Part 1: Overview

Introduction

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

Oracle Integration Cloud Service (ICS) or the new offering Oracle Integration Cloud (OIC) allow very easily to receive (subscribe) to these events and forward them, for example, to external applications. Following a previous A-Team post on Chronicles on Sales Cloud Events, we will give an update on Release 13 and how to use the event filters.

One example would be to publish an event every time a new item in SCM is created. With this event, a call to ICS/OIC is executed which triggers an integration.

The easiest way of subscribing to business events is by using the Oracle Sales Cloud Adapter or Oracle ERP Cloud Adapter (for SCM) in Oracle Integration Cloud Service (ICS).

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 – now there is a single Service Catalog WSDL URL and a single Events Catalog URL – which simplifies creation of event subscriptions.

In this blog series, I will give an update of the new events available, how to subscribe from ICS – or the new Oracle Integration Cloud (OIC) offering – and how to use Event Expressions to filter only specific events to subscribe to.

 List of Business Events in Release 13

This is a list of all Business Events in an R13 GSI instance you can subscribe to (this version is based on Update 17C):

 
Business Event Event Operation
Account Created/Deleted/Updated
Activity Created/Deleted/Updated
Activity Note Created/Deleted/Updated
Advance Shipment Notice Event N/A
ASN Creation Event N/A
Asset Created/Deleted/Updated
Backorder Line Event N/A
Business Plan Created/Deleted/Updated
Business Plan Note Created/Deleted/Updated
Change Order Scheduled Event N/A
Contact Created/Deleted/Updated
Create Correction Transaction Event N/A
Create Deliver Transaction Event N/A
Create Receiving Receipt Event N/A
Create Return Transaction N/A
Customer Asset Created/Updated
Customer Asset Relationship Created/Deleted
Data Pool Subscription Confirmation Sent Event N/A
Data Pool Subscription Event N/A
Deal Created/Updated
Deal Note Created/Deleted/Updated
ERP Integration Inbound Event N/A
ERP Integration Outbound Event N/A
Item Created/Updated
Item Bulk Load Event N/A
Item Catalog Category Assignment Change N/A
Item Revision Change Event N/A
Item Structure Created/Updated
Item Structure Component Created/Updated
Item Supplier Association Created/Updated
Lead Created/Deleted/Updated
Lead Note Created/Deleted/Updated
Manifest Request Event N/A
Opportunity Created/Deleted/Updated
Opportunity Note Created/Deleted/Updated
Order Status Updated N/A
Partner Created/Updated
Partner Contact Created/Updated
Partner Note Created/Deleted/Updated
Product Upload Status Change Event N/A
Receipt Advice Event Notification N/A
Recurrence Activity Created/Deleted/Updated
Sales Order Notification N/A
Sales Order Trade Compliance Screening N/A
Sales Order Transportation Planning N/A
Service Request Created/Deleted/Updated
Service Request Message Created Event N/A
Shipment Advice Event N/A
Shipment Request Generate Event N/A
Standard Cost Exported/Published
Trade Screening Request Event N/A
Transfer Price Published Event N/A
Work Order Created/Updated

How you subscribe to events with ICS/OIC

The process of subscribing to events requires the following steps:

  • Create a connection to your Cloud instance using the correct Service Catalog WSDL URL and Events Catalog WSDL. Please notice that the Events Catalog WSDL is optional – but when you omit it, then you will not be able to select “Business Events” as a request type from the Connection Wizard in an Integration.
  • Once this connection is tested and showing active, drop it into an integration – and complete the selection of event and other required definitions
  • Activate the integration.
  • Verify that the event subscription has been created.
  • Test that the events are successfully published to ICS/OIC.

We will show these steps in an example in Part 2 of this post for Item Creation (SCM) and in part 3 also for Contact Creation (CRM) events with ICS – and how to diagnose in case of issues.

Part 3 concludes with a description how to filter events using XPath expressions.

References

  • Oracle ERP Cloud Adapter (for SCM Cloud and ERP Cloud): https://docs.oracle.com/en/cloud/paas/integration-cloud-service/icser/oracle-erp-cloud-adapter-capabilities.html
  • Oracle Sales Cloud Adapter: https://docs.oracle.com/en/cloud/paas/integration-cloud-service/icssc/oracle-sales-cloud-capabilities.html

Add Your Comment