My Oracle Support Banner

Demantra Data Load / Import Diagnostics Investigation - EBS and Legacy (Doc ID 809410.1)

Last updated on AUGUST 25, 2021

Applies to:

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

Purpose

This document walks through several key areas as noted in bugs and SRs.

This data loading performance document consists of the following:

  1. General Data Loading Concerns
  2. Key Logs
  3. Data loading from non EBS tables
  4. Data loading from EBS tables.  This subject will be covered in detail as we use SQL to trace back to the source EBS instance.
  5. Data loading from stage to Demantra tables
  6. Pushing the data back to the source instance in the form of a forecast.  This will be covered at a later date.
  7. RDBMS Best practices for all
  8. Data Loading Miscellaneous
  9. Data Load SR Performance Template Questions

Questions and Answers

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
Purpose
Questions and Answers
 Overview
 KEY Logs
 General Data Loading Concerns
 Data Loading from non EBS tables
 Data Loading Directly into Staging Tables
 Data Loading From EBS
 General Investigation
 Debugging
 Configurable Parallel Parameters
 EP_LOAD Specific
 RDBMS Best Practices
 Data Loading Miscellaneous
References

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