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

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

• Install Workato on-prem agent (opens new window)

• Sign in to your Oracle EBS account and deploy the User PL/SQL REST service internal name: FND_USER_PKG) with name user. Complete the following steps to install PL/SQL REST service:

1

Go to the main menu and select Integrated SOA Gateway > Integration Repository.

Oracle Applications home page

2

Select Search, search for the interface name user, and then select the service with internal name FND_USER_PKG.

Select Search

Locate FND_USER_PKG

3

Go to the REST Web Service tab, enter the service name as user, and then select Deploy.

Go to the REST Web Service tab, enter the service name as user, and then select Deploy

Connection setup

Complete the following steps to set up your connection:

1

Provide a Connection name that identifies which Oracle EBS instance Workato is connected to.

Set up your Oracle E-Business Suite connection

2

Use the On-prem secure agent menu to select the appropriate, active on-premise agent that has network access to this Oracle EBS instance if your Oracle EBS instance is not accessible directly from the internet.

3

Provide the Instance URL. This is the base URL where the REST services enabled on your Oracle SOA gateway are accessed.

4

Provide the Username you plan to use to access the REST services on your Oracle SOA gateway.

5

Enter the Password associated with your username.

6

Provide a User service name. This is used only to test connectivity.

7

Click Connect. A “hello world” test displays your Oracle EBS instance using the REST service specified in User service name in the preceding steps.