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