Update August 2019: Please note that this blog was written in 2017 when SCM Cloud R13 was available. The Current version is R13 19B. Although much of this blog still applies, some steps may be different meanwhile. Please visit https://docs.oracle.com/en/cloud/saas/supply-chain-management/19b/index.html for the latest.
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.
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 | |
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 |
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.
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
Next Post