Oracle eBusiness Suite

1

• Oracle eBusiness Suite
• From IBM/HPUX/SUN/et.al
• To Lightening-Fast-Linux
• Presented by Michael Barone, OATC DBA
• David Channell, Liggett

Eastern States Oracle Applications Users
Group Friday May 18, 2007
2

• Agenda
• Review Process/Approach taken
• Review Core Team
• Review some technical details
• Questions and Answers (maybe!)
• Wrap-up

3
The Process or Approach Taken CRPs
4

The Process or Approach Taken CRPs

• CRP Definition
• CRP is a Conference Room Pilot
• Prototyping, according to APICS
• a CRP is a product model constructed for
  testing and evaluation to see how the product
  performs before releasing the product to
  production
• In this case
• Product Oracle Applications 11i
• Testing and evaluation The upgrade to 11i via
  CRP
• Product to Production Releasing 11i to the end
  users!

5

The Process or Approach Taken CRPs
A typical upgrade using the CRP method goes like
this
6

The Process or Approach Taken CRPs

• Some important things to keep in mind
• Liggett upgraded from 10.7 to 11i (11.5.6) in
  2003
• Preserving/reusing Upgrade/Testing material
• Reusing Upgrade/Testing Materials saved time
  money!
• End-users (familiarity, reproducible results)
• Auditors

7

The Process or Approach Taken CRPs
An upgrade using previous CRP documents goes like
this
8

The Process or Approach Taken CRPs
An upgrade using previous CRP documents goes like
this

• Technical Upgrades are applied
• Rudimentary testing is performed
• Repeat until successful
• Patches/Fixes/Setups/Profiles
• User Unit testing
• User Acceptance Testing
• Final approval
• and then
• Select the GoLive date, and
• Upgrade production!

UAT
9
Our team!
10

Our Core Team Members

• David Channell, Project Manager
• Michael Barone, OATC DBA
• Jim Sizemore, DBA
• Lisa Over, Applications Technical Lead
• Various testers

11

Our Core Team Members

• Project Manager
• Hardware Selection/Negotiations/OS Licensing
• Systems Set up/Administration/Backup Strategies
• DBA
• eBusiness Suite Certification Matrix
• eBusiness Suite Migration/Upgrade scripts
• eBusiness Suite Migration/Upgrade AIM
  documentation
• Developers
• Technical and Functional Testing

12
Some Technical Details
13
Some Technical Details why wait?

• eBusiness Suite fully supports the migration
• From Proprietary UNIX hardware/OS
• To Lightning-Fast Linux OS
• there really isnt a reason to wait any longer.
• Save money
• Save hardware-resources
• Save-software resources

14
Technical Environment Hardware
Current System eBusiness Suite 11.5.6
PA-RISC HP-UX Servers Single Node Installation
HP Direct Attached Storage Tape Backup
Target System eBusiness Suite 11.5.10.2 HP C
Class Blade Servers Single Node Installation
Network Appliance SAN/NAS Storage Disk to Disk
to Tape Backup
15
Technical Environment Software
Current System eBusiness Suite 11.5.6
Operating System - HP-UX version 11.0 Database
Oracle 8.1.7 CA Brightstor ARCServe Backup
for Windows
Target System eBusiness Suite 11.5.10.2
VMWare 3.0.1 w/Virtualized Red Hat Linux
Enterprise version 4 Network Appliance - FCP,
iSCSI, CIFS, Snapshot,
SnapRestore, Cluster Disk to Disk to Tape
using CA Brightstor ARCServe Backup for Windows
16
eBusiness Suite IBM/HPUX/Sun ? Lightening Fast
Linux
Some Technical Details overview!

• Metalink Note 230627.1
• Export/Import eBusiness Suite Release 11i
  Process
• Create a new Oracle eBusiness Suite 11i
  environment via Oracle eBusinss Suite RapidWiz
  (RapidInstall).
• Export (exp) and Import (imp) utilities then move
  the existing data to the new Hardware/OS
  Platforms
• No ugly Export-FileSize limits
• Table-Level Row-Count/Confirmation
• Update the Imported eBusiness Suite 11i Database

17
Some Technical Details beware!
The Oracle-Squeeze -- Caveat Emptor

• The Source-IBM/HP/Sun (export-from) MUST use
• Oracle8i Enterprise Edition Release 8.1.7
  or
• Oracle9i Enterprise Edition Release 2
  (9.2.0)
• The Target-Linux-Server (import into) MUST use
• Oracle9i Enterprise Edition Release 2
  (9.2.0).
• Fortunately, eBusiness Suite 11.5.10
• eBusiness Suite Rapidwiz Installs
  Oracle9i (9.2.0.6)

18
eBusiness Suite IBM/HPUX/Sun ? Lightening Fast
Linux
Some Technical Details MiniPacks!
Pre-Requisites Source 11i (IBM/HP/Sun) Database
(Oracle8i/Oracle9i) AD MiniPack
PreRequisite 2291496 AD MiniPack
F 2141471 Applications Export/Import
Consolidated Patch 2826013 Materialized Views
11.5.7-Only 2447246 New Improved Database
Preparation Scripts 2096242
19
eBusiness Suite IBM/HPUX/Sun ? Lightening Fast
Linux
Some Technical Details TechStack version

• Oracle 11.5.10 Release 2 Information
• Oracle Database Executables 9.2.0.6
• Oracle RDBMS Home 8.0.6
• Oracle Applications Server (Includes
  HTTP) 1.0.2.2.2
• Oracle Discoverer 4.1.48
• Jinitiator 1.3.1.21
• Oracle Developer6i (Forms/Reports/Graphics) 6.0.8.
  25
• RapidWiz (rapidwiz/RapidWizVersion) 11.5.10.35

20
eBusiness Suite IBM/HPUX/Sun ? Lightening Fast
Linux
Some Technical Details Post Upgrade
Consolidated Update Patch 2 MetaLink
316366.1 AD MiniPack I Delta 4 ATG Technology
Family Pack Additional Family Packs and
MiniPacks JInitiator Upgrade Personalization
21
and there is more to 11i than meets the eye!
22

But Wait Theres More New eBusiness Suite
Personalization

AutoConfig
VS.
Personalize Self-Service Defn Yes ltSelf-Service
Personalizationgt FND Personalization Region Link
Yes ltSelf-Service Personalizationgt Disable
Self-Service Personal No ltSelf-Service
Personalizationgt Corporate Branding Image
liggett_logo.jpg FND Diagnostics Yes ltApache
About This Pagegt Local Login Mask 32 lt If
Multi-Languagegt -or- 40 ltPassword-Hint/Fo
rgot URLgt General Preferences Show Flag
Yes ltGeneral Preferences Menugt
23
But Wait Theres Even More New eBusiness Suite
Personalize AutoConfig

• Metalink 270519.1 (February 2007)
• Customizing an AutoConfig Environment
• Review and migrate existing customizations
• AppsTier AD_TOP/bin/adcustomizer.sh
• DBTier ORACLEME/appsutil/bin/adcustomizer.sh
• Implementing AutoConfig customizations
• cp -i FND_TOP/admin/template/appsweb.cfg \  
    FND_TOP/admin/template/custom/appsweb.cfg
• Execute AutoConfig

24
Wrap-up
25
Wrap-Up
Q A
26
Wrap-Up
Thanks for your time!
David Channell dchannell_at_liggettgroup.com Jim
Sizemore jsizemore_at_liggettgroup.com Michael
Barone mbarone_at_liggettgroup.com