Oracle EBS Release 12.2 from A to Z. Real Experience of a Technical Upgrade

(1)

Oracle EBS Release 12.2 from A to Z.

Real Experience of a Technical Upgrade

Presentador:

Gustavo Gonzalez, CTO

[email protected] @ggonza4itc

(2)

Presenter

Co-Author of “Oracle E-Business Suite Financial Handbook Third Edition” McGraw-Hill / Oracle Press

Gustavo González

IT Convergence,

(3)

IT Convergence Release 12.2

More about Gustavo

§ 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

(4)

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

(5)

Taking our own medicine

And we host our systems running Oracle VM

Used the E-Business Suite since 2004 Upgraded to R12 in January 2009 Implemented OBIEE in January 2010 R12.2 Early Adopter since October 2013 R12.2 Beta Program in January 2012

(6)

(7)

(8)

(9)

E-BUSINESS SUITE RELEASE 12.2

(10)

Oracle E-Business Suite Support Timelines

Updated Support Polices for 11.5, 12.0, 12.1& 12.2

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

12.0

Jan '12 Jan '15 Jan ‘07

PREMIER EXTENDED SUSTAINING

12.1

May ‘09 Dec‘16

PREMIER EXTENDED

Dec’19

Extend 12.1 Premier Support thru Dec ‘16

12.2 11.5.10 Nov '10 EXTENDED SUSTAINING Nov '13 Dec ’15 EXEPTION

Offer Exception to Sustaining Support

PREMIER Sep‘18 Sep‘13 EXTENDED Sep’21 Today

(11)

E-BUSINESS SUITE RELEASE 12.2

(12)

(13)

SOA Suite Uptake

E-Business Suite 12.2

Integrated SOA Gateway SOA Suite

WebLogic Server 11g

E-Business Suite 12.1.3

Integrated SOA Gateway

Oracle AS & 10g for E-Business Suite WS

Framework

Adapter Framework

(14)

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.

(15)

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

(16)

Single Sign On integrations with E-Business Suite

R12.2

(17)

E-Business Suite R12.2 Online Patching

E-Business Suite will remain available to users during patching operations Downtime window will be predictable and in minutes Patches are applied while the

production application remains online

(18)

Online Patching Cycle - Phases

Apply one or more patches to the copy Ready the system for cutover Restart application on patched copy Remove obsolete objects Copy the production application code

Prepare Apply Finalize Cutover Cleanup

(19)

(20)

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

(21)

E-Business Suite R12.2 Online Patching

New Development Standards

§ Views (ordinary, not materialized) § PL/SQL code § Synonyms § User Types § Virtual Private Database Policies § Tables § Temporary Tables § Indexes § Materialized Views § Sequences § Database links

(22)

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

(23)

E-BUSINESS SUITE RELEASE 12.2

(24)

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

(25)

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

(26)

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.

(27)

New Release 12.2.4

–

Tech Stack

§  Online Patching Log Analyzer: This utility automates analysis of

adop log files, locating warnings and errors and then displaying messages to help you quickly and easily identify any problems that occurred in an adop run.

§ Online Patching Standard Cleanup: The new 'standard' cleanup

mode performs the same cleanup actions as the existing 'quick' mode, and in addition removes obsolete editioned code objects. This new mode is the default.

§ Online Patching Downtime Mode: This new adop option can be

used to apply patches to the run edition of the Oracle E-Business Suite database and file system without the need to run an online patching cycle. Patch application in downtime mode is faster than online mode, but requires longer system downtime. Downtime mode is only supported for production use where explicitly documented, or when directed by Oracle.

(28)

(29)

Oracle E-Business Suite Mobile App

Oracle EBS Mobile App MOS Note

Oracle Mobile Timecards for Oracle E-Business Suite

Note 1669224.1 Oracle Mobile Approvals for Oracle

E-Business Suite

Note 1642423.1

Oracle Mobile Field Service Implementation Guide R12.2

(30)

(31)

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

u Performance metrics during online patching

(32)

(33)

Recommendations

Oracle E-Business Suite Release 12.2 Information Center - Documentation (Doc ID 1583110.1)

§ 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

(34)

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

(35)

Are you on 11.5 with no direct access to 12.2?

Do you prefer a release with 1,000’s customers

running it? Would you prefer to

invest in a single upgrade project? Are you in a phase that

can move the target release?

YES Prefer to stay in R12.1.3

for 3-5 years?

Do you need high availability provided by

Online Patching? Are functional enhancements in R12.2 a

priority for your business requirements?

Have you started your upgrade to R12.1.3? EBS Release 12.1.3 EBS Release 12.2

(36)

How to get in touch

Blog itconvergence.blogspot.com LinkedIn www.linkedin.com/company/it-convergence YouTube www.youtube.com/user/ITConvergenceMKT Twitter @IT_Convergence

Gustavo Gonzalez, CTO @ IT Convergence

[email protected] [email protected]

+1 (415) 962-8604 // +54 (11) 4000-8484

(37)

(38)