Skip to main content

Celonis Product Documentation

Oracle EBS Connection
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 EMS.

There are two scenarios:

  • If the user wants to allow the EMS to access their database directly: a JDBC connection from the EMS to the database is set up selecting the EMS as source system (EMS 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 EMS 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 EMS as target system (EMS IPs varies depending on cloud cluster), port 443 and TCP protocol.

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

Related Content

Help-Articles: How do I set up a connection?

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

30999651.png
Set up Data Connection

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

Table 2. 

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.

Database name

Name of the database within the database server.

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

<listitem>

AP.AP_CHECKS_AL

</listitem>
<listitem>

AP.AP_HOLDS_ALL

</listitem>
<listitem>

AP.AP_HOLD_CODES

</listitem>
<listitem>

AP.AP_INVOICES_ALL

</listitem>
<listitem>

AP.AP_INVOICE_DISTRIBUTIONS_ALL

</listitem>
<listitem>

AP.AP_INVOICE_LINES_ALL

</listitem>
<listitem>

AP.AP_INVOICE_PAYMENTS_ALL

</listitem>
<listitem>

AP.AP_INV_APPRVL_HIST_ALL

</listitem>
<listitem>

AP.AP_PAYMENT_SCHEDULES_ALL

</listitem>
<listitem>

AP.AP_SUPPLIERS

</listitem>
<listitem>

AP.AP_SUPPLIER_SITES_ALL

</listitem>
<listitem>

AP.AP_TERMS_TL

</listitem>
<listitem>

CE.CE_STATEMENT_HEADERS

</listitem>
<listitem>

CE.CE_STATEMENT_LINES

</listitem>
<listitem>

CE.CE_STATEMENT_RECONCILS_ALL

</listitem>
<listitem>

AP.FINANCIALS_SYSTEM_PARAMS_ALL

</listitem>
<listitem>

APPLSYS.FND_FLEX_VALUES

</listitem>
<listitem>

APPLSYS.FND_FLEX_VALUES_TL

</listitem>
<listitem>

APPLSYS.FND_ID_FLEX_SEGMENTS

</listitem>
<listitem>

APPLSYS.FND_ID_FLEX_STRUCTURES

</listitem>
<listitem>

APPLSYS.FND_LOOKUP_VALUES

</listitem>
<listitem>

APPLSYS.FND_SEGMENT_ATTRIBUTE_VALUES

</listitem>
<listitem>

APPLSYS.FND_USER

</listitem>
<listitem>

GL.GL_CODE_COMBINATIONS

</listitem>
<listitem>

GL.GL_DAILY_RATES

</listitem>
<listitem>

GL.GL_LEDGERS

</listitem>
<listitem>

HR.HR_ALL_ORGANIZATION_UNITS

</listitem>
<listitem>

HR.HR_ORGANIZATION_INFORMATION

</listitem>
<listitem>

IBY.IBY_EXT_BANK_ACCOUNTS

</listitem>
<listitem>

INV.MPL_PARAMETERS

</listitem>
<listitem>

HR.PER_ALL_ASSIGNMENTS_F

</listitem>
<listitem>

HR.PER_ALL_PEOPLE_F

</listitem>
<listitem>

HR.PER_ASSIGNMENT_STATUS_TYPES

</listitem>
<listitem>

PO.PO_AGENTS

</listitem>
<listitem>

PO.PO_DISTRIBUTIONS_ALL

</listitem>
<listitem>

PO.PO_DISTRIBUTIONS_ARCHIVE_ALL

</listitem>
<listitem>

PO.PO_HEADERS_ALL

</listitem>
<listitem>

PO.PO_LINES_ALL

</listitem>
<listitem>

PO.PO_LINE_LOCATIONS_ALL

</listitem>
<listitem>

PO.PO_LINE_TYPES_TL

</listitem>
<listitem>

PO.PO_RELEASES_ALL

</listitem>
<listitem>

PO.PO_REQUISITION_LINES_ALL

</listitem>
<listitem>

PO.PO_REQ_DISTRIBUTIONS_ALL

</listitem>
<listitem>

PO.PO_REQUISITION_LINES_ALL

</listitem>
<listitem>

XLA.XLA_EVENTS

</listitem>
<listitem>

XLA.XLA_TRANSACTION_ENTITIES

</listitem>

Accounts Receivable

<listitem>

AR.AP_SUPPLIERS

</listitem>
<listitem>

AR.AR_ADJUSTMENTS_ALL

</listitem>
<listitem>

AR.AR_BATCHES_ALL

</listitem>
<listitem>

AR.AR_CASH_RECEIPTS_ALL

</listitem>
<listitem>

AR.AR_CASH_RECEIPT_HISTORY_ALL

</listitem>
<listitem>

AR.AR_DISPUTE_HISTORY

</listitem>
<listitem>

AR.AR_PAYMENT_SCHEDULES_ALL

</listitem>
<listitem>

AR.AR_RECEIPT_CLASSES

</listitem>
<listitem>

AR.AR_RECEIPT_METHODS

</listitem>
<listitem>

AR.AR_RECEIVABLE_APPLICATIONS_ALL

</listitem>
<listitem>

CE.CE_STATEMENT_HEADERS

</listitem>
<listitem>

CE.CE_STATEMENT_LINES

</listitem>
<listitem>

CE.CE_STATEMENT_RECONCILS_ALL

</listitem>
<listitem>

APPLSYS.FND_FLEX_VALUES

</listitem>
<listitem>

APPLSYS.FND_FLEX_VALUES_TL

</listitem>
<listitem>

APPLSYS.FND_ID_FLEX_SEGMENTS

</listitem>
<listitem>

APPLSYS.FND_ID_FLEX_STRUCTURES

</listitem>
<listitem>

APPLSYS.FND_LOOKUP_VALUES

</listitem>
<listitem>

APPLSYS.FND_SEGMENT_ATTRIBUTE_VALUES

</listitem>
<listitem>

APPLSYS.FND_USER

</listitem>
<listitem>

GL.GL_CODE_COMBINATIONS

</listitem>
<listitem>

GL.GL_DAILY_RATES

</listitem>
<listitem>

GL.GL_LEDGERS

</listitem>
<listitem>

HR.HR_ALL_ORGANIZATION_UNITS

</listitem>
<listitem>

HR.HR_LOCATIONS_ALL

</listitem>
<listitem>

HR.HR_ORGANIZATION_INFORMATION

</listitem>
<listitem>

AR.HZ_CUST_ACCT_SITES_ALL

</listitem>
<listitem>

AR.HZ_CUST_SITE_USES_ALL

</listitem>
<listitem>

AR.HZ_LOCATIONS

</listitem>
<listitem>

AR.HZ_PARTIES

</listitem>
<listitem>

AR.HZ_PARTY_SITES

</listitem>
<listitem>

IEX.IEX_DELINQUENCIES_ALL

</listitem>
<listitem>

IEX.IEX_STRATEGIES

</listitem>
<listitem>

IEX.IEX_STRATEGY_WORK_ITEMS

</listitem>
<listitem>

IEX.IEX_STRY_TEMP_WORK_ITEMS_B

</listitem>
<listitem>

IEX.IEX_STRY_TEMP_WORK_ITEMS_TL

</listitem>
<listitem>

INV.MTL_MATERIAL_TRANSACTIONS

</listitem>
<listitem>

ONT.OE_ORDER_LINES_ALL

</listitem>
<listitem>

AR.RA_BATCH_SOURCES_ALL

</listitem>
<listitem>

AR.RA_CUSTOMER_TRX_ALL

</listitem>
<listitem>

AR.RA_CUSTOMER_TRX_LINES_ALL

</listitem>
<listitem>

AR.RA_CUST_TRX_LINE_GL_DIST_ALL

</listitem>
<listitem>

AR.RA_CUST_TRX_TYPES_ALL

</listitem>
<listitem>

AR.RA_TERMS_B

</listitem>
<listitem>

AR.RA_TERMS_LINES

</listitem>
<listitem>

AR.RA_TERMS_LINES_DISCOUNTS

</listitem>
<listitem>

AR.RA_TERMS_TL

</listitem>

Order-to-Cash

<listitem>

AR.AR_ADJUSTMENTS_ALL

</listitem>
<listitem>

AR.AR_CASH_RECEIPTS_ALL

</listitem>
<listitem>

AR.AR_CASH_RECEIPTS_HISTORY_ALL

</listitem>
<listitem>

AR.AR_LOCKBOXES_ALL

</listitem>
<listitem>

AR.AR_PAYMENT_SCHEDULES_ALL

</listitem>
<listitem>

AR.AR_RECEIPT_CLASSES

</listitem>
<listitem>

AR.AR_RECEIPT_METHODS

</listitem>
<listitem>

AR.AR_RECEIVABLE_APPLICATIONS_ALL

</listitem>
<listitem>

CE.CE_STATEMENT_LINES

</listitem>
<listitem>

CE.CE_STATEMENT_RECONCILS_ALL

</listitem>
<listitem>

APPLSYS.FND_LOOKUP_VALUES

</listitem>
<listitem>

APPLSYS.FND_USER

</listitem>
<listitem>

GL.GL_DAILY_RATES

</listitem>
<listitem>

GL.GL_LEDGERS

</listitem>
<listitem>

HR.HR_ALL_ORGANIZATION_UNITS

</listitem>
<listitem>

HR.HR_ORGANIZATION_INFORMATION

</listitem>
<listitem>

AR.HZ_CUST_ACCOUNTS

</listitem>
<listitem>

AR.HZ_CUST_ACCT_SITES_ALL

</listitem>
<listitem>

AR.HZ_CUST_SITES_USES_ALL

</listitem>
<listitem>

AR.HZ_LOCATIONS

</listitem>
<listitem>

AR.HZ_PARTIES

</listitem>
<listitem>

AR.HZ_PARTY_SITES

</listitem>
<listitem>

JTF.JTF_RS_SALESREPS

</listitem>
<listitem>

INV.MTL_CATEGORIES_B

</listitem>
<listitem>

INV.MTL_CATEGORIES_TL

</listitem>
<listitem>

INV.MTL_DEFAULT_CATEGORY_SETS

</listitem>
<listitem>

INV.MTL_ITEM_CATEGORIES

</listitem>
<listitem>

INV.MTL_MATERIAL_TRANSACTIONS

</listitem>
<listitem>

INV.MTL_PARAMETERS

</listitem>
<listitem>

INV.MTL_SYSTEM_ITEMS_B

</listitem>
<listitem>

INV.MTL_TXN_REQUEST_LINES

</listitem>
<listitem>

ON.TOE_HOLD_DEFINITIONS

</listitem>
<listitem>

ON.TOE_HOLD_RELEASES

</listitem>
<listitem>

ON.TOE_HOLD_SOURCES_ALL

</listitem>
<listitem>

ON.TOE_ORDER_HEADERS_ALL

</listitem>
<listitem>

ON.TOE_ORDER_HOLDS_ALL

</listitem>
<listitem>

ON.TOE_ORDER_LINES_ALL

</listitem>
<listitem>

ON.TOE_ORDER_LINES_HISTORY

</listitem>
<listitem>

ON.TOE_ORDER_SOURCES

</listitem>
<listitem>

ON.TOE_PRICE_ADJUSTMENTS

</listitem>
<listitem>

ON.TOE_TRANSACTION_TYPES_TL

</listitem>
<listitem>

QP.QP_LIST_HEADERS_B

</listitem>
<listitem>

QP.QP_LIST_HEADERS_TL

</listitem>
<listitem>

AR.RA_BATCH_SOURCES_ALL

</listitem>
<listitem>

AR.RA_CUSTOMER_TRX_ALL

</listitem>
<listitem>

AR.RA_CUSTOMER_TRX_LINES_ALL

</listitem>
<listitem>

AR.RA_CUST_TRX_TYPES_ALL

</listitem>
<listitem>

AR.RA_RULES

</listitem>
<listitem>

AR.RA_TERMS_TL

</listitem>
<listitem>

WSH.WSH_DELIVERY_ASSIGNMENTS

</listitem>
<listitem>

WSH.WSH_DELIVERY_DETAILS

</listitem>
<listitem>

WSH.WSH_EXCEPTIONS

</listitem>

Purchase-to-Pay

<listitem>

HR.AME_APPROVAL_GROUPS

</listitem>
<listitem>

AP.AP_CHECKS_ALL

</listitem>
<listitem>

AP.AP_HOLDS_ALL

</listitem>
<listitem>

AP.AP_HOLD_CODES

</listitem>
<listitem>

AP.AP_INVOICES_ALL

</listitem>
<listitem>

AP.AP_INVOICE_DISTRIBUTIONS_ALL

</listitem>
<listitem>

AP.AP_INV_APPRVL_HIST_ALL

</listitem>
<listitem>

AP.AP_SUPPLIERS

</listitem>
<listitem>

AP.AP_SUPPLIER_SITES_ALL

</listitem>
<listitem>

AP.FINANCIALS_SYSTEM_PARAMS_ALL

</listitem>
<listitem>

APPLSYS.FND_FLEX_VALUES

</listitem>
<listitem>

APPLSYS.FND_FLEX_VALUES_TL

</listitem>
<listitem>

APPLSYS.FND_ID_FLEX_SEGMENTS

</listitem>
<listitem>

APPLSYS.FND_ID_FLEX_STRUCTURES

</listitem>
<listitem>

APPS.FND_LOOKUPS

</listitem>
<listitem>

APPLSYS.FND_LOOKUP_VALUES

</listitem>
<listitem>

APPLSYS.FND_NEW_MESSAGES

</listitem>
<listitem>

APPLSYS.FND_SEGMENT_ATTRIBUTE_VALUES

</listitem>
<listitem>

APPLSYS.FND_USER

</listitem>
<listitem>

GL.GL_CODE_COMBINATIONS

</listitem>
<listitem>

GL.GL_LEDGERS

</listitem>
<listitem>

HR.HR_ALL_ORGANIZATION_UNITS

</listitem>
<listitem>

HR.HR_LOCATIONS_ALL

</listitem>
<listitem>

INVT.MTL_CATEGORIES_B

</listitem>
<listitem>

INVT.MTL_CATEGORIES_TL

</listitem>
<listitem>

INVT.MTL_PARAMETERS

</listitem>
<listitem>

INVT.MTL_SYSTEM_ITEMS_B

</listitem>
<listitem>

INVT.MTL_TRANSACTION_REASONS

</listitem>
<listitem>

PA.PA_PROJECTS_ALL

</listitem>
<listitem>

PA.PA_TASKS

</listitem>
<listitem>

HR.PER_ALL_ASSIGNMENTS_F

</listitem>
<listitem>

HR.PER_ALL_PEOPLE_F

</listitem>
<listitem>

HR.PER_ASSIGNMENT_STATUS_TYPES

</listitem>
<listitem>

ICX.POR_NONCAT_TEMPLATES_ALL_TL

</listitem>
<listitem>

PO.PO_ACCEPTANCES

</listitem>
<listitem>

PO.PO_ACTION_HISTORY

</listitem>
<listitem>

PO.PO_AGENTS

</listitem>
<listitem>

PO.PO_DISTRIBUTIONS_ALL

</listitem>
<listitem>

PO.PO_DISTRIBUTIONS_ARCHIVE_ALL

</listitem>
<listitem>

PO.PO_HEADERS_ALL

</listitem>
<listitem>

PO.PO_HEADERS_ARCHIVE_ALL

</listitem>
<listitem>

PO.PO_LINES_ALL

</listitem>
<listitem>

PO.PO_LINES_ARCHIVE_ALL

</listitem>
<listitem>

PO.PO_LINE_LOCATIONS_ALL

</listitem>
<listitem>

PO.PO_LINE_TYPES_B

</listitem>
<listitem>

PO.PO_LINE_TYPES_TL

</listitem>
<listitem>

PO.PO_RELEASES_ALL

</listitem>
<listitem>

PO.PO_REQUISITION_HEADERS_ALL

</listitem>
<listitem>

PO.PO_REQUISITION_LINES_ALL

</listitem>
<listitem>

PO.PO_REQ_DISTRIBUTIONS_ALL

</listitem>
<listitem>

PO.RCV_SHIPMENT_HEADERS

</listitem>
<listitem>

PO.RCV_TRANSACTIONS

</listitem>