Installation Guide for Oracle Billing Insight > Migrating to Oracle Billing Insight 7.1 > Process of Migrating Oracle Billing Insight Version 7.0 to Version 7.1 >

Migrating Currency Symbol Data

If you use currency symbols other than USD (United States dollar), you must populate two new columns that were added to the EDX_RPT_CURRENCY_TYPE_DIM table for these currencies. (The migration script automatically populates the columns for USD.)

To populate the EDX_RPT_CURRENCY_TYPE_DIM table with additional currency symbol data

1. Create a master file with a 270 record for each currency you have in the EDX_RPT_CURRENCY_TYPE_DIM table. For each record, add values for the following columns.

   Column in the EDX_RPT_CURRENCY_TYPE_DIM Table	Value to specify
   CURRENCY_TYPE_SYMBOL	Currency symbol
   CURRENCY_IS_DEFAULT	Whether to use this currency as the system default. Y=Yes, N=No

   For details on the currency table record format, see Implementation Guide for Oracle Billing Insight.

2. Run the load master file ODI process to load the updated 270 records.