OIPA Reports 'Failed To Calculate Math Variable InterestRateArray' With Surrender Activity After Deployment of v11.3.1.36 (Doc ID 3078273.1)

Last updated on MARCH 28, 2025

Applies to:

Symptoms

On : 11.3.1.36 version, Activity

When attempting to add a Surrender Activity in Oracle Insurance Policy Administration (OIPA), the following error occurs.

ERROR
-----------------------
SEVERE: java.lang.RuntimeException: com.adminserver.utl.exception.AsExceptionUtl: Failed to generate OnLoad event processor.
at com.adminserver.pas.uip.aspects.UipExtensibilityAspect.extendUipMethod(UipExtensibilityAspect.jav a:65)
at com.adminserver.pas.uip.ActivityDetailUip.processTransactionChange(ActivityDetailUip.java:2561)
at com.oracle.pas.page.ActivityDetailPage.processTransactionChange(ActivityDetailPage.java:154)
at com.oracle.pas.service.delegate.ActivityDetailServiceDelegate.processTransactionChange(ActivityDe tailServiceDelegate.java:248)
at com.oracle.pas.service.ActivityDetailService.processTransactionChange(ActivityDetailService.java: 56)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
Caused by: com.adminserver.utl.exception.EngineException: Failed to calculate Math Variable InterestRateArray with Statement ID 354. Location is RuleElementLocation[Entity=Transaction,GUID=5DC9424B-DA23-4781-A37C- 88841BAB7B9C,XPath=/CopyBook/MathVariable[1],CopyBook=8CAB37F7-66D1-44F3-BB3B-2A529B73BC8F].
at com.adminserver.sre.bll.generatedClasses.MathEngine_ba0b06adcba1061c3e3ff11c7be8583f_Debug.execut eStatement_354(Unknown Source)
... 83 more Caused by: com.adminserver.utl.exception.EngineException: Error Executing SQL Select CASE WHEN Rate > ? THEN Rate ELSE ? END From AsRate Where RateGroupGuid IN (Select RateGroupGuid From AsRateGroup Where RateDescription =? AND ActiveFromDate <= ? Order By ActiveFromDate Desc Fetch First Rows Only) Order By DateCriteria Asc.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to OIPA.
2. Locate an Active Policy.
3. Attempt to add the Surrender Activity.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.