Oracle® Insurance Rules Palette Release 9.3.1.0 E21044_01
Point in time valuation allows users to control how valuation is calculated during transaction processing. There are two business rules used: PointinTimeValuation and WriteValuationElements.
At the plan level, the PointInTimeValuation business rule can be configured to value the policy back to the last valued date rather than the start of the policy. This rule can be configured to show the beginning value and the ending value on the Activity Results screen of a transaction. If needed, the beginning valuation can be set to No and the ending valuation can be set to only show when there is a change in the fund.
The WriteValuationElements business rule has the ability to write and update the existing valuation fields to the database. Configuration is divided into four sections: Policy, Fund, Deposit, and PolicyValues. In these sections, a set list of elements are the only elements that can be written. The one exception to this is the Policy Values section, which can be configured to access any variables from the PolicyValues business rule. CopyBooks may be used in this rule.
Two scenarios can be created to demonstrate this functionality.
User adds an activity to a policy that applies money to a fixed fund and performs valuation.
User adds an activity to a policy that values the policy, but does not add money.
On the AsPlan table a new column named PointInTimeValuation must be set to a value of Y in order to use the PointInTimeValuation business rule. In addition, the DepositLevelTracking column of AsFund must be set to N in order to write the correct valuation records. The additional configuration required includes:
PointInTimeValuation business rule
WriteValuationElements business rule
transactions to demonstrate functionality
IMPORTANT: Prior to configuring Point-in-Time valuation, ensure that basic fund valuation is already fully working in your environment. Funds, allocations, and assignments must already be setup and configured before attempting to enable Point-in-Time valuation.
Two transactions have been configured to demonstrate the enhancements to the system.
IntRateCalcMoneyIn transaction: This transaction allows the user to apply money to a fixed fund and perform valuation. Slight changes can be made to the plan level overrides of the PointInTimeValuation business rule to limit the amount of valuation being displayed on the Activity Results screen. Navigate through the following folders in the Main Explorer to locate the configuration sample: Companies | Prototype Company | Subsidiary Companies | Prototype Child Company | Plans | Functional Prototype Plan | Transactions | Policy Transactions | IntRateCalcMoneyIn.
IntRateCalcValuation transaction: This transaction does not apply any money, but does value the policy. Navigate through the following folders in the Main Explorer to locate the configuration sample: Companies | Prototype Company | Subsidiary Companies | Prototype Child Company | Plans | Functional Prototype Plan | Transactions | Policy Transactions | IntRateCalcValuation.
PointInTime Transactions in Main Explorer
Two business rules have been configured to demonstrate the enhancements to the system.
PointInTimeValuation: This rule is configured as a plan level override and values the policy back to the last valued date rather than the start of the policy. Navigate through the following folders in the Global Rules Explorer to locate the configuration sample: Business Rules | System | PointinTimeValuation | Plan Overrides.
PointInTimeValuation Business Rule in Global Rules Explorer
WriteValuationElements: This rule can write and update the existing valuation fields to the database. Navigate through the following folders in the Global Rules Explorer to locate the configuration sample: Business Rules | System | WriteValuationElements | Plan Overrides.
WriteValuationElements Business Rule in Global Rules Explorer
