Removing Policy-New Button Causes Login To Be Very Slow. (Doc ID 2110923.1)

Last updated on JUNE 28, 2017

Applies to:

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

Symptoms

On : 10.1.2.6 version, Policy information

ACTUAL BEHAVIOR
---------------
It needs to be possible to remove a user's ability to create a policy manually using the New button in the policy menu. The current implementation when doing so the environment will become extremely slow upon loading any screen as well as on login. What the system is doing is going through each and every plan (about 30,000 plans in our converted data) and checking if the new button is available in each plan, as soon as it finds one plan where the button is available it loads the screen.

EXPECTED BEHAVIOR
-----------------------
There should be no performance issues with the policy-new button being removed from a user.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. attempt to log in with user who does not have policy-new
3. Experience slowness.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Administrators cannot remove the button because if they do, it will run through each plan one by one and it will never find a plan with the New button. Going through all of the 30,000+ plans takes a few minutes rendering the environment unusable.

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