My Oracle Support Banner

Performance Issue During 'Download Unit Cost' TABLE RE-ORG TROUBLESHOOTING (Doc ID 2014522.1)

Last updated on JULY 05, 2021

Applies to:

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


On : 12.2.3 version, Technical

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 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.

 'Download Unit Cost' to take less time

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.

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.




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
 -- <Document: 1964291.1> Troubleshooting TABLE_REORG Package issues
 ORA-32422 is fixed after implementing workaround from Note  <Document: 1950119.1>
 ORA-600 encountered during MDP_MATRIX table reorg

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