Skip to main content

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

This section details important prerequisites or prerequisite knowledge for using this extractor.

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.

If your Oracle Fusion Cloud applications are 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 Celonis domain names, IP addresses, and third-party domains.

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

    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

    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

    Configuring the Oracle Fusion Cloud REST extractor

    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:

    1. From your data pool diagram, Select Data Connections.

      A screenshot showing how to access the data connections screen from a data pool diagram.
    2. Select Add Data Connection, and then 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 selecting your profile and then About Application.

    5. Select Test Connection and correct any issues highlighted.

    6. Select Save.

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