Performance Issue Of Change Advanced Search With "Requested By" As A Search Criterion

(Doc ID 2138307.1)

Last updated on MAY 18, 2016

Applies to:

Oracle Product Hub - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Actual Behavior
In Change Advanced Search page, set "Requested By" as a search criterion and try to search by certain name.
But the search window eventually times out and produces the error message as below.

You have encountered an unexpected error.
Please contact the System Administrator for assistance.

From trace file, following statement take much time.

 
Expected Behavior
Improve the performance to add items to search by "Requested By" as a search criterion.

Steps to Reproduce

  1. Path for PIM Change Advance Search:
    PIM Super User > Change Management > Change Advance Search
  2. In Change Category, select Change Order - click Go
  3. In Search Criteria, add "Requested By" or "Assigned To"

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