My Oracle Support Banner

Assign Categories To an iStore Section takes long time (Doc ID 1599703.1)

Last updated on MARCH 31, 2020

Applies to:

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

Symptoms

On test and prod: 12.1.3 version, Merchant UI

ACTUAL BEHAVIOR
---------------
Assign Category LOV takes more than 5 minutes and page ultimately times out.

EXPECTED BEHAVIOR
-----------------------
Expect LOV should return in a reasonable time (a few seconds).

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Login to EBS with iStore Administrator resp
2. Select any section, press update
3. From left hand side cue card, click "Categories"
4. Press "Assign Categories" button to launch list of values
5. Select either by code/name, enter partial value and submit.
6. After 5 minutes, page crashes with a message "Internal Server Error"

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, Admin users cannot add products to sections.
User keeps pressing submit on LOV, this resulted in multiple long executions of same poor SQL, putting extra load.

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.