• Oracle Utilities Customer Care and Billing Database Administrator’s Guide
• Database Overview
  • Supported Database Platforms
    • Supported Platforms Summary Table
    • Support for Software Patches and Upgrades
  • Database Maintenance Rules
    • Permitted Database Changes
    • Non-Permitted Database Changes
• Installing the Database
  • Installation Overview
    • Creating the Database
  • Installing the Oracle Database
    • Database Scripts and Utilities
    • Initial Install (Installing v2.9.0.0.0 for the First Time)
    • Installing the CISADM Schema
    • Upgrade Install
    • Demo Install
• Database Design
  • Database Object Standard
    • Categories of Data
    • Naming Standards
  • Column Data Type and Constraints
    • User Defined Code
    • System Assigned Identifier
    • Date/Time/Timestamp
    • Number
    • Fixed Length/Variable Length Character Columns
    • Null Column Support
    • XML Type Support
    • Cache and Key Validation Flags
    • Table Classification and Table Volume Flags
    • Default Value Setting
    • Foreign Key Constraints
  • Standard Columns
    • Owner Flag
    • Version
• Database Implementation Guidelines
  • Configuration Guidelines
    • Index
    • Table Partitioning Recommendations
    • Transparent Data Encryption Recommendations
    • Data Compression Recommendations
    • Database Vault Recommendations
    • Oracle Fuzzy Search Support
    • Information Lifecycle Management (ILM) and Data Archiving Support
    • Storage Recommendations
    • ILM Enabled Tablespace Requirements
    • Database Configuration Recommendations
    • Database Syntax
    • Database Initialization Parameters
  • Oracle Database Implementation Guidelines
    • Oracle Partitioning
    • Database Statistic
    • Materialized View
• Conversion Tools
  • Database Configuration
  • Installing the Script
  • Preparing the Production Database
  • Preparing the Staging Database
    • Linux/UNIX:
  • Upgrading the Production Database
  • Upgrading the Staging Database
• Information Lifecycle Management and Data Archiving in CCB
  • ILM Implementation Overview
  • ILM Implementation Components
  • ILM Database Administrator’s Tasks
    • Preparation Phase
    • On-going Maintenance Phase
  • Naming Convention
• Sample SQL for Enabling ILM in CCB (Initial Install)
  • Maintenance Object: TO DO ENTRY
    • Parent Table: CI_TD_ENTRY
    • Child Table: CI_TD_DRLKEY
    • Child Table: CI_TD_ENTRY_CHA
    • Child Table: CI_TD_LOG
    • Child Table: CI_TD_MSG_PARM
    • Child Table: CI_TD_SRTKEY
  • Maintenance Object:F1-SYNCREQIN
    • Parent Table: F1_SYNC_REQ_IN
    • Child Table: F1_SYNC_REQ_IN_CHAR
    • Child Table: F1_SYNC_REQ_IN_EXCP
    • Child Table: F1_SYNC_REQ_IN_EXCP_PARM
    • Child Table: F1_SYNC_REQ_IN_LOG
    • Child Table: F1_SYNC_REQ_IN_LOG_PARM
    • Child Table: F1_SYNC_REQ_IN_REL_OBJ
• Sample SQL For Enabling ILM in CCB (Existing Installation)
• Sample SQL for Periodic Maintenance
  • Add Partition
  • Archive Partition
  • Restore Partition
• Sample SQL for ILM in CCB
  • Maintenance Object: Adjustment
    • Parent Table: CI_ADJ
  • Maintenance Object: Bill Segment
    • Parent Table: CI_BSEG
• Sample Scripts for Customer Contact Enhancement
  • Updating Customer Contact Account and Premise
  • Updating Preferred Contact Method on Legacy Values
• Upgrades to the Oracle Utilities Customer Care and Billing 2.9.0.0.0 Database
• Upgrades to the Oracle Utilities Application Framework Database
  • Upgrading from Oracle Utilities Application Framework v4.3.0.1.0 to v4.3.0.2.0
  • Upgrading from Oracle Utilities Application Framework v4.3.0.2.0 to v4.3.0.3.0
  • Upgrading from Oracle Utilities Application Framework v4.3.0.3.0 to v4.3.0.4.0
  • Upgrading from Oracle Utilities Application Framework v4.3.0.4.0 to v4.3.0.5.0
  • Upgrading from Oracle Utilities Application Framework v4.3.0.5.0 to v4.3.0.6.0
  • Upgrading from Oracle Utilities Application Framework v4.3.0.6.0 to v4.4.0.0.0
  • Upgrading from Oracle Utilities Application Framework v4.4.0.0.0 to v4.4.0.2.0
  • Upgrading from Oracle Utilities Application Framework v4.4.0.2.0 to v4.4.0.3.0
  • Upgrading from Oracle Utilities Application Framework v4.4.0.3.0 to v4.5.0.0.0
• Oracle Utilities Application Framework System Table Guide
  • About the Application Framework System Tables
  • System Table Standards
  • Guidelines for System Table Updates
    • Business Configuration Tables
    • Development and Implementation System Tables
  • System Table List
• Sample SQL Script for Interval Partitioning

Oracle Utilities Customer Care and Billing Database Administrator’s Guide

Oracle Utilities Customer Care and Billing Release 2.9.0.0.0 Database Administrator’s Guide