Data Loading into Demantra EP_Load (Doc ID 815124.1)

Last updated on SEPTEMBER 12, 2024

Applies to:

Purpose

The material presented below is of a technical nature.   Little attention has been given to functional navigation, functional demonstrations.  The vast majority of data load issues are investigated / solved using SQL.  To that end, this presentation focuses almost exclusively on problem investigation and resolution.

This material has been assembled from 100s of bugs in which DEV gave us techniques to drill into source/destination data.  

==================================
Data Loading into Demantra EP_Load
==================================

Data Loading Flow
-----------------

There are four data flows that move data in and out of Demantra:
1.  Loading data from source into collection staging tables
2.  Moving data from the collection staging tables into Dematra data store
3.  Loading data from the Demantra data store into the Demantra engine and downloading from Demtra back to the Demantr data store.
4.  Pushing the data back to the source instance in the form of a forecast.

We will cover #3 and #4 in this presentation.

At the end, the reader should be able to investigate EP_LOAD data errors.

Scope

This is a technical presentation.

Details

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.