Oracle EBS Release 12.2 from A to Z. Real Experience of a Technical Upgrade
Presentador:
Gustavo Gonzalez, CTO
[email protected] @ggonza4itc
IT Convergence Release 12.2
Presenter Gustavo González IT Convergence, Chief Technology Officer
© IT Convergence 2014 All rights reserved.
Co-Author of “Oracle E-Business Suite Financial Handbook Third Edition” McGraw-Hill / Oracle Press
IT Convergence Release 12.2
More about Gustavo @ggonza4itc
§ Oracle ACE Director Specialty Applications § More than 15 years Oracle Applications Experience § Head of IT at IT Convergence since 2006 § Co-Author “Oracle E-Business Suite Financials Handbook 3rd Edition” § Technical Editor “Oracle Fusion Applications Development and Extensibility Handbook” § Member of the Oracle EBS Customer Advisory Board § Member of the Oracle Usability Advisory Board § Project Manager of the R12 Upgrade at IT Convergence § Project Manager of R12.2 Beta Program & Early Adopter § Project Manager of Fusion Apps Implementation at ITC © IT Convergence 2014 All rights reserved.
IT Convergence Release 12.2
About IT Convergence § Premier Global Oracle Services Company § Consulting, Education, Development, Testing, Hosting & Managed Services § International Staffing / Delivery Model § Deep relationship with Oracle Development – 12.2 Beta Partner § Oracle Platinum Partner and OAUG Star Partner Level Five § Recognized by Gartner § 80+ R12 Upgrades Plus Roll Outs and Training Workshops § Focus is Long-Term Business Relationships § Full-Service Oracle Provider with 850+ FTE’s globally
© IT Convergence 2014 All rights reserved.
IT Convergence Release 12.2
Taking our own medicine
Used the E-Business Suite since 2004
Upgraded to R12 in January 2009
Implemented OBIEE in January 2010
R12.2 Beta Program in January 2012
And we host our systems running Oracle VM
© IT Convergence 2014 All rights reserved.
R12.2 Early Adopter since October 2013
New Features
INTRODUCTION
IT Convergence Release 12.2
Joe’s Volvo 1996
© IT Convergence 2014 All rights reserved.
IT Convergence Release 12.2
New Volvo XC90
© IT Convergence 2014 All rights reserved.
E-BUSINESS SUITE RELEASE 12.2 GENERAL AVAILABILITY & SUPPORT
IT Convergence Release 12.2
Oracle E-Business Suite Support Timelines Updated Support Polices for 11.5, 12.0, 12.1& 12.2 2010
2011
2012
2013
Nov '10
2015
Nov '13
EXTENDED
11.5.10
2014
2016
2017
2018
2019
2020
2021
Dec ’15
SUSTAINING
EXEPTION
Offer Exception to Sustaining Support
Jan ‘07
12.0
PREMIER
Jan '12
Jan '15
EXTENDED
SUSTAINING
Dec‘16
May ‘09
12.1
Dec’19
EXTENDED
PREMIER Extend 12.1 Premier Support thru Dec ‘16
Sep‘18
Sep‘13
PREMIER
12.2 Today
© IT Convergence 2014 All rights reserved.
EXTENDED
Sep’21
2022
E-BUSINESS SUITE RELEASE 12.2 TECHNOLOGY CHANGES
IT Convergence Release 12.2
Technology Stack Changes
© IT Convergence 2014 All rights reserved.
IT Convergence Release 12.2
SOA Suite Uptake
E-Business Suite 12.1.3
E-Business Suite 12.2
Integrated SOA Gateway
Integrated SOA Gateway
WS Framework
Adapter Framework & EBS Adapter Lib
WSIF
Oracle AS & 10g for E-Business Suite
© IT Convergence 2014 All rights reserved.
SOA Suite
WebLogic Server 11g
IT Convergence Release 12.2
Oracle Weblogic and Licensing § Customers' existing E-Business Suite licenses will cover Oracle Weblogic Server (WLS). § Existing E-Business Suite licenses include iAS EE, which in turn includes WLS Basic. § EBS customers who have customized their environment must purchase full-use iAS EE licenses. § Customers' optional use of EBS 12.2's Integrated SOA Gateway components will require additional full-use licenses for both SOA Suite and the Oracle Applications Adapter.
© IT Convergence 2014 All rights reserved.
IT Convergence Release 12.2
Advantages Integrated SOA Gateway in E-Business Suite R12.2 § Use the Integration Repository user interface to generate and deploy Oracle E-Business Suite Web services into Oracle SOA Suite § Leverage Oracle SOA Suite to handle SOAP requests and responses from Web service clients and consumers at run time § Support multiple authentication types for inbound service requests in securing Web service content and authenticating Web service operations § Support synchronous and asynchronous (callback without acknowledgement only) Web services § Audit and monitor Oracle E-Business Suite inbound service operations from Service Monitor © IT Convergence 2014 All rights reserved.
IT Convergence Release 12.2
Single Sign On integrations with E-Business Suite R12.2 Release 11i, 12.0 & 12.1
© IT Convergence 2014 All rights reserved.
Release 12.2
IT Convergence Release 12.2
E-Business Suite R12.2 Online Patching
E-Business Suite will remain available to users during patching operations
© IT Convergence 2014 All rights reserved.
Downtime window will be predictable and in minutes
Patches are applied while the production application remains online
IT Convergence Release 12.2
Online Patching Cycle - Phases Users Online
Users Offline
Users Online
Prepare
Apply
Finalize
Cutover
Cleanup
Copy the production application code
Apply one or more patches to the copy
Ready the system for cutover
Restart application on patched copy
Remove obsolete objects
© IT Convergence 2014 All rights reserved.
IT Convergence Release 12.2
Online Patching Cycle - Actions
© IT Convergence 2014 All rights reserved.
IT Convergence Release 12.2
E-Business Suite R12.2 Readiness Report § Online patching Readiness Report (MOS Doc ID #1531121.1) § Online patching Analysis Report (Patch #16236081) § Available for all releases prior to 12.2
§ Reports all violations of “Non-Editioned Objects can’t reference Editioned Objects” § Some EBR violations are automatically fixed by the 12.2 upgrade § The report is key to determine the scope of effort on custom code
© IT Convergence 2014 All rights reserved.
IT Convergence Release 12.2
E-Business Suite R12.2 Online Patching New Development Standards Editionable Objects
Non-Editionable Objects
§ Views (ordinary, not materialized)
§ Tables
§ PL/SQL code
§ Indexes
§ Synonyms
§ Materialized Views
§ User Types
§ Sequences
§ Virtual Private Database Policies
§ Database links
© IT Convergence 2014 All rights reserved.
§ Temporary Tables
IT Convergence Release 12.2
Development challenges § Objects that contain data are Noneditioned § Patching a table structure, must be done through “adop” and the EVs § Changes to a table are made on the base schema and the Editioning Views publish the correct object layout based on the current Edition
© IT Convergence 2014 All rights reserved.
E-BUSINESS SUITE RELEASE 12.2 FUNCTIONAL ENHANCEMENTS
IT Convergence Release 12.2
Functional Enhancements § Oracle Financials § Integration with Oracle Fusion Accounting Hub and Oracle Data Relationship Management. § New tax rule Operators § Ability to schedule AP/AR Netting Batch Program § New Legislative & regulatory updates for many countries
§ Oracle Projects: § Costing using HR rates or using Payroll actuals § Total Time Reporting for Exempt Employees
© IT Convergence 2014 All rights reserved.
IT Convergence Release 12.2
Functional Enhancements (Cont.) § Oracle Purchasing: § Parallel approvals § Improved Supplier User Interface Registration
§ Oracle Payroll and Oracle Time and Labor: § Simplified functions for local payroll administrators § Allow update person with future person type changes
§ Oracle Order Management: § Selling subscriptions § Enhanced Billing for Extended Warranty.
© IT Convergence 2014 All rights reserved.
IT Convergence Release 12.2
Functional Enhancements (Cont.) § Oracle Inventory Management § New Lot Allocation § Distributed WMS integration with R12
§ Oracle Warehouse Management: § Streamlined mobile user interfaces, enhanced managerial workbenches, improved catch-weight functionality and better extensibility supports greater fulfillment flexibility.
© IT Convergence 2014 All rights reserved.
IT Convergence Release 12.2
New in EBS Release 12.2.3
Flexfield Value Set Security Enhanced Setup
© IT Convergence 2014 All rights reserved.
Advanced Password Hashing
Worklist Header Icon
Skyros Lookand-Feel
IT Convergence Release 12.2
User Experience Design Patterns u Proven u Best
of Oracle applications
scientific usability
u Informed
by consumer expectations
u Design
u Deep understanding of Oracle toolkit
© IT Convergence 2014 All rights reserved.
pattern website
u Productivity for applications developers
u Result: Consistent, highquality user experience built by ADF enterprise community
IT Convergence Release 12.2
Common UX Design Patterns Persistent Global Area High-Level Actions Streamlines Navigation
u E-Business
Suite 12.1.3
u People
Soft 9.1
u Fusion
Applicati ons
© IT Convergence 2014 All rights reserved.
EXPERIENCE AND RECOMMENDATIONS
IT Convergence Release 12.2
IT Convergence Internal Upgrade to R12.2 § More than 50 customizations (multiple types) § Integrations (Payroll & others) § More than 350 test script ran § Multidisciplinary team § DBA, Functional, Technical, Developers, Testers
§ Unit & Stress tests § Latest cutover last 16 minutes § DB Size: 500Gb
© IT Convergence 2014 All rights reserved.
u Performance
metrics during online patching u CPU & I/O on Apps and DB Servers
IT Convergence Release 12.2
Recommendations § EBS 11i. 12.0 & 12.1 users should upgrade to 12.1.3 or 12.2. § Before upgrading, 11i users should be on the minimum 11i patching baseline. § Before upgrading, 12.0 users should be on the minimum 12.0 patching baseline,
§ Oracle Database 10gR2 and 11gR1 users should upgrade to 11.2.0.4 or 12.1.0.1 (not certified for 12.2 yet) § EBS 12 users of Oracle Single Sign-On 10g users should migrate to OAM 11gR2 Patchset 1 11.1.2.1.0 § EBS R12.2 it is “mandatory” to apply R12.AD.C.Delta.4 and R12.TXK.C.Delta.4 Release Update Packs (Note id: 1617461.1)
© IT Convergence 2014 All rights reserved.
IT Convergence Release 12.2
Recommendations (Cont.) § EBS 11i users of Oracle Single Sign-On 10g users should migrate to OAM 11gR2 Patchset 1 11.1.2.1.0 § Oracle Internet Directory 10g users should upgrade to Oracle Internet Directory 11g 11.1.1.7 § Oracle Discoverer users should migrate to Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Business Intelligence Applications (OBIA), or Discoverer 11g 11.1.1.7 § Oracle Portal 10g users should migrate to Oracle WebCenter 11g 11.1.1.7 or upgrade to Portal 11g 11.1.1.6 § All Windows desktop users should migrate from JInitiator and older Java releases to JRE 1.6.0_65 or later 1.6 updates or JRE 1.7.0_45 or later 1.7 updates § All EBS 11i, 12.0, 12.1, and 12.2 users must sign their environment's JAR files now. © IT Convergence 2014 All rights reserved.
IT Convergence Release 12.2
YES
Have you started your upgrade to R12.1.3?
NO
Are you in a phase that can move the target release?
Are you on 11.5 with no direct access to 12.2?
YES NO Prefer to stay in R12.1.3 for 3-5 years? NO
Are functional enhancements in R12.2 a priority for your business requirements?
YES
EBS Release 12.2
EBS Release 12.1.3
NO
Would you prefer to invest in a single upgrade project?
YES
YES Do you need high availability provided by Online Patching?
© IT Convergence 2014 All rights reserved.
Do you prefer a release with 1,000’s customers running it?
IT Convergence Release 12.2
How to get in touch Gustavo Gonzalez, CTO @ IT Convergence
[email protected] [email protected] +1 (415) 962-8604 // +54 (11) 4000-8484 Twitter: @ggonza4itc
LinkedIn: bit.ly/ggonza4itc
Twitter
LinkedIn
@IT_Convergence
www.linkedin.com/company/it-convergence
Blog
YouTube
itconvergence.blogspot.com
www.youtube.com/user/ITConvergenceMKT
© IT Convergence 2014 All rights reserved.
IT Convergence Release 12.2
© IT Convergence 2014 All rights reserved.