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:
Click Data Connections.
Click Add Data Connection and select Connect to Data Source.
Select Cloud - Oracle Fusion.
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.
Click Test Connection and correct any issues highlighted.
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 |