Database Upgrade Service

Architecture and Technology

R11i & R12 Technology Contrast

 

R11i & R12 Component Contrast

Component
11.5.9
R12 (12.1.2)
Database Server
9.2.0.5
10.2.0.3
Web Server
iAS 1.0.2.2.2
AS 10g 10.1.3
Java Servlet Container
Jserv
OC4J
Forms Server
Developer 6i
AS 10g 10.1.2
Java Development Kit
JDK 1.4 – 1.4.2
JDK 5.0
Client Viewer
Jinitiator
Sun JRE

 

Technology – Change from R11i to R12

New Features in R12

  • AutoConfig can be run in parallel on different nodes of Apps
  • Technology Stack Inventory Validation Report
  • Shared Application Tier File System Amongst Multiple EBS Instances
  • Record History is now available for OA Framework based pages
  • Concurrent requests and managers can now be directed to a specific database instance or node

Analysis and Planning

Why update?

IT Drives
Business Drivers
Supportability
New Modules
Stability
New features & functionality
Improved performance
New requirements
New features
Re-engineer
Maintenance cost
Design Improvements
Out of box use

 

Customizations

 

 

 

EBS Support

Release
GA date
Premier Support Ends
Extended Support Ends
Sustaining Support Ends
11.5.9
Jun 2003
Jun 2008
Not Offered
Indefinite
11.5.10
Nov 2004
Nov 2010
Nov 2013
Indefinite
12
Jan 2007
Jan 2012
Jan 2015
Indefinite

 

 

Features in R12

  • Think Globally
  • Work Globally
  • Manage Globally
  • Reduced pop-ups & duplicate screens
  • Reduced steps to complete key tasks
  • Improved look, feel and visual style
  • Increased personalization capabilities
  • New functionality in the Financials area
  • The best in technology : 10gR2 & 10gAS

 

Application Migration Path

 

Upgrade Path

Applications R11.5.7 and up can be directly upgraded to R12

Database in all releases must have been upgraded to 10gR2 (11.5.9.2/11.5.10.2) or should be done during upgrade to R12 (11.5.9.1/11.5.10.1 and below)

 

Simple Project Plan

Items
Phase
Tasks
Lead time
Estimate downtime
I
Pre-Upgrade
Preparation
2 weeks
-
II
Pre-Upgrade
Testing Platform Installation
1 week
 
-
III
Pre-Upgrade
Migrate and Upgrade Database to 10G testing
2 weeks
 
-
IV
Upgrade
Migrate the database to 10gR2
1 week
72 hours
V
Upgrade
Upgrade the Appz to R12
1 week
 
40 hours
VI
Post-Upgrade
Reapply Customizations
2 weeks
 
12 hours
VII
Post-Upgrade
Migrate Custom Forms, Reports etc
2 weeks
 
12 hours
VIII
Post-Upgrade
Test, test and test the Applications
2 weeks
 
-

 

Appendix

Technology Improvements

  • AutoPatch replaces AutoUpgrade tool
  • AD parallel infrastructure improvements for work distribution of Large Table Update
  • Inclusion of Gather Auto Stats job in R12 Upgrade driver itself to keep statistics up-to-date after the upgrade
  • sqlplus parallel directive to eliminate the contention between jobs executing parallel query
  • Optimizer dynamic sampling (for objects with no statistics)
  • Converted non-critical jobs as concurrent manager requests to reduce overall downtime
  • R12 unified upgrade driver provides an option to defer compilation of PL/SQL packages during creation

 

Maintenance Wizard

  • This tool will guide you through upgrade of Oracle Applications technology stack and products from Release 11i versions to Release 12
  • Currently, the Maintenance Wizard performs the following types of upgrades:
    • Upgrades to 11i via the Upgrade Assistant for Release 11.5.10 product. This includes:
      1. 10.7 NCA to 11.5.10.2
      2. 11.0.3 to 11.5.10.2
    • Upgrades within 11i via the Maintenance Pack Assistant for 11.5.10 product. This includes:
      1. 11.5.3 or higher to 11.5.10.2
    • Upgrades to Release 12 via the Upgrade Assistant for Release 12 product. This includes:
      1. 11.5.8 or higher to 12.0.4
    • Release Update Pack upgrades via the R12 RUP patches. This includes:
      1. 12.0.0 or higher to 12.0.6
    • RDBMS upgrades for Applications customers via the Applications Database Upgrade Assistant 10g and 11g products. This includes:
      1. 8i to 10.2.0.3 9i to 10.2.0.3
      2. 9.2.0.8 to 11.1 10.1 or 10.2 to 11.

 

Upgrade by Request

  • Option to additionally upgrade historical data that has not been upgraded during the initial upgrade process
  • Historical data can be upgraded anytime when system is up or down
  • Following products historical data can be upgraded at a later date
    • Financials and Procurement
    • Projects
    • Supply Chain Management
    • CRM

 

Analysis and Planning: Pre-Upgrade Tasks

 

Analysis and Planning: Upgrade Tasks

 

Analysis and Planning: Post Upgrade Tasks