Item Advanced Search Is Running Very Slow In R12.2.9
(Doc ID 2725692.1)
Last updated on NOVEMBER 09, 2020
Applies to:Oracle Product Hub - Version 12.2.9 and later
Information in this document applies to any platform.
On : 12.2.9 version, Catalog items
Item Advance search is running very slow in R12.2.9 when searching for Item Catalog Categories having larger Item count (> 1000) \.
The issue can be reproduced at will with the following steps:
1. Run Advanced Search for ICC with items > 10K , Use display format with attributes (Char / Translatable)
2. Current profile settings (same on 12.1.3 and 12.2.9) -
EGO: Maximum Match Results 50
EGO: Maximum number of attribute groups in Search. 30
EGO: Maximum number of attribute groups in UDA extension fra 100
EGO: Maximum number of rows for sorting 2000
FND: View Object Max Fetch Size 5000
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document