Performance Slow When Querying Master Items In Inventory

(Doc ID 848380.1)

Last updated on MAY 19, 2017

Applies to:

Oracle Service Fulfillment Manager - Version to 12.2.6 [Release 11.5 to 12.2]
Oracle Installed Base - Version to 12.2.6 [Release 11.5 to 12.2]
Information in this document applies to any platform.
***Checked for relevance on 20-Jan-2016***


In Inventory, when the user queries up an item in the  Master Items form, it takes too much time to bring back the data (approx 40-70 seconds).  The performance of the Master Item query is too slow.

Steps to reproduce:

  1. Go to Inventory
  2. Go to Items > Master Items
  3. Search for an Item




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