Cloud Services Implementation Guide
Implementation Guidelines
Post-Provisioning Setup
Initial Identity Management Setup
Initial Object Storage Setup
Initial Cloud Service Setup
Process Automation Tool Setup (for a new cloud service)
Process Automation Tool Setup (after adding new environments to your cloud service)
Language Pack Setup (Optional)
Available Languages with Cloud Services
Setup Instructions
Security and Access
Identity Management
Use of Identity Domains in OCI Identity and Access Management
User Provisioning with Identity and Access Management
Server Access
Configuration Tools
Customization Tools Summary
Algorithm Types and Algorithms
Application Environments
Environment Names and Codes
Application / Environment Access and URL Tokens
Creating Batch Processes
Data Conversion Guidelines
Data Conversion Approach
Data Conversion Tips
Integration Guidelines
Integration Methods
Integration Method: File-Based
Integration Method: Web Services
Integration Middleware
Integration Middleware: Oracle Integration Cloud (OIC)
Integration Middleware: Oracle SOA Suite on Marketplace - Platform-as-a-Service
Integration Middleware: Oracle SOA Suite On-Premises
Allowlisting
IP Allowlisting
Data Access and Analytics
Analytics Publisher
Database Access
Reports and Queries
File Access - Cloud Object Storage
Uploading and Downloading File To and From Object Storage
Data Conversion and Migration
Overview
Data Conversion and Migration Overview
Conversion Process Overview
Implementation Effort
What Is in the Newly Provisioned Environment?
Data Conversion and Migration on Cloud
Terms and Definitions
Database Tables
Scope and Assumptions
Additional Information
Data Conversion and Migration Scenarios
Legacy Customer Information System to C2MO
Legacy Customer Information System to C2M
Legacy Meter Data Management to MDM/ODM
Customer Care and Billing to C2M
Customer Care and Billing to C2MO
Customer Care & Billing and Meter Data Management to C2M
Customer Care & Billing and Meter Data Management and Operational Device Management to C2MO
Customer Care & Billing and Meter Data Management to C2MO
Meter Data Management to MDM/ODM
Data Conversion and Migration Design
Extract/Upload by Table or Maintenance Object
CLOB Data in a Secondary File
Multiple Data Files for Single Table or MO Upload
Data Conversion and Migration Processes
Customer Data Migration
Legacy Customer Information System Upgrading to Oracle Utilities Cloud Service
Customer Care and Billing Upgrading to Oracle Utilities Cloud Service
Integrated Customer Care & Billing and Meter Data Management Upgrading to Oracle Utilities Cloud Service
Integrated Customer Care & Billing and Meter Data Management Upgrading to Oracle Utilities Cloud Service
Integrated Customer Care & Billing, Meter Data Management and Operational Device Management Upgrading to Oracle Utilities Cloud Service
Meter Data Management Install Event Migration
Meter Data Migration
Legacy Meter Data Management Upgrading to Oracle Utilities Meter Solution Cloud Service
Meter Data Management Upgrading to Oracle Utilities Meter Solution Cloud Service
Integrated Meter Data Management and Operational Device Management Upgrading to Oracle Utilities Meter Solution Cloud Service
Meter Conversion
Binding Meter Data Management Device IDs and Operational Device Management Asset IDs
Asset Conversion
Measurement Data Migration
Required Configuration for Measurement Upload
Preparing for Conversion
Preparing Environment for Conversion
Set Up Conversion Security
Prepare Environment for Conversion
Preparing Legacy Data Extract for Upload
ILM Date Fields
Data Conversion and Migration Steps
Upload Data into a Table or Maintenance Object
Review Input Data File Spec
Create Input Data File(s)
Switch Schema
Cleanup Target Table
Upload Data
Populate Key Table(s)
Data Upload Orchestration
Single Table Upload
Multiple Tables or MOs Upload
Full Conversion Chain per MO, Parallel Run
Upload All + Subsequent Validate/Transform MOs
Customizing Data Conversion and Migration
Why Customize
When to Customize
What to Customize
Control File
Additional Customization Items
How to Customize
Tips and Important Mistakes to Avoid
Sample Artifacts and Data Files
File-Based Integration
Object Storage Connection Management
Oracle Object Storage Setup
Oracle Utilities Cloud Service Configuration for Object Storage Connection
Creating API Keys
Creating An Object Storage Connection
Register API Key to Oracle Cloud Object Storage
File Export Sample Implementation
Creating a File Export Batch Process
Configuring the Export Process
Setting Up Communication Between Cloud Service and Object Storage
Configuring File Export Batch Parameters
Testing the Export Process
File Import Sample Implementation
Identifying Upload File Content Data
Uploading File to Oracle Cloud Object Storage
Creating a File Import Batch Process
Plug-In Script
Algorithm Type and Algorithm
File Upload Batch Control
Configuring the Import Process
Setting Up Communication Between Cloud Service and Object Storage
Configuring File Import Batch Controls
Testing the Import Process
Oracle REST Data Services
SQL Developer Web
REST APIs
Product-Specific Integrations
Customer Cloud Service Receipt Printing
Oracle Utilities Cloud Services Configuration
Configuring the Point of Sale Printer Integration Master Configuration
Configuring UI Maps and BPA Scripts
Printer Installation
Recommended Printer Preferences
Printer Preferences for Endorsements and Stubs
Printer Preferences for Payment Receipts
Browser Printer Settings
Web Services
Web Services in Oracle Utilities Cloud Services
Inbound Web Services
SOAP Inbound Web Services
REST Inbound Web Services
Outbound Messages
Using SOAP Services
Using REST Services
Web Service Catalog on Cloud Services
Web Service Catalog on On-Premises Applications
User Rights
Debugging & Tracing Options
REST Inbound Web Services
SOAP Inbound Web Services
Cloud Services Implementation Guide
Oracle Utilities Cloud Services 22B Implementation Guide