Skip to main content

Celonis Product Documentation

Oracle EBS Connection

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.

Connect to Oracle EBS
Modify network settings

A regular JDBC connection is used to connect with Oracle EBS. Specific network setting modifications are required to allow the extractor to communicate with the database and the Celonis Platform.

There are two scenarios:

  • If the user wants to allow the Celonis Platform to access their database directly: a JDBC connection from the Celonis Platform to the database is set up selecting the Celonis Platform as source system (Celonis Platform IP varies depending on cloud cluster), the on prem source system as target system, the port that is usually used to connect to the database and TCP protocol.

  • If the user does not want to or cannot allow the Celonis Platform to access their database directly and wants to use an on premise extractor instead: first, a JDBC connection from the on prem extractor to the database is set up selecting the on prem extractor server as source system, the on prem source system as target system, the port that is usually used to connect to the database and TCP protocol. Second, a HTTPS connection from the on premise extractor server to the Celonis cloud endpoint is set up selecting the on prem extractor server as source system, the Celonis Platform as target system (Celonis Platform IPs varies depending on cloud cluster), port 443 and TCP protocol.

Only if a database is not reachable from the Celonis Platform, an extractor server has to be set up on premise in the customer network.

Configure user permissions

To extract data from a database, an existing user needs to be used or a new one created who has read access to all tables which should be extracted. The user should also have access to information_schema to read meta data for the tables to be extracted.

30999651b.png
Set up data connection

Parameters As you can see in the picture the required parameters to configure the Oracle EBS connection are:

Name

Description

Name

Enter a name for your connection.

Connection type

Choose between Direct or Uplinked. Direct for extracting data from cloud platforms and Uplinked for local systems that run within your organization (on-premises). In this case only Uplinked is applicable and selected by default.

Configuration type

Choose between Standard and custom JDBC String.

Host

Select the host of the databse server.

Port

Port to connect to database server.

Service name

Name of the JDBC service at Oracle.

Maximum Parallel Table Extractions

Choose how many tables should be extracted in parallel.

Additional Properties (Optional)

Additional properties such as validateCertificate=false for a HANA database or integratedSecurity=true for domain users in MSSQL.

Username

User name to connect to the database server.

Password

User password.

Extraction Tables: Accounts Payable

  • AP.AP_CHECKS_AL

  • AP.AP_HOLDS_ALL

  • AP.AP_HOLD_CODES

  • AP.AP_INVOICES_ALL

  • AP.AP_INVOICE_DISTRIBUTIONS_ALL

  • AP.AP_INVOICE_LINES_ALL

  • AP.AP_INVOICE_PAYMENTS_ALL

  • AP.AP_INV_APPRVL_HIST_ALL

  • AP.AP_PAYMENT_SCHEDULES_ALL

  • AP.AP_SUPPLIERS

  • AP.AP_SUPPLIER_SITES_ALL

  • AP.AP_TERMS_TL

  • CE.CE_STATEMENT_HEADERS

  • CE.CE_STATEMENT_LINES

  • CE.CE_STATEMENT_RECONCILS_ALL

  • AP.FINANCIALS_SYSTEM_PARAMS_ALL

  • APPLSYS.FND_FLEX_VALUES

  • APPLSYS.FND_FLEX_VALUES_TL

  • APPLSYS.FND_ID_FLEX_SEGMENTS

  • APPLSYS.FND_ID_FLEX_STRUCTURES

  • APPLSYS.FND_LOOKUP_VALUES

  • APPLSYS.FND_SEGMENT_ATTRIBUTE_VALUES

  • APPLSYS.FND_USER

  • GL.GL_CODE_COMBINATIONS

  • GL.GL_DAILY_RATES

  • GL.GL_LEDGERS

  • HR.HR_ALL_ORGANIZATION_UNITS

  • HR.HR_ORGANIZATION_INFORMATION

  • IBY.IBY_EXT_BANK_ACCOUNTS

  • INV.MPL_PARAMETERS

  • HR.PER_ALL_ASSIGNMENTS_F

  • HR.PER_ALL_PEOPLE_F

  • HR.PER_ASSIGNMENT_STATUS_TYPES

  • PO.PO_AGENTS

  • PO.PO_DISTRIBUTIONS_ALL

  • PO.PO_DISTRIBUTIONS_ARCHIVE_ALL

  • PO.PO_HEADERS_ALL

  • PO.PO_LINES_ALL

  • PO.PO_LINE_LOCATIONS_ALL

  • PO.PO_LINE_TYPES_TL

  • PO.PO_RELEASES_ALL

  • PO.PO_REQUISITION_LINES_ALL

  • PO.PO_REQ_DISTRIBUTIONS_ALL

  • PO.PO_REQUISITION_LINES_ALL

  • XLA.XLA_EVENTS

  • XLA.XLA_TRANSACTION_ENTITIES

Accounts Receivable

  • AR.AP_SUPPLIERS

  • AR.AR_ADJUSTMENTS_ALL

  • AR.AR_BATCHES_ALL

  • AR.AR_CASH_RECEIPTS_ALL

  • AR.AR_CASH_RECEIPT_HISTORY_ALL

  • AR.AR_DISPUTE_HISTORY

  • AR.AR_PAYMENT_SCHEDULES_ALL

  • AR.AR_RECEIPT_CLASSES

  • AR.AR_RECEIPT_METHODS

  • AR.AR_RECEIVABLE_APPLICATIONS_ALL

  • CE.CE_STATEMENT_HEADERS

  • CE.CE_STATEMENT_LINES

  • CE.CE_STATEMENT_RECONCILS_ALL

  • APPLSYS.FND_FLEX_VALUES

  • APPLSYS.FND_FLEX_VALUES_TL

  • APPLSYS.FND_ID_FLEX_SEGMENTS

  • APPLSYS.FND_ID_FLEX_STRUCTURES

  • APPLSYS.FND_LOOKUP_VALUES

  • APPLSYS.FND_SEGMENT_ATTRIBUTE_VALUES

  • APPLSYS.FND_USER

  • GL.GL_CODE_COMBINATIONS

  • GL.GL_DAILY_RATES

  • GL.GL_LEDGERS

  • HR.HR_ALL_ORGANIZATION_UNITS

  • HR.HR_LOCATIONS_ALL

  • HR.HR_ORGANIZATION_INFORMATION

  • AR.HZ_CUST_ACCT_SITES_ALL

  • AR.HZ_CUST_SITE_USES_ALL

  • AR.HZ_LOCATIONS

  • AR.HZ_PARTIES

  • AR.HZ_PARTY_SITES

  • IEX.IEX_DELINQUENCIES_ALL

  • IEX.IEX_STRATEGIES

  • IEX.IEX_STRATEGY_WORK_ITCelonis Platform

  • IEX.IEX_STRY_TEMP_WORK_ITCelonis Platform_B

  • IEX.IEX_STRY_TEMP_WORK_ITCelonis Platform_TL

  • INV.MTL_MATERIAL_TRANSACTIONS

  • ONT.OE_ORDER_LINES_ALL

  • AR.RA_BATCH_SOURCES_ALL

  • AR.RA_CUSTOMER_TRX_ALL

  • AR.RA_CUSTOMER_TRX_LINES_ALL

  • AR.RA_CUST_TRX_LINE_GL_DIST_ALL

  • AR.RA_CUST_TRX_TYPES_ALL

  • AR.RA_TERMS_B

  • AR.RA_TERMS_LINES

  • AR.RA_TERMS_LINES_DISCOUNTS

  • AR.RA_TERMS_TL

Order-to-Cash

  • AR.AR_ADJUSTMENTS_ALL

  • AR.AR_CASH_RECEIPTS_ALL

  • AR.AR_CASH_RECEIPTS_HISTORY_ALL

  • AR.AR_LOCKBOXES_ALL

  • AR.AR_PAYMENT_SCHEDULES_ALL

  • AR.AR_RECEIPT_CLASSES

  • AR.AR_RECEIPT_METHODS

  • AR.AR_RECEIVABLE_APPLICATIONS_ALL

  • CE.CE_STATEMENT_LINES

  • CE.CE_STATEMENT_RECONCILS_ALL

  • APPLSYS.FND_LOOKUP_VALUES

  • APPLSYS.FND_USER

  • GL.GL_DAILY_RATES

  • GL.GL_LEDGERS

  • HR.HR_ALL_ORGANIZATION_UNITS

  • HR.HR_ORGANIZATION_INFORMATION

  • AR.HZ_CUST_ACCOUNTS

  • AR.HZ_CUST_ACCT_SITES_ALL

  • AR.HZ_CUST_SITES_USES_ALL

  • AR.HZ_LOCATIONS

  • AR.HZ_PARTIES

  • AR.HZ_PARTY_SITES

  • JTF.JTF_RS_SALESREPS

  • INV.MTL_CATEGORIES_B

  • INV.MTL_CATEGORIES_TL

  • INV.MTL_DEFAULT_CATEGORY_SETS

  • INV.MTL_ITEM_CATEGORIES

  • INV.MTL_MATERIAL_TRANSACTIONS

  • INV.MTL_PARAMETERS

  • INV.MTL_SYSTEM_ITCelonis Platform_B

  • INV.MTL_TXN_REQUEST_LINES

  • ON.TOE_HOLD_DEFINITIONS

  • ON.TOE_HOLD_RELEASES

  • ON.TOE_HOLD_SOURCES_ALL

  • ON.TOE_ORDER_HEADERS_ALL

  • ON.TOE_ORDER_HOLDS_ALL

  • ON.TOE_ORDER_LINES_ALL

  • ON.TOE_ORDER_LINES_HISTORY

  • ON.TOE_ORDER_SOURCES

  • ON.TOE_PRICE_ADJUSTMENTS

  • ON.TOE_TRANSACTION_TYPES_TL

  • QP.QP_LIST_HEADERS_B

  • QP.QP_LIST_HEADERS_TL

  • AR.RA_BATCH_SOURCES_ALL

  • AR.RA_CUSTOMER_TRX_ALL

  • AR.RA_CUSTOMER_TRX_LINES_ALL

  • AR.RA_CUST_TRX_TYPES_ALL

  • AR.RA_RULES

  • AR.RA_TERMS_TL

  • WSH.WSH_DELIVERY_ASSIGNMENTS

  • WSH.WSH_DELIVERY_DETAILS

  • WSH.WSH_EXCEPTIONS

Purchase-to-Pay

  • HR.AME_APPROVAL_GROUPS

  • AP.AP_CHECKS_ALL

  • AP.AP_HOLDS_ALL

  • AP.AP_HOLD_CODES

  • AP.AP_INVOICES_ALL

  • AP.AP_INVOICE_DISTRIBUTIONS_ALL

  • AP.AP_INV_APPRVL_HIST_ALL

  • AP.AP_SUPPLIERS

  • AP.AP_SUPPLIER_SITES_ALL

  • AP.FINANCIALS_SYSTEM_PARAMS_ALL

  • APPLSYS.FND_FLEX_VALUES

  • APPLSYS.FND_FLEX_VALUES_TL

  • APPLSYS.FND_ID_FLEX_SEGMENTS

  • APPLSYS.FND_ID_FLEX_STRUCTURES

  • APPS.FND_LOOKUPS

  • APPLSYS.FND_LOOKUP_VALUES

  • APPLSYS.FND_NEW_MESSAGES

  • APPLSYS.FND_SEGMENT_ATTRIBUTE_VALUES

  • APPLSYS.FND_USER

  • GL.GL_CODE_COMBINATIONS

  • GL.GL_LEDGERS

  • HR.HR_ALL_ORGANIZATION_UNITS

  • HR.HR_LOCATIONS_ALL

  • INVT.MTL_CATEGORIES_B

  • INVT.MTL_CATEGORIES_TL

  • INVT.MTL_PARAMETERS

  • INVT.MTL_SYSTEM_ITCelonis Platform_B

  • INVT.MTL_TRANSACTION_REASONS

  • PA.PA_PROJECTS_ALL

  • PA.PA_TASKS

  • HR.PER_ALL_ASSIGNMENTS_F

  • HR.PER_ALL_PEOPLE_F

  • HR.PER_ASSIGNMENT_STATUS_TYPES

  • ICX.POR_NONCAT_TEMPLATES_ALL_TL

  • PO.PO_ACCEPTANCES

  • PO.PO_ACTION_HISTORY

  • PO.PO_AGENTS

  • PO.PO_DISTRIBUTIONS_ALL

  • PO.PO_DISTRIBUTIONS_ARCHIVE_ALL

  • PO.PO_HEADERS_ALL

  • PO.PO_HEADERS_ARCHIVE_ALL

  • PO.PO_LINES_ALL

  • PO.PO_LINES_ARCHIVE_ALL

  • PO.PO_LINE_LOCATIONS_ALL

  • PO.PO_LINE_TYPES_B

  • PO.PO_LINE_TYPES_TL

  • PO.PO_RELEASES_ALL

  • PO.PO_REQUISITION_HEADERS_ALL

  • PO.PO_REQUISITION_LINES_ALL

  • PO.PO_REQ_DISTRIBUTIONS_ALL

  • PO.RCV_SHIPMENT_HEADERS

  • PO.RCV_TRANSACTIONS