My Oracle Support Banner

Company Level Activities Query Needs To Be Paginated (Doc ID 2773322.1)

Last updated on MAY 03, 2021

Applies to:

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

Symptoms

On : 11.2.0.27 version, General

ACTUAL BEHAVIOR
---------------
Company Level Activities query needs to be paginated. Fetch query for company level activities is not paginated and hence in an attempt to fetch all the records is taking long time to run and performance delay. Query needs to be modified to add OFFSET and FETCH NEXT ROWS for pagination.

EXPECTED BEHAVIOR
-----------------------
Company Level Activities for a given plan should be loaded in ~3 to 5 secs. The Fetch query should only load limited set of records based on pagination.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login To OIPA V11 --> Navigate to "Admin" --> "Misc" --> Company Activity.

Select company and Plan.

Notice that loading activities will take ~30 to 45 secs (depending on the number of activities in the system).

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
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.