Performance Issue of Master Item Form When Query Item That Have Too Many Records in "BOM_SUBSTITUTE_COMPONENTS"

(Doc ID 2126257.1)

Last updated on APRIL 12, 2016

Applies to:

Oracle Item Master - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Actual Behavior
Performance issue when query item in form if item have too many record in table "BOM_SUBSTITUTE_COMPONENTS".
From trace file, below script takes a lot of time.

 
Expected Behavior
Improve the performance when query item in form

Steps to Reproduce

  1. Go to Inventory > Items > Master Items
  2. Enter an item and query it.
  3. It takes around 10 mins to shown result.

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