My Oracle Support Banner

Version 1.7.15 Service Request Module, Cost Summary View Has Excessive Run Time (Doc ID 579333.1)

Last updated on OCTOBER 07, 2019

Applies to:

Oracle Utilities Work and Asset Management - Version 1.7.15 and later
Information in this document applies to any platform.

Symptoms

The Service Request module, Cost Summary view has excessive run time. The application will not
return results in a reasonable timeframe. Performance needs to be enhanced to eliminate performance degradation. The Explain Plan from Toad shows that full table scans are occurring when this view is selected.





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

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