Skip to main content

Celonis Product Documentation

Oracle ERP Cloud Connection

Steps to set up a Oracle data connection

Step 1: Configure a user with sufficient permissions in Oracle

The following steps help you to set up a new user in Oracle with the necessary permissions to use data extractions to Celonis.

Create a user or provide an existing user with the following privileges:

  • Administer Purchase Order by REST Service

  • View Payables Payment

  • View Payables Invoice by Web Service

  • View Payables Invoice Holds

  • View Holds Resolution and Negotiation History

And as sub roles the following seeded roles:

  • Procurement REST Service

  • Payables Invoice Inquiry

Additionally the data security policies need to allow the data to be extracted. These can be copied from the seeded Procurement Integration Specialist role and added one for database resource Business Unit and action Manage Payables Invoice.

Otherwise no invoice related data can be extracted.

Step 2: Allowlist the IPs of the EMS

Note

Follow this step only if your system is IP-blocked.

If your system is only reachable within a certain IP range, you need to allowlist the outbound IPs of the EMS, otherwise data cannot be extracted. The IPs of the EMS are different depending on the cluster (eu-1 or us-1). For more information, see Allowlisting Celonis IP addresses.

Step 3: Create a Data Connection in a Data Pool
Step-by-step
  1. Enter the name of the new Oracle Data Connection.

  2. Choose between Direct or Uplinked. Direct for extracting data from cloud platforms and Uplinked for local systems that run within your organization (on-premises).

  3. Insert the user name of the user connecting with the Oracle ERP Cloud system.

  4. Enter the password of the user connecting with the Oracle ERP Clou system.

  5. Select the Version of the Instance your Oracle Fusion Applications are on. If you're not sure which version that is, you can find the current version via:

    1. Log in to the Oracle Fusion Applications in Oracle Applications Cloud Services instance.

    2. Click the user name in the top right area of the window, then choose About Applications.

    3. The version appears just below the heading "About Oracle Fusion Applications."

  6. The host is the REST server to contact for your identity domain or Cloud account.

    For example, to find the server name for Oracle Sales Cloud Services:

    1. Sign in to the My Services dashboard for your identity domain or Cloud Account.

    2. In the list of services, click Sales Cloud.

    3. Locate the REST Endpoint field, which shows the URL to the REST server.

    For example: https://sales.oraclecloud.com/

    If you do not have access to the My Services dashboard, get the REST server URL from your Oracle Cloud Account administrator.

  7. The maximum number of parallel extractions that the data connection allows.

Data Extraction
Data Access

The Celonis Extractor performs read-only operations on your Oracle data. No writing changes (like updates, deletions) will be performed at any time during the extraction process.

Source System Impact

The Celonis Extractor is bound to the API call limits applied by Oracle, guarding the system from any performance issues.

Security

Transfer of the data from the Oracle system to the target system is secured through HTTPS, which allows for an encrypted exchange of information.

Used API

The Celonis Extractor uses the standard REST API of Oracle. As the Oracle Procurement API currently does not provide Change Logs, an additional data extraction via the Oracle BI Publisher is needed.

For more details see the corresponding BI Publisher section.