4 MIN READ

Improving sales team productivity by integrating Oracle EBS and Salesforce.

A salesperson is effective only to the extent of knowledge they have about the product or service that they are selling. Even the most "blue chip" CRM systems do not effectively provide the internal product or service information required by the salesperson at that time. Typically, the information related to customers, sales orders, availability, etc. resides within the internal ERP systems, which limits access to the increasingly mobile salesforce. Having the ability to access information on the go in real-time expedites the sales process and enables the salesperson to make more effective sales.

Don’t have time? Read it later:

Client Snapshot

  • Manufacturer of physical infrastructure for Data Centers, Enterprise, and Industrial environments
  • 5,000+ employees
  • $1+ billion (USD) annual revenue
  • Location: Chicago, IL

Project Overview

A manufacturer needed to integrate Salesforce CRM into its Oracle E-Business Suite ERP system. Using MuleSoft Anypoint Studio, ennVee would build the integration and a framework to allow each salesperson to optimize sales via Salesforce, and access required information from a central repository (the ERP system). In this case, Oracle EBS is the back-end system for business transactions.

  • Use MuleSoft as the integration engine to build a solution that creates customer details (customer and site details) and sales orders in Oracle EBS based on the opportunity created in Salesforce.
  • Send an acknowledgment back to Salesforce by updating the sales order number against the designated opportunity.
  • Deploy the MuleSoft solution exclusively to Cloud.

Solution Components

Oracle EBS to Salesforce Integration Process

  1. MuleSoft integrations assist in updating an item from Oracle EBS to SFDC as a product that a salesperson can see and plan to sell.
  2. When a salesperson selects a product in SFDC, this event triggers an action in Oracle EBS to bring the availability information back to SFDC.
  3. The salesperson can proceed to create an opportunity based on availability. The system will allow an opportunity to be created if the available quantity is equal to or greater than the requested quantity. Alternatively, if there is no availability or less availability, SFDC will throw up a warning but allow the opportunity to be created.
  4. Based on the opportunity details, MuleSoft will check if the customer pre-exists in Oracle EBS for the associated account in SFDC. If the customer does not exist in EBS, MuleSoft creates the customer details and associated Bill-To and Ship-To details (sites) by calling standard APIs. Subsequently, MuleSoft creates the sales order in Oracle EBS for the customer.
  5. Later, MuleSoft sends back the information to SFDC regarding the generated sales order for the particular opportunity.
  6. MuleSoft throws up an exception if it cannot connect to either SFDC or Oracle EBS after a set number of tries.

Read the full white paper here: