Main

Oracle Applications Release11i (11.5.10.2)

Upgrade Assistant Spreadsheet

The 11i Upgrade Assistant Spreadsheet is a tool that assists you in planning an Oracle Applications upgrade to Release 11i. This
spreadsheet is to be used in conjunction with the Upgrading Oracle Applications, Release 11i manual. When performing a test upgrade
of your current system, use this spreadsheet to enter the actual time of any upgrade step. The total time for the step as well as
the total time for the upgrade and the time for the critical system downtime are automatically calculated. The timing statistics
gathered for the test upgrade can be used as a benchmark for subsequent test upgrades and the production upgrade.

All time calculations are carried over to this Main page. The time calculations on the left are resource times for each category of the
upgrade and total upgrade time. Resource time is the actual time required to perform a step. It does not account for stoppage time.
The time calculations on the right are wall clock times for the categories in the critical system downtime. Wall clock time is the time
required to perform a step, including stoppage time. The critical system downtime is a 64-hour window when users cannot access
Oracle Applications. The Benchmark Time represents the time from a prior test upgrade.

Click on the Main Menu button at the top of this page to access the Main Menu dialog box. Within this dialog box select the category,
component application, and release you are upgrading from to see the list of upgrade steps pertinent to your upgrade. You can return
to the Main page from any page by clicking on the To Main Page button in the upper left corner. Use the Prepare New button to prepare
the spreadsheet for the next test upgrade or for the production upgrade.

For detailed instructions on how to use this spreadsheet, click on the Readme button in the upper right corner of this page.

Always check OracleMetaLink for the most up-to-date information.

Time by Category
Resource Benchmark
h:mm h:mm Time by Category
Category 1 0:00 0:00 Total Upgrade Time Wall Clock Benchmark Critical System Downtime
Category 2 0:00 0:00 Resource Benchmark h:mm h:mm Wall Clock Benchmark
Category 3 0:00 0:00 h:mm h:mm Category 3 0:00 0:00 h:mm h:mm
AutoUpgrade 0:00 0:00 0:00 0:00 AutoUpgrade 0:00 0:00 0:00 0:00
AD Mini-pack 0:00 0:00 AD Mini-pack 0:00 0:00
11.5.x DB Update 0:00 0:00 11.5.x DB Update 0:00 0:00
Other Updates 0:00 0:00 Other Updates 0:00 0:00
Category 4 0:00 0:00 Category 4 0:00 0:00
Category 5 0:00 0:00
Category 6 0:00 0:00
Finishing 0:00 0:00
Custom 0:00 0:00

Page 1
 Category 1 - Before You Receive the Software

"X" Products Category 1 Steps Upgrade from Resource Time Benchmark Time Performed Notes
Before You Receive the Software Release Format = h:mm from Test Upg by
Database
Database Upgrade Tasks
Step 1 Back up the Oracle Applications database (recommended)
10.7, 11.0
Step 2 Maintain multilingual tables (conditionally required) 10.7, 11.0
Step 3 Verify operating system login (required) 10.7, 11.0
Rename custom database objects with Applications
Step 4
prefixes (conditionally required) 10.7, 11.0
Back up Oracle Applications and customizations
Step 5
(conditionally required) 10.7, 11.0
Applications Technology
System Administration Tasks
Determine attachment file upload directory (conditionally
Step 1
required) 10.7, 11.0
Step 2 Preserve the CUSTOM library (recommended) 10.7, 11.0
Application Object Library Tasks
Transition custom forms to Oracle Forms Developer 6i
Step 1
(conditionally required) 10.7, 11.0
Oracle Alert Tasks
Step 1 Purge Alert and Action Set Check alert (recommended) 10.7, 11.0
Oracle Workflow Tasks
Step 1 Upgrade to Oracle Workflow 2.0.3 (required) 10.7
Financials
Oracle Cash Management Tasks
Back up custom Reconciliation Open Interface objects
Step 1
(conditionally required) 10.7, 11.0
Oracle Payables Tasks
Step 1 Complete outstanding payment batches (required)
10.7, 11.0
Oracle Receivables Tasks
Step 1 Rename custom tax structure (conditionally required) 10.7, 11.0
Save custom tax vendor extension views (conditionally
Step 2
required) 10.7, 11.0
Verify realized gains, realized losses, and rounding
Step 3
accounts (conditionally required) 10.7, 11.0
Step 4 Migrate customers as persons (conditionally required) 10.7, 11.0
Oracle Financials for Latin America Tasks
Step 1 Import outstanding bank collection documents (required)
11.0
Restore all archived technical appraisals and adjustments
Step 2
(recommended) 11.0
Step 3 Print all completed transactions (required) 10.7, 11.0
Projects
Oracle Projects Tasks
Complete transfer and tieback of cost, revenue, and
Step 1
invoices (required) 10.7, 11.0
Step 2 Clear Transaction Interface table (conditionally required)
10.7, 11.0
Transfer asset lines and post mass additions (conditionally
Step 3
required) 10.7, 11.0

Page 2 of 27 08/17/2010 08:11:43

 Category 1 - Before You Receive the Software

"X" Products Category 1 Steps Upgrade from Resource Time Benchmark Time Performed Notes
Before You Receive the Software Release Format = h:mm from Test Upg by
Upgrade to the new summarization model (conditionally
Step 4
required) 10.7
HRMS
Oracle Human Resources Tasks
Update custom code that references obsolete synonyms
Step 1
(conditionally required) 10.7
Update custom reports that reference HRV_ and OTV_
Step 2
(conditionally required) 10.7, 11.0
Note location of custom script for Salary Proposal view
Step 3
(conditionally required) 10.7
Step 4 Update custom code for positions (conditionally required)
10.7, 11.0
Update user-defined FastFormula definitions (conditionally
Step 5
required) 10.7, 11.0
Step 6 Update Vertex geocodes data (conditionally required) 10.7, 11.0
Oracle Payroll (U.S.) Tasks
Update custom code for U.S. tax information (W4) changes
Step 1
(conditionally required) 10.7
Step 2 Complete all Multiple Worksite reporting (required) 10.7
Oracle Labor Distribution Tasks
Ensure that transactions are summarized and transferred
Step 1
(required) 10.7, 11.0
Manufacturing
Oracle Work in Process Tasks
Close discrete jobs and purge unneeded data – WIP
Step 1
(recommended) 10.7, 11.0
Public Sector
Oracle Public Sector Financials (International) Tasks
Step 1 Verify patch set level (required) 11.0
SubTotal Database Steps 10.7, 11.0 0:00 0:00
SubTotal Apps Tech Steps 10.7, 11.0 0:00 0:00
SubTotal Financials Steps 10.7, 11.0 0:00 0:00
SubTotal Projects Steps 10.7, 11.0 0:00 0:00
SubTotal HRMS Steps 10.7, 11.0 0:00 0:00
SubTotal Manufacturing Steps 10.7, 11.0 0:00 0:00
SubTotal Public Sector Steps 10.7, 11.0 0:00 0:00

Page 3 of 27 08/17/2010 08:11:43

 Category 2 - After You Receive the Software

"X" Products Category 2 Steps Upgrade from Resource Time Benchmark Time Performed Notes
After You Receive the Software Release Format = h:mm from Test Upg by
Environment Preparation
Step 1 Run Rapid Install (required) 10.7, 11.0
Set environment variables and add custom settings
Step 2
(required) 10.7, 11.0
Step 3 Apply upgrade patches (required) 10.7, 11.0
Database
Database Upgrade Tasks
Step 1 Validate APPS schema(s) (recommended) 10.7, 11.0
Step 2 Verify custom index privileges (conditionally required)
10.7, 11.0
Applications Technology
Oracle System Administration Tasks
Restrict access to administration directory - all servers
Step 1
except database (recommended) 10.7, 11.0
Step 2 Purge old concurrent requests (recommended) 10.7, 11.0
Oracle FlexBuilder/Account Generator Tasks
Indicate use of FlexBuilder process for Account Generator
Step 1
(conditionally required) 10.7
Financials
Oracle General Ledger Tasks
Step 1 Review daily rates (conditionally required) 10.7
Revise custom programs that automatically load daily rates
Step 2
(conditionally required) 10.7
Global Accounting Engine Tasks
Step 1 Update accounting data model (conditionally required)
11.0
Step 2 Ensure that transactions are translated (required)
10.7, 11.0
Step 3 Calculate balances (conditionally required) 10.7
Step 4 Close all accounting periods (required) 10.7, 11.0
Oracle Payables Tasks
Update supplier/supplier site bank data for multiple supplier
Step 1
banks (conditionally required) 10.7
Choose payment method for future dated payments
Step 2
(conditionally required) 10.7, 11.0
Step 3 Enable recoverable tax option (conditionally required) 10.7, 11.0
Oracle iPayment Tasks
Step 1 Configure payees and payment systems (required) 10.7, 11.0
Oracle Financials for Asia/Pacific Tasks
Record truncated lookup codes or renamed meanings in
Step 1
custom modules (required) 10.7, 11.0
Move government uniform invoice information for each
Step 2
organization (required) 10.7, 11.0
Move supplier uniform numbers and tax registration
Step 3
numbers (recommended) 10.7, 11.0
Step 4 Record uniform numbers for your company (recommended)
10.7, 11.0
Step 5 Record Canadian tax setup (conditionally required)
10.7, 11.0
Step 6 Print tax rebate and rule listings (recommended) 10.7, 11.0
Oracle Financials for Europe Tasks

Page 4 of 27 08/17/2010 08:11:43

 Category 2 - After You Receive the Software

"X" Products Category 2 Steps Upgrade from Resource Time Benchmark Time Performed Notes
After You Receive the Software Release Format = h:mm from Test Upg by
Step 1 Update Swedish EFT payment format information (required)
11.0
Step 2 Pay Danish EFT invoices (conditionally required) 10.7, 11.0
Oracle Financials for Latin America Tasks
Step 1 Upgrade Brazilian subledgers data structure (required)
11.0
Identify and correct duplicate rows in JL_BR_LOOKUPS
Step 2
(required) 10.7, 11.0
Projects
Oracle Projects Tasks
Correct the week ending date and month ending date for
Step 1
MLS (required) 10.7, 11.0
Correct excess revenue amounts data for hard limit funded
Step 2
agreements (conditionally required) 10.7, 11.0

Correct excess revenue accrued for non-adjusting negative

Step 3
amount expenditure items (conditionally required)
10.7, 11.0
Step 4 Correct credit memo invoice dates (conditionally required)
10.7, 11.0
Correct bill amount data stored on revenue distributions
Step 5
(conditionally required) 10.7, 11.0
Correct billing hold data on reversing items (conditionally
Step 6
required) 10.7, 11.0
Step 7 Correct billable flag data for reversing items (required)
10.7, 11.0
Correct inconsistencies in Cost Budgets and Revenue
Step 8
Budgets (conditionally required) 10.7
Logistics
Oracle Inventory Tasks
Step 1 Purge unwanted transaction history - INV (recommended)
10.7, 11.0
Order Management
Oracle Order Management Tasks
Step 1 Run Order Import program (required) 10.7, 11.0
Step 2 Run Order Entry Interface programs (required) 10.7, 11.0
Step 3 Close eligible orders (required) 10.7, 11.0
Run AutoCreate Installed Base program for Services
Step 4
(required) 10.7, 11.0
Step 5 Make sure orders are in a supported status (required) 10.7, 11.0
Close open pick slips/picking batches or open
Step 6
deliveries/departures (required) 10.7, 11.0
Step 7 Run the Shipping Interface programs (required) 10.7, 11.0
Step 8 Review Item Validation Org settings (required)
10.7, 11.0
Step 9 Validate inventory organization data (required) 10.7, 11.0
Step 10 Review cycles that may not be upgraded (required)
10.7, 11.0
Step 11 Selectively upgrade active transactions (recommended) 10.7, 11.0
Procurement
Oracle Purchasing Tasks
Step 1 Clear open interface tables (required) 10.7, 11.0
Public Sector

Page 5 of 27 08/17/2010 08:11:43

 Category 2 - After You Receive the Software

"X" Products Category 2 Steps Upgrade from Resource Time Benchmark Time Performed Notes
After You Receive the Software Release Format = h:mm from Test Upg by
Oracle Public Sector Financials (International) Tasks
Step 1 Drop obsolete seed data (required) 10.7, 11.0
Complete current Internal Trading charges (conditionally
Step 2 10.7, 11.0
required)
SubTotal Environment & Database Steps 10.7, 11.0 0:00 0:00
SubTotal Apps Tech Steps 10.7, 11.0 0:00 0:00
SubTotal Financials Steps 10.7, 11.0 0:00 0:00
SubTotal Projects Steps 10.7, 11.0 0:00 0:00
SubTotal Logistics Steps 10.7, 11.0 0:00 0:00
SubTotal Order Management Steps 10.7, 11.0 0:00 0:00
SubTotal Procurement Steps 10.7, 11.0 0:00 0:00
SubTotal Public Sector Steps 10.7, 11.0 0:00 0:00

Page 6 of 27 08/17/2010 08:11:43

 Category 3 - Performing the Upgrade

Wall Clock Time Benchmark Time

Format = MM/DD/YY h:mm (24 hour format)
Enter the start time of the first Category 3 step:
Enter the end time of the last Category 3 step:

"X" Products Category 3 Steps Upgrade from Resource Time Benchmark Time Performed Notes
Performing the Upgrade Release Format = h:mm from Test Upg by
Applications Technology
Oracle Alert Tasks
Drop event alert triggers in custom schemas (conditionally
Step 1 10.7, 11.0
required)
Oracle Common Modules Task
Fix invalid AK data in non-Global Demo databases
Step 1
(conditionally required) 10.7, 11.0
Oracle Workflow Tasks
Update protection and customization levels of seeded item
Step 1 10.7, 11.0
types (recommended)
System Administration Tasks (Performed after all product specific Category 3 steps and before the Category 3 database steps)
Identify potential ORACLE schema conflicts (conditionally
Step 1 10.7, 11.0
required)
Step 2 Enable SYSADMIN user and password (required) 10.7, 11.0
Financials
Oracle Payables Tasks
Step 1 Determine exchange rates (MRC) (conditionally required) 11.0

Import and purge Payables Open Interface invoices

Step 2 11.0
(required)
Import and purge Invoice Import Interface expense reports
Step 3 10.7, 11.0
and invoices (required)
Step 4 Transfer all data to General Ledger (required) 10.7, 11.0
Calculate space requirements for new accounting tables
Step 5 10.7, 11.0
(recommended)
Oracle Receivables Tasks
Diagnose and correct pre-existing database problems
Step 1 10.7, 11.0
(recommended)
Step 2 Reconcile Receivables tax transactions (required) 10.7, 11.0
Oracle Financials Common Country Features Tasks
Partition EFT system formats information by operating unit
Step 1 10.7
(conditionally required)
Projects
Oracle Projects Tasks
Submit and obtain approval for all timecards entered in PTE
Step 1 10.7, 11.0
or Project Time and Expense (conditionally required)

Correct excess revenue accrued for negative amount

Step 2 10.7
events (conditionally required)
Back up custom client extension packages and views
Step 3 10.7, 11.0
(conditionally required)
Oracle Grants Accounting Tasks
Verify that all awards have a current, baselined budget
Step 1 10.7, 11.0
(required)
Step 2 Run costing and funds check procedures (required) 10.7, 11.0

Page 7 of 27 08/17/2010 08:11:43

 Category 3 - Performing the Upgrade

"X" Products Category 3 Steps Upgrade from Resource Time Benchmark Time Performed Notes
Performing the Upgrade Release Format = h:mm from Test Upg by
Step 3 Run the Distribute Burden process (required) 10.7, 11.0
Manufacturing
Oracle Cost Management Tasks
Verify that no uncosted transactions exist - Standard and
Step 1 10.7, 11.0
Average Costing (required)
Run WIP Value report- Standard and Average Costing
Step 2 10.7, 11.0
(recommended)
Close all accounting periods - Standard and Average
Step 3 10.7, 11.0
Costing (required)
Logistics
Oracle Inventory Tasks
Complete physical inventories in process - INV
Step 1 10.7, 11.0
(recommended)
Process data in temporary and interface tables - INV
Step 2 10.7, 11.0
(required)
Step 3 Run inventory valuation reports - INV (recommended) 10.7, 11.0
Order Management
Oracle Order Management Tasks
Step 1 Repeat Category 2 steps 1 – 10 (conditionally required) 10.7, 11.0
Procurement
Oracle Purchasing Tasks
Step 1 Modify default MRP profile options (conditionally required) 10.7
Public Sector
Oracle U.S. Federal Financials Tasks
Step 1 Drop obsolete objects (required) 10.7, 11.0
Marketing and Sales
Oracle Sales / Oracle Sales Compensation Tasks
Step 1 Apply pre-upgrade patch (required) 10.7, 11.0
Step 2 Set profile options (required) 10.7, 11.0
Step 3 Run setup data verification scripts (required) 10.7, 11.0
Service
Oracle Service Tasks
Step 1 Apply pre-upgrade patch (required) 10.7, 11.0
Step 2 Correct issues in Install Base data (conditionally required) 10.7, 11.0

Step 3 Clear Oracle Order Entry Service Interface data (required) 10.7, 11.0
Step 4 Set profile options (required) 10.7, 11.0
Process data in interface tables for Depot Repair
Step 5 10.7, 11.0
(conditionally required)
Process data in interface tables for Contracts (conditionally
Step 6 10.7, 11.0
required)
Step 7 Remove multiple counter groups (conditionally required) 10.7, 11.0
Estimate additional tablespace for Oracle Install Base
Step 8 10.7, 11.0
(required)
Step 9 Run setup data verification scripts (required) 10.7, 11.0
Database
Database Upgrade Tasks

Page 8 of 27 08/17/2010 08:11:43

 Category 3 - Performing the Upgrade

"X" Products Category 3 Steps Upgrade from Resource Time Benchmark Time Performed Notes
Performing the Upgrade Release Format = h:mm from Test Upg by
Shut down applications tier listeners and concurrent
Step 1 10.7, 11.0
managers (required)
Step 2 Migrate or upgrade database to Oracle9i (required) 10.7, 11.0
Step 3 Set up tablespaces (conditionally required) 10.7, 11.0
Set up Net Services - node where database is installed
Step 4 10.7, 11.0
(conditionally required)
Run preparatory scripts - node where database is installed
Step 5 10.7, 11.0
(required)
Step 6 Apply database patch (required) 10.7, 11.0
Step 7 Run preparatory scripts – administration node (required) 10.7, 11.0
Step 8 Gather database statistics for CBO (required) 10.7, 11.0
Step 9 Gather database information (recommended) 10.7, 11.0
Step 10 Check SQL*Plus options (required) 10.7, 11.0
Step 11 Verify rollback segment sizing (required) 10.7, 11.0
Turn off automatic archive logging and Replication
Step 12 10.7, 11.0
(required)
Disable custom triggers, constraints, and indexes
Step 13 10.7, 11.0
(conditionally required)
Step 14 Install XML Parser for PL/SQL (required) 10.7, 11.0
Step 15 Back up the database (recommended) 10.7, 11.0
SubTotal Database Steps 10.7, 11.0 0:00 0:00
SubTotal Apps Tech Steps 10.7, 11.0 0:00 0:00
SubTotal Financials Steps 10.7, 11.0 0:00 0:00
SubTotal Projects Steps 10.7, 11.0 0:00 0:00
SubTotal Manufacturing Steps 10.7, 11.0 0:00 0:00
SubTotal Logistics Steps 10.7, 11.0 0:00 0:00
SubTotal Order Management Steps 10.7, 11.0 0:00 0:00
SubTotal Procurement Steps 10.7, 11.0 0:00 0:00
SubTotal Public Sector Steps 10.7, 11.0 0:00 0:00
SubTotal Marketing and Sales Steps 10.7, 11.0 0:00 0:00
SubTotal Service Steps 10.7, 11.0 0:00 0:00

Page 9 of 27 08/17/2010 08:11:43

 AutoUpgrade & AutoPatch Steps

Start Time End Time Stoppage Time Total Time Benchmark Time Performed
Format = MM/DD/YY h:mm (24 hour format) h:mm from Test Upg By Notes
AutoUpgrade

Run AutoUpgrade (required) 0:00

Update and Patching Tasks

Download and apply latest AD minipack - US

Step 1
version (required) 0:00
Update database to current Applications
Step 2
release level (required) 0:00
Other Update Related Steps

Step 3 Disable maintenance mode (required) 0:00

Install translated software (conditionally
Step 4
required) 0:00
Update installed and licensed products
Step 5 0:00
(required)
Step 6 Install online help (conditionally required) 0:00
Step 7 Comment out Events settings (required) 0:00
0:00
Enter other patching related upgrade tasks
during the critical system downtime here. 0:00
0:00
0:00
0:00
0:00
0:00
0:00
0:00
0:00
0:00
SubTotal AutoUpgrade 0:00 0:00
SubTotal AD Minipack 0:00 0:00
SubTotal 11.5.x MP DB Driver 0:00 0:00
SubTotal Other Update Related Tasks 0:00 0:00

Page 10 of 27 08/17/201008:11:43
 Category 4 - Before Using Oracle Applications

Wall Clock Time Benchmark Time

Format = MM/DD/YY h:mm (24 hour format)
Enter the start time of the first Category 4 step:
Enter the end time of the last Category 4 step:

"X" Products Category 4 Steps Upgrade from Resource Time Benchmark Time Performed Notes
Before Using Oracle Applications Release Format = h:mm from Test Upg by
Environment Preparation
Environment Preparation Tasks
Run Rapid Install to configure and start server processes
Step 1 10.7, 11.0
(required)
Configure Applications client software (conditionally
Step 2 10.7, 11.0
required)
Step 3 Reapply customizations (conditionally required) 10.7, 11.0
Database
Database Upgrade Tasks
Step 1 Reset ORACLE schema passwords (recommended) 10.7, 11.0
Step 2 Gather database statistics for CBO (required) 10.7, 11.0
Step 3 Set rollback segments for normal use (required) 10.7, 11.0
Step 4 Validate and compile APPS schema (required) 10.7, 11.0
Integrate custom objects and schemas (conditionally
Step 5 10.7, 11.0
required)
Re-enable custom triggers, constraints, and indexes
Step 6 10.7, 11.0
(conditionally required)
Step 7 Back up Oracle Applications (recommended) 10.7, 11.0
Applications Technology
System Administration Tasks
Configure the Java-based Workflow Notification Mailer
Step 1 10.7, 11.0
(required)
Step 2 Fix flexfields cross-validation rules (required) 10.7
Step 3 Set profile options (required) 10.7, 11.0
Convert flexfield Date and DateTime value sets
Step 4 10.7, 11.0
(recommended)
Step 5 Upgrade flexfield date and number data (required) 10.7, 11.0
Set up electronic mail for use by concurrent managers
Step 6 10.7, 11.0
(required)
Reconnect spawned concurrent programs (conditionally
Step 7 10.7, 11.0
required)
Update/verify custom responsibilities (conditionally
Step 8 10.7
required)
Copy and re-customize previously modified scripts or
Step 9 10.7, 11.0
reports (conditionally required)
Step 10 Migrate the CUSTOM library (recommended) 10.7, 11.0
Step 11 Copy existing custom start scripts (conditionally required) 10.7, 11.0

Step 12 Restrict access to concurrent processing servers (required) 10.7, 11.0

Step 13 Load attachment files into database (conditionally required) 10.7, 11.0
Oracle FlexBuilder/Account Generator Tasks

Page 11 of 27 08/17/2010 08:11:44

 Category 4 - Before Using Oracle Applications

"X" Products Category 4 Steps Upgrade from Resource Time Benchmark Time Performed Notes
Before Using Oracle Applications Release Format = h:mm from Test Upg by
Step 1 Complete installation steps for Oracle Workflow (required) 10.7
Complete installation steps for Oracle Workflow Builder
Step 2 10.7
(conditionally required)

Step 3 Update Account Generator process (conditionally required) 10.7

Associate FlexBuilder rules for Accounting Flexfield

Step 4 10.7
structure and Workflow item type (conditionally required)

Financials
Oracle Financials for Asia/Pacific Tasks
Modify truncated lookup codes or renamed meanings in
Step 1 10.7, 11.0
custom modules (conditionally required)
Move customer uniform numbers and tax registration
Step 2 10.7, 11.0
numbers (recommended)
Oracle Financials Common Country Features Tasks
Upgrade descriptive flexfield dates to use the new AOL
Step 1 10.7
date validation (conditionally required)
Projects
Oracle Grants Accounting Tasks
Step 1 Run migration driver (required) 10.7, 11.0
Service
Oracle Service Tasks
Step 1 Migrate calendar dates (required) 10.7, 11.0
Environment Verification
Step 1 Verify application server DAD (required)
11.0
SubTotal Database & Env. Steps 10.7, 11.0 0:00 0:00
SubTotal Apps Tech Steps 10.7, 11.0 0:00 0:00
SubTotal Financials Steps 10.7, 11.0 0:00 0:00
SubTotal Projects Steps 10.7, 11.0 0:00 0:00
SubTotal Service Steps 10.7, 11.0 0:00 0:00

Page 12 of 27 08/17/2010 08:11:44

 Category 5 - Before Using Your Products

"X" Products Category 5 Steps Upgrade from Resource Time Benchmark Time Performed Notes
Before Using Your Products Release Format = h:mm from Test Upg by
All Components
Implementation and Set Up Tasks
Step 1 Review product-specific documentation (required) 10.7, 11.0
Financials
Oracle General Ledger Tasks
Step 1 Migrate conflicting daily rates (conditionally required) 10.7
Global Accounting Engine Tasks
Perform Multiple Reporting Currencies tasks (conditionally
Step 1 11.0
required)

Step 2 Migrate existing date and non-integer data (required) 10.7, 11.0
Step 3 Populate tax information for accounting lines (required) 10.7, 11.0
Oracle Payables Tasks
Step 1 Replace payment formats (conditionally required) 10.7

Step 2 Set up prepayment payment terms (recommended) 10.7, 11.0

Create or modify data for data model changes for MRC

Step 3 11.0
(conditionally required)
Oracle Receivables Tasks
Create indexes on transaction flexfield columns
Step 1 10.7, 11.0
(conditionally required)
Recreate custom tax vendor extension views (conditionally
Step 2 10.7, 11.0
required)
Update tax vendor descriptive flexfield information
Step 3 10.7, 11.0
(required)
Step 4 Create contexts and segments for new flexfields (required) 10.7, 11.0

Create or modify data for data model changes for MRC

Step 5 11.0
(conditionally required)
Oracle Financials Common Country Features Tasks
Update customized menus that use JG submenus
Step 1 10.7, 11.0
(conditionally required)
Oracle Financials for Asia/Pacific Tasks
Correct existing data before reporting tax information
Step 1 10.7, 11.0
(required)
Oracle Financials for Europe Tasks
Update customized menus that use JE submenus
Step 1 10.7, 11.0
(conditionally required)
Oracle Financials for Latin America Tasks
Step 1 Create new lookup codes (conditionally required) 10.7, 11.0
Step 2 Set tax system options (conditionally required) 10.7
Step 3 Update sales orders and invoices (conditionally required) 10.7

Step 4 Add warehouse name information (conditionally required) 10.7, 11.0

Associate tax information for each inventory organization
Step 5 11.0
location (conditionally required)
Associate tax groups and tax categories (conditionally
Step 6 11.0
required)

Page 13 of 27 08/17/2010 08:11:44

 Category 5 - Before Using Your Products

"X" Products Category 5 Steps Upgrade from Resource Time Benchmark Time Performed Notes
Before Using Your Products Release Format = h:mm from Test Upg by
Cancel and re-enter all unapproved and unposted invoices
Step 7 11.0
(conditionally required)
Archive restored technical appraisals (conditionally
Step 8 11.0
required)
Projects
Oracle Projects Tasks
Review organization hierarchies and uses of organizations
Step 1 10.7
(required)
Step 2 Update project status values (required) 10.7

Update customized billing extensions (conditionally

Step 3 10.7
required)
Review and update billing cycle names (conditionally
Step 4 10.7
required)
Convert custom overtime calculation program to PL/SQL
Step 5 10.7
(conditionally required)
Populate billing title for employee assignments
Step 6 10.7
(conditionally required)
Step 7 Set up the invoice rounding account (conditionally required) 10.7, 11.0
Add new parameters to custom invoice-related client
Step 8 11.0
extensions (conditionally required)
Add new parameters to custom transaction control
Step 9 10.7, 11.0
extension (conditionally required)
Add new currencies and non-recoverable tax amounts to
Step 10 10.7, 11.0
commitment views (conditionally required)
Update custom code that populates the Transaction
Step 11 10.7, 11.0
Interface table (conditionally required)
Reinstall custom client extension packages and views
Step 12 10.7, 11.0
(conditionally required)
Correct FIFO marking of expenditure items (conditionally
Step 13 10.7, 11.0
required)
Oracle Grants Accounting Tasks
Step 1 Verify AutoAccounting rules (conditionally required) 10.7, 11.0

Step 2 Set up AutoAccounting for Burden transactions (required) 10.7

HRMS
Oracle Payroll Tasks
Run the exchange rate migration script (conditionally
Step 1 10.7, 11.0
required)
Associate a set of books with your organizational payment
Step 2 10.7, 11.0
method (conditionally required)
Oracle Time and Labor Tasks
Step 1 Determine corrective actions for Time and Labor (required) 10.7, 11.0
Oracle Labor Distribution Tasks
Step 1 Determine corrective actions (required) 10.7, 11.0
Oracle iLearning 11i Tasks
Step 1 Verify Data Migration Error Log report (required) 10.7, 11.0
Manufacturing
Oracle Cost Management Tasks

Page 14 of 27 08/17/2010 08:11:44

 Category 5 - Before Using Your Products

"X" Products Category 5 Steps Upgrade from Resource Time Benchmark Time Performed Notes
Before Using Your Products Release Format = h:mm from Test Upg by
Step 1 Verify balances in WIP Value reports (recommended) 10.7, 11.0
Define default material subelement - Average Costing
Step 2 10.7, 11.0
(conditionally required)
Define Average Rates cost type - Average Costing
Step 3 10.7, 11.0
(conditionally required)
Oracle MRP / Supply Chain Planning Tasks
Define sales orders history cutoff date (conditionally
Step 1 10.7, 11.0
required)
Step 2 Start the Planning Manager (required) 10.7, 11.0
Logistics
Oracle Inventory Tasks
Review and correct organization default accounts - INV
Step 1 10.7, 11.0
(recommended)
Verify totals in inventory valuation reports - INV
Step 2 10.7, 11.0
(recommended)
Order Management
Oracle Order Management Tasks
Set up responsibilities for order creation/manipulation
Step 1 10.7, 11.0
(required)
Step 2 Review upgraded transaction types (required) 10.7, 11.0

Step 3 Set up processing constraints (required) 10.7, 11.0

Step 4 Set up flexfield definitions (required) 10.7, 11.0
Set up Workflow notification approver and update Workflow
Step 5 10.7, 11.0
item attributes (required)
Step 6 Generate and review upgrade error report (recommended) 10.7, 11.0
Step 7 Review Pricing upgrade errors (recommended) 10.7, 11.0
Procurement
Oracle Purchasing Tasks
Activate transaction managers for Multi-Org (conditionally
Step 1 10.7, 11.0
required)
Step 2 Upgrade notifications (conditionally required) 10.7
Step 3 Set MRP profile options (conditionally required) 10.7
Step 4 Verify and modify sourcing rules (conditionally required) 10.7
Step 5 Verify date formats (required) 10.7, 11.0
Step 6 Verify RMA upgrade (conditionally required) 10.7, 11.0
Public Sector
Oracle Public Sector Financials Tasks
Step 1 Switch to new responsibilities (conditionally required) 10.7, 11.0
Oracle U.S. Federal Financials Tasks
Step 1 Migrate data to new tables (required) 10.7, 11.0
Marketing and Sales
Oracle Sales / Oracle Sales Compensation Tasks
Step 1 Migrate FND responsibilities/profiles (required) 10.7, 11.0
Service
Oracle Service Tasks
Step 1 Update coverage transaction time zones (required) 10.7, 11.0
Step 2 Update migrated contacts and service lines (required) 10.7, 11.0
Step 3 Register Oracle Install Base (conditionally required) 10.7, 11.0

Page 15 of 27 08/17/2010 08:11:44

 Category 5 - Before Using Your Products

"X" Products Category 5 Steps Upgrade from Resource Time Benchmark Time Performed Notes
Before Using Your Products Release Format = h:mm from Test Upg by
Oracle Install Base Tasks
Step 1 Set up the Action menu in Order Management (required) 10.7, 11.0
Step 2 Set up the Order Management workflow (required) 10.7, 11.0
Confirm Service Fulfillment Manager Event Queue set up
Step 3 10.7, 11.0
(required)
Step 4 Create Agent users (required) 10.7, 11.0
Step 5 Create Business users (conditionally required) 10.7, 11.0
Schedule the Expire End Dated Instances concurrent
Step 6 10.7, 11.0
program (required)
SubTotal Setup Steps 10.7, 11.0 0:00 0:00
SubTotal Financials Steps 10.7, 11.0 0:00 0:00
SubTotal Projects Steps 10.7, 11.0 0:00 0:00
SubTotal HRMS Steps 10.7, 11.0 0:00 0:00
SubTotal Manufacturing Steps 10.7, 11.0 0:00 0:00
SubTotal Logistics Steps 10.7, 11.0 0:00 0:00
SubTotal Order Management Steps 10.7, 11.0 0:00 0:00
SubTotal Procurement Steps 10.7, 11.0 0:00 0:00
SubTotal Public Sector Steps 10.7, 11.0 0:00 0:00
SubTotal Marketing and Sales Steps 0:00 0:00
SubTotal Service Steps 10.7, 11.0 0:00 0:00

Page 16 of 27 08/17/2010 08:11:44

 Category 6 - Before Using Product Features

"X" Products Category 6 Steps Upgrade from Resource Time Benchmark Time Performed Notes
Before Using Product Features Release Format = h:mm from Test Upg by
All Components
Implementation and Set Up Tasks
Step 1 Review product-specific documentation (required) 10.7, 11.0
Applications Technology
System Administration Tasks
Step 1 Review user responsibility assignments (recommended) 10.7, 11.0
Application Object Library Tasks
Update custom code using flexfield values in
Step 1
FND_LOOKUPS (conditionally required) 10.7
Update custom calls to
Step 2 FND_DESCR_FLEX_CONTEXT_TL (conditionally
required) 10.7
Step 3 Rename the srw directory (conditionally required) 10.7
Copy custom forms libraries to AU_TOP (conditionally
Step 4
required) 10.7, 11.0
Step 5 Copy custom .fmb files to AU_TOP (conditionally required)
10.7, 11.0
Convert messages for custom applications (conditionally
Step 6
required) 10.7
Regenerate, recompile, and re-link custom concurrent
Step 7
program libraries (conditionally required) 10.7, 11.0
Oracle Alert Tasks
Associate organization names with custom Alert definitions
Step 1
(conditionally required) 10.7
Re-create event alert triggers in custom schemas
Step 2
(conditionally required) 10.7
Financials
Oracle Cash Management Tasks
Reinstall custom Reconciliation Open Interface objects
Step 1
(conditionally required) 10.7, 11.0
Oracle General Ledger Tasks
Preserve GL account combinations affected by the
Step 1
Segment Value Inheritance program (required) 10.7, 11.0
Ensure that account segment values use correct account
Step 2
type(conditionally required) 10.7
Step 3 Review period rates (conditionally required) 10.7, 11.0
Step 4 Review AutoPost criteria (conditionally required)
10.7
Define GIS conversion rates and rate types (conditionally
Step 5
required) 11.0
Verify program submission parameters for Mass Funds
Step 6
Check/Reservation (conditionally required) 10.7
Set function security for journal posting and reversing
Step 7
functions (recommended) 10.7

Step 8 Set up Intercompany Balancing (recommended)

10.7, 11.0
Oracle Payables Tasks
Step 1 Set up Offset taxes (conditionally required) 10.7, 11.0
Set up the future dated payment account (conditionally
Step 2
required) 10.7, 11.0
Step 3 Set up recoverable taxes (conditionally required)
10.7, 11.0
Step 4 Link GL records and AP records (required) 10.7, 11.0

Page 17 of 27 08/17/2010 08:11:44

 Category 6 - Before Using Product Features

"X" Products Category 6 Steps Upgrade from Resource Time Benchmark Time Performed Notes
Before Using Product Features Release Format = h:mm from Test Upg by
Oracle Receivables Tasks
Define GL tax assignments for Natural Account tax codes
Step 1
(conditionally required) 10.7, 11.0
Link GL and AR records and set Gain, Loss, and Round
Step 2
accounting entries code combinations (required) 10.7, 11.0
Oracle iPayment Tasks
Step 1 Upgrade iPayment 3i transaction data (required) 11.0
Oracle Financials for Asia/Pacific Tasks
Enter uniform numbers for your company – Taiwan
Step 1
(required) 10.7, 11.0
Step 2 Enter GST registration information – Singapore (required)
11.0
Step 3 Update tax types (recommended) 11.0
Modify existing globalization flexfields in Payables
Step 4
(required) 10.7, 11.0
Step 5 Update Thai Payables tax codes (required)
10.7, 11.0
Update Thai Payables globalization flexfield attributes
Step 6
(required) 10.7, 11.0
Modify the attribute set for the Thai Output Tax Summary
Step 7
report (recommended) 10.7, 11.0
Oracle Financials Common Country Features Tasks
Step 1 Set up Appreciation QuickCode (recommended) 10.7, 11.0
Step 2 Upgrade Appreciation transactions (recommended) 10.7, 11.0
Assign request groups to your responsibilities
Step 3
(recommended) 10.7, 11.0
Oracle Financials for Europe Tasks
Update Polish and Turkish journal line sequence numbers
Step 1
(conditionally required) 11.0
Update Danish EFT invoices to use EDI flexfield
Step 2
(conditionally required) 10.7, 11.0
Update taxable amounts for custom bills and self invoices
Step 3
(required) 10.7, 11.0
Step 4 Update Hungarian VAT transactions (conditionally required)
10.7, 11.0
Enable the Additional Information for Hungary globalization
Step 5
flexfield (conditionally required) 10.7, 11.0
Oracle Financials for Latin America Tasks
Update Colombian journal line third party information
Step 1
(required) 11.0
Projects
Oracle Projects Tasks
Step 1 Implement Self-Service Time (conditionally required)
10.7, 11.0
Step 2 Implement cross charge (conditionally required)
10.7, 11.0
HRMS
Oracle Human Resources Tasks
Recreate custom Salary Proposal view (conditionally
Step 1
required) 10.7
Step 2 Drop obsolete Oracle users (recommended) 10.7
Oracle Payroll (U.S.) Tasks

Page 18 of 27 08/17/2010 08:11:44

 Category 6 - Before Using Product Features

"X" Products Category 6 Steps Upgrade from Resource Time Benchmark Time Performed Notes
Before Using Product Features Release Format = h:mm from Test Upg by
Check for invalid U.S. address information (conditionally
Step 1
required) 10.7, 11.0
Logistics
Oracle Inventory Tasks
Create indexes on flexfield segment columns - INV
Step 1
(required) 10.7, 11.0
Change Item Description profile option - INV
Step 2
(recommended) 10.7, 11.0
Public Sector
Oracle Public Sector Financials (International) Tasks
Step 1 Migrate gross-based VAT data (conditionally required)
10.7, 11.0
Step 2 Upgrade subledger security (conditionally required) 10.7, 11.0
SubTotal Setup Steps 10.7, 11.0 0:00 0:00
SubTotal Apps Tech Steps 0:00 0:00
SubTotal Financials Steps 10.7, 11.0 0:00 0:00
SubTotal Projects Steps 10.7, 11.0 0:00 0:00
SubTotal HRMS Steps 10.7, 11.0 0:00 0:00
SubTotal Logistics Steps 10.7, 11.0 0:00 0:00
SubTotal Public Sector Steps 10.7, 11.0 0:00 0:00

Page 19 of 27 08/17/2010 08:11:44

 Finishing Your Upgrade

"X" Finishing Your Upgrade Upgrade from Resource Time Benchmark Time Performed Notes
Release Format = h:mm from Test Upg by
Finishing Your Upgrade
System Maintenance Tasks
Step 1 Drop obsolete database objects (recommended) 10.7, 11.0
Step 2 Drop MRC schema (recommended) 11.0
Step 3 Delete obsolete product files (recommended) 10.7, 11.0
Step 4 Drop obsolete columns in Oracle Assets (recommended) 10.7, 11.0
Drop unnecessary indexes for Oracle Payables
Step 5 10.7, 11.0
(recommended)
Remove old subledger security schemas for Public Sector
Step 6 10.7, 11.0
Financials (recommended)
Step 7 Install online help (recommended) 10.7, 11.0
Tasks for All Users
Step 1 Understand System Administration Tasks 10.7, 11.0
Step 2 Understand Oracle Applications Maintenance Tasks 10.7, 11.0
Step 3 Implement New Product and Country-specific Functionality 10.7, 11.0
Step 4 Resize the Database 10.7, 11.0
Step 5 Change Passwords 10.7, 11.0
Step 6 Maintain Snapshot Information 10.7, 11.0
Step 7 Back Up Oracle Applications 10.7, 11.0
Step 8 Review Security Practices 10.7, 11.0
Step 9 Log on to Oracle Applications 10.7, 11.0
System Specific Tasks
Step 1 Run Tablespace Migration Utility 10.7, 11.0
Step 2 Register Newly Licensed Products 10.7, 11.0
Configure the Oracle Workflow Java-based Notification
Step 3 10.7, 11.0
Mailer
Set Up and Implement Oracle Discoverer End User Layer
Step 4 10.7, 11.0
(EUL)
Set Up and Implement Oracle Embedded Data Warehouse
Step 5 10.7, 11.0
(EDW)
Step 6 Convert Custom Message Dictionary Functions 10.7, 11.0
Step 7 Convert Database to Multiple Organizations (Multi-Org) 10.7, 11.0
Step 8 Convert to Multiple Reporting Currencies (MRC) 10.7, 11.0
SubTotal Finishing Steps 10.7, 11.0 0:00 0:00

Page 20 of 27 08/17/2010 08:11:45

 Custom

Custom Steps Resource Time Benchmark Time Performed by Notes

Format = h:mm from Test Upg
Enter Your Custom Steps Here:

Step 1
Step 2
Step 3
Step 4
Step 5
Step 6
Step 7
Step 8
Step 9
Step 10
Step 11
Step 12
Step 13
Step 14
Step 15
Step 16
Step 17
Step 18
Step 19
Step 20
Step 21
Step 22
Step 23
Step 24
Step 25
Step 26
Step 27
Step 28
Step 29
Step 30
Step 31
Step 32
Step 33
Step 34
Step 35
Step 36
Step 37
Step 38
Step 39
Step 40
Step 41
Step 42
Step 43
Step 44

Page 21 of 27 08/17/2010 08:11:45

 Custom

Custom Steps Resource Time Benchmark Time Performed by Notes

Format = h:mm from Test Upg
Step 45
Step 46
Step 47
Step 48
Step 49
Step 50
Step 51
Step 52
Step 53
Step 54
Step 55
Step 56
Step 57
Step 58
Step 59
Step 60
Step 61
Step 62
Step 63
Step 64
Step 65
Step 66
Step 67
Step 68
Step 69
Step 70
Step 71
Step 72
Step 73
Step 74
Step 75
Step 76
Step 77
Step 78
Step 79
Step 80
Step 81
Step 82
Step 83
Step 84
Step 85
Step 86
Step 87
Step 88
Step 89
Step 90

Page 22 of 27 08/17/2010 08:11:45

 Custom

Custom Steps Resource Time Benchmark Time Performed by Notes

Format = h:mm from Test Upg
Step 91
Step 92
Step 93
Step 94
Step 95
Step 96
Step 97
Step 98
Step 99
Step 100
SubTotal Custom Steps 0:00 0:00

Page 23 of 27 08/17/2010 08:11:45

 Oracle Applications 11i Upgrade Assistant Spreadsheet, Release 11.5.10.2
Copyright 2005 Oracle Corporation. All Rights Reserved.
Updated July 13, 2005

This readme contains the following sections:

1. Introduction
2. Minimum Requirements
3. Send us your Comments
4. Detailed Instructions
5. Additional Information

Introduction:
The R11i Upgrade Assistant Spreadsheet is a tool that assists you in planning an Oracle Applications upgrade
to Release 11i. This spreadsheet is to be used in conjunction with the Upgrading Oracle Applications, Release 11i
manual. When performing a test upgrade of your current system, use this spreadsheet to enter the time
required to perform an upgrade step. The total time for the category as well as the total time for the upgrade and the
time for the critical system downtime are automatically calculated. The timing statistics gathered for the test
upgrade can be used as a benchmark for subsequent test upgrades and the production upgrade.

The upgrade is comprised of six main categories, the AutoUpgrade run, the patch application process using
AutoPatch, and the finishing steps. Categories 1, 2, and 3 are pre-upgrade steps and are performed before
running AutoUpgrade. Categories 4, 5, and 6 are post-upgrade steps and are performed after a successful
AutoUpgrade session and system update. Categories 3 and 4, the AutoUpgrade process, and the AutoPatch
steps fall in the critical system downtime period of an upgrade. During this downtime period, your users
will not be able to use Oracle Applications.

Minimum Requirements:
Microsoft Excel 2000 with Microsoft Office 2000 Service Release 1

Send us your Comments:

We welcome your comments and suggestions on the quality and usefulness of this spreadsheet. Your input will
help us improve the next release.
Consider the following:
- Did you find any errors?
- Is the information clearly presented?
- Do you need more information? If so, where?
- What features did you like most about this spreadsheet?

If you find errors or have any other suggestions for improvement, please indicate the sheet, feature, or
functionality (if available). You can send comments to us in the following ways:

Email: apps_relgrp_us@oracle.com

FAX: 650.506.1113 Attn: Oracle Applications Release Group

Postal service:
Oracle Corporation
Oracle Applications Release Group
500 Oracle Parkway, M/S 3op4
Redwood Shores, CA 94065
U.S.A

Detailed Instructions:
1. Main Page
When the spreadsheet is opened it defaults to the Main page. The Main page contains summary time
information for the upgrade. All total calculations are carried over from the individual category sheets to this
page.

To begin using the Upgrade Assistant Spreadsheet, click on the Main Menu button in the upper right corner of
the Main page. This produces the Main Menu dialog box. Within the Main Menu dialog box you select the category,
component application and the release you are upgrading from for the upgrade steps that you would like to see.

The Category selections are

1 pre-upgrade = Category 1 pre-upgrade steps

24 of 27
 2 pre-upgrade = Category 2 pre-upgrade steps
3 pre-upgrade = Category 3 pre-upgrade steps
AutoUpgrade & AutoPatch = For AutoUpgrade and AutoPatch steps
4 pre-upgrade = Category 4 post-upgrade steps
5 pre-upgrade = Category 5 post-upgrade steps
6 pre-upgrade = Category 6 post-upgrade steps
Finishing = For the Finishing your Upgrade steps
Custom = For any custom upgrade steps

The Component Application selections are

Database = All database related steps
Applications Technology = All System Administration and Apps Technology
products steps
Financials = All Financials products steps
Projects = All Projects products steps
HRMS = All Human Resources Management Systems products steps
Manufacturing = All Manufac. and Distrib. products steps
Logistics = All Logistics products steps
Order Management = All Order Management products steps
Procurement = All Procurement products steps
Public Sector = All Public Sector products steps
Marketing and Sales = All Marketing and Sales products steps
Service = All Service products steps
All Components = Shows a list of all Component Applications upgrade steps

The Release selections are

10.7 = For steps when upgrading from Release 10.7
11 = For steps when upgrading from Release 11.0
All Releases = For all upgrade steps regardless of release upgrading from

By making your selections and clicking [ok], the spreadsheet queries the list of selected upgrade steps. The
Category search criteria is required and a message box notifies you if it is left blank. The Component Application
search criteria is required when you query any of the six category pages.

Once the upgrade step times are entered into the category sheets, the total time calculations are
carried over to the Main page. The left side shows total resource time by category and the total resource time
for the entire upgrade. The right side shows total wall clock time for each category in the critical system downtime
and the total wall clock time for the critical system downtime. The critical system downtime totals represent
the time for all Category 3 and 4 steps, the AutoUpgrade run and the AutoPatch steps.

The resource time represents the actual time spent on the upgrade steps. It does not include stoppage time or
non-working time. The wall clock time is the amount of actual time, including stoppage time, required to
complete the upgrade steps. The wall clock time is important for the critical system downtime as this a period of
the upgrade when users cannot use Oracle Applications.

The benchmark time totals represent the resource or wall clock times from a prior upgrade. The times from
a prior upgrade are moved to the benchmark time fields when you click the Prepare Now button in the upper
right corner of the Main page.

Use the Prepare Now button after completing a test upgrade to prepare the spreadsheet for a subsequent test
upgrade or the production upgrade. Prepare Now saves the current spreadsheet, saves a copy of the current
spreadsheet with the default name upgasst<current date>.xls, and moves the upgrade step times to the
benchmark time fields.

The Readme button in the upper right of the Main page takes you to this readme page.

2. The Category pages

Each of the Category sheets (Category 1 - Category 6 and Finishing) are accessed by clicking on the sheet tab at the bottom or
by selecting the desired category in the Main Menu dialog box. The shaded (gray) areas on these sheets should not be updated.

The "X", Resource Time, Benchmark Time, Performed By, and Notes fields are updatable on the category sheets.
"X" = Enter X for steps that are not required based on the TUMS report
Resource Time = Enter the time required for the upgrade step
Benchmark Time = This field is automatically populated with the resource time from a prior upgrade
when you click Prepare New on the Main page. Use this as a benchmark for the
current upgrade.

25 of 27
 Performed By = Enter the name of the person(s) performing the step
Notes = Enter any additional information that may be useful for subsequent upgrades

The Upgrade Manual Script (TUMS) produces a report that lists all upgrade steps that are not required for the upgrade of
your specific Oracle Applications system. For each step listed in the TUMS report, place an X in the X column, then click
the Update button at the top of the page. This will strikethrough the step, reminding you that the step is not required.
See OracleMetaLink Document ID: 230538.1 for additional information on TUMS.

When entering the resource time for a step, enter it in the format "h:mm", where h is the hour and mm are the minutes.
Enter the time in 24 hour format (that is, 15:00 for 3:00 PM). The total time for each component application is calculated
and the total times appear at the bottom of each category sheet. The Benchmark Time column can be used to store the
time required for the step during a test or prior upgrade, thereby allowing you to track the progress of the current upgrade
against a benchmark. The benchmark time is automatically populated with the resource time from a prior upgrade when
you click Prepare Now on the Main page. You can also enter benchmark time manually.

Clicking the To Main Page button in the upper left corner takes you back to the Main page of this spreadsheet. The Verify
button provides you with information on the number of incomplete steps in the respective category sheet. The Verify button
counts all incomplete steps regardless of whether they are required for your upgrade. Therefore, if you are not performing
any Financials upgrade steps, you can ignore the message that states you have incomplete Financials steps.

Category 3 and Category 4 Pages

The Category 3 and 4 pages have fields for wall clock time in addition to the resource time. Category 3 and 4 are part of the
critical system downtime, therefore, total wall clock time for these two categories are important when planning for the
production upgrade. At the top of these pages are two fields: one to enter the begin time for the first upgrade step performed
in the category and another for the end time of the last upgrade step completed in the category.

When entering the start time and end time, enter it in the format "MM/DD/YY h:mm", where h is the hour and mm are the
minutes. Enter the time in 24 hour format (that is, 15:00 for 3:00 PM).

The wall clock time is calculated and carried over to the Main page. The wall clock benchmark time fields are populated
with the wall clock times for the current upgrade when Prepare Now is selected on the Main page.

3. The AutoUpgrade & AutoPatch page

This sheet is accessed by clicking on the sheet tab at the bottom or by selecting AutoUpgrade & AutoPatch in the Category
section of the Main Menu dialog box. When selecting AutoUpgrade & AutoPatch as the Category in the Main Menu dialog
box, the Component Application and Release fields are not required.

This sheet is used to enter the times for AutoUpgrade and the application of the AD minipack, the 11.5.x database driver,
and other patches. The AutoPatch steps are listed in the Update and Patching Tasks section at the beginning of Category 4
in Upgrading Oracle Applications.

The Start Time, End Time, Stoppage Time, Benchmark Time, Performed By, and Notes fields are updatable.
Start Time = Enter the time the upgrade step was started
End Time = Enter the time the upgrade step was completed
Stoppage Time = Enter the time the utility was not running
Benchmark Time = This field is automatically populated with the resource time from a prior upgrade
when you click Prepare New on the Main page. Use this as a benchmark for the
current upgrade.
Performed By = Enter the name of the person(s) performing the step
Notes = Enter any additional information that may be useful for subsequent upgrades

When entering the start time and end time for a step, enter it in the format "MM/DD/YY h:mm", where h is the hour and mm
are the minutes. Enter the time in 24 hour format (that is, 15:00 for 3:00 PM). Enter the Stoppage time in the format "h:mm",
where h is the hour and mm are the minutes, for example 24:00 for 24 hours of stoppage time. The Total Time column is
calculated based upon the start and end times you enter minus the stoppage time.

The AD Job Timing report provides timing information on the jobs performed by AutoUpgrade and AutoPatch. See the
Oracle Applications Maintenance Utilities guide for additional information on this report.

4. The Custom page

The Custom page is provided for any custom upgrade steps that you may want to record. This sheet is
accessed by clicking on the sheet tab at the bottom or by selecting Custom in the Category section of the Main
Menu dialog box. When selecting Custom as the Category in the Main Menu dialog box, the Component
Application and Release fields are not required.

The Custom Steps column allows you to enter a description of the custom step you are performing. The time

26 of 27
 calculations on the Custom page are not added into the Critical System Downtime total.

See the Category Pages section above for an explanation of the updateable Resource Time, Benchmark Time,
Performed By, and Notes fields and the To Main Page button.

5. The Other sheets

The Index, Module, and main_form sheets store the various functionalities of the spreadsheet. These sheets are
protected and should not require any updates or edits.

Additional Information:
1. The Special menu
The Special menu to the right of the Help menu has four options:
Update X = Crosses out rows with an X in the X column See "X" above.
Refresh X = Reverses the action of the Update X command
Show Key = Shows the step key used in the TUMS report
Hide Key = Hides the step key used in the TUMS report

The TUMS report references most upgrade steps by a step key. Use the step key information to determine the
steps that are not required for your upgrade.

2. Reset Category sheets

When you query for and display upgrade steps for a product, the steps remain displayed until another set of
steps is queried. For example,

Select Category = 1 pre-upgrade

Component = Financials
Release = All Releases

This displays all upgrade steps for the Financials Component Application in Category 1. These upgrade steps
for the Financials Component Application remain displayed until you run a new query.

To reset the sheet so that all products are displayed, go to the main menu, select the desired category, select
All Components in the Component drop down box, and select All Releases in the Release drop down box.

For example, to reset the above example select

Category = 1 pre-upgrade
Components = All Components
Release = All Releases

This displays all components and steps on the Category 1 sheet.

3. Step numbers
When you use the Main Menu to query for a particular set of steps, you may notice that the resulting steps
are not numbered sequentially.

For example, select Category = 2 pre-upgrade, Component = Financials, and Release = 11.0.
The Global Accounting Engine Tasks may show the following steps:
step 1:...
step 2:...
step 4:...

This is normal functionality for the Upgrade Assistant Spreadsheet as the step numbers in the spreadsheet
match the step numbers in the Upgrading Oracle Applications manual. The missing step numbers have
been filtered out as they do not apply to your upgrade.

27 of 27