Oracle E-Business Suite
Oracle's E-Business Suite (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
Install Workato on-prem agent
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, click on Integrated SOA Gateway > Integration Repository
Oracle Applications home page
c. Click on Search
Click on Search
d. Search for interface name "user" and select the service with internal name FND_USER_PKG
e. Go to the REST Web Services tab. Enter the service name as "user" and click on 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:
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, e.g. “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.
The username that Workato will use to access the REST services on your Oracle SOA gateway.
Corresponding password for the above username.
- User service name:
This is used only to test connectivity.