Field Service Wireless Material Debrief Item List Of Values Causing Severe Performance Issue
Last updated on MARCH 08, 2017
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms