My Oracle Support Banner

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.

Symptoms

On : 12.2.9 version, Catalog items

ACTUAL BEHAVIOR
---------------
Item Advance search is running very slow in R12.2.9 when searching for Item Catalog Categories having larger Item count (> 1000) \.
 
STEPS
-----------------------
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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.