Data Applications → Oracle EBS Order to Cash

About the Oracle EBS Order to Cash Data Application

The Oracle E-Business Suite (EBS) Order to Cash (O2C) business flow enables the complete process of entering an order into the system, delivery of the goods, and producing the invoice for the goods. The Incorta data application for the Order to Cash business flow provides prebuilt schemas, dashboards, and insights to help you manage cash, and accelerate the order to cash cycle.

Here are some of the questions answered by the Oracle EBS Order to Cash data application:

• What is the cash conversion cycle?
• What are the average days sales outstanding?
• What are the average days of inventory?
• What are the average days payables outstanding?
• How does each component of the order to cash cycle trend?

You can further customize and add on to the insights in the Incorta Order to Cash data application to support your specific business needs.

Installation

Cloud Installation

Follow these steps to install Oracle EBS Order to Cash for BigQuery:

1. Sign in to Incorta Analytics.
2. Select Marketplace in the navigation bar (accessible to user with SuperUser permission).
3. Select Applications from the submenu bar.
4. Search for and select Oracle E-Business Suite Order to Cash for Google Cortex data app.
5. Select Install.
6. Proceed to the below step: Configure the data source.

On-Premises Installation

Deploy the Oracle E-Business Suite Order to Cash for BigQuery data application using the following file:

Copy
InstallBQEBSVer<VERSION_NUMBER>.zip

The Oracle EBS data application requires the import of a tenant file to an Incorta Cluster. A CMC Administrator can perform the tenant import. A systems administrator with root access to the host can copy the tenant data files, configure Spark, and configure the necessary data sources.

Here are the steps to install the Oracle EBS data application:

• Contact Incorta Support to obtain the Oracle EBS data application ZIP file. Download and unzip the file.
• Within the unzipped Oracle EBS data application file, locate the ebsVer<VERSION_NUMBER>.zip file.

Import the EBS Data Application tenant

• Import the ebsVer<VERSION_NUMBER>.zip tenant:
  • Sign in to the CMC
  • In the Navigation bar, select Clusters
  • In the cluster list, select the Cluster name
  • In the canvas tabs, select Tenants
  • Select + → Import Tenant (if it asks for a security password, enter admin).
  • Drag and drop the ebsVer<VERSION_NUMBER>.zip to the Click or drag a file here to upload panel in the Import a tenant to the cluster dialog
  • Select Next
  • Verify or enter the tenant properties.
  • Verify or enter the tenant email properties.
  • Select Create

Tenant properties

Tenant email properties

Configure the EBS Data Application data source

• A data agent is needed as Incorta will use it to run table extract SQL statements on the EBS source Oracle database which will be outside GCP
• Deploy the Data Agent on the EBS source. Refer to this document on how to install, configure, and test it
• Sign in to the Incorta Direct Data Platform™
• In the Navigation bar, select Data
• In the Context bar, select the External Data Source tab

Edit the EBS data source

• Select Edit (pencil icon) to the right of the EBS data source
• Enter the connection properties for your EBS instance:
  • Username
  • Password
  • Connection Pool: 10
  • Connection String:
    • jdbc:oracle:thin:@<HOST>:<PORT>/<DATABASE>
  • Test the connection, if the data agent is correctly set up, then you will see a success message

Configure the initial extract date

Optionally configure the _$$Default_InitialExtractDate_ global variable to store the initial extract date or rolling period. This will limit rows for large transaction tables during full load.

• In the Navigation bar, select Schema
• In the Schema Manager, select the Global Variables tab
• In the list view of global variables, select the Default_InitialExtractDate global variable to open it
• Update the Value
• Select OK
• In the EBS_ schema tables there is a filter on the sql extract as follows - WHERE creation_date >= $$Default_InitialExtractDate as shown below

Order to Cash Data Application Components

The following table lists all of the schemas and tables provided as part of the Data Application. You can further customize the Oracle EBS Order to Cash data application to support your specific business needs.