Field Service Wireless Material Debrief Item List Of Values Causing Severe Performance Issue

(Doc ID 2223065.1)

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms