Oracle® Rules Palette Release 9.1.0.0.0 E15811-01

# Step 1: Configure the Plan’s Funds

Funds must be set-up prior to configuring valuation calculations specific to your company’s business requirements. See the Funds section for details on entering funds into OIPA. There are different sets of steps according to what type of funds you are configuring.

Steps According to Funds

- Fixed Funds

- Variable Funds

### Fixed Funds

If using fixed funds, you must complete the following steps.

1. Configure the interest rate log-in via the InterestRateCalculation rule.

2. Make sure the interest rate is configured.

Interest Rate Logic

The InterestRateCalculation rule supports interest calculation. It supports guaranteed interest calculations, bonus interest calculations, current interest calculations, compound interest, simple interest, leap year methods, numerator calculation methods and previous day valuation.

Steps to Configure Interest Rate Calculation

1. Navigate to the Global Rules Explorer.

2. Expand the Business Rule folder.

3. Expand the System folder.

4. Right-click on InterestRateCalculation.

5. Select New InterestRateCalculation Override. The Override Wizard opens.

6. Select the Next button for step one.

7. Select the company, plan and fund where this override should be used.

8. Select Finish.

9. Configure your interest logic in the XML Source Pane of the override of the InterestRateCalculation that was created. View the V9 XML Configuration topic in this help system for additional information. View Business Rules | System Rules | InterestRateCalculation.

Interest Rate to be used with the Fund

In addition to configuring the logic for the interest rate calculation you must also ensure there is an interest rate for the fund to use. In the InterestRateCalculation rule you can enter it OR you can retrieve it from AsRate via the AsRateGroup name. If you decide to retrieve the rate from the rate tables, please see the Rates section for details on uploading rates via RateGroups in the Admin Explorer.

### Variable Funds

If using variable funds, you will need to complete the following steps.

1. Verify that the AsNetAssetValue table has unit values for funds to use.

2. Configure the UnitValuePrecision rule.

Step 1: Verify the AsNetAssetValue Table

A very important part of this is the price of a fund unit at a specific point in time. The AsNetAssetValue table stores the unit values for the various funds. If you configured funds whose value varies due to market conditions, then those values must be stored in the AsNetAsset table according to dates.

Depending on your needs, you may update the AsNetAssetValue table in the following ways.

- The tables menu in OIPA provides an interface for entering and viewing unit values. Tables menu is in the OIPA system.

- To update the database manually you can use an INSERT statement.

Example of a Manual SQL Statement
INSERT INTO AsNetAssetValue (NetAssetValueGUID,FundGUID,EffectiveDate,NetAssetValue,UnitValue,Dividend,MortalityandExpense) VALUES (newid(),'054BD142-1AD5-7074-5E67-68EA40C405FD', '7/23/2030',11,11,0,0)

- The Files administration functionality allows you to select, transform and upload incoming data and insert it directly into the OIPA database. Please see the Files section for additional information on how to configure.

You can review the Funds data model to see how the NetUnitValues are associated.

Step 2: Configure the UnitValuePrecision Rule

The UnitValuePrecision rule is used to determine the number of digits allowed after the decimal point of a unit. This allows you to display the proper unit value to the OIPA user. This rule can also be used to calculate the unit’s precision at accumulation and benefit level by attaching this rule to the transactions that affect benefit. These values are ultimately stored as units in the AsValuation table. If this rule is not configured then the system will revert to a default setting of ten decimal places.

Note: If you want to use the same unit precision, then you can configure the global rule.

Steps to Configure Unit Value Precision

1. Navigate to the Global Rules Explorer.

2. Expand the Business Rule folder.

3. Expand the System folder.

4. Right-click UnitValuePrecision.

5. Select New UnitValuePrecision override. The Override Wizard will open.

6. Select Next for step one.

7. Select the level you want the unit precision to apply to.

8. Select Finish.

9. Configure your unit precision value in the XML Source Pane of the override of the UnitValuePrecision that was created. View the V9 XML Configuration topic in this help system for additional information. View Business Rules | System Rules | UnitValuePrecision.