My Oracle Support Banner

Performance Issue During Load Supply Plan Scenario Data (Doc ID 2050962.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Real-Time Sales and Operations Planning - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, LoadData

ACTUAL BEHAVIOR
---------------
Performance issue during Load Supply Plan Scenario Data.
Load Plan Scenario Data for a plan takes around 23 hours
In supply_plan_data table the number of rows processed is 2691013.

EXPECTED BEHAVIOR
-----------------------
Load Plan Scenario Data should take maximum 2 hours.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into Collaborator Workbench.
2. Run Load scenario data method.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot load supply plan data in a reasonable time. This is affection production instance.

Cause

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
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.