My Oracle Support Banner

Activity Hierarchy In MDM Have Some Performance Issues (Doc ID 2761595.1)

Last updated on MARCH 26, 2021

Applies to:

Oracle Utilities Meter Data Management - Version 2.3.0.2.0 and later
Information in this document applies to any platform.

Symptoms

On Oracle Utilities Meter Data Management 2.3.0.2.0 version, Performance / Database

ACTUAL BEHAVIOR
---------------
This occurs on MDM v2.3.0.2.0 (upgrade project) and MDM v2.1.0.3.0.
When a user attempts to open an activity that has communication IDs linked to it, it takes more than 15 seconds for the activity hierarchy zone to load.

EXPECTED BEHAVIOR
-----------------------
It is expected that this zone load within milliseconds.

WORK AROUND
-----------------------
A custom index was added:
create index CISADM.CM_IDXINCOMMID on CISADM.D1_COMPL_EVT("IN_COMM_ID");
This will reduce the cost to < 100 which makes the activity hierarchy to load at milliseconds.
The table is partitioned and the added index is a global index so this might lead to issues in the long run thus requesting a permanent solution.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. In MDM UI, go to Activity Query and enter terms for search
2. Select an Activity
3. Activity screen loads but the Activity Hierarchy is taking 15 seconds to load

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


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