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

Last updated on OCTOBER 16, 2016

Applies to:

Oracle Utilities Work and Asset Management - Version: 1.7.15 and later   [Release: 1.7 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

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