Oracle E-Business Suite

Oracle's E-Business Suite (opens new window) (also known as Applications/Apps or EB-Suite/EBS), is a collection of enterprise resource planning (ERP), customer relationship management (CRM), and supply-chain management (SCM) computer applications that enables organizations of any size to operate and perform effectively.

How to connect to Oracle E-Business Suite on Workato

Prerequisites

1. Install Oracle E-Business Suite Integrated SOA Gateway (opens new window)

2. Install Workato on-prem agent (opens new window)

3. In the Oracle EBS, deploy User PL/SQL REST service (internal name: FND_USER_PKG) with name “user”. Below are the steps to install PL/SQL REST service

a. Login to Oracle EBS

b. From the main menu, select Integrated SOA Gateway > Integration Repository

Oracle Applications home page

c. Select Search

Select Search

d. Search for interface name "user" and select the service with internal name FND_USER_PKG

Locate FND_USER_PKG

e. Go to the REST Web Services tab. Enter the service name as "user" and select Deploy.

Locate the REST web services and enter "user"

Establishing the connection on Workato

Create the Oracle EBS connection from within the recipe Connections tab, or from the account connections page (opens new window):

To create the connection, select Oracle E-Business Suite, fill in the fields required, and click Connect. At this point, Workato will make a simple “hello world” test to your Oracle EBS instance, using the REST service specified in User service name above.

If all goes well, you should get a green success message displayed next to the button.

Creating new Oracle E-Business Suite connection

Fields are as follows:

• Connection name:

Use something that identifies the specific Oracle EBS instance, for example, “HR Sandbox”.

• On-prem secure agent:

If your Oracle EBS instance is not accessible directly from the Internet, Workato will need to connect to it via an on-premise agent. Select the appropriate, active on-premise agent that has network access to this Oracle EBS instance.

• Instance URL:

The base URL where the REST services enabled on your Oracle SOA gateway can be accessed.

• Username:

The username that Workato will use to access the REST services on your Oracle SOA gateway.

• Password:

Corresponding password for the above username.

• User service name:

This is used only to test connectivity.