SalesForce Integration With Oracle ERP Cloud

Salesforce integration with Oracle ERP cloud can easily be achieved using Oracle OIC.

Oracle Integration cloud provides a prebuild salesforce adapter for inbound and outbound integrations.

Let us see the high-level steps to integrate salesforce with oracle saas applications.

As with other OIC adapters, the salesforce commonly known as SFDC adapter has benefits over direct soap or rest calls like :

  • Makes bidirectional integration with Salesforce.com easy.
  • Select business objects and operations from UI and do mapping easily.
  • Provides support for CRUD operation against business objects fetched from the Salesforce application:
  • Supports all custom objects defined by the user and custom fields created at SFDC along with the standard objects and fields.
  • Supports receiving notifications (events) sent with Send Outbound Messages from Salesforce.
  • Supports trigger (source) callbacks.
  • Supports Salesforce APIs protected using OAuth.

Prerequisites on Salesforce Side

The integration with SFDC can be achieved by couple of ways

  1. WorkFlow Outbound messaging
  2. Enabling Events on required objects.

1. When Using Workflow outbound messaging:

You can configure sfdc workflow outbound messages to send required fields and provide your integration endpoint in the configuration.

image 3 SalesForce Integration With Oracle ERP Cloud 1

To do that navigate to Setup > search workflow> select outbound messages > button New Outbound Message.

Select object (Order) in our case . Enter a name and a dummy URL (to be updated with your integration OIC URL later). Select all the fields to be sent as part of payload outbound message.

image 4 SalesForce Integration With Oracle ERP Cloud 2
image 6 SalesForce Integration With Oracle ERP Cloud 3

Click on the WSDL endpoint

image 7 SalesForce Integration With Oracle ERP Cloud 4

Save the WSDL to a local folder

image 8 SalesForce Integration With Oracle ERP Cloud 5

Go to setup > workflow rules and create a rule to invoke the outbound message

image 9 SalesForce Integration With Oracle ERP Cloud 6
image 10 SalesForce Integration With Oracle ERP Cloud 7
image 11 SalesForce Integration With Oracle ERP Cloud 8

make sure to activate the rule

image 12 SalesForce Integration With Oracle ERP Cloud 9

Connected App in SFDC

A connected App has to be created in salesforce to define the security authentication policy to access the direct SFDC Rest apis ( this Is required when not using the SFDC Adapter)

image 22 SalesForce Integration With Oracle ERP Cloud 10
image 23 SalesForce Integration With Oracle ERP Cloud 11
image 26 SalesForce Integration With Oracle ERP Cloud 12
image 27 SalesForce Integration With Oracle ERP Cloud 13
Configure Policies as required

OIC Configuration for SFDC outbound messaging

Create a App driven orchestration in Oracle OIC and Use Outbound messaging in the Salesforce Adapter during OIC process creation when the SFDC integration is set to Workflow outbound messaging

image 15 SalesForce Integration With Oracle ERP Cloud 14

Upload the WSDL saved in previous step while configure SFDC outbound message

image 16 SalesForce Integration With Oracle ERP Cloud 15
image 17 SalesForce Integration With Oracle ERP Cloud 16

2. Using Platform Change Data Capture Events

image 13 SalesForce Integration With Oracle ERP Cloud 17

Go to Setup> Integrations> Change Data Capture and select the Object to the right side. Once done any change on the object will trigger a event which can be captured by middleware ( Oracle integration Cloud)

OIC Configuration for SFDC Change data capture event

image 18 SalesForce Integration With Oracle ERP Cloud 18

Create a app driven orchestration in Oracle OIC and use Streaming API in the Salesforce Adapter during OIC process creation for reading change data capture events.

image 19 SalesForce Integration With Oracle ERP Cloud 19
Select the business object (order ) on which the data change event is configured in SFDC. Also select when you want this to trigger (create ,update , delete etc.)

OIC Connections to Sales force

1. Create a Salesforce Connection in OIC

image 20 SalesForce Integration With Oracle ERP Cloud 20

Create a connection to the Salesforce instance using the salesforce adapter

  • go to Home > Integration>Connections> Click on Create Connection
  • Select Salesforce adapter
  • Configure Salesforce adapter connection properties .
  • Instance as production, Sandbox or government. The Api version (e.g 54.0 )
Pre-requisites for Creating a Connection

You should have a salesforce development organization created.

When you enter password It has to be concatenated with a Security Token from SFDC and then only a successful connection can be established.

so In password field you will need to enter <your password><your token> as a single conctenated string.
image 75 SalesForce Integration With Oracle ERP Cloud 21

2.Configure Endpoint for SalesForce Integration With ERP Cloud

Configure the object you want to do transaction on salesforce

image 77 SalesForce Integration With Oracle ERP Cloud 22

Select the operation to be performed

image 78 SalesForce Integration With Oracle ERP Cloud 23

Select the business object like account

image 79 SalesForce Integration With Oracle ERP Cloud 24
image 80 SalesForce Integration With Oracle ERP Cloud 25

3. Do Mapping for the business object e.g account

image 82 SalesForce Integration With Oracle ERP Cloud 26
image 83 SalesForce Integration With Oracle ERP Cloud 27

For more details on Salesforce adapter refer the oracle documentation here.

SalesForce Integration with Oracle E-business Suite (EBS)

Salesforce can also be integrated seamlessly with EBS. Refer the oracle standard video below which describes and integration flow to create a EBS Order from Salesforce opportunity.

These were the highlevel steps to integrate Oracle ERP Cloud and SalesForce.

If you are new to oracle integration cloud do checkout OIC Basics

Summary

With the above steps we can create a integration from salesforce to Oracle ERP cloud. Let us summarize the steps.

  • Decide the trigger pattern from salesforce > Set it up for outbound messaging or Change data capture event
  • Create a Connected App and configure the oAuth Usage access policy
  • Configure Outbound messaging > add url to be later replaced by your OIC process url
  • Create Workflow Rules to trigger based on conditions
  • Activate Workflow Rule

When Using Change Data capture

Setup the change data capture event in sfdc for the object ( order)

configure OIC salesforce adapter to read the data from SFDC via outbound message or Streaming API event.

Once done and order is created in SFDC you will see OIC getting triggered with the Paylod from SFDC. This can be used to design your orchestration process based on your requirement.

image 21 SalesForce Integration With Oracle ERP Cloud 28

FAQs:

Why OIC SalesForce Adapter Return Error 401 Unauthorized?

It was a bug in which it gave 401 error in first attempt. It is addressed now .

Does OIC Supports SalesForce Bulk API 2.0?

Not Yet.

SFDC Integration Inbound To OIC Fails With “No Content-Length header in request

In Integration Cloud, we either need with the Content-Length header to be passed (0 is also valid value for this field) or Transfer-Encoding being passed (Content-Length is not needed). refer https://help.salesforce.com/articleView?id=000220245&type=1

Can Attachments be fetched from Salesforce Adapter?

Yes. The attachment retrieved will be in Base64 encoded format

You may like

wpsadmin
We will be happy to hear your thoughts

Leave a reply

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
100% Free SEO Tools - Tool Kits PRO
Cloud Technologies Blog
Logo
Compare items
  • Total (0)
Compare
0
Shopping cart