You are here: Configuration > Transactions > Configuration Panes > Math Pane

Oracle® Insurance Rules Palette 9.4.1.0 E23637_01

# Math Pane

The Math pane is used to perform the bulk of business processes. Calculations can be performed using math variables and the values calculated can be used by supporting rules.

Examples of when to use math:

- add, subtract, multiply or divide values

- pull in policy data to be used within functions

- pick the next business day for an activity

- determine whether or not to spawn a transaction

The Math pane contains the definitions and calculations that process math variables and functions. Literal values may also be applied to math variables. Set-up conditions to evaluate if something is true or false and create an array of values. Fields may be referenced in the Math pane of a transaction in order to perform calculations.

Note: Math variables are populated in the order in which they are configured. If a math variable name is repeated in the configuration, the final value will display in the Math tab of the Activity Details screen.

## Steps to Create a New Math Variable

(Please see the XML Configuration Guide for a list of all elements, attributes and values needed for configuration. View Transaction Rules | Transaction Elements | Math Elements.)

1. Open a transaction in the Configuration Area. Check-out the transaction so that changes can be made and saved.
2. Click the Math pane at the top of the window.
3. Make sure the SearchPalette window is open. It contains a list of math variables that can be dragged and dropped onto the screen. If this window is not open, click Window on the Main Menu and select Open Search Palette Window.
4. Drag the type of math variable needed from the Palette window to the Configuration Area.

- General:Commonly used math variables, such as CURRENCY, EXPRESSION, VALUE, POLICYFIELD and STOREDPROCEDURE.

- Array:Math variables used to create and perform operations on an array.

- Commutation: Math variables used to perform commutation functions.

- Conditional:Math Variables that perform IIF or MathIF operations.

- Loop:Math variables that perform math loop operations, including FOR, SEGMENT and OBJECT.

- Rate Lookup:Math variables that retrieve a RateArray or Rate.

- Rule:Math variables that call a CopyBook, FunctionCall or Function.

- Solve:Math variables that create an IRR, SolveFor or Target math variable.

- SQL:Math variables that retrieve results from a SQL statement.

- Update: Math variables that allow values to be stored in memory and updated without affecting the database values.

- WebService:Math variables that create a Web Service call math variable.

- XML:Math variables that use XPATH to obtain a value from an XML blob.

5. Depending on the type of math variable selected there will be various operations, behaviors and characteristics defined. The following are required:

- Name of the math variable.
- Select the DataType if necessary.>
- Math variable type automatically is selected based on the drag and drop variable that was selected.
- Only those attributes associated with TYPE will be displayed and available for entry.

Note: The scroll bar for the Math pane is hidden from view. To scroll to the bottom of the Math Pane, click the scroll bar at the bottom of the window and drag it to the right. This will reveal the vertical scroll bar used to move to the bottom of the Math Pane.

6. Move the math variables in the hierarchy using the Up or Down buttons at the top of the Configuration Area.
7. Create or delete math folder structures by using the Move Into and Move Out Of buttons at the top of the Configuration Area. Move Into means that a math variable will be moved inside a MathLoop or MathIF. Move Out Of means that a math variable will be moved outside and above the MathLoop or MathIF that it is currently inside.

Functionality of Math Pane

8. Use the Comment and Uncomment buttons to comment or uncomment a math variable.

## Use an Existing Math Variable

From the SearchPalette window, use the DataDictionary to search for existing math variables. If the exact math variable name is unknown, then use the % sign as a wildcard. This wildcard can be used at the beginning and/or the end of a partial search term. The category section can also be searched to find a math variable term name.

## Steps to Use an Existing Math Variable

1. Open the SearchPalette window. This can be done by clicking Window on the Main Menu and selecting Open SearchPalette Window. Open a transaction in the Configuration Area. Make sure to check-out the transaction or updates cannot be made.

2. Click the Math pane at the top of the window.

3. Click the plus box to expand the Data Dictionary search section at the top of the SearchPalette window.

4. Search for the math variable using the Search Field text box or Search Category list.

5. Select the Search button.

6. Select the math variable from the Search Results section in the Palette window.

7. Drag and drop the math variable from the Palette window to the Configuration Area.

8. Use the Up or Down button to place the math variable in the correct spot in the hierarchy.

9. Edit the math variable properties as necessary.

Note: When configuring a general math variable that is a PlanField or PolicyField type, you can use the auto-complete feature. Hitting Ctrl + Space will bring up the plan's policy fields or plan fields (not mathvariables). The auto-complete feature is also available for the Field type MathVariable, in which case, depending on the prefix that is used (Activity, Policy, Plan), auto-complete will bring up the Activity, Policy or Plan fields. StoreProcedure and StoredProcedureCollection also have drop-down boxes populated with all available stored procedures. An array with Operation FillyBy-StoredProcedure also has the StoredProcedure dropdown available.

Note: When checking-out a transaction that contains a Disbursement section, a pop-up notification will display indicating that there is a Disbursement section in the transaction and that the XML Source pane should be used to edit that section. When the XML Source pane is open, scroll to the Disbursement section and make the changes. Check the transaction back in to save the changes.

Disbursement Message

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