Poor Performance when Opening Customer Detail Page with many Party Relationships
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.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms