Customer Data Migration
This section outlines the steps for migrating customer data to an Oracle Utilities Customer Cloud Service implementation that includes Customer Care and Billing, Meter Data Management, and Operational Device Management functionality.
Legacy Customer Information System Upgrading to Oracle Utilities Customer Cloud Service
In this scenario a new customer using a legacy CIS application is upgrading to Oracle Utilities Customer Cloud Service. The steps outlined below apply to Master data only.
| Step | Description | Remarks |
|---|---|---|
| 1 | Transform legacy person, account, premise, service point and service agreement to CC&B person, account, premise, service point and service agreement. | This step is performed outside of the cloud service. |
| 2 | Transform legacy meter/item, meter/item configuration, and register to CC&B meter/item, meter/item configuration, and register. | This step is performed outside of the cloud service. |
| 3 | Transform legacy meter/item history to CC&B SP meter/item history. | This step is performed outside of the cloud service. |
| 4 | Extract files based on the CC&B master entities (person, account, premise, service point, service agreement, meter/items, and meter/item history). | This step is performed outside of the cloud service. |
| 5 | Upload master data files into Oracle Object Storage. | This step is performed outside of the cloud service. |
| 6 | Run the SQL Loader batch process to load data from the master data files into the staging schema objects. | |
| 7 | Generate Keys, perform Validations, and insert data into the production schema. | |
| 8 | Perform validation in the production schema | |
| 9 | Run the Admin migration (X1-MIGAD) batch process | |
| 10 | Migrate CC&B Person, Service Point, and Service Agreement, to MDM Contact, Service Point, and Usage Subscription | |
| 11 | Migrate CC&B Meter/Item (including meter/item configuration and register) to MDM Device/ODM Asset | |
| 12 | Migrate CC&B SP Meter/Item History to MDM Install Event/ODM Asset Node |
Customer Care and Billing Upgrading to Oracle Utilities Customer Cloud Service
In this scenario an existing Customer Care and Billing customer is upgrading to Oracle Utilities Customer Cloud Service. The steps outlined below apply to Master data only.
| Step | Description | Remarks |
|---|---|---|
| 1 | Export CC&B database to a single instance database. | This step is performed outside of the cloud service. |
| 2 | Perform database upgrade to match your cloud service supported version. | This step is performed outside of the cloud service. |
| 3 | Extract master data files based on CC&B master entities from the upgrade database, and upload files to Oracle Cloud ObjectStorage. | This step is performed outside of the cloud service. |
| 4 | Run the SQL Loader batch process to load data from the master data files into the production schema. | |
| 5 | Perform validation in the production schema | |
| 6 | Run the Admin migration (X1-MIGAD) batch process | |
| 7 | Migrate CC&B Person, Service Point, and Service Agreement, to MDM Contact, Service Point, and Usage Subscription | |
| 8 | Migrate CC&B Meter/Item (including meter/item configuration and register) to MDM Device/ODM Asset | |
| 9 | Migrate CC&B SP Meter/Item History to MDM Install Event/ODM Asset Node |
Integrated Customer Care & Billing and Meter Data Management Upgrading to Oracle Utilities Customer Cloud Service
In this scenario an existing customer using integrated CC&B and MDM applications is upgrading to Oracle Utilities Customer Cloud Service. The steps outlined below apply to Master data only.
| Step | Description | Remarks |
|---|---|---|
| 1 | Export CC&B database to a single-instance database. | This step is performed outside of the cloud service. |
| 2 | Perform database upgrade to match your cloud service supported version. | This step is performed outside of the cloud service. |
| 3 | Export MDM database to a single-instance database. | This step is performed outside of the cloud service. |
| 4 | Perform database upgrade to match your cloud service supported version. | This step is performed outside of the cloud service. |
| 5 | Extract master data files based on CC&B master entities from the upgrade database, and upload files to oracle cloud object storage. | |
| 6 | Extract master data files based on MDM master entities from the upgrade database, and upload files to oracle cloud object storage. | |
| 7 | Run the SQL Loader batch process to load data from the master data files (CC&B and MDM) into production schema | |
| 8 | Update the Business Object field in the following tables:•D1_SP: from "D1-ServicePoint" to "X1D-ServicePoint" object.•D1_SP_TYPE: “D1-ServicePointType” to “X1D-ServicePointType”. | |
| 9 | Perform validations in the production schema | |
| 10 | Convert MDM meters to ODM assets. | The following steps only apply if ODM functionality is included. |
| 11 | Synchronize MDM service points to ODM service points. | |
| 12 | Synchronize MDM install events to ODM asset dispositions. | |
| 13 | Create the MDM device identifiers from ODM asset identifiers. |
Integrated Customer Care & Billing, Meter Data Management and Operational Device Management Upgrading to Oracle Utilities Customer Cloud Service
In this scenario an existing customer using integrated CC&B, MDM and ODM applications is upgrading to Oracle Utilities Customer Cloud Service. The steps outlined below apply to Master data only.
| Step | Description | Remarks |
|---|---|---|
| 1 | Export CC&B database to a single-instance database. | This step is performed outside of the cloud service. |
| 2 | Perform database upgrade to match your cloud service supported version. | This step is performed outside of the cloud service. |
| 3 | Export MDM database to a single-instance database. | This step is performed outside of the cloud service. |
| 4 | Perform database upgrade to match your cloud service supported version. | This step is performed outside of the cloud service. |
| 5 | Export ODM database to a single-instance database. | This step is performed outside of the cloud service. |
| 6 | Perform database upgrade to match your cloud service supported version. | This step is performed outside of the cloud service. |
| 7 | Extract master data files based on CC&B master entities from the upgrade database, and upload files to oracle cloud object storage. | |
| 8 | Extract master data files based on MDM master entities from the upgrade database, and upload files to oracle cloud object storage. | |
| 9 | Extract master data files based on ODM master entities from the upgrade database, and upload files to oracle cloud object storage. | |
| 10 | Run the SQL Loader batch process to load data from the master data files (CC&B, MDM, and ODM) into production schema | |
| 11 | Update the Business Object field in the following tables:•D1_SP: from "D1-ServicePoint" to "X1D-ServicePoint" object.•D1_SP_TYPE: “D1-ServicePointType” to “X1D-ServicePointType”. | |
| 12 | Perform validations in the production schema |
Customer Care and Billing Upgrading to Oracle Utilities Customer Care and Billing Cloud Service
In this scenario an existing customer using CC&B applications is upgrading to Oracle Utilities Customer Care and Billing Cloud Service. The steps outlined below apply to Master data only.
| Step | Description | Remarks |
|---|---|---|
| 1 | Export CC&B database to a single-instance database. | This step is performed outside of the cloud service. |
| 2 | Perform database upgrade to match your cloud service supported version. | This step is performed outside of the cloud service. |
| 3 | Extract master and transactional data files based on the CCB entities from the upgraded database and upload files to Oracle Cloud Object Storage. | |
| 4 | Run the SQL Loader batch process to load data from the master and transactional data files into the production schema objects. | |
| 5 | Perform validation in the production schema |
Customer Care and Billing and Oracle Utilities Meter Solution Cloud Service Upgrading to Oracle Utilities Customer Cloud Service
In this scenario an existing customer using CC&B and MSCS applications is upgrading to Oracle Utilities Customer Cloud Service (CCS). The steps outlined below apply to Master data only.
| Step | Description | Remarks |
|---|---|---|
| 1 | Export CC&B database to a single-instance database. | This step is performed outside of the cloud service. |
| 2 | Perform database upgrade to match your cloud service supported version. | This step is performed outside of the cloud service. |
| 3 | Take a clone of the MSCS Production environment and migrate it to CCS | This step is performed by Oracle Cloud Operations via a Service Request. |
| 4 | Review and Create missing CC&B-related table partitions and migrated the CC&B configuration to CCS. | |
| 5 | Extract master and transactional data files based on the CC&B entities from the upgraded database and upload files to Oracle Cloud Object Storage. | |
| 6 | Run the SQL Loader batch process to load data from the master and transactional data files into the production schema objects. | |
| 7 | Perform validation in the production schema | |
| 8 | Run the Admin Migration (X1-MIGAD) batch process. | |
| 9 | Migrate the CC&B Person, Service Point, and Service Agreement to MDM Contact, Service Point, and Usage Subscription. | |
| 10 | Migrate CC&B Meter/Item (including Meter/Item configuration and register data) to MDM Device/ODM Asset. | |
| 11 | Migrate CC&B SP Meter/Item History to MDM Install Event / ODM Asset Node. |