My Oracle Support Banner

Data Loading into Demantra EP_Load (Doc ID 815124.1)

Last updated on APRIL 07, 2023

Applies to:

Oracle Demantra Demand Management - Version 7.0.1 and later
Information in this document applies to any platform.


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.


This is a technical presentation.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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