Oracle® Insurance Rules Palette 9.4.0.0 E18894_01
The Rules Palette manages multiple currencies within the OIPA system. The currency information is displayed according to the international standards outlined in the ISO 4217 Currency Names and Codes Element Table. The Currency Editor is the tool used to define and update currencies and rounding methods. Currency codes cannot be edited.
Note: If decimal displays need to be changed for the currency, use the Localization Editor.
Once currency codes are defined in the Currency Editor, they can be associated with activities, plans or companies. This is done by setting currency displays. Currencies can also be associated with funds. Refer to the Currency Conversion section for more information on how currencies are used in the conversion process.
There may be times when additional currency codes are needed. The Currency Editor is used to add new currencies and edit the existing ones. The information displayed in the currency editor is all stored in the AsCurrency table.
Once a new currency code is created, it can be selected as an option in the Countries Editor under the Taxable Currency Code drop-down box.
Currency File in Admin Explorer
Open the Admin Explorer window.
Double-click the Currency folder. It will open in the Configuration Area.
Right-click on the currency XML file and select Check-out.
Click Add at the bottom of the Configuration Area window. If the Add button is not visible, grab the bottom of the window and pull it down until the Add button is visible.
Select a Currency code from the drop down menu. The corresponding Currency Name will display.
Select the number of decimal places to round the currency for display purposes.
Select the number of digits to the right of the decimal place to keep after a currency calculation is performed.
Select the rounding method to employ once a calculation is performed.
Arithmetic Round: Increases the last digit by one if the next digit is five or greater.
Round Down: Leaves the last digit the same, regardless of the next digit.
Round to Even: Increases the last digit by one if the next digit is six or more, or a five followed by one or more non-zero digits. Also will increase the last digit by one if the next digit is five followed by zeros when the last digit is odd.
Check-in the XML file to save the changes to the database.
Note: The currency rounding is applied first based on the currency round places determined in step 7. Then, the result is truncated based on the display rounding places defined in step 6.
Open the Admin Explorer window.
Double-click the Currency folder.
Right-click the currency XML file and select Check-Out. Each currency row contains five pieces of information.
Currency Code: Displays the currency code. Code names cannot be changed.
Currency Name: Displays the currency name. Display names can be updated.
Display Round Places: Determines the number of decimal places the currency will be rounded to for display purposes.
Currency Round Places: Indicates the number of digits to the right of the decimal place to keep after a currency calculation is performed.
Currency Round Method: Determines the type of rounding method to employ once a calculation is performed. There are three options:
Arithmetic Round: Increases the last digit by one if the next digit is five or greater.
Round Down: Leaves the last digit the same, regardless of the next digit.
Round to Even: Increases the last digit by one if the next digit is six or more, or a five followed by one or more non-zero digits. Also will increase the last digit by one if the next digit is five followed by zeros when the last digit is odd.
Find the name of the currency for update in the Currency Name column. The currency attributes that can be changed are in the columns to the right and are accompanied by a drop-down list.
Click the down arrow next to the attribute to change. The currency’s row will appear highlighted in green.
Make the necessary currency rounding adjustments.
Check-in the file to save the changes to the database.
Currency File in Admin Explorer
Copyright © 2009, 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices