Cloud Services Implementation Guide
Implementation Guidelines
Post-Provisioning Setup
Before You Begin
Before You Begin
Initial Identity Management Setup
Initial Object Storage Setup
Initial Cloud Service Setup
Process Automation Tool Setup
Initial Cloud Service Setup - Adding a New Environment to an Existing Cloud Service
Process Automation Tool Setup (for a newly provisioned environment)
Process Automation Tool Setup (for existing cloud environments)
Security Setup
Configure Product Use Metrics
Configure Master Configuration
Configure Snapshot Business Objects and Algorithms (Optional)
Batch Processing
Language Pack Setup (Optional)
Available Languages with Cloud Services
Setup Instructions
Oracle Guided Learning Integration (Optional)
Security and Access
Identity Management
Use of Identity Domains in OCI Identity and Access Management
User Provisioning with Identity and Access Management
Server Access
SMTP Integration
Batch Error / Completion Notification
Additional Options for Extracting and Sending Data via Email Delivery
Configuration Tools
Customization Tools Summary
Algorithm Types and Algorithms
Application Environments
Environment Names and Codes
Environment Type Use Cases
Additional Environment Resources
Application / Environment Access and URL Tokens
Creating Batch Processes
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
Information Lifecycle Management
Information Lifecycle Management Overview
Initial Configuration During Provisioning
Configuration During Implementation
ILM Configuration
ILM Configuration - MDM Sub-Retention
Recommendations
Go-Live Checklist
Network Integration Guidelines for Integrating Oracle Utilities Cloud Services with External Applications
Introduction
Integrate Oracle Utilities Cloud Services Using Web Services
Architecture 1: Integrating Through Public (Internet) Web Service APIs
Architecture 2. Integrating Through VPN Connect
Architecture 3. Integrating Through FastConnect for Private Web Service APIs
Network Scenarios
Scenario 1: Connect Over Public Internet Without VPN or FastConnect
Scenario 2: Connect Over Public Internet With VPN but Without FastConnect
Scenario 3: Connect Over FastConnect Without VPN
Scenario 4: Connect Over Public Internet with VPN and FASTConnect
Integrate Oracle Utilities Cloud Services using File Transfers
Allowing Inbound-Outbound Communication by Using File Transfers
Understanding Connection Technologies
Understanding Akamai Networking Usage for Oracle Utilities Cloud Services
Understanding Oracle VPN Connect
Understanding Oracle Cloud Infrastructure FastConnect
Understanding Private Endpoints
Accessing SaaS Applications Using the Service Gateway
Understanding the Differences Between VPN Connect and OCI FastConnect
Migrating Legacy Custom Tables and Java to Oracle Utilities Cloud Services
Introduction
Migration Features
Process
Custom Tables in Oracle Utilities Cloud Services
Restrictions
Implementation Details
Table Definition and Maintenance Process
Guidelines for Migrating Tables
Custom Java in Oracle Utilities Cloud Services
Restrictions
Code Migration Process
Upload and Process API
Preparing and Deploying
Advanced Operations
Allow and No Allowlist Of Java Classes
Migration using Content Migration Assistant
Other Object Types
Appendix - Database Naming Conventions
Tables
Columns
Indexes
Frequently Asked Questions
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 Guidelines
Data Conversion Approach
Data Conversion Tips
Go-Live Checklist
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
Oracle Database Actions
REST APIs
Product-Specific Integrations
Customer Cloud Service Receipt Printing
Application 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 25.4 Implementation Guide