You are here: Configuration > Valuation > OIPA Valuation Mechanisms

Oracle® Insurance Rules Palette 9.4.0.0 E18894_01

# Understanding OIPA Valuation Mechanisms

Before configuring a plan that will value policies it is important to understand how OIPA processes values. The OIPA code will perform hard coded calculations depending on the type of funds being used for valuation. OIPA will also perform certain predefined steps when valuation is run. This is known as running the valuation engine.

A transaction may be configured to execute or not execute the valuation engine. Upon execution of the valuation engine, the OIPA system gathers the fund information needed to perform the valuation steps. The information gathered is dependent on the use of Point-In-Time valuation or Traditional valuation.

With Point-In-Time valuation this data consists of the fund and/or deposit information and values as of the last time valuation was executed by an acitvity on the policy. With Traditional valuation this data consists of all of the policy’s deposits and removals since inception of the policy. Along the way to gathering this information, the policy’s fund values are calculated as of each deposit and removal date until it reaches the last. The data accumulated to this point is kept in OIPA system memory and is known as the Valuation Structure. With both methods now at a similar point, fund and deposit values are calculated to the current valuation date. Results of the calculations are stored in the Valuation Structure. Data in the Valuation Structure are available to the Math section Each fund type follows a different calculation path in the OIPA system to achieve the policy’s/fund’s/deposit’s values.

Note: Refer to the XML Configuration Guide topic in this help system for information on using Valuation prefixes to access values within the valuation structure. Select Common Elements | Available Prefixes.

##

## Configuring Valuation

Valuation can be configured and run at the transaction level. The output can be viewed on the OIPA Activity Results screen. Valuation can also be configured at the policy level. The output can be viewed on the OIPA Values screen.

High Level Valuation Steps

High Level Work Flow Diagram

## Valuation Structure

In traditional valuation, when the system calls the valuation engine, the engine creates a valuation structure. The valuation structure includes the policy, fund, deposit and removal information since the inception of the policy. The Valuation Structure is then stored in XML when the activity is completed.

## Active Valuation

Initially all valuation records will be in a pending state but as more values are known the status will move to an active state. This update is system driven and not configurable much like normal disbursement and activity status transitions.

As the assignment is written, redemption records will receive negative amounts and units while subscriptions are positive.

##

For unit linked funds, an attached activity could be in NUV Pending status and its valuation records would need to be excluded from the valuation process. This means that a unit linked valuation record is only active if:

- It has an EffectiveDate less than or equal to the valuation date input.
- The current system date falls between its Active dates.
- When all the Redemption amounts and units for an activity are known and written, the Subscription amounts can also be derived and written at the same time so all Valuation records can also move to an Active state. Otherwise the status is unchanged. The activity will remain in an NUV Pending state until the Redemption units are known.

When all three of the above criteria are met, the record is written to AsActiveValuationActivity.and will be included when valuing the policy.

## Valuation XML

The Valuation XML is made up of specified values that can be used in a transaction's math section. Most of the valuation structure cannot be changed and is hard coded. The valuation structure and its content cannot be changed during the execution of the activity that created it. There is one business rule called PolicyValues, which allows custom configuration of values and is added to the valuation structure. The structure with its associated values are located in the XMLData column of the AsValuationXML table. Use these values in a transaction's Math by prefixing a MathVariable with Valuation: and the node path separated by colons. This is discussed in more detail in the Configuring Math section.

With Point-In-Time valuation, a valuation structure is also created. This structure consists of the last known policy/fund/deposit values. Its values are available in a transaction’s math section using the same syntax as above. The structure is not saved in the AsValuationXML table.

Example of XML Valuation Structure taken from AsValuationXML

Copyright © 2009, 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices

Open table of contents