Skip to main content

Celonis Product Documentation

Connecting to Oracle Fusion Cloud REST (extractor)

You can connect to your Oracle Fusion Cloud applications using the REST API extractor, allowing you to run GET requests for information. This method allows the Celonis Platform read only access to your Oracle Fusion Cloud data, meaning that no writing changes (such as updates or deletions) will be performed at any time during the extraction process.

You can also connect via the Business Intelligence Cloud Connector, which we recommend. For more information about the difference between the two extractors, see: Oracle Fusion Cloud.

Prerequisites for connecting to Oracle Fusion Cloud REST

Before connecting your Oracle Fusion Cloud instance to the Celonis Platform, you must meet the following prerequisite:

  • Oracle Fusion Cloud user permissions: To extract data from your Oracle Fusion Cloud instance, you need access to a user with the following permissions and sub-roles:

    • 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

    • Subroles: Procurement REST Service, Payables Invoice Inquiry.

    • In addition: 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.

  • Allowlist Celonis Platform IPs and domains: If your Oracle Fusion Cloud instance 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 IPs of the Celonis Platform are different depending on the cluster (eu-1 or us-1).

    For more information, see: Allowlisting domain names and IP addresses

Creating a data connection between Oracle Fusion Cloud and Celonis Platform

With access to the necessary Oracle Fusion Cloud user permissions, you can create a connection between your Oracle Fusion Cloud instance and the Celonis Platform from your data pool diagram:

  1. Click Data Connections.

    data_connections_within_data_pool_diagram.png
  2. Click Add Data Connection and select Connect to Data Source.

  3. Select Cloud - Oracle Fusion.

  4. Configure the following connection details:

    • Name: An internal reference for this data connection.

    • Host: The REST server to contact for your identity domain or Cloud account. This information can be found by accessing your My Services dashboard for your identity domain or Cloud account. Locate the REST Endpoint field, which shows the URL to the REST server, for example: https://sales.oraclecloud.com/.

    • Username / Password: The username and password for the user who holds the permissions outlined in the prerequisites.

    • Instance version: Select the instance version that your Oracle Fusion Cloud instance is currently running. This can be found by clicking your profile and then About Application.

  5. Click Test Connection and correct any issues highlighted.

  6. Click Save.

    The connection between your Oracle Fusion Cloud instance and the Celonis Platform is establised. You can manage this connection at any time by clicking options:

The Oracle Fusion Cloud REST extractor supports the following procurement and finance endpoints:

Procument

Method

Endpoint

Table

GET

Get All PurchaseOrderLines

PURCHASEORDER_LINES

GET

Get All PurchaseOrderLinesScheduleDistributions

PURCHASEORDER_LINE_SCHEDULE_DISTRIBUTIONS

GET

Get All PurchaseOrderLinesSchedules

PURCHASEORDER_LINE_SCHEDULES

GET

Get All PurchaseOrders

PURCHASEORDERS

GET

Get All PurchaseRequisitionLines

PURCHASEREQUISITION_LINES

GET

Get All PurchaseRequisitions

PURCHASEREQUISITIONS

GET

Get All PurchasingNewsItems

PURCHASINGNEWS

GET

Get All RecentRequisitions

RECENTREQUISITIONS

GET

Get All RequisitionproductDetailsPriceBreaks

REQUISITIONPRODUCTDETAILS_PRICESBREAKS

GET

Get All RequsitionProductDetails

REQUISITIONPRODUCTDETAILS

GET

Get All ShoppingSearchItems

SHOPPINGSEARCHES

GET

Get All ShoppingSearchItemsBrandFilters

SHOPPINGSEARCHES_BRANDFILTERS

GET

Get All ShoppingSearchItemsPunchoutCatalogs

SHOPPINGSEARCHES_RESULTPUNCHOUTCATALOGS

GET

Get All ShoppingSearchItemsResultItems

SHOPPINGSEARCHES_RESULTITEMS

GET

Get All Suppliers

SUPPLIERS

GET

Get All SuppliersAddresses

SUPPLIER_ADDRESSES

GET

Get All SuppliersAttachments

SUPPLIER_ATTACHMENTS

GET

Get All SuppliersBusinessClassifications

SUPPLIER_BUSINESSCLASSIFICATIONS

GET

Get All SuppliersContacts

SUPPLIERS_CONTACTS

GET

Get All SupplierSites

SUPPLIER_SITES

GET

Get All SuppliersProductsAndServices

SUPPLIER_PRODUCTSANDSERVICES

Finance

Method

Endpoint

Table

GET

Get All StandardReceipts

STANDARDRECEIPTS

GET

Get All StandardReceiptAttachments

STANDARDRECEIPTS_ATTACHMENTS

GET

Get All StandardReceiptsRemmittedReferences

STANDARDRECEIPTS_REMIITANCEREFERENCES

GET

Get All ReceiptMethodAssignments

RECEIPTMETHODASSIGNMENTS

GET

Get All Invoices

INVOICES

GET

Get All Invoice Attachments

INVOICE_ATTACHMENTS

GET

Get All Invoice Installments

INVOICE_INSTALLMENTS

GET

Get All Invoice Lines

INVOICE_INVOICELINES

GET

Get All InvoiceHolds

INVOICEHOLDS

GET

Get All ReceivablesInvoices

RECEIVABLESINVOICES

GET

Get All ReceivablesInvoiceLines

RECEIVABLESINVOICE_RECEIVABLESINVOICELINES

GET

Get All ReceivablesInvoiceDistributions

RECEIVABLESINVOICE_RECEIVABLESINVOICEDISTRIBUTIONS

GET

Get All ReceivablesCreditMemos

RECEIVABLESCREDITMEMOS

GET

Get All ReceivablesAdjustments

RECEIVABLESADJUSTMENTS

GET

Get All ReceivablesCustomerAccountActivities

RECEIVABLESCUSTOMERACCOUNTACTIVITIES

GET

Get All ReceivablesCustomerAccountSiteActivities

RECEIVABLESCUSTOMERACCOUNTSITEACTIVITIES

GET

Get All ReceivablesCustomerAccountSiteActivityStandardReceiptApplications

RECEIVABLESCUSTOMERACCOUNTSITEACTIVITIE_STANDARDRECEIPTAPPLICATIONS

GET

Get All ReceivabblesDisputes

RECEIVABLESDISPUTES

GET

Get All CollectionPromises

COLLECTIONPROMISES

GET

Get All TransactionSources

TRANSACTIONSOURCESLOV

GET

Get All TransactionTypes

TRANSACTIONTYPESLOV

GET

Get All SalesPersonReferenceAccounts

SALESPERSONREFERENCEACCOUNTS

GET

Get All AccountCombinations

ACCOUNTCOMBINATIONSLOV

GET

Get All Payments

PAYABLEPAYMENTS

GET

Get All Payments Related Invoices

PAYABLEPAYMENTS_RELATEDINVOICES

GET

Get All PaymentTermsLOV

PAYMENTTERMSLOV

GET

Get All JournalBatches

JOURNALBATCHES

GET

Get All JournalHeaders

JOURNALBATCHESHEADERS

GET

Get All JournalLines

JOURNALBATCHES_JOURNALHEADER_JOURNALLINES

GET

Get All JournalErrors

JOURNALBATCHES_JOURNALERRORS

GET

Get All JournalCategories

JOURNALCATEGORIESLOV

GET

Get All AccountingPeriods

ACCOUNTINGPERIODSLOV

GET

Get All Ledgers

LEDGERSLOV

GET

Get All Descriptive flexfield segments for expenses and expense reports

EXPENSEDFFSEGMENTS

GET

Get All JournalSources

JOURNALSOURCESLOV

GET

Get All ExpenseDFFSegments

EXPENSEDFFSEGMENTS

GET

Get All CurrencyRates

CURRENCYRATES

GET

Get All Legal Entities

LEGALENTITIESLOV