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

This topic describes the process required to migrate Oracle Billing Insight version 7.0 to Oracle Billing Insight version 7.1.

To migrate from Oracle Billing Insight version 7.0 to version 7.1, perform the following tasks:

1. Back up your existing OLTP and OLAP Oracle Billing Insight databases.

   For additional information, see Oracle Database 12c documentation on Oracle Technology Network.

2. Start the database instance that accesses the database you are upgrading. Check the status of all user objects. If any of them indicate an INVALID status, then contact the database administrator to correct this problem.

   For additional information, see Oracle Database 12c documentation on Oracle Technology Network.

3. Have any existing Oracle Billing Insight database passwords available.

   Check with your database administrator.

4. Process all pending notifications in Oracle Billing Insight version 7.0.

   For details on how to run the Notifier job, see Administration Guide for Oracle Billing Insight, version 7.0.

5. Process all pending batch reports in Oracle Billing Insight version 7.0

   For details on how to run the batch report jobs, see Administration Guide for Oracle Billing Insight, version 7.0.

6. Write down your payment gateway and job configuration settings as shown in the Command Center. You must reenter the settings after migrating.
7. Write down your Command Center admin user names. You must recreate these users after migrating.
8. Perform the following installation tasks:
   1. Checking the Integrity of the Oracle Billing Insight Installer Package
   2. Installing the Oracle Billing Insight Software Using InstallAnywhere. Select Option 2, Oracle E-Billing and Migration Tools on the Product Features Screen.
   3. Go to My Oracle Support (MOS) and open a Service Request (SR) to receive the Oracle Billing Insight v7.1.0.1 patch. Follow the steps in the Patch 1 release notes to install the patch.
   4. Configuring Log File Paths for Log4j
9. Perform the following migration tasks:
   1. Migrate the OLTP schema and data. Run Options 1, Migrate OLTP schema, and 2, Migrate OLTP data in Migrating Oracle Billing Insight Version 7.0 OLTP to Oracle Billing Insight Version 7.1. (Do not run Options 3 and 4 yet.)
   2. Migrating Oracle Billing Insight Version 7.0 OLAP to Oracle Billing Insight Version 7.1
   3. Migrating Batch Reports from Oracle Billing Insight Version 7.0 to Oracle Billing Insight Version 7.1
10. Run the following command on both the OLTP and OLAP schemas to verify that all objects are valid. The correct result is zero. Connect as the OLTP and OLAP schema owner.

    select count(*) from user_objects where status ='INVALID';

11. If you use currency symbols other than USD, migrate the currency symbol information. Follow Migrating Currency Symbol Data
12. If you ran the master key update process on Oracle Billing Insight version 7.0, then you must copy the version 7.0 EDX_HOME/keystore directory to version 7.1. Otherwise, encryption and decryption will not work.
13. Configure your application server for Oracle Billing Insight version 7.1.

    Follow Roadmap for Configuring Oracle WebLogic for Oracle Billing Insight.

14. Follow the tasks and processes in Roadmap for Configuring the Data Load Processes for Oracle Billing Insight.
15. Uninstall Oracle Billing Insight version 7.0.

    For information about uninstalling, see Uninstalling Oracle Billing Insight.

16. Enable password auto-migration. Open the cryptography.xma.xml file, located in the following directory, and set the passwordMigrationEnabled property to true:
    • UNIX. EDX_HOME\xma\config\modules\cryptography
    • Windows. EDX_HOME/xma/config/modules/cryptography

      Migrating passwords enables the Self-Service application and the Assisted Service application users to log in with their passwords from version 7.0.

17. Recreate the Command Center admin users, using the bootstrap user.

    For details, see Administration Guide for Oracle Billing Insight.

18. Recreate the payment gateway and jobs, using the Command Center.

    For details, see Administration Guide for Oracle Billing Insight.

19. If you have debit card type payment accounts with Chase Paymentech Orbital or PayPal Payflow Pro gateways, then run the OLTP migration script as described in Migrating Oracle Billing Insight Version 7.0 OLTP to Oracle Billing Insight Version 7.1, and select Option 3, Convert payment accounts with debit card type to credit card.
20. If you have payment accounts created for Chase Paymentech Orbital or PayPal Payflow Pro gateways, then run the OLTP migration script as described in Migrating Oracle Billing Insight Version 7.0 OLTP to Oracle Billing Insight Version 7.1, and select Option 4, Tokenize payment accounts for Chase Paymentech Orbital and PayPal Payflow Pro gateways only.

NOTE:  Debit cards are not supported in Oracle Billing Insight version 7.1 and will process as a credit card transaction.