My Oracle Support Banner

Fixed Funds - AsDepositValue.RegularInterest Incorrect (Doc ID 2858601.1)

Last updated on MARCH 28, 2022

Applies to:

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

Symptoms

On : 11.3.1.1 version, General

ACTUAL BEHAVIOR
---------------
Users are encountering 2 issues with AsDepositValue.RegularInterest for Fixed Funds.
1. First Activity to do a PIT Valuation following a Traditional Valuation has an incorrect value.
2. Sometimes, V11 logs "-0.01" instead of "0.00".


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to OIPA.
2. Navigate to Activity Screen on the specific Policy.
3. Click Process All
4. Run the following SQL for this Policy, filter on Fund "Fixed Account" and compare V10 to V11.

SELECT T.TransactionName, A.EffectiveDate, F.FUNDNAME, DV.RegularInterest
FROM AsPolicy P
JOIN AsActivity A ON A.PolicyGUID = P.PolicyGUID AND A.TypeCode IN ('01','04') AND A.StatusCode IN ('01','14')
JOIN AsTransaction T ON T.TransactionGUID = A.TransactionGUID
JOIN AsDepositValue DV ON DV.ACTIVITYGUID = A.ACTIVITYGUID
AND DV.BeginEndFlag = 'E' -- this is only needed in V10
JOIN AsFund F ON F.FUNDGUID = DV.FUNDGUID
where p.policynumber like '%#######'
ORDER BY A.EffectiveDate DESC, A.CREATIONGMT DESC, F.FundName


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.