Performance Issue Of Change Advanced Search With "Requested By" As A Search Criterion
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.
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.
Improve the performance to add items to search by "Requested By" as a search criterion.
Steps to Reproduce
- Path for PIM Change Advance Search:
PIM Super User > Change Management > Change Advance Search
- In Change Category, select Change Order - click Go
- In Search Criteria, add "Requested By" or "Assigned To"
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