Poor Performance when Opening Customer Detail Page with many Party Relationships (Doc ID 2292039.1)

Last updated on JULY 31, 2017

Applies to:

Oracle Trading Community - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Customers Related
Performance issues raised when opening the customer detail page.

As more Party Relationships are linked to the customer as longer the page load takes.
Once the results are present in the buffer cache performance get better. But it is still performing bad.
E.g.: page load times for one customer:
Customer Account Number: 412; cust_account_id: 50010318; active relationships: 70640
Page Load Times:
- when not in buffer cache: 3+ mins
- when in buffer cache: ~8 secs



Changes

 

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