How To Improve Your Productivity With An Orgs Suite

(1)

(2)

Support for Your Oracle E-Business Suite

12.2 Upgrade

Cliff Godwin, Senior Vice President, Application Development

Anne Carlson, Senior Director, Product Strategy

Oracle E-Business Suite Development

October 28, 2015

(3)

Safe Harbor Statement

The following is intended to outline our general product direction. It is intended for

information purposes only, and may not be incorporated into any contract. It is not a

commitment to deliver any material, code, or functionality, and should not be relied upon

in making purchasing decisions. The development, release, and timing of any features or

functionality described for Oracle’s products remains at the sole discretion of Oracle.

(4)

Program Agenda

EBS Roadmap - 12.2 and Beyond

12.2 Upgrade Value

12.2 Upgrade Planning Considerations

12.2 Upgrade Resources

1

2

3

(5)

EBS Roadmap

(6)

Continued Investment for Years to Come

Oracle E-Business Suite Release Roadmap

9/2013 12/2013

9/2014

12.2

12.2.3 12.2.4 12.2.5 12.2.6 12.2.7

12.3

12.1

12.1.2 12.1.3 12.1.3+

5/2009

12/2009

8/2010

10/2015

(7)

2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023

11.5.10

GA 11/2004

Sustaining

12.0

GA 1/2007

12.1

GA 5/2009

12.2

GA 9/2013

Sustaining

Extended

11/2013

1/2012

1/2015

11/2010

12/2015

12/2016

12/2019

5/2009

9/2013

9/2021

Exception

Sustaining

Extended

Premier

Customer Choice to Use 12.1 or 12.2

Oracle E-Business Suite Support Timelines

Support updates as of 5/2015

12.2 Premier Support through 9/2021 (3 years of Extended Support changed to Premier Support)

For more info, see

Oracle Lifetime Support Policy: Oracle Applications

7

1

Premier

Extended

Sustaining

Extended

Sustaining

1

Premier

Exception

Premier

(8)

(9)

Continued Investment Building Upon the Strengths of EBS Integrated Global Suite

Oracle E-Business Suite 12.2 Investment Priorities

EBS

9

Projects &

Procurement

Financials

Human

Capital

Manufacturing

& Planning

Asset Lifecycle

& Service

Order Mgt

& Logistics

Modern User

Experience and Mobility

Simple and actionable user

experience for operational roles

Functional

Advancements

Rich functional flows for modern

business in integrated global suite

Operational

Efficiency

Lower effort and cost to operate

and optimize EBS system

(10)

Reduced Downtime; Richer User Experience and Functional Flows Across the Suite

Oracle E-Business Suite Release 12.2 Highlights

•

Latest Oracle Look and Feel:

Choice for Icon-Based Navigation; New Interactions & Widgets

•

Tablet Optimizations:

Support for Familiar Tablet Interactions in HTML UIs; Tablet Optimized App Designs

•

Smartphone Apps

:

Simple, Actionable Apps for Targeted Roles On the Go. Available for 12.1.3 & 12.2

•

Information Discovery

: Dashboards to Identify & Act on Priority Transactions without Custom Reporting*

•

Functional Advancements Across the Suite

•

Subscription and Services Selling

•

Outcome-Based Procurement

•

Supply Chain Agility across Logistics,

Manufacturing, Planning, and Service

•

Advanced Project Controls and Project Billing

•

Linear Asset Management

•

Streamlined HTML User Interfaces

•

Customer Voted Enhancements

•

Online Patching:

Patching While Users on the System for Reduced Downtime

•

Technology Stack:

WebLogic Server, Advanced Configuration Management

•

Automated System Mgt and Testing:

Enhanced Patch Wizard, OATS Flowbuilder with EBS Content*

Modern User

Functional

Advancements

Operational

Efficiency

•

New Products

•

Procurement Command Center*

•

Project Procurement*

•

Contract Renewal Command Center*

•

Advanced Project Planning and Control*

•

Yard Management

•

Outsourced Manufacturing*

•

In-Memory Cost Management*

•

Supply Chain Event Management*

(11)

Oracle Cloud Home Page

Common Ground with Cloud Applications

User Experience Convergence

Shared User Experience Lab

EBS 12.2.4 and 12.2.5 Touch Friendly New Home Page

(12)

Tablet Optimization with OAF 12.2

12

•

Icon-Based Navigation: Home Page, Page Navigation

•

Touch-Friendly Layout

–

Increased Row Height and Spacing

–

Increased Column Header and Button Height

•

Gesture Support

–

Page Navigation

–

Table Interactions

•

Device Support

–

Camera, Email, Maps

–

Responsive Layout for Portrait & Landscape (Planned)

Enhanced User Productivity and More Appealing User Experience

(13)

Receiving

Receive, Deliver and Manage Receipts on a Tablet

Deliver

Receive

13

(14)

(15)

(16)

Asset Definition

Search and Take Action

Asset Quick Create

16

(17)

Enterprise Asset Management

17

Draw a Map area to review Assets, Work Orders & data mapped from GIS system

(18)

•

Procurement

•

Procurement Command Center – New Product*

•

Project Procurement – New Product*

•

iProcurement Info Discovery: Ratings, Reviews and Feedback

•

iProcurement Info Discovery: Catalog Upload via Supplier Network

•

iProcurement: 1 Step Checkout

•

Sourcing: Initiatives, Multiple Offers and Alternative Lines

•

Supplier Lifecycle Mgt (SLM): Dependent Questions, Automated

Assessments, Dynamic Supplier Lists, Qualification Templates. more

•

Services Procurement: Complex Financing for Std POs

•

Contract Lifecycle Mgt for Public Sector (CLM): Many enhancements

•

Smartphone Apps: iProcurement, Procurement

•

Human Capital Management

•

Payroll Dashboard

•

Self-Service Human Resources Transaction Dashboard

•

SSHR: Improved UI

•

Learning: Improved UI

•

Succession Planning: Improved UI

•

OIC: Compensation Analytics

•

Smartphone Apps: Timecards, Learning, Person Directory

•

Information Discovery: HR, Learning, iRecruitment, OIC

•

Financials

•

GL: Journal Approvals with AME

•

AP: Parallel Invoice Approvals

•

AR: Receipt Application - Match Score and Knapsack Method

•

AR: Manage Accounting Exceptions During Period Close

•

EB Tax: Transaction Tax Configuration Workbook

•

CHRM: Volume Offer Enhancements, HTML UIs

•

Leasing: Enhanced Termination Processing

•

Smartphone App: Expenses

•

Information Discovery: Fin (AP, AR, FA), CHRM

•

Projects

•

Advanced Project Planning and Control - New Product*

•

Federal Contract Billing

•

Labor Costing with Projects and Payroll

•

Schedule of Values

•

Project Cost Breakdown Structure

•

Enhanced Intercompany Billing for Global Operations

•

Invoice Consolidations, Expenditure Grouping, Revenue Holds

•

Budgetary Controls on Financial Plans; Improved UX

•

Smartphone App: Project Manager

E-Business Suite 12.2: ERP and HCM Release Highlights

Product Family Highlights

(19)

•

Order Management

•

Contract Renewal Command Center - New Product*

•

OM/Pricing: Selling Services and Subscriptions

•

OM: HTML UI

•

OM: Credit Checks, Holds, Manual Line Splitting of ISOs

•

OM/CHRM: Enhanced Gross Margin Calculations

•

Quoting: Validation Framework, Parallel Approvals

•

Smartphone App: Sales Orders

•

Information Discovery: OM, Quoting, iStore

•

Logistics

•

Yard Management – New Product

•

LOG/OM: Flexible Serial Tagging

•

LOG/OM: Advanced Catch Weight

•

INV: Receiving Tablet Optimized HTML User Interface

•

WMS: Zone Picking, Nested LPNs, Mobile Task Dashboard

•

MSCA: Single Sign-On Support; Personalization Enhancements

•

Smartphone App: Inventory

•

Information Discovery: Inventory, WMS

E-Business Suite 12.2: SCM Release Highlights

Product Family Highlights

•

Manufacturing

•

Outsourced Manufacturing – New Product*

•

Just-In-Time Manufacturing (E-Kanban)

•

Process Mfg: Outside Processing, Batch Hold Management

•

MES: Component Availability Mgt: Day 0 Clear to Build

•

MES: Discrete MES Supervisor Tablet Optimized HTML UI

•

MES: Serialized Manufacturing: Express Transact, Auto-Dekit

•

Smartphone Apps: Discrete Production Supervisor, Process Production

Supervisor Project Mfg, Product Info

•

Information Discovery: Discrete Mfg, Process Mfg, Quality, Cost Mgt

•

Value Chain Planning

•

APCC: Enhanced Reporting for Demand Management, S&OP, Trade

Promotions Planning and Distribution Planning

•

ASCP: Resource Overtime and Warehouse Capacities; New UI

•

Project Driven Supply Chain (ASCP-Primavera Integration)

•

Calendar Month Support in Weekly Demantra System

•

Promotional Calendar Optimization

•

RP: Clear to Build Enhancements

•

PS: Synchronous Make-Pack

•

SPP: Integration to Enterprise Asset Management

(20)

•

Asset Lifecycle Management

•

Linear Asset Support

•

Safety Management: Lockout, Tagout

•

Map Visualization for Assets and Work

•

Asset: Expanded HTML User Interfaces

•

Smartphone App: Maintenance

•

Information Discovery: EAM, Installed Base

E-Business Suite 12.2: ALM & Service Release Highlights

Product Family Highlights

•

Service

•

Execute Project Tasks using Field Service

•

Service Request Operating Unit Security with MOAC

•

Service: Inquira/Oracle Knowledge Integration

•

Field Service: Auto Creation of OTL Timecards

•

Field Service: High Volume Parts Ordering & Debriefing

•

Field Service: Decentralized Scheduling

•

Field Service: Dispatch Center HTML UI

•

Spares Mgt: Warehouse Shipping Method Calendars

•

Spares Mgt: External Repair Execution In-Transit Tracking

•

Spares Mgt: HTML Planners Dashboard

•

Depot Repair: Supply Warranty Mgt

•

Depot Repair: Waste Mgt

•

Depot Repair: Outsourced Repair

•

TeleService: Contact Center HTML User Interface

•

Service Contracts: Configurability; HTML User Interface

•

CMRO: Counter Entry and Corrections

•

Mobile Field Service: Multi-Platform for iOS, Android, & Windows

•

Information Discovery: Field Service, TeleService, Depot Repair, CMRO

(21)

Richer User Experience and Functional Flows Across the Suite

Oracle E-Business Suite Release 12.2.5 Highlights

•

Latest Oracle Look and Feel:

Icon-Based Page Navigation, New User Interactions and Widgets

•

Tablet Optimized HTML User Interfaces:

Receiving, Discrete MES Supervisor

•

Information Discovery

: New Areas: FA, Customers, Quoting, iStore, OIC, & CMRO; Rename from Endeca Ext

•

Financials:

GL Approvals in AME, AR Automated Receipt Application New Methods

•

Procurement

: Procurement Command Center*, iProcurement: Ratings and Reviews, Catalog Upload

•

Projects

: Advanced Project Planning and Control*, Schedule of Values, Invoice Consolidations

•

Order Management:

Contract Renewal Command Center*, Selling Subscriptions, Quote Validation Fwk

•

Logistics:

Flexible Serial Tracking, Zone Picking, Nested LPNs, WMS Productivity

•

Manufacturing:

Outsourced Mfg, Component Availability Mgt

•

Value Chain Planning:

Configurable Supply Planning Work Area, Service Parts Enh for Auto/High Tech

•

Asset Management:

Map Visualization, Linear Asset Enhancements, Asset Route Enhancements

•

Service:

SR OU Security, Auto Creation of OTL Timecards, Spares Shipping Method Calendars

•

Human Capital Management:

Payroll Dashboard Enhancements, Configurable Talent Matrix

•

Online Patching:

Support for Simplified Dev Environments, Patching Progress Monitoring Tool

•

Technology Stack:

Middle Tier Technology Checker

•

Automated System Management:

Streamlined Patch Wizard Reports, Patch Wizard Export

Modern User

Functional

Advancements

Operational

Efficiency

(22)

E-Business Suite 12.2 - Highlights

•

Users remain online while patches are applied

•

User downtime is limited to a short cutover period

•

The maintenance window in 12.2 is predictable

•

Critical business operations and revenue

generating activities continue during patching

Signature Feature – Online Patching for Business Continuity

(23)

Oracle E-Business Suite 12.2: Customer Success Examples

(24)

CUSTOMER PERSPECTIVE

“June 2015: This past weekend, HIGLAS passed a

monumental milestone – namely the upgrade to

Release 12.2 for 3 Lines of Business. We have had no

significant issues or business show stoppers.

Successfully processed over $6B of payment

transactions and are aggressively moving into Phase 2,

transitioning the MACs to Release 12.2.”

Chris Martin

, Director, Financial Management Systems

Group (FMSG), CMS

COMPANY OVERVIEW

•

The Centers for Medicare and Medicaid Services (CMS) is part of the US Department of Health

and Human Services (HHS). CMS ensures availability of effective, up-to-date health care

coverage and promotes quality care for beneficiaries.

•

CMS’s Healthcare Integrated General Ledger Accounting System (HIGLAS) is a dual-entry

accounting system which supports over 100 million Medicare & Medicaid beneficiaries. The

system processes approximately 4.5 million transactions daily for Medicare, Medicaid, and State

Children’s Health Insurance Program (SCHIP) combined. An average of 163,000 payments are

processed daily, totaling an average of $1.5 Billion.

•

Industry: Public Sector

•

Employees: 5,000

80.000+ HHS Total

•

Budget : US$ 1 trillion -

http://www.hhs.gov/about/budget/fy2015/budget-in-brief/index.html

CHALLENGES/OPPORTUNITIES

•

Prevent unplanned downtime

•

Deploy a robust, highly scalable enterprise resource planning (ERP) solution

•

Expedite global period-end financial closing

•

Eliminate the need to maintain disparate, proprietary legacy financial systems and integrations

•

Upgrade entire AP and AR data to eliminate post upgrade XLA upgrade on demand

SOLUTIONS

•

Oracle U.S. Federal Financials

•

Oracle Receivables

•

Oracle Payables

•

Oracle Payments

•

Oracle General Ledger

•

Oracle Cash Management

RESULTS

•

Completed tech upgrade for primary and DR site from

11.5.10.2 to 12.2 of 40TB database in 4.5 days.

Overall outage – 5 business days

•

Completed SLA conversion of entire AR data

(approximately 15 years) and AP data (13 months

containing billions of rows) as part of this upgrade

•

Reduced the 12.2 driver runtime from 69 days to 27

hours and automated remediated code deployment

to keep downtime to the minimum

Centers for Medicare and Medicaid Services Upgrades

to Oracle E-Business Suite 12.2

•

Oracle Application Object Library

•

Oracle Applications Technology Stack

•

Oracle Database - Enterprise Edition

•

Enterprise Manager Base Platform

•

Oracle WebCenter Portal

•

Oracle Business Intelligence

•

Oracle Governance, Risk, and Compliance

(25)

CUSTOMER PERSPECTIVE

“The efficiencies gained through adoption of standard

E-Business Suite modules, consolidation of data, and

the move to Exadata - Exalogic has a profound impact

on our business, saving Thousands processing hours

per year across retail and financial close operations.”

Awad Ahmed Ali El-Sidiq

, Senior Database

Administrator - Team Lead ,Abu Dhabi National Oil

Company Distribution

COMPANY OVERVIEW

•

Abu Dhabi National Oil Company Distribution (ADNOC Distribution) is a United Arab Emirates

(UAE) government-owned company that specializes in marketing and distributing petroleum

products within the country.

•

ADNOC Distribution is one of the largest and more innovative petroleum companies in the Arab

Gulf and Middle East, with 5,000 concurrent daily users and more than 350 million financial

transactions annually at its filling stations.

•

Industry: Oil and Gas

•

Employees: 13,000

CHALLENGES/OPPORTUNITIES

•

Improve efficiency of human resources (HR), finance, and supply-chain departments, which

form the backbone of ADNOC Distribution’s operations

•

Remove processing bottlenecks and curb rising costs generated by more than 5,000 concurrent

Oracle Database users, 24/7 business-critical applications, and multiple operating systems

•

Sustain business growth with a comprehensive database solution that can significantly improve

productivity and business performance

SOLUTIONS

•

Oracle E-Business Suite

•

Oracle Financials

•

Oracle Learning Management

•

Oracle Payroll

•

Oracle Self-Service Human Resources

•

Oracle Exadata Database Machine

•

Oracle Exalogic Elastic Cloud

RESULTS

•

Replaced legacy and in-house systems with Oracle

Financials, Payroll and Self-Service Human Resources

to simplify business processes, enhance end user

experience, and reduce TCO

•

Experienced a 15x performance increase across

business processes, such as retail forms entry, retail

report generation, and stores’ financial closings

•

Reduced payroll processing time for 13,000

employees from 2.5 hours to 20 minutes

ADNOC Distribution Upgrades to Oracle E-Business

Suite 12.2 on Exalogic and Exadata

•

Oracle Enterprise Manager

•

Oracle Linux

•

Oracle Cloud SaaS – Talent Management

•

Oracle PaaS – DB as Service

•

Oracle GoldenGate

•

Oracle Active Data Guard

•

Oracle Application Server

(26)

CUSTOMER PERSPECTIVE

“Oracle EBS Release 12.2 provides the base to

effectively utilize a technically complex, vertically

integrated value stream within the dynamic customer

driven automotive industry. The on-line patching has

allowed shorter deployment windows increasing

production availability and capital utilization.”

Paul Flynn

, Vice President Operations

COMPANY OVERVIEW

•

Vertically integrated high speed, high variability value stream developing and manufacturing

electronics, microelectronics, software, vision systems, chemistry, glass coatings, glass

fabricating,

•

Industry: Automotive, Aerospace, and Commercial Fire Protection

•

Employees: 4,000+

•

Annual Revenue: US$1.38 billion

•

Mirrors shipped: 31,079,818

CHALLENGES/OPPORTUNITIE

S

•

Integrating and Developing Enterprise Resource Planning (ERP) and Value Chain Planning (VCP)

solutions supporting a high speed, highly variable value stream with lead times longer than

customer demand.

•

Existing ERP version 12.0.6 starting extended support.

•

Required patching window exceeds available time for patching

•

Custom scheduling tool for flow manufacturing utilized in final assembly areas.

•

Multiple methods / tools for production planning production areas.

•

Deploy new core procurement functionality.

•

Limited support of Flow Manufacturing.

•

Identify and retire unused custom elements.

SOLUTIONS

•

Upgrade ERP 12.0.6 to 12.2.4

•

Upgrade VCP 12.1.3.9 to 12.2.4.1

•

Utilize Production Scheduling for final assembly

•

Convert production from Flow Manufacturing to Discrete (In-Progress)

RESULTS

•

Completed upgrade in nine months, on time and

under budget

•

Retired 30% of customizations

•

Decreased the overall patching windows from 4 hours

to 2 hours (Trending shorter), with EBS Cutover of 25

minutes

•

Converted Final Assembly Manufacturing to Discrete

•

Retired custom schedule tool

Gentex Upgrades to Oracle E-Business

Suite 12.2 ERP and VCP

(27)

Customer Engagement Program

Oracle E-Business Suite Model

Enhancement Requests - My Oracle Support

Support Communities

Special Interest Groups (SIGs)

eForums Surveys/Feedback

Customer

Advisory Boards (CABs)

Strategy Councils

CIO

Advisory

Board

Customers

High

Low

Customer

Commitment &

Investment

27

(28)

•

Increased Visibility and Influence on ERs

–

Submit enhancement requests directly

–

View requests from others

–

Collaborate with other customers and Oracle

to discuss alternatives and proposed designs

–

Vote on requests to influence delivery

28

EBS Enhancement Requests in EBS Support Communities

(29)

ER Statistics:

•

Launched Oct 2014

•

~ 1900 ERs created

•

~ 5% of Community Content

is now ERs

•

~ 40K Active Users exposed

to the ER information

•

Over 7000 Votes cast

•

On Avg. ~4 ERs are created

each day in EBS

•

Payables now accepting ERs

in Community

FAQ: Doc Id 1584210.1

My Oracle Support Community

E-Business Suite

Enhancement Request in My Oracle Support Community

(30)

(31)

12.2 Upgrade Planning Considerations

31

1.

Build the Business Case for 12.2 Upgrade

2.

Understand Factors Driving Time and Resources

3.

Understand Online Patching Architecture

4.

Plan for Impacts on Business Users

5.

Plan for Impacts on Apps DBAs

6.

Plan for Impacts on Customization Developers

7.

Determine the Target Code Configuration

8.

Plan to Provision Upgrade Environments

9.

Understand the Upgrade Process

(32)

12.2 Upgrade Planning Considerations

32

1.

Build the Business Case for 12.2 Upgrade

2.

Understand Factors Driving Time and Resources

3.

Understand Online Patching Architecture

4.

Plan for Impacts on Business Users

5.

Plan for Impacts on Apps DBAs

6.

7.

Determine the Target Code Configuration

8.

Plan to Provision Upgrade Environments

9.

Understand the Upgrade Process

(33)

Key Factors Driving Time and Resources

12.1 to 12.2 Upgrade

•

Size of EBS footprint and uptake of new functionality

–

Number of modules and business flows that will need validation

•

Number and complexity of customizations and integrations

–

Compliance with new 12.2 development standards, including for vendor-supplied integrations

•

Complexity of topology

–

Multiple middle tier nodes, nodes inside and outside the firewall, RAC, etc.

•

Technical team skills

–

Readiness to adapt to 12.2 technology changes: Online Patching and WebLogic Server

•

Other changes you combine with the EBS upgrade

(34)

Different Project Team for the 12.1 to 12.2 Upgrade

11.5.10 to 12.1

12.1 to 12.2

34

Technical team is key

Functional team is key

•

DBAs

•

System Administrators

•

Customization Developers

•

Financials Specialists

•

Tax Specialist

(35)

Online Patching

Dramatically Reduce Patching Downtime

•

Remove

obsolete

objects

•

Restart

application on

Patch Edition

•

Compile invalid

objects

•

Wait for a good

downtime window

•

Apply one or more

patches to the

Patch Edition

•

Copy the

production app

code

•

Create a new Patch

Edition in the DB

Cutover

Finalize

Apply

Prepare

Cleanup

Users

Online

Users

Offline

Users

Online

•

Online Patching cycle includes 5 phases

•

Application is only offline during the “Cutover” phase

•

Online Patching is used to apply all EBS patches in 12.2

(36)

12.2 Online Patching Architecture

36

Synchronization is managed

by patching tools

Editions-Enabled Database

Non-Editioned File System

Developer 10.1.2

COMMON_TOP

APPL_TOP

INST_TOP

Oracle HTTP Server (OHS)

WebLogic Server (WLS)

FS1

Developer 10.1.2

COMMON_TOP

APPL_TOP

INST_TOP

WebLogic Server (WLS)

FS2

PATCH_TOP

APPL_TOP_NE

LOGS

Run File System

Patch File System

(37)

Online Patching is enabled by 11gR2 Database Editioning

Multiple Copies of Database Code Objects Can Coexist

•

Client code connects to an

“edition” of database code

–

Run Edition

•

Used by online users

•

Never changed by a patch

–

Patch Edition

•

Used by patching tools

•

Changes do not affect the running application

•

Patch Edition becomes the

Run Edition at Cutover

37

DBA

(38)

Prepare:

Sync Patch & Run File Systems, Create Patch Edition in DB

38

Synchronization is managed

by patching tools

Developer 10.1.2

COMMON_TOP

APPL_TOP

INST_TOP

FS1

Developer 10.1.2

COMMON_TOP

APPL_TOP

INST_TOP

FS2

PATCH_TOP

APPL_TOP_NE

LOGS

Run File System

Patch File System

FS_NE

EBS

Patch

(39)

Apply:

Apply Patches to Patch File System and Patch Edition in DB

39

Developer 10.1.2

COMMON_TOP

APPL_TOP

INST_TOP

FS1

Developer 10.1.2

COMMON_TOP

APPL_TOP

INST_TOP

FS2

PATCH_TOP

APPL_TOP_NE

LOGS

Run File System

Patch File System

FS_NE

EBS

Patch

(40)

Cutover:

Restart App Tier Services on Switched Patch and Run

40

Editions-Enabled Database

Developer 10.1.2

COMMON_TOP

APPL_TOP

INST_TOP

Run File System

Developer 10.1.2

COMMON_TOP

APPL_TOP

INST_TOP

Patch File System

FS1

FS2

FS_NE

PATCH_TOP

APPL_TOP_NE

(41)

Learn ADOP – New Utility to Orchestrate Online Patching

•

Prepare

the running system for an Online

Patching cycle

•

Apply

one or more patches with a single

adop command

•

Repeat

Apply

and

Finalize

phases as

often as needed

•

Defer

Cutover

until a convenient time

•

When users are back online, do

Cleanup

of obsolete objects

$ adop phase=prepare

$ adop phase=apply patches=1234,5678

$ adop phase=finalize

$ adop phase=cutover

$ adop phase=cleanup

41

Steps You Through the Online Patching Phases

See Oracle E-Business Suite Maintenance Guide, Release 12.2

for adop syntax options.

(42)

10gR2 | 11g

EBS Release 12.0/12.1

Technology Stack

Client

JDBC/S

Q

L Ne

t

HT

TP

/S

Application

Database

RAC & ASM

Global Single

Data Model

Forms

BI Publisher

BC4J

W

e

b

Lis

te

ne

r

10g

JSP

UIX

OC4J

42

(43)

EBS Release 12.2 Technology Stack

Client

JDBC/S

Q

L Ne

t

HT

TP

/S

Application

Database

R2

Edition-Based

Redefinition

WebLogic JSP

Forms

BI Publisher

BC4J

W

e

b

Lis

te

ne

r

WebLogic Server

RAC & ASM

Global Single

Data Model

43

(44)

WebLogic Server 11g

Part of the EBS 12.2 Application Tier

44

•

Familiar to some Apps DBAs/Sysadmins

•

Will use both EBS Autoconfig and native

WebLogic facilities for 12.2 configuration

•

Don’t assume that prior knowledge is

sufficient

See Managing Configuration of Oracle HTTP Server and Web Application Services in

Oracle E-Business Suite Release 12.2 (Doc 1905593.1)

(45)

Plan for Impacts on Apps DBAs

Summary



Learn ADOP, a new 12.2 utility to orchestrate Online Patching



Learn to use WebLogic Server 11g with Autoconfig for 12.2 configuration



Re-evaluate Application tier sizing for WebLogic Server & Dual File System



Practice EBS 12.2 cloning, including single-step cloning of Run & Patch file

systems (new with AD/TXK Delta 7)

(46)

Expectations Around Online Patching Downtime

Set Appropriate Expectations for Online Patching Downtime

•

Online Patching does not mean zero downtime

–

There is still a brief Cutover phase during which users are offline

•

DBAs can choose to combine Online Patching Cutover with other

maintenance activities that prolong the downtime, e.g.:

–

Applying custom code

–

Updating system passwords

•

Online Patching cannot be used for Database and OS patching

–

Users will still experience a downtime when Database and OS patches are applied

(47)

Evaluating Customizations

Plan for 12.2 Impacts on Customizations You Decide to Upgrade

•

EBS 12.2 data model changes

–

See Data Model Comparison Report (Doc 1290886.1)

•

New 12.2 UI standards for OA Framework-based pages

–

See Oracle E-Business Suite Release 12.2.4 Upgrade Considerations for OA

Framework-based Applications (Doc 1927975.1)

•

New 12.2 development standards for Online Patching compatibility

(48)

Decide Which Standards Compliance Level to Target

New 12.2 Development Standards for Custom Code

Minimal

Full

•

Optional, additional standards

must be met for custom code to

be Online Patchable

•

Required, minimal set of

standards must be met for custom

code to run correctly on 12.2

•

Decision is based on importance of minimizing downtime

(49)

Custom Code is Fully Compliant with 12.2 Standards

Apply Custom Code While Users are Online, Incur Brief Cutover Downtime

•

Remove

obsolete

objects

•

Restart

application on

Patch Edition

•

Compile invalid

objects

•

Wait for a good

downtime window

•

Apply EBS patches

to the Patch

Edition

•

Apply custom

code patches to

the Patch Edition

•

Copy the

production app

code

•

Create a new Patch

Edition in the DB

Cutover

Finalize

Apply

Prepare

Cleanup

Users

Online

Users

Offline

Users

Online

•

Apply to the Patch Edition while users are online

•

Patch both EBS and custom code during same Apply phase

•

Restart application on Patch Edition after brief Cutover period

(50)

Custom Code is Minimally Compliant with 12.2 Standards

Apply Custom Code During Extended Cutover, Prolonging the Downtime

•

Remove

obsolete

objects

•

Apply custom code

to new the Run

Edition during

Extended Cutover

•

Compile invalid

objects

•

Wait for a good

downtime window

•

Copy the

production app

code

•

Create a new Patch

Edition in the DB

Cutover

Finalize

Apply

Prepare

Cleanup

Users

Online

Users

Offline

Users

Online

•

Prevent automatic restart at end of Cutover

•

Apply custom code directly to new Run Edition

•

Restart application after Extended Cutover period

52

Extended

Cutover

•

Apply EBS patches

to the Patch

(51)

Identify Standards Violations and Recommended Fixes

Reports to Check for Standards Compliance

Summary Readiness Report

Custom DB schemas you must register with

EBS before Online Patching Enablement

Manual Fix Readiness Report

Custom DB objects you must manually fix

before Online Patching Enablement

Database Standards Checker

DB objects and code that violate 12.2

development standards

File System Standards Checker

File system source files that violate 12.2

development standards

(52)

Preparing Custom Code: Prior to 12.2 Upgrade Project

55

Run Reports and Apply Fixes Today to Avoid Rework at Upgrade Time

See Using the Online Patching Readiness Report in Oracle E-Business Suite Release 12.2 (Doc 1531121.1)

Get the reports patch

for your current

release (11.5.10,

12.0, or 12.1)

Run reports

on current

release

Apply recommended

fixes in test

environments

Iterate until compliant

Deploy

remediated code

in production

(optional)

Recommended fixes

are backward

compatible

(53)

Preparing Custom Code: During 12.2 Upgrade Project

56

Run Reports During 12.2 Upgrade Cycles to Confirm Standards Compliance

See Using the Online Patching Readiness Report in Oracle E-Business Suite Release 12.2 (Doc 1531121.1)

Upgrade to

12.2

Run reports

on 12.2

Apply recommended

fixes to custom DB

code and schemas

•

Iterate until compliant for DB

•

Apply MT fixes at later stage

Re-run reports to

confirm standards

compliance

Run Online

Patching

Enablement

Automatically fixes

many violations

(54)

Summary



Learn new 12.2 development standards that apply to custom code and

many integrations



Decide on Minimal vs. Full development standards compliance based on

importance of minimizing patching downtime



Leverage Oracle-supplied reports

today

to prepare custom code for 12.2



Confirm that your third-party integrations have been validated with 12.2

(55)

Understand the Technical Upgrade Process

Overview

•

You perform the 12.2 upgrade during downtime

•

You get Online Patching as a result of doing the 12.2 upgrade

•

The upgrade includes additional steps to enable Online Patching

(56)

Understand the Technical Upgrade Process

Key Takeaways

•

Critically important to follow latest, documented upgrade instructions

•

Start with Oracle E-Business Suite Release 12.2: Technical Planning, Getting

Started, and Go-Live Checklist (Doc 1585857.1)

–

Summary of technical upgrade planning considerations

–

Flowchart of upgrade execution steps

–

Pointers to related 12.2 docs

(57)

Test and Optimize Your Upgrade Process

Overview

•

As for any upgrade to a major new release level …

–

Plan to do full functional testing

–

Plan to do load and volume testing

–

Include customizations and integrations in your test plans

•

Plan for 12.2-specific testing

•

Plan to minimize upgrade downtime

(58)

Plan for 12.2-Specific Testing

Where & Where Not to Test Online Patches

•

Test Online Patches on a system that matches your production topology

•

Especially critical for complex topologies, such as those involving:

–

Multiple nodes

–

Nodes inside and outside the firewall (DMZ)

–

RAC

(59)

Plan for 12.2-Specific Testing

Where & Where Not to Test Online Patches

•

Understand that Patch Edition is not a test environment

–

Designed solely for reducing patching downtime

–

Usable only when an Online Patching cycle is in progress

–

Cannot be accessed by end users

•

Must apply and validate every Online Patch on a test system

–

Consider performing tests with users online during patch application

(60)

Plan to Minimize Upgrade Downtime

Do Several Complete Practice Upgrades

•

Iterate on a step-by-step plan of tasks and timings

–

Ensure consistency with latest upgrade documentation

–

Use a topology similar to your production environment

•

With each iteration, optimize your timing

–

Tune performance of core upgrade driver

•

Identify long-running jobs & SQLs, check MOS for known issues & workarounds

–

Minimize duration of tasks done before & after core upgrade driver runs

•

For example: interim backups, final acceptance testing

•

Repeat practice upgrades until the process is predictable and fits within your

downtime window, with no outstanding issues

63

(61)

Related Sessions

12.2 Technical Upgrade Process

Thursday

Oct 29

1:15 pm

-2:00 pm

CON8141 - Technical Upgrade Best Practices for Oracle E-Business Suite 12.2

Samer Barakat

, Director, Applications Performance, Oracle

Udayan Parvate

, Senior Director, EBS Release Engineering, Oracle

MW-3022

(62)

Key Takeaways

Project Manager

1.

A more technical project team is needed than for prior 11i to 12 upgrade

2.

DBAs should learn about WebLogic Server & new ADOP patching tool

3.

Developers should learn new 12.2 development & deployment standards

4.

Project team should read and follow 12.2 documentation, starting with

12.2 Technical Planning Guide (Doc 1585857.1)

5.

Project team should seek Oracle Support’s help when obstacles are met

(don’t improvise)

(63)

Key Takeaways

Technical Team

1.

All EBS patches for 12.2 and beyond are Online Patches

2.

Online Patches still need to be tested on a test system

3.

Developers can start applying new 12.2 standards to custom code

today

with the help of Oracle-provided compliance reports (Doc 1531121.1)

4.

DBAs will use both WebLogic Server 11g and the traditional EBS

Autoconfig tool for 12.2 configuration changes (Doc 1905593.1)

5.

DBAs should plan to stay current with latest Database, Middleware, and

EBS patches during and after the 12.2 project

(64)

(65)

Comprehensive Training

Prepare implementation and

technical professionals to effectively

perform the tasks relevant to their

job with on demand training

•

Oracle

E-Business Learning Subscription

Learning Simplified

24/7 Access for 12 Months

All-digital training with on-demand

videos, product demonstrations

and practice labs

Expert Delivered

Created and delivered by Oracle

experts

Continuous Updates

Regular updates for product

enhancements and new releases

Flexible and Scalable

To meet your business needs

(66)

•

See Video Highlight and Other Links at Bottom of Press Release

69

EBS 12.2.5 Press Release and Video Highlight

Generally Available Oct 16, 2015

Link to Press Release

(67)

blogs.oracle.com/stevenChan

•

Direct from EBS Development

•

Release Value Props

•

Release Content Docs

•

Install Guide

•

Upgrade Guide

•

Implementation Guides

•

FAQs & White Papers

•

Online Training (TOIs)

•

Proactive Support Tools

Release 12.2 Information Center,

Doc 1581299.1

Keep Current with Latest 12.2 Info

(69)

EBS Release Content Documents

12.1 and 12.2 New Products and New Features,

Doc 1302189.1

72

Organized by

family, product,

and point release

(70)

EBS Transfer of Information Online Training,

Doc 807319.1

On-Demand, Self-Service Training for Implementers

73

How to implement

and use new products

and new features

(71)

E-Business Suite Globalization Center,

Doc 973912.1

Information on Localizations, Internationalizations, Translations

74

Legislative

Updates

Center

Country Specific

Feature Data Sheets

(72)

Review and Download the Latest Oracle E-Business Suite Documentation

EBS Documentation Web Library

http://docs.oracle.com/cd/E26401_01/index.htm

HTML and

PDF

formats

(73)

(74)

Oracle Premier Support: Get Proactive!

(75)

(76)

How to Find E-Business Suite & E-Business Suite Technology Stack Patches

(Doc ID 1633974.2)

TABBED

(77)

My Oracle Support “Hot Topic” for E-mailed Updates

(78)

Some Suggested “Hot Topics”

•

Oracle E-Business Suite Release 12.2: Technical Planning, Getting Started,

and Go-Live Checklist (Doc ID 1585857.1)

•

Oracle E-Business Suite Release 12.2 Technology Stack Documentation

Roadmap (Doc ID 1934915.1)

•

Oracle E-Business Suite Release Notes, Release 12.2 (Doc ID 1320300.1)

•

Oracle E-Business Suite Release 12.2: Consolidated List of Patches and

Technology Bug Fixes (Doc ID 1594274.1)

•

Applying the Latest AD and TXK Release Update Packs to Oracle E-Business

Suite Release 12.2 (Doc ID 1617461.1)

(79)

Stay Informed

•

Oracle E-Business Newsletters

•

Follow Oracle Premier Support through social media channels

–

Twitter

|

myoraclesupport

|

Oracle_EBS

–

Blog

–

My Oracle Support Community

–

Facebook

•

Participate in

Advisor Webcasts

and hear from Oracle Premier

Support subject matter experts who will offer methods and

solutions to help you avoid potential pitfalls

(80)

(81)

12.2 Documentation - Important Docs

•

12.2 Information Center: Doc ID 1581299.1

•

12.2 Documentation:

http://docs.oracle.com/cd/E26401_01/index.htm

•

Always use this Web Library as it contains the most recent versions of the documentation

•

Oracle E-Business Suite Release 12.2 Technology Stack Documentation Roadmap (Doc ID 1934915.1)

•

Oracle E-Business Suite Release 12.2: Technical Planning, Getting Started, and Go-Live Checklist (Doc ID 1585857.1)

•

Oracle E-Business Suite Release Notes, Release 12.2 Note 1320300.1

•

Oracle E-Business Suite Release 12.2: Upgrade Sizing and Best Practices (Doc ID 1597531.1)

•

Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 Note 1617461.1

•

Oracle E-Business Suite Release 12.2.4 Readme Note 1617458.1

•

Upgrade Advisor: E-Business Suite (EBS) 11i Upgrade to 12.2 Note 1614508.1

•

Upgrade Advisor: E-Business Suite (EBS) Upgrade from 12.0/12.1 to 12.2.x Note 1593640.1

•

Database Preparation Guidelines for an E-Business Suite Release 12.2 Upgrade Note 1349240.1

•

Database Patch Set Update Overlay Patches Required for Use with PSUs and Oracle E-Business Suite Note 1147107.1

resource for database patch conflicts

•

Database Initialization Parameters for Oracle E-Business Suite Release 12 Note 396009.1 Contains 12.2 specific settings

(82)

12.2 Documentation - Important Docs

•

Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone Note 1383621.1

•

Enabling SSL in Oracle E-Business Suite Release 12.2 Note 1367293.1

•

Oracle E-Business Suite Release 12.2 Configuration in a DMZ Note 1375670.1

•

Using Load-Balancers with Oracle E-Business Suite Release 12.2 Note 1375686.1

•

Sharing The Application Tier File System in Oracle E-Business Suite Release 12.2 Note 1375769.1

•

Oracle E-Business Suite Recommended Performance Patches Note 244040.1

•

Managed Server Related Information

•

Managing Configuration of Oracle HTTP Server and Oacore, Oafm, Forms and Forms-c4ws Applications in Oracle E-Business Suite

Release 12.2 Note 1905593.1

•

Deploying Customizations in Oracle E-Business Suite Release 12.2 Note 1577661.1

•

Creating a Custom Application in Oracle E-Business Suite Release 12.2 Note 1577707.1

Working with customers to date we have found it is important to use and follow the latest documentation

and it does change….

(83)

12.2 Troubleshooting

TROUBLESHOOTING:

•

EBS Technology Codelevel Checker (ETCC) – (Doc ID: 1594274.1) Downloaded via Patch 17537119

•

analyzes a Oracle Database Oracle Home and warns of missing database bug fixes

•

Script to Diagnose adop and Other AD-TXK Issues in Oracle E-Business Suite Release 12.2 (Doc ID 1901242.1)

•

Rapid Install for E-Business Suite Release 12.2 (Doc ID: 1378579.1) see appendix A for Rapid Install log file locations

•

12.2 E-Business Suite - How To Enable FND: Debug / AF Logging When Login Is Not Possible (Doc Id: 1563168.1)

•

Using Oracle Fusion Middleware Diagnostic Framework With Oracle E-Business Suite Release 12.2 (Doc Id: 1428056.1)

WEBLOGIC:

•

Oracle Applications E-Business Suite 12.2 Fusion Middleware Log Files: Locate,View, and Control (Doc ID 1366187.1)

•

12.2 Ebusiness Suite - Collecting Fusion Middleware Log Files (Doc ID 1362900.1)

CONFIG:

•

Oracle E-Business Suite Release 12.2 Configuration in a DMZ (Doc ID 1375670.1)

•

DMZ and SSL Configuration Guide for Oracle E-Business Suite Extensions for Oracle Endeca, Release 12.2 V4 and V5 (Doc ID 1575921.1)

•

11i - 12.2 Oracle Application Framework Troubleshooting Guide- (Doc ID 1496055.1)

•

Oracle E-Business Suite Java APIs for Forms Troubleshooting Guide, Release 12.2 (Doc ID 1469785.1)

•

Oracle E-Business Suite Integrated SOA Gateway Troubleshooting Guide, Release 12.2 (Doc ID 1317697.1)

(84)

Sizing & Testing Documents

Sizing:

•

Database and Application Tier Sizing Guidelines

from our 12.2 Install Guide

•

Oracle XML Gateway Sizing and Performance Guidelines

Testing:

•

Oracle Open World 2014 Presentation:

Presentation Download

CON7168 - Testing Oracle E-Business Suite: Best Practices from Oracle Development

Tuning:

•

Tune performance of the core upgrade driver… See

•

Oracle E-Business Suite Upgrade Guide, Release 11i to 12.1.1

•

Oracle E-Business Suite Upgrade Guide Release 11i to 12.2

(85)

•

Configuration

•

Managing Configuration of Oracle HTTP Server and Web Application Services in Oracle E-Business Suite

Release 12.2 (Doc ID 1905593.1

)

•

Feature Functionality Usage:

•

RCD’s- R12.1 / R12.2 : Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Documents (Doc ID

1302189.1

(86)

Performance & Benchmark

Performance

•

Oracle E-Business Suite Performance Guide (Doc ID 1672174.1)

•

Express Diagnosis of Oracle E-Business Suite Release 12 Upgrade Performance Issues (Doc ID 1583752.1)

•

Recommended Performance Fixes (Doc Id 244040.1)

•

CON7693_Barakat-Getting Optimal Performance from Oracle E-Business Suite - CON7693.pdf

Oracle Benchmarks

http://www.oracle.com/us/solutions/performance-scalability/index.html

•

Oracle Applications Benchmark

http://www.oracle.com/us/solutions/benchmark/apps-benchmark/index.html

•

Oracle R12 E-Business Standard Benchmark Overview

(87)

How to Find E-Business Suite & E-Business Suite Technology Stack Patches

(Doc ID 1633974.2)

TABBED

(88)

Patch Wizard – Doc 976188.1



Patch Wizard analyzes and compares

patches currently applied in your

instance with the ones included in the

Recommended Patch List



Patch Wizard performs an impact

analysis, and allows for easy download

of patches you decide to apply

(89)

(90)

Bundle Benefits:

•

Easy to install and obtain all available EBS Support Analyzers in Index [Doc ID 1545562.1]

•

Convenient method for DBA/SYSADMIN to execute analyzers from a single menu

•

Provides a Maintenance methodology for obtaining new and updated analyzers

•

Quickly load and register Analyzers as Concurrent Programs

•

Menu option shows Analyzers installed as concurrent programs and versions

•

Ability to remove and uninstall from the menu

(91)

Period Close Advisor – Doc 335.1



One-stop shop for period close

steps for all products (in the

order of closing)



Complete the critical financial

reporting process accurately

(92)

Classroom Training

Learning Subscription

Live Virtual Class

Training On Demand

Keep Learning with Oracle University

education.oracle.com

Cloud

Technology

Applications

Industries

(93)

(94)

see Oracle Lifetime Support Policy: Oracle Applications

http://www.hhs.gov/about/budget/fy2015/budget-in-brief/index.html

Link to Press Release

education.oracle.com/streams/ebusinesssuite