Performance Issue During 'Download Unit Cost' TABLE RE-ORG TROUBLESHOOTING (Doc ID 2014522.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, Technical

ACTUAL BEHAVIOR
---------------
Performance issue during 'Download Unit Cost'

We are running 'Download Unit Cost' to load the item cost data from EBS to Demantra Staging tables and then to Base Tables, collecting the item cost data for the month of April'15 on Production.
Initially the workflow 'Download Unit Cost' used to take around 2.30 hrs, but in the last run it took around 36 hrs to collect the item cost for the month of April'15. We ran gather schema stats to improve the run time but it didn't help.We checked from mdp_matrix base tables using the Last update date date & time and the data was getting loaded.

We haven't faced this issue earlier on any other Development & Test Instance.

EXPECTED BEHAVIOR
-----------------------
 'Download Unit Cost' to take less time

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Running Download Unit Cost to load the item cost data from EBS to Demantra Staging Tables and then to Base Tables. Its taking more than 36 hrs to complete.

BUSINESS IMPACT
-----------------------
The issue has the following business impact: We are facing this issue on Production and we can't afford this every time we collect unit cost.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms