Field Service Wireless Material Debrief Item List Of Values Causing Severe Performance Issue
(Doc ID 2223065.1)
Last updated on MARCH 01, 2019
Applies to:Oracle Field Service - Version 12.1.3 and later
Information in this document applies to any platform.
Below is the SQL which causing High CPU Utilization 100% when bad Plan is used, when Material Debrief Item List Of Values in Field Service Wireless is selected.
Expect that the sql should not cause High CPU utilization 100%
a) Login to Field Service Wireless application
b) Select a Task and click the Debrief
c) In the Material Debrief select the Item LOV, it is taking a long time to display the items from the lov.
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