Increase Efficiency of Freight Shipping from Oracle E-Business Suite - A Case Study for Elkay Mfg.pdf
thesis about features of e-crm and e-loyalty and case of study about mobile phones in Uk.
Oracle E-Business R12.2 Step by Step Installation Guide
Oracle E-Business Consultancy Handbook by John PriestleyFull description
Oracle E-Business Consultancy Handbook by John PriestleyFull description
origami
10 Things You Can Do Today to Prepare for Oracle E-Business Suite 12.2 Nadia Bendjedou Senior Director, Product Strategy, Oracle
Supported Upgrade Paths
11.5.10
11.5.9
12.0 & 12.1
12.2
11.5.10 CU2 [1]
[1]: Patch Requirements for Extended Support of Oracle E-Business Suite Release 11.5.10 [ID 883202.1]
E-Business Suite 12.2 - Highlights Signature Feature – Online Patching for Business Continuity
Users remain online while patches are applied
User downtime is limited to the time required to restart the system
The maintenance window in 12.2 is predictable
Critical business operations and revenue generating activities are not interrupted
Preparing for the 12.2 Upgrade 12.2 Overall EBS READINESS
12.2 Online Patching READINESS
1. Review the Functional Changes
5. Understand the 12.2 Patching Cycle
2. Understand the Technical
6. Understand Edition Based
Architecture Changes 3. Consider Upgrading your Technical
Architecture 4. Learn about WebLogic Server
Redefinition (EBR, 11gR2 DB) 7. Understanding the Enablement
Process for Online Patching (OP) 8. Review Online Patching Standards 9. Plan for 12.2 Dual File System 10. Consider New Operational
Characteristics
#2 Understand The Technical Architecture Changes
Oracle E-Business Suite 11i Architecture Client
Application
Database
iA S 1.0.2.2.2
10g R2 | 11g
JServ
H T T P / S
r e n e t s i L b e W
JSP
BC4J UIX BI Publisher Forms
J D B C / S Q L N e t
Global Single Data Model
RAC & ASM
#2
Oracle E-Business Suite 12.0/12.1 Architecture #2 Client
Application
Database
10g 10g R2 | 11g OC4J
H T T P / S
r e n e t s i L b e W
JSP
BC4J UIX BI Publisher Forms
J D B C / S Q L N e t
Global Single Data Model
RAC & ASM
Oracle E-Business Suite 12.2 Architecture Client
Application
Database
R2 WebLogic Server
H T T P / S
r e n e t s i L b e W
WebLogic JSP
BC4J UIX 11g BI Publisher Forms
J D B C / S Q L N e t
Global Single Data Model
RAC & ASM Edition-Based Redefinition
#2
Oracle E-Business Suite Architecture Applications Tier – 12.1
#2
Applications Tier – 12.2 Oracle HTTP Server (OHS)
AS 10.1.3.1
WebLogic Server (WLS)
Developer 10.1.2
Developer 10.1.2
APPL_TOP
APPL_TOP
COMMON_TOP
COMMON_TOP
INST_TOP
INST_TOP
Fusion Midd leware 11g
Applications Tier
#2
Oracle E-Business Suite Architecture in 12.2
Forms & Reports Services – –
OracleAS 10.1.2.1 ORACLE_HOME Coming from 11i: Replaces the 8.0.6-based Oracle_Home provided by iAS 1.0.2.2
HTML-based Apps – FMW 11g ORACLE_HOME
–
Coming from 11i: Replaces the 8.1.7-based Oracle_Home provided by iAS 1.0.2.2
–
Coming from 12: Replaces the OracleAS 10.1.3-based ORACLE_HOME (OC4J) used in Oracle E-Business Suite 12.0 and 12.1
Oracle JDeveloper 10.1.2
#2 Understand the Technical Architecture Changes Resources
Oracle E-Business Suite 12.2 Technical Planning Guide, First Edition: 1585857.1
EBS 12.2 Product Information Center , 1581299.1
12.2 Documentation Library
#5 Understand the 12.2 Patching Cycle
Online Patching Online Patching Cycle - Overview Prepare • Copy the production app code • Create a new Patch Edition in the DB
Apply • Apply one or more patches to the Patch Edition
Users Online
Finalize • Compile invalid objects • Wait for a good downtime window
Cutover • Restart application on Patch Edition
Users Offline
Online Patching cycle includes 5 phases Application is only offline during the “Cutover” phase Online Patching is used to apply all patches in 12.2
Cleanup • Remove obsolete objects
Users Online
#8 Review Online Patching Standards
#8 Review Online Patching Standards a) Readiness Reports
Helps prepare customization and extensions for Online Patching – Custom schemas that require registration for Online Patching enablement – Custom objects that require manual intervention in order to avoid
invalidation post enablement All
Customers should
– Execute the Readiness Reports before enabling Online Patching – Understand and fix any exceptions reported before enabling Online
Patching
Standalone patches available for Readiness Reports – 11i, 12.0 & 12.1
#8 Review Online Patching Standards a) Readiness Reports
Summary Readiness Report (ADZDPSUM.sql) – Reports schemas that will be automatically editioned All
schemas owned by EBS are automatically registered for editioning
– Reports custom schemas with objects that will become invalid if schema is
not registered for editioining
Recommended to register all schemas listed
Manual Readiness Report ( ADZDPMAN.sql) – Reports custom objects that must be manually fixed before Online
Patching is enabled – Any exception not fixed will cause object invalidation post enablement
#8 Review Online Patching Standards a) Readiness Reports
No 3. Execute File System Standards Checker (gscc.pl )
Exceptions Reported
Yes
No
4. Fix Exceptions
Code Standards Compliant
#8 Review Online Patching Standards References for Readiness Reports and Development Standards
The standalone Readiness Reports are documented in the MOS Note:1531121.1
Development Standards are documented in Chapter 7 of the Oracle E-Business Suite Developer's Guide Release 12.2. – This book is currently available as part of the R12.2 Documentation
Library. The library can be downloaded from the Software Delivery Cloud, Under E-Business Suite 12.2 Media Pack
Key Takeaways
E-Business Suite Support Timelines Reinforce Customer Choice to Use 12.1 or 12.2 2008
2009 2010
2011 2012
GA Nov 2004
Premier
2014 2015
Nov 2013
Nov 2010
11.5.10
2013
Extended
12.0 GA Jan 2007
Premier
Sustaining
1
Extended
Sustaining Dec 2019
Dec 2016
Premier
GA May 2009
2
Extended
Premier
GA Sep 2013
3
Sep 2018
Sep 2013
12.2
2022 2023
Jan 2015
May 2009
12.1
2020 2021
Dec 2015
Exception
Jan 2012
2016 2017 2018 2019
Sep 2021
Extended
Support updates as of Sep 2013 1. 1 11.5.10 Sustaining Support Exception through Dec 2015 (from Dec 2014; additional 12 months) 2. 2 12.1 Premier Support through Dec 2016 (from May 2014; additional 31 months) 3. 12.1 Extended Support through Dec 2019 (from Dec 2018; additional 12 months) 3
Sustaining Sustaining
Which Release Should You Target? Will Depend on Your Circumstances
Choose 12.2 if you: – Need the high availability provided by Online Patching – Want the functional enhancements that are in 12.2 – Prefer to invest in a single project to upgrade directly to 12.2
Choose 12.1 if you: – Prefer to target a release with thousands of live customers – Would like to stay on 12.1 for 3-5 years before upgrading to 12.2 – Need to move from a release below 11.5.10 with no direct upgrade to 12.2
Key Takeaways
Don’t wait, keep moving forward with your upgrade
Direct upgrade path from EBS 11.5.10.2, 12.0.4 and 12.0.6 to 12.2
11gR2 (11.2.0.3) is Pre-requisite for 12.2
Get familiar with Web Logic Server
Understand the 12.2 Patching Cycle
Review Online Patching Standards
Plan for 12.2 Dual File System
Consider New Operational Characteristics
Q&A
What’s Hot in E-Business Suite Release 12.2 Plus Q&A with Oracle EBS Strategy Leader Nadia Bendjedou Senior Director Product Strategy Oracle Europe Shoba Sivanesan National Practice Manager – Oracle E-Business Suite UXC Red Rock Consulting
ORACLE E-BUSINESS SUITE R12.2 NEW FEATURES BY MODULE FAMILIES
Top Enhancement across Product Families FINANCIALS
PROJECTS
ORACLE GENERAL LEDGER 1) Oracle E-Business Suite General Ledger Integration with the Fusion Accounting Hub 2) Data Relationship Management (DRM) Integration with EBusiness Suite
ORACLE PROJECT BILLING 1) Standard Invoicing for Adjusted Transactions
ORACLE RECEIVABLES 1) Review and Manage Accounting Exceptions during Period Close 2) Automate Auto Lockbox Processing 3) Assign Customers to Unidentified Receipts using API 4) Golden Tax Adapter Enhancement for Mainland China ORACLE IEXPENSES 1) Standard Program to Update Employee Supplier bank account details from Payroll ORACLE ENVIRONMENTAL ACCOUNTING & REPORTING 1) Updated Carbon Disclosure Project Report 2) Enhanced Performance Dashboards 3) Enhanced Key Performance Indicators
ORACLE PROJECT COSTING 1) Labor Costing Enhancements 2) Costing with HR Rates with Support for Multiple Rates per Employee 3) New OTL Timecard Layout to Support Rate by Criteria 4) Labor Costing using Payroll Actual 5) Labor Costing Accruals 6) Total Time Reporting for Exempt Employees
ORACLE PROJECT MANAGEMENT 1) Planning with HR Rates 2) Updated Rates when Generating Forecast from the Workplan 3) Planning without Resource Classes 4) Planning by Cost Breakdown Structure PROJECT RESOURCE MANAGEMENT No enhancements
Top Enhancement across Product Families FINANCIALS
ORDER MANAGEMENT AND CONTRACTS
ORACLE E-BUSINESS TAX 1) Customer Tax Information Import 2) New Condition Set Operator for Tax Rules
ORACLE ORDER MANAGEMENT 1) OM integration with Oracle Approvals Management (AME) 2) Tax Calculation on Freight Charges 3) Credit Tolerance for Honouring Manually Released Credit Checks Holds 4) Support for Service as Promotional Goods 5) Scheduling Enhancements 6) Credit Card Authorisation Reversal 7) Support for Assemble-To-Order (ATO) Items in Pick-To-Order (PTO) Models and Kits 8) Order Information Portal (OIP) Enhancements 9) Support for Credit Hold Based on Bill To Customer 10) Selling Services Enhancements 11) User Defined Attributes (UDA) 12) Support for Advanced Catch Weight 13) Additional Business Events 14) Order Management Productivity Enhancements
ORACLE PAYMENTS 1) Payment Acknowledgement Import ORACLE PAYABLES No enhancements SUBLEDGER ACCOUNTING (SLA) No enhancements ORACLE ASSETS No enhancements
Top Enhancement across Product Families SUPPLY CHAIN MANAGEMENT (SCM)
ORDER MANAGEMENT AND CONTRACTS
ORACLE PROCUREMENT CONTRACTS 1) Apply Multiple Templates to a Sourcing or Purchasing Document 2) API’s for Importing Templates, Rules, Questions and Constants 3) New Clause Descriptor Field 4) Clause Mandatory Attribute at Rule Level 5) Clause Selection Placement by Contract Expert 6) Deletion of Provisional Sections from Solicitation to Award 7) Instruction Text 8) Multi-Row Variables 9) Display Clause Number and Sort by Clause Number 10) Repository Contracts Configurability Enhancements 11) UDA support for Deliverables 12) MS Word 2010 Certification 13) Contract Expert Performance Improvements
ORACLE SALES CONTRACTS 1) Repository Contracts Enhancements 2) UDA support for Deliverables 3) MS Word 2010 Certification ORACLE ADVANCED PRICING 1) Service Item Support in Promotional Modifiers 2) Support of Non-Continuous Price Breaks ORACLE SHIPPING 1) Integration to 3PLs or 3rd Party Distributed Warehouse Management System
Top Enhancement across Product Families SUPPLY CHAIN MANAGEMENT (SCM)
SUPPLY CHAIN MANAGEMENT (SCM)
ORACLE SOURCING 1) Add Requisition lines to a Draft Negotiation (RFx & Auction) 2) Response W ithdrawal 3) Track Amendment Acknowledgement 4) Staggered Awards 5) Import of Price Breaks 6) Negative Cost Fact ors 7) Sourcing API’s 8) Online Discussion Attachments 9) Terms and Conditions Controls 10) Lot Price Summation
ORACLE ISUPPLIER PORTAL 1) Integrate with Oracle Flow Manufacturing to View and Edit EKanbans 2) Capture Additional Supplier Contact Details
ORACLE SPEND CLASSIFICATION 1) Reclassify Historical Data 2) Asynchronous Approval Flow 3) Enhanced Training Data Upload 4) Enhanced Tracking Capabilities 5) Improvements in Analyzing Batches and Excel to Export 6) Increased Flexibility in Resetting Data
SERVICES PROCUREMENT No enhancements SOURCING OPTIMIZATION No enhancements
Top Enhancement across Product Families Human Capital Management (HCM)
Human Capital Management (HCM)
CORE HR 1) Workflow Synchronization 2) Update Records with Future Person Changes 3) Enhanced Key Performance Indicators
ORACLE PAYROLL 1) Enhanced Retro Pay set as Default
ORACLE SELF SERVICE HR 1) Support for Parallel Approvals in SSHR 2) Organization Chart 3) Current Effective Date Appears on Initial Page 4) Launch Actions from Side Navigator in Organization Chart or Talent Profile 5) Control the Display of Effective Date, Review, and Confirmation Pages 6) Use Quick Termination and Changing Hours Processes ORACLE TIME AND LABOR (OTL) 1) New Projects layouts for Actual Costing 2) Attachments in Timecards 3)
Checkbox to Confirm Time Entry Accuracy
ORACLE IRECRUITMENT 1) Multi Location Vacancy PERFORMANCE MANAGEMENT 1) Use Star Ratings to Rate Performance and Proficiency Levels SUCCESSION PLANNING No enhancements COMPENSATION WORKBENCH No enhancements
WHICH RELEASE SHOULD YOU UPGRADE TO?
Choosing R12.1.3 or R12.2 ? THIS WILL DEPEND ON YOUR CURRENT CIRCUMSTANCE CHOOSE R12.2 IF YOUR BUSINESS: 1) Needs the high availability provided by Online Patching
2) Wants the Functional Enhancements introduced in R12.2. 3) This also means that customisations within R11.5.10 can be replaced by standard functionality in R12.2 related to these enhancements 4) Prefers to invest in a single project to upgrade directly to R12.2 CHOOSE R12.1.3 IF YOUR BUSINESS: 1) Prefers to target a release with thousands of live customers
2) Would like to stay on R12.1 for 3 – 5 years before upgrading to R12.2