My Oracle Support Banner

After Database Upgrade To 19c, the MDP_ADD Procedure Runs for a Long Time (Doc ID 3001725.1)

Last updated on FEBRUARY 06, 2024

Applies to:

Oracle Demantra Predictive Trade Planning - Version 12.2.5 and later
Information in this document applies to any platform.


Before upgrade, MDP_ADD procedure completed under 4–5 hours.

However, after upgrading Demantra from 12.2.5 to version in combination with the Database upgrade to 19c, the procedure ran more than twenty-four hours.

The issue can be reproduced at will with the following steps:
1. Upgrade Demantra to and upgrade the Database to 19c
2. Load new data into Demantra via loading staging tables from EBS
3. Run workflows : Load items, Load Locations ,Load Sales data
4. Procedure step “MDP_ADD” takes long time to complete


Upgrade Demantra to (or any higher version)
Upgrade Database to 19c


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.