Data Applications → Incorta Data Delivery of Oracle EBS for Data Destinations

About Incorta Data Delivery of Oracle EBS

Incorta Data Delivery streamlines the integration between Oracle E-Business Suite (EBS) and Data Destinations. Incorta Data Delivery accelerates data mart deployment, and automates data model design and source schema mapping with the Incorta Oracle EBS data application. The Incorta Oracle EBS data application provides a new, faster, more effective option for analyzing and understanding your data, with no data modeling or extract, transform, load (ETL) required.

Following is the high-level Incorta Data Delivery process:

Connect Incorta to your data source with a data application, and load pre-existing physical schema fact and dimension tables.
The physical schema tables are materialized into parquet.
Load the Data Destination using the previously materialized parquet.

Configure Incorta Data Delivery

To configure Incorta Data Delivery, the following steps are required:

Configure the Oracle EBS data application
Create a Data Destination
Set a Data Destination for a Physical Schema
Create Materialized Views to Trigger Data Ingest

Install and Configure the Oracle EBS Data Application

Incorta Data Delivery is pre-configured with sample Oracle EBS data, which will allow you to preview the Oracle EBS integration with your Data Destionation before you connect to and configure the data application for your Oracle EBS instance. If you would like to use your own Oracle EBS data, follow the steps in the Configure the Oracle EBS data application section of Data applications → Install and Configure Oracle EBS for Incorta Cloud.

External Data Sources

Here are the predefined External Data Sources:

External Data Source	Type	Description
EBS	oracle	This external data source connects to your Oracle EBS database. Refer to Configure the Oracle EBS data application for details on how to update the properties for your instance.
Incorta	mysql	This external data source is for the Incorta metadata.
Postgres	postgres	This external data source is for Incorta over Incorta.
SparkSql	postgres	This external data source is for materialized views.

Important

Do not delete the External Data Sources, as they are required.

Data Files

Here are the pre-defined Local Data Files used in the COMMON physical schemas:

Date_US.csv
Month_US.csv
Period.csv
Quarter.csv

Important

Do not delete the Local Data Files, as they are required.

Global Variables

Here are the pre-defined global variables:

Global Variable	Description
flex_value_set_id	This global variable is used in the Account_Hierarchy and CostCenter_Hierarchy tables in the EBS_FIN_COMMON physical schema. Refer to Configure the Oracle EBS data application for details on how to update the value of this global variable for your Oracle EBS instance.
Default_InitialExtractDate	Optionally use this global variable to limit rows for large transaction tables during a full load. For example: `last_update_date > $$Default_InitialExtractDate` Refer to Configure the Oracle EBS data application for more details.

Security Groups

Here are the pre-defined security groups:

Security Group	Description
Super User	This is the Administrator. You can change this password using the Profile Manager.

Create a Data Destination

To create a data destionation, please refer to this page for the most up-to-date list of destinations and their configuration instructions.

For more information on how to manage Data Destinations, refer to Tools → Data Manager.

Set a Data Destination for the Fact and Dimension physical schemas

Configure and set a Data Destination for each Fact and Dimension table listed for the applicable module(s).

Business Process	Module	Fact and Dimension Physical Schemas
Procure To Pay	Account Payables (AP) Procurement (PO)	EBS_COMMON_DIM_ALL EBS_AP_FACTS_ALL EBS_PO_FACTS_ALL
Order to Cash	Account Receivables (AR) Order Management (OM)	EBS_COMMON_DIM_ALL EBS_AR_FACTS_ALL EBS_OM_FACTS_ALL
General Ledger	General Ledger (GL)	EBS_COMMON_DIM_ALL EBS_GL_FACTS_ALL
Projects (PPM)	Projects (PPM)	EBS_COMMON_DIM_ALL EBS_PRJ_FACTS_ALL
HCM Core	HCM Core	EBS_COMMON_DIM_ALL EBS_HCM_FACTS_ALL
Fixed Assets	Fixed Assets	EBS_COMMON_DIM_ALL EBS_FA_FACTS_ALL

Load the physical schemas

Prerequisite

Before loading the Oracle EBS Fact and Dimension schemas, load the Oracle EBS base schemas as outlined in Data applications → Install and Configure Oracle EBS → Perform a Full Load of the Physical Schemas.

Here are the steps to perform a full load for each physical schema:

In the Navigation bar, select Schema.
In the Schema Manager, select the Schemas tab.
In the list view of physical schemas, select the base schema to open it.
In the Schema Designer, in the Action bar, select Load → Full Load.

Load the Base physical schemas

Business Process	Module
Procure To Pay	Account Payables (AP) Procurement (PO)
Order Management	Account Receivables (AR) Order Management (OM)
General Ledger	General Ledger (GL)
Projects (PPM)	Projects (PPM)
HCM Core	HCM Core
Fixed Assets	Fixed Assets

Load the Fact and Dimension physical schemas

Perform a load of the Fact and Dimension physical schemas for each Oracle Cloud ERP module:

Business Process	Module
Procure To Pay	Account Payables (AP) Procurement (PO)
Order to Cash	Account Receivables (AR) Order Management (OM)
General Ledger	General Ledger (GL)
Projects (PPM)	Projects (PPM)
HCM Core	HCM Core
Fixed Assets	Fixed Assets