My Oracle Support Banner

Valuation With Fixed Fund Returns 'An Exception In EntityManager' Error Message (Doc ID 2824201.1)

Last updated on NOVEMBER 29, 2021

Applies to:

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

Symptoms

On : 11.3.1.0 version, General

Following an upgrade from V10.2.0.39 to V11.3.1, any Valuation on a Policy with a Fixed Fund returns the following error:


ERROR
-----------------------
java.lang.RuntimeException: java.lang.RuntimeException: java.lang.IllegalArgumentException: An exception occurred while creating a query in EntityManager:
Exception Description: Problem compiling [SELECT rateDcl.integerCriteria, rateDcl.dateCriteria, rateDcl.rate FROM RateDcl rateDcl, RateGroupDcl rateGroupDcl WHERE rateDcl.rateGroupGuid = rateGroupDcl.rateGroupGuid AND rateGroupDcl.rateDescription = :rateDescription AND rateDcl.integerCriteria <= :duration AND rateGroupDcl.effectiveDate = ( SELECT MAX( subRateGroupDcl.effectiveDate ) FROM RateGroupDcl subRateGroupDcl WHERE subRateGroupDcl.rateDescription = rateGroupDcl.rateDescription AND subRateGroupDcl.effectiveDate <= :effectiveDate ) AND ( rateDcl.CRITERIA1 IN (:CRITERIA11,:CRITERIA12) AND rateDcl.CRITERIA2 IN (:CRITERIA21,:CRITERIA22) ) AND rateDcl.dateCriteria = ( SELECT MAX( subRateDcl.dateCriteria ) FROM RateDcl subRateDcl WHERE subRateDcl.rateGroupGuid = rateGroupDcl.rateGroupGuid AND subRateDcl.rateDescription = rateGroupDcl.rateDescription AND subRateDcl.dateCriteria <= :referenceDate AND ( subRateDcl.CRITERIA1 IN (:CRITERIA11,:CRITERIA12) AND subRateDcl.CRITERIA2 IN (:CRITERIA21,:CRITERIA22) ) ) ORDER BY rateDcl.integerCriteria , rateDcl.CRITERIA1, rateDcl.CRITERIA2].
[502, 519] The state field path 'rateDcl.CRITERIA1' cannot be resolved to a valid type.
[553, 570] The state field path 'rateDcl.CRITERIA2' cannot be resolved to a valid type.
[862, 882] The state field path 'subRateDcl.CRITERIA1' cannot be resolved to a valid type.
[916, 936] The state field path 'subRateDcl.CRITERIA2' cannot be resolved to a valid type.
[1003, 1020] The state field path 'rateDcl.CRITERIA1' cannot be resolved to a valid type.
[1022, 1039] The state field path 'rateDcl.CRITERIA2' cannot be resolved to a valid type.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to the OIPA application.
2. Navigate to the Policy Inquiry Screen.
3. Search in the specific Policy value.

The Base Code appears to be struggling to translate the RateCriteria configuration within the InterestRateCalculation rules into a SQL.


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.