Connector to Oracle E-Business Suite (EBS)

This connector has been discontinued

This article is for an unsupported connector that will soon be removed from the Workiva platform.
It can no longer be activated within a workspace.

Click here to learn more about discontinued connectors.

With the Oracle® E-Business Suite® connector, you can use a command to import journals into Oracle E-Business Suite (EBS) as part of a chain.

Note: This connector is built by Workiva and connects to a third-party system. While our Support team can help configure this connector within your workspace, we are unable to troubleshoot or otherwise assist with any issues that originate outside of the Workiva platform.

Prerequisites

To enable the connection, the connector uses Java Database Connectivity (JDBC) and the Oracle EBS APIs. To set up the connector, you'll need:

• The JDBC connection URL, such as jdbc:oracle:thin:@127.0.0.1:1521:EBSDB
• An integration user set up on the backend database for the connector
• The integration user's authentication credentials
• To connect to an on-premise database, a GroundRunner for the connector

Note: To connect to a cloud database, use the default CloudRunner.

Set up the Oracle E-Business Suite connector

Note: To make the connector available for use in your organization's chains, an org security administrator first enables it from Configuration.

1. From Chain Builder, click Connections  compare_arrows, and then Create at the top right.
2. Under BizApp Connection, select Oracle E-Business Suite and the runner to use with the connector.
   
3. Under Basic Info, enter a unique name and description to help identify the connection.
4. Under Properties, enter the connector's details:
   
   

   Property	Details
   Database username	To interact with the backend database, enter the username of the integration user to use with the connector.
   Database password	Enter the password for the Database Username property.
   Database connection URL	Enter the JDBC connection URL, such as jdbc:oracle:thin:@127.0.0.1:1521:EBSDB.

   Note: All sensitive credentials are automatically encrypted and stored at Advanced Encryption Standard (AES)-256 encryption.

5. Select the environments to use with the connection, and click Save.
6. To test the connection, create and run a chain with the connector's Import Journal command, and verify it returns a valid output.

Troubleshooting

If the connection to Oracle EBS fails:

• Check the JDBC connection URL for the database.
• Verify the integration user's authentication credentials.
• For an on-premise database, check the GroundRunner selected for the connector.