My Oracle Support Banner

Client Role Screen Loading Slow Based On System Generated SQL (Doc ID 3051826.1)

Last updated on OCTOBER 10, 2024

Applies to:

Oracle Insurance Policy Administration J2EE - Version 11.3.1.17 and later
Information in this document applies to any platform.

Symptoms

On : 11.3.1.17 version, Client Activity

ACTUAL BEHAVIOR
---------------
Client Role Screen is very slow to load in the Production environment.
After navigating to the Client Screen, the user is using the Client Role Screen to show other Policies that the Client has a Role on.
However, the Screen is very slow to load data often taking several minutes before displaying the list.


EXPECTED BEHAVIOR
-----------------------
The Client Role Screen should display in a couple of seconds based on the Client id.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to OIPA.
2. Navigate to a Client that has multiple Policy Roles and select the Client Roles.


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.