1. Home
  2. Guides
  3. Concepts
  4. Tools
  5. References
  6. Integrations
  7. Data applications
    1. Cloud Data Apps
      1. Incorta Data Delivery
        1. Data Delivery for Azure Synapse
        2. Data Delivery for Google BigQuery
        3. Data Delivery for Snowflake
        4. Data Delivery of Oracle Cloud ERP
        5. Data Delivery of Oracle EBS
      2. Oracle Cloud ERP data app
      3. Oracle EBS data app
      4. Salesforce data app
      5. BlackLine
      6. XLCubed Excel plugin dashboards for SAP ECC
      7. NetSuite data app
      8. SAP S/4HANA Financials and Supply Chain data app
      9. Data app Data Wizard
    2. On-Premises Data Apps
      1. Incorta Data Delivery
        1. Data Delivery for Azure Synapse
        2. Data Delivery for Google BigQuery
        3. Data Delivery of Oracle Cloud ERP
        4. Data Delivery of Oracle EBS
      2. Oracle Enterprise Resource Planning (ERP)
      3. Install and Configure NetSuite for Incorta
      4. BlackLine data app
  8. Release Notes
  9. Incorta Premium

Data Applications → Incorta Data Delivery of Oracle Cloud ERP

About Incorta Data Delivery of Oracle Cloud ERP for Data Destinations

Incorta Data Delivery streamlines the integration between Oracle Cloud ERP and Data Destinations. Incorta Data Delivery accelerates data mart deployment and automates data model design and source schema mapping with the Incorta Oracle Cloud ERP data application. The Incorta Cloud ERP 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.

Install and configure Oracle Cloud ERP for Incorta On-Premises

Follow the steps on the Data applications → Install and Configure Oracle Cloud ERP doc to install and configure Oracle Cloud ERP.

Install and configure Oracle Cloud ERP for Incorta Cloud

  • Sign in to Incorta Analytics.
  • Select Marketplace in the navigation bar.
  • Select Applications from the submenu bar.
  • Search for and select Oracle Cloud ERP data app (BICC).
  • Select Install.

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 ProcessModuleFact and Dimension Physical Schemas
Procure To PayAdvanced Payables (AP)
Procurement (PO)		FUSION_COMMON_DIM_ALL
FUSION_AP_FACTS_ALL
FUSION_PO_FACTS_ALL
Order to CashAccount Receivables (AR)
Order Management (OM)		FUSION_COMMON_DIM_ALL
FUSION_AR_FACTS_ALL
FUSION_OM_FACTS_ALL
General LedgerGeneral Ledger (GL)FUSION_COMMON_DIM_ALL
FUSION_GL_FACTS_ALL
Projects (PPM)Projects (PPM)FUSION_COMMON_DIM_ALL
FUSION_PRJ_FACTS_ALL
HCM CoreHCM CoreFUSION_COMMON_DIM_ALL
FUSION_HCM_FACTS_ALL
GL Budgetary ControlBudgetary ControlFUSION_COMMON_DIM_ALL
FUSION_BUDGET_CONTROL_FACTS_ALL

Load the physical schemas

Prerequisite

Before loading the Oracle Cloud ERP Fact and Dimension schemas, load the Oracle Cloud ERP base schemas as outlined in Data applications → Install and Configure Oracle Cloud ERP → 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 ProcessModulePhysical Schema Load Order
Procure To PayAdvanced Payables (AP)
Procurement (PO)		Fusion_CAL_COMMON
Fusion_Item_Common
Fusion_HR_Common
Fusion_FND_Common
Fusion_FIN_Common
Fusion_PARTY_COMMON
Fusion_AP
Fusion_PO
Fusion_INV
Order to CashAccount Receivables (AR)
Order Management (OM)		Fusion_CAL_COMMON
Fusion_Item_Common
Fusion_HR_Common
Fusion_FND_Common
Fusion_FIN_Common
Fusion_PARTY_COMMON
Fusion_AR
Fusion_ONT
Fusion_AR_SNP
Fusion_AR_MV
General LedgerGeneral Ledger (GL)Fusion_CAL_COMMON
Fusion_Item_Common
Fusion_HR_Common
Fusion_FND_Common
Fusion_FIN_Common
Fusion_PARTY_COMMON
Fusion_GL
Fusion_XLA
Fusion_XLA_MV
Projects (PPM)Projects (PPM)Fusion_CAL_COMMON
Fusion_Item_Common
Fusion_HR_Common,
Fusion_FND_Common
Fusion_FIN_Common
Fusion_PARTY_COMMON
Fusion_PRJ
Fusion_GMS
HCM CoreHCM CoreFusion_CAL_COMMON
Fusion_HR_Common
Fusion_HCM
GL Budgetary ControlBudgetary ControlFusion_CAL_COMMON
Fusion_Item_Common
Fusion_HR_Common
Fusion_FND_Common
Fusion_FIN_Common
Fusion_PARTY_COMMON
Fusion_Budgetary_Control

Load the Fact and Dimension physical schemas

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

Business ProcessModuleFact and Dimension Physical Schema Load Order
Procure To PayAdvanced Payables (AP)
Procurement (PO)		FUSION_COMMON_DIM_ALL
FUSION_AP_FACTS_ALL
FUSION_PO_FACTS_ALL
Order to CashAccount Receivables (AR)
Order Management (OM)		FUSION_COMMON_DIM_ALL
FUSION_AR_FACTS_ALL
FUSION_OM_FACTS_ALL
General LedgerGeneral Ledger (GL)FUSION_COMMON_DIM_ALL
FUSION_GL_FACTS_ALL
Projects (PPM)Projects (PPM)FUSION_COMMON_DIM_ALL
FUSION_PRJ_FACTS_ALL
HCM CoreHCM CoreFUSION_COMMON_DIM_ALL
FUSION_HCM_FACTS_ALL
GL Budgetary ControlBudgetary ControlFUSION_COMMON_DIM_ALL
FUSION_BUDGET_CONTROL_FACTS_ALL

Additional Information

Here are the star schema models for each Oracle Cloud ERP Module.

Procure to Pay

Order to Cash

General Ledger

General Ledger Budgetary Control

Projects (PPM)

Billing and Revenue

Costing and Budgeting

HCM Core