Configure Point-In-Time Valuation

Prior to configuring Point-in-Time valuation, ensure that basic fund valuation is already fully working in the environment. Funds, allocations, and assignments must already be setup and configured before attempting to enable Point-in-Time valuation.

Point-in-Time valuation requires the configuration of these business rules:

Point-in-Time valuation must also be enabled at the Plan level for each plan that will use its functionality. This can be configured in the Rules Palette through the New Plan editor by setting the Point-in-Time Valuation field to Yes. The action can be confirmed by checking the PointInTimeValuation column of the AsPlan table. The value of the column should be Y. As soon as policies have been added to a plan, the Point-in-Time valuation field cannot be switched to traditional valuation by setting the Point-in-Time valuation field to No.

In addition, each of the plan's funds should have deposit level tracking set to Yes or No. This can be configured in the Rules Palette in the New Fund editor by setting the Deposit Level Tracking field. It can be confirmed in the database by examining the DepositLevelTracking column of the AsFund table. The value of the column must be Y or N.

Transitioning Existing Plans to Point-in-Time Valuation

If an existing plan transitions from Traditional valuation to Point-in-Time valuation, then a mixed methods indicator is used and the transition date determines how valuation records are written. This indicator can be found on the Plan Maintenance editor. When the mixed valuation methods indicator is set to Yes, the transition date will determine how valuation should be written. When the mixed valuation methods indicator is set to No or null, any activity that is processed on the policy will write Point-in-Time valuation and no transition date will be required. This includes activities that are reprocessed, which previously calculated valuation using Period of Time.

Important   The transition date is set by a utility when traditional valuation is converted to point in time valuation. To request this utility, go to My Oracle Support at https://support.oracle.com and file a service request. A support specialist will facilitate the process.

Once a plan transitions to Point-in-Time valuation, it cannot switch back to Traditional valuation.

Important   With the Re-design Data Storage for PIT in version 11.3.0.0, there is no configuration change for this feature though SQL statements interrogating or pulling data from AsDepositValue, AsPolicyValue or AsFundValue will need modification with the elimination of individual beginning and ending records. If NetGain associated to a "begin" valuation record is pulled by SQL statement, the statement must be altered to pull BeginNetGain. If NetGain associated to an "end" valuation record is pulled by SQL statement, the statement must be altered to pull EndNetGain.