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

Last updated on MARCH 28, 2022

Applies to:

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

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