Slow Performance with MerchUI Navigating from Site Catalogs to The List of Sites. (Doc ID 1487670.1)

Last updated on JUNE 15, 2017

Applies to:

Oracle Commerce Merchandising - Version 10.0 and later
Information in this document applies to any platform.

Symptoms

Navigating from Site Catalogs to the list of Sites is taking over a minute and a half.

Secured ProductCatalog is used.

Another area where the delay was found was with the following steps.

1. In Merchandising, search a category and open it.
2. Go to its 'Products' tab.
3. Click on 'Fixed child products' section
4. Hit 'Select' button
5. Pop up states loading --> This is very slow 5 minutes. No errors in the log.

The following SQL was taking a few minutes.

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