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

Pre-requisites

  1. Install Oracle E-Business Suite Integrated SOA Gateway

  2. Install Workato on-prem agent

  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, click on Integrated SOA Gateway > Integration Repository

Oracle Applications Home page Oracle Applications home page

c. Click on Search

Search on page Click on Search

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

Search for User Locate FND_USER_PKG

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

User service name 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.

Oracle recipe 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.

  • 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.

results matching ""

    No results matching ""