Contents

1. Preface

  • 1.1 Introduction
  • 1.2 Intended Audience
  • 1.3 Documentation Accessibility
  • 1.4 Scope
  • 1.5 Organization
  • 1.6 Related Information Sources

    • 2. Upgrade and Conversion Approach

  • 2.1 Introduction
  • 2.2 Approach - Data Import to Target Schema
  • 2.2.1 Advantages
  • 2.2.2 Disadvantages
  • 2.3 Upgrade Process Summary

    • 3. Mock Upgrade

  • 3.1 Introduction
  • 3.2 Prerequisites
  • 3.3 Mock Upgrade Activity
  • 3.3.1 Applying Temp Soft Changes
  • 3.3.2 Setting up Target Schema
  • 3.3.3 Upgrading Database
  • 3.3.4 Deploying Front End Application
  • 3.3.5 Impact on Existing External System Interfaces
  • 3.3.6 Verifying Data after Database Upgrade

    • 4. Module Upgrade

  • 4.1 Introduction
  • 4.2 Scope
  • 4.3 Upgrade of Revamped Modules
  • 4.4 Migrating Data from Loans and Deposits to Consumer Lending Module
  • 4.4.1 Migrating Products from LD to CL
  • 4.4.2 Migrating Contracts from LD to CL
  • 4.4.3 Migrating Commitments
  • 4.5 Migrating Data from LM Module to ELCM Module
  • 4.5.1 Migration Approach
  • 4.5.2 Prerequisites
  • 4.5.3 Enabling Triggers
  • 4.5.4 Migrating Data
  • 4.5.5 Truncating Database
  • 4.6 Migrating Data from Branch to Retail Teller
  • 4.7 ATM/POS Modules Impact
  • 4.8 Upgrading Existing Modules
  • 4.8.1 Generic Conversion Methods
  • 4.8.2 Upgrading Core Module
  • 4.8.3 Upgrading SMS Module
  • 4.8.4 Upgrading Deposits Module
  • 4.8.5 Dynamic Package Generation for IC Rule
  • 4.8.6 Dynamic Package Generation for Products in CD/MM
  • 4.8.7 Upgrading PC Module
  • 4.8.8 LC Module - Tracers Generation
  • 4.8.9 Upgrading CASA Module - Lower Case Alphabets in Account Number
  • 4.9 Module Wise Verification Check Points

    • 5. Cut-over Upgrade Activities

  • 5.1 Introduction
  • 5.2 Activities in Production Environment
  • 5.3 Database Upgrade in Production Environment
  • 5.4 Installation of Other Components

    • 6. Conversion Script Generation Tool

  • 6.1 Introduction
  • 6.2 Generating and Executing Scripts
  • 6.2.1 Setting up Parameters
  • 6.2.2 Generating Dynamic Scripts and Spooling Files
  • 6.2.3 Generating Dynamic Script for Specific Modules
  • 6.2.4 Generating Dynamic Script for Specific script_identifier
  • 6.2.5 Generating Dynamic Script for Aborted Script Identifiers
  • 6.2.6 Spooling Module-wise Spool Files and Control File for a Run Number

    • 7. Data Reconciliation

  • 7.1 Introduction
  • 7.2 Setting Up New Environment
  • 7.3 Releasing Additional Units - Delta Release
  • 7.4 Changing Source and Target Schema in Existing System
  • 7.5 Generating Reports
  • 7.5.1 Generating Migration Reconciliation Report
  • 7.5.2 Generating Adhoc Reconciliation Report
  • 7.5.3 Generating Parallel Run Reconciliation Report
  • 7.5.4 Moving Extraction Data into History Table

    • 8. Annexure

  • 8.1 Utility Scripts

    • 9. Function ID Glossary