My Oracle Support Banner

Fund Principal Is Not Calculated Correctly for Unit Valued Funds (Doc ID 2314218.1)

Last updated on MAY 25, 2020

Applies to:

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


Actual Behavior
Principal value (End) = Principal value (Begin) + [ unit(End) - Unit(Begin) ] * (unit value at time of current activity)

Expected Behavior
Definition of Principal

1. The beginning principal is always the ending principal of the fund's prior valuation record or zero if it is the application of money.
2. If it is the application of money, the ending Principal is equal to the ending cash value of the deposit
3. If it is the removal of money, the ending Principal is equal to the beginning principal times the beginning units divided by the ending units


1. Funds to be considered for inclusion in updated logic are those under type codes
    01 (Fixed), 02 (Variable, 03 (Fixed Benefit), 04 (Unitized Fixed), 05 (Non-Invest) and 07 (DCA).
2. Funds to be excluded from inclusion of updated logic are those under type codes
    06 (MVA), 08 (Collateral), 09 (Index) and 10 (UnitLinkedVariable).
3. The FundGain and FundNetGain columns will be populated with the same values derived from the same calculation.



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

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