ORACLE APPLICATIONS UPGRADE

1
ORACLE APPLICATIONS UPGRADE
11i
10.7
2
Need for Upgrade

• Advantage of 11i Features and Functionality
• Reduced IT cost infrastructure

Lowering the cost of Ownership Lowering the cost
of Administration Improved Decision Making

• Standard Support for release 10.7 SC ended at
  2000 and
• Transition Support will end mid 2001.
• Transition Support for 10.7 character is
  likely to end by 2002.

3
Release 11i offers
Internet Computing Architecture
Application Implementation Wizard
New applications like Treasury, Property Manager
Multi-National Organization Support
Customizable On-Line Help
4
Internet Computing Architecture
5
Application Implementation Wizard

• Provides Step-by-Step Guidance
• Increase Productivity by reduced effort and
  time
• Lower implementation risk
• Effective Management of implementation
• Easy Upgrade of production system from 11 to
  11i

6
Some New Applications in 11i

• Self-Service Expenses
• Self-Service Purchasing
• Self-Service Time
• Treasury
• Property Manager

7
Release 11i Enhancements

• Increased Performance using Oracle 8i
• Improved Usability
• Rapid Installation
• Simplified Maintenance
• web-deployed user interface over character mode
  or
• client/server systems
• Eliminates Desktop software install/upgrade
• Improved WAN operation
• Personalized homepage on desktop for accessing
  all
• ERP,CRM products

8
User Interface Enhancements

• Multiple Document Interface
• Oracle Look and Feel broader range of colors
• Required fields indicated by distinct
  background colors
• List of Values (LOV) indicator fields
  associated with
• LOVs are clearly marked

9
Minimum 11i System Requirements

• Oracle 8i Enterprise Edition 8.1.6
• 8.0.6 Oracle Home
• Forms Server
• Reports Server
• WebDB 2.2 Listner
• Applications Servers
• WebDB 2.5 and Apache 1.3.9 with JServ 1.1
• Java Runtime Environment 1.1.8
• Jinitiator 1.1.7 on client

10
Upgrading from 10.7 to 11i

• Database Upgrade
• Application Tools Upgrade
• Customized Applications to 11i
• Tune 11i to existing system requirements

11
Database Upgrade
RDBMS 7.3/8
RDBMS 8i
12
Database Upgrade

• 11i requires 8i Enterprise Edition DB Server
• Database should be upgraded first before
  application
• upgrade
• Database Migration will improve the
  scalability/performance

13
Database Upgrade Steps

• Create Empty Database on Target
• Run the preparatory Scripts for Target
• Export Oracle Database
• Create missing objects
• Update Table space Information
• Verify Oracle Applications product on Target

14
Application Tools Upgrade

• Upgrade Application Tools for new version
• Forms
• Reports
• PL/SQL
• Workflow (Install)
• Setup Environment Variables
• Environment Files (.env) Setup
• Configuration Files Setup

15
Application Tools Upgrade
16
Customized Applications to 11i

• Identify all Custom Objects
• Forms
• Reports
• PL\SQL
• Workflow, etc
• Identify all Custom added Database objects
• Schemas
• Tables
• Stored Procedures, etc

17
Customized Applications to 11i

• Upgrade custom objects to 11i
• Upgrade all Custom Database objects
• Incorporate changes due to schema modifications
• between the two versions of Oracle
  Applications.
• Test all upgraded objects under 11i environment

18
Forms Upgrade to 11i
19
Forms Upgrade to 11i

• Upgrade custom libraries
• Convert 4.5 forms to 6i
• Perform changes to meet 11i application
  coding
• standards
• Perform required manual changes
• Compile to get new .fmx files

20
Required Menu Changes
In Release 11i..

• Most internal names of menu items have changed
• No Toolbar block the toolbar is just an
  extension of the menu

Upgrade process should

• modify some Menu calls
• modify Toolbar calls

21
Required Manual Changes
11i
22
Optional Form Changes for 11i

• Alternative regions ? Tabbed regions
• Left block scrollbars ? Right scrollbars
• Modify form code to handle flexible date
  formatting
• Modify form code to handle flexible number
  format
• Customize right mouse button menus
• Add help buttons to modal windows

23
After you Upgrade to 11i

• Drop unneeded database objects
• Install On-Line Help
• Drop obsolete product files
• Drop obsolete columns in tables
• Drop unnecessary indexes

24
Why KUMARAN ?

• World Leader in ORACLE Migration
• Unique Tools for Migration
• Forms Converter V2 to V3
• GUI Converter V3 to V4.5/5/6/6i
• Object Converter v4.5 to Higher
• Well Developed Process Methodology

25
KUMARANs Methodology
Analysis
Migration
Test
Training Documentation
Maintenance