Skip to main content

Celonis Product Documentation

Oracle Fusion REST extractor

New data integration content available

You're currently viewing a data integration topic that has been replaced and will eventually be removed from our documentation.

For the latest data integration content, see: Data Integration.

Important

Any references to third-party products or services do not constitute Celonis Product Documentation nor do they create any contractual obligations. This material is for informational purposes only and is subject to change without notice.

Celonis does not warrant the availability, accuracy, reliability, completeness, or usefulness of any information regarding the subject of third-party services or systems.

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 Celonis Platform

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 Celonis Platform, otherwise, data cannot be extracted. The Celonis Platform's IPs differ depending on the cluster (eu-1 or us-1). For more information, see Allowlisting domain names and 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 (such as updates or 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 against 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.

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.