My Oracle Support Banner

CSC Takes Long Time to Load Purchase History Panel And Customer Detail Page (Doc ID 2469723.1)

Last updated on JULY 20, 2021

Applies to:

Oracle Commerce Platform - Version 11.3 and later
Information in this document applies to any platform.

Symptoms

Purchase history panel is taking a long time to return the result, because of this panel is unresponsive unless purchase history panel is loaded. This slowness is observed on the Customer who doesn't have purchase History as well.

Reproducible Steps:

----------------------------

  1. Login to CSC application
  2. Click on Customer>Search for customer>Input 'a' in the 'First Name' field.
  3. Customer will be listed out and choose One customer with a. Purchase History' values and another Customer with no 'Purchase History' values.
  4. Now see the Performance Issue if it is taking a too long time or not

Changes

In 11.3 unnecessary split queries are used while the previous version uses a single query. 

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.