For Variable Funds Units In AsDepositValue Is Non-Zero Whereas The Cash Value In AsDepositValue Is 0 (Doc ID 2913003.1)

Last updated on DECEMBER 02, 2022

Applies to:

Symptoms

On : 11.0.2.33 version, Fund

ACTUAL BEHAVIOR
---------------
When the Variable Fund Values are completely removed as part of FundToFundTransfer Activity, the Cash Value in AsDepoistValue become zero but at the same time there are a fractional portion left in the Units.
This results in errored out in Monthaversary or any Fund depletion Transaction while trying to remove the money.
The expectation is to set the Units to Zero so that Monthaversary or any depletion Transaction processed successfully without any issue.

EXPECTED BEHAVIOR
-----------------
The Units in AsDepsotValue should be zero when the CashValue in AsDepositValue is also Zero.

STEPS TO REPRODUCE:
------------------
1. The following query could be used to identify the errors where CashValue is zero, but units is no-zero.

select * from AsDepositValue join asactivity on AsDepositValue.activityguid = asactivity.activityguid
join aspolicy on asactivity.policyguid = aspolicy.policyguid
Join AsTransaction on AsActivity.TRansactionGUID = AsTransaction.TransactionGUID
Join AsPlan ON AsPolicy.PlanGUID = AsPlan.PlanGUID
And AsTransaction.TransactionName ='FundToFundTransfer'
and asactivity.typecode in ('01','04')
and asactivity.statuscode in ('01')
and AsDepositValue.cashvalue = 0
and AsDepositValue.units <> 0
and asdepositvalue.BEGINENDFLAG ='E'

As mentioned above, any FundToFundTransfer Activity to remove the money from any Variable Fund.

OTHER DETAILS:
WORKAROUND: A check is being placed in Monthaversary Transaction to deduct the charges if the Cash Value for the Variable Fund is greater than or equal to 0.01.

Cause

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