gl preso(agis)
Post on 03-Jun-2018
229 Views
Preview:
TRANSCRIPT
-
8/12/2019 Gl Preso(AGIS)
1/67
Upgrade to R12 Now
A Financials Overview
Presented by:
Lee Briggs, BizTech
-
8/12/2019 Gl Preso(AGIS)
2/67
Upgrade to R12 NowOAUG eLearning
Sessions
Presentation Date Presenter Company
Upgrade to R12 NowA
Financials OverviewJul 19, 2012 Lee Briggs
Upgrade to R12 NowA
Deep Dive into General
Ledger
Jul 26, 2012 Mohan Iyer
Upgrade to R12 NowThe
International and Multi-
National Arena
Aug 2, 2012
Marsha
Edgell/Thomas
Simkiss
Upgrade to R12 Now
Improvements in Cost
Management
Aug 9, 2012 Douglas Volz
Upgrade to R12 Now
Manufacturing and OrderProcessing Aug 15, 2012 Bob Bullman
Upgrade to R12 Now
Realizing Enterprise Value
with Projects R12
Aug 23, 2012 Mike Lennon
Upgrade to R12 Now
Round Table DiscussionAug 30, 2012 Thomas Simkiss
2
-
8/12/2019 Gl Preso(AGIS)
3/67
www.BizTech.com
Professional Services Firm
Professional Services firm focused on Oracle applications and technology
Oracle Platinum PartnerHighest Level of certification
Specialized Pillar Partner in BI/EPM, EBS, CRM, and Core Technology
Over 400 successful Oracle implementations over the past 15 years
NY, PA, NJ, VA offices with Regional, Global, and International clients
100+ Consulting Resources Centers of Excellence across key solutions and industries
Solutions: Oracle Applications, Technology, BI/EPM, and Managed Services
Industries: Financial, Professional, Business Services; Communications andMedia; Manufacturing; Distribution; Public Sector, Government; Healthcareand Life Sciences
BizTech Software Solutions : BizTech Data Integrators, BizTech InsightAccelerators, BizTech Reporting Foundation
Oracle License Reseller
3
-
8/12/2019 Gl Preso(AGIS)
4/67
Lee Briggs, BizTech
Director, Financials Management Practice 12 Years of experience as an Oracle Application
implementation consultant
Over 38 Full Cycle implementations
Coordinator of the ADI SIG
Oracle Certified Specialist in General Ledger and Payables
Prior Presentations at Collaborate XML PublisherTaking Reports from Drab to Fab! Collaborate 08 & 09
FSGs in Release 12: Since ADI Is Not Supported, How Do I Use BI Publisher?Collaborate 10
Desktop IntegratorsYou Mean I Can Load Data Straight From a Spreadsheet?
Collaborate 11
Inter and Intra Accounting in R12A Deep Dive Collaborate 12
http://www.partycity.com/http://upload.wikimedia.org/wikipedia/en/e/e0/Primavera_logo.png -
8/12/2019 Gl Preso(AGIS)
5/67
5
Contact Information
Thomas Simkiss, JD, CPA
Tsimkiss@BizTech.com
Lee Briggs
Lbriggs@BizTech.com
Bob Bullman
Bbullman@BizTech.com
Mike Lennon
Mlennon@BizTech.com
Mohan Iyer
mohan@fscpsolutions.com
Hans Kolbe
hanskolbe@celantrasystems.com
Douglas Volz
doug@volzconsulting.com 5
mailto:Tsimkiss@biztech.commailto:Lbriggs@BizTech.commailto:Bbullman@BizTech.commailto:Mlennon@BizTech.commailto:mohan@fscpsolutions.commailto:hanskolbe@celantrasystems.commailto:doug@volzconsulting.commailto:doug@volzconsulting.commailto:hanskolbe@celantrasystems.commailto:mohan@fscpsolutions.commailto:Mlennon@BizTech.commailto:Bbullman@BizTech.commailto:Lbriggs@BizTech.commailto:Tsimkiss@biztech.com -
8/12/2019 Gl Preso(AGIS)
6/67
Plan| The Right Strategy
Building a Business Case To Upgrade
-
8/12/2019 Gl Preso(AGIS)
7/67
R12 Upgrade Key Questions
Would you like to reduce reliance on IT staff for report creation?
Are you satisfied with the number of days it takes to close at period end?
Do you have a large number of sets of books?
Do you want to improve reconciliation and reporting at period end?
Would you like to increase the efficiency of your tax and paymentprocessing?
Are you required to maintain multiple accounting representations?
Would you like auditable and transparent accounting entries accessible with
full drilldown? Would you like to gain efficiency with processing and reporting across
operating units?
Would you like to implement shared service centers?
-
8/12/2019 Gl Preso(AGIS)
8/67
Ability to issue one payment instruction to the bank for payments of invoices in
multiple operating units was viewed as a huge benefit from the user community.
We have 60 sets of books and see tremendous efficiencies with running processes
across these sets of books using Ledger Sets.
Why Upgrade to R12Straight Talk from Customers
The ability to access multiple operating units with a single responsibility can simplify
SOX compliance monitoring.
Multi-Org Access Control (MOAC) will definitely reduce the workload and the number
of people performing process related tasks. The users are very excited and the
benefits of MOAC were readily visible to them.
Banks, taxes, payments, and accounting everything that becomes centralized will
bring tremendous efficiencies to our organization.
The functionality offered with Advanced Global Intercompany System (AGIS),
specifically the creation of physical invoices to be created for I/C transactions in Payables
and Receivables eliminates many customizationsin this area.
Centralization of subledger accounting rules would minimize set up and maintenance,
providing greater financial control, and enforcing a consistent approach for true global
accounting.
-
8/12/2019 Gl Preso(AGIS)
9/67
Plan| The Right Strategy
Why Upgrade to R12?
-
8/12/2019 Gl Preso(AGIS)
10/67
Continued Release and Innovation
10
EBSR12
EBSR12.1
EBS12.1.2
EBS12.1.3
2004 2007 2009 2010 2011
Released
Financials,Technology
Procurement, HCM, Service, SCM, Projects,Financials, Technology, MDM
Functional
Innovation
Major Release
Minor Release
EBS11i10
-
8/12/2019 Gl Preso(AGIS)
11/67
Focus on Opportunities to Achieve
Rapid Return
Invest in Ways to Standardize and
Simplify with a Global Business
Platform
E-Business Suite Release 12.1
11
-
8/12/2019 Gl Preso(AGIS)
12/67
Procurement
Customer &
Master DataManagement
HumanCapital
SupplyChain
Procurement
SupplyChain
HumanCapital
Customer &
Master DataManagement
Financials
ApplicationsTechnology
E-BusinessSuite12.1
& Projects
Oracle E-Business Suite
12
-
8/12/2019 Gl Preso(AGIS)
13/67
Procurement
SupplyChain
HumanCapital
Customer &Master DataManagement
Financials& Projects
ApplicationsTechnology
E-BusinessSuite12.1
Results:
Greater control with increased
flexibility
Centralized administration of global
shared services
Make better decisions with greater
insight
Increase Operational Control and
Efficiency
13
-
8/12/2019 Gl Preso(AGIS)
14/67
WHATS NEW IN 12
Ledgers and Ledger Sets Rules-based Accounting Engine
Unified Bank Account Model
Centralized Payments
Global Tax Engine
Global Intercompany System
RESULTS
Faster, simpler period end processing
Easily meet local accounting requirements
Streamline intercompany trading andreconciliation
Adapt quickly to regulatory changes
More productive shared service centers
Legal Entity
Operating Units
UNIFIED BANK ACCOUNT MODEL
ONE GLOBAL TAX ENGINE
Centrally managed rules
Consistent tax services
Tax Determination Process
Regime ApplicableTaxes
Tax Status,Rate
TaxableBasis
TaxCalculation
CENTRALIZED PAYMENTS ENGINE
Payments
Engine
Funds Capture and Disbursement
Greater Control, Increased Flexibility
14
-
8/12/2019 Gl Preso(AGIS)
15/67
ResponsibilityResponsibilityResponsibility
Holland
Legal Entity
Denmark
Legal Entity
Belgium
Legal Entity
Belgium
Legal Entity
Single Responsibility
Functional Tasks
Accounting
Billing, Dunning& Collections
Procurement
Order Management
Payments
Data Management
Holland
Operating Unit
Belgium
Operating Unit
Denmark
Operating Unit
Centralized Administration of Global
Shared Services
15
-
8/12/2019 Gl Preso(AGIS)
16/67
WHAT
Prebuilt analytics for Federal Financials Budget execution analysis
Spending & Payment analysis
HOW
Track appropriations, apportionments &
allotments
Track commitments, obligations, and
expenditures at different fund levels
Visibility and drill down at each fund level:
Fund, Programs, Projects, Organization,
Object Class
RESULTS
Monitor budget spending
Improve cash flow management
Minimize interest payments
Minimize delinquent debt amounts
Visibility to prepare new budgets
Make Better Decisions with
Greater Insight
16
-
8/12/2019 Gl Preso(AGIS)
17/67
Plan| R12 Financials
Why Upgrade to R12?
-
8/12/2019 Gl Preso(AGIS)
18/67
Financials
New Architecture SubLedger Accounting
Accounts Payable
Payments
Accounts Receivable eBusiness Tax
Advanced Global Intercompany System
Assets
Cash Management
General Ledger
18
-
8/12/2019 Gl Preso(AGIS)
19/67
New Architecture
Legal Entity Configurator Multi Organization Access Control
19
-
8/12/2019 Gl Preso(AGIS)
20/67
SubLedger Accounting
Accounting Rules Transaction Account Builder
Standard Reports
20
-
8/12/2019 Gl Preso(AGIS)
21/67
21
Primary LedgerUS GAAP rulesCorp COACorp CalendarUSD
Legal Entity:
France
Secondary LedgerFrench Fiscal rulesFrench COACorp CalendarEUR
Same Subledger
Transaction can
Create MultipleAccounting
RepresentationsCentralizedAccounting
Dr Cr
SubLedger Accounting
-
8/12/2019 Gl Preso(AGIS)
22/67
Accounts Payable
Payments within Accounts Payable is obsolete Representation of Suppliers in the Trading Community
Architecture
AP / AR Netting
Introduction of Invoice Lines Invoice Processing for Contract Financing, Retainage and
Progress Terms
Enhanced Invoice Approval including Line Level Approval
Non PO Invoices entered via iSupplier Portal Collaboration with Suppliers to Resolve Disputes
22
-
8/12/2019 Gl Preso(AGIS)
23/67
Accounts Payable (contd)
Oracle Disbursement Requests Discount Calculation Enhancements
Subcontractor Management for Engineering and Construction
Supplier Dispute Processing
Third Party Payments Replace Supplier Bank Accounts on Invoices
Change Taxes from Inclusive to Exclusive Online
New User Interface for Supplier Entry and Maintenance
23
-
8/12/2019 Gl Preso(AGIS)
24/67
Accounts Payable
24
-
8/12/2019 Gl Preso(AGIS)
25/67
Payments (Funds Disbursement)
Disbursement Dashboard
Electronic Payment Processing
Improved Remittance Advice
Reporting
Migration of Global Features
to Central Engine Payment Processing User
Interface
Enhanced Check Printing
Process
Consolidation of PaymentFeatures
25
-
8/12/2019 Gl Preso(AGIS)
26/67
Accounts Receivable
Revenue Management Enhancements Line Level Cash Application
Customer Standard User Interface Redesign
Funds Capture Enhancement Uptake
Refunds Enhancements Credit Card Error Handling
Credit Card Chargebacks
Deduction Management
Balance Forward Billing
Late Charges
26
-
8/12/2019 Gl Preso(AGIS)
27/67
Receivables
Line Level Cash Application
27
-
8/12/2019 Gl Preso(AGIS)
28/67
Receivables
Customer Standard User Interface
28
-
8/12/2019 Gl Preso(AGIS)
29/67
Accounts Receivable (contd)
Receivables Reconciliation Enhancement Additional Bills Receivable Reference Field
Collections Workbench Obsolescence
Bills of Exchange Obsolescence
Trade Accounting Obsolescence Cash Application Work Queue
Default Customer Bank Account Information on Unidentified
Receipts
29
-
8/12/2019 Gl Preso(AGIS)
30/67
Payments (Funds Capture)
Funds Capture Dashboard Supports multiple Payment Processing Systems
simultaneously
Improved Support for Credit Card Security Features
Out-of-the-box integration with third party payment systems PINless Debit Card Transaction Support
Improved Payer Notification of Settlement
Direct Debit Enhancement
Improved Batch Settlement Performance
30
-
8/12/2019 Gl Preso(AGIS)
31/67
Cash Management
Centralized Internal Bank Account Model Bank Account Balances and Interest Calculation
Bank Account Transfers
Cash Pooling
Bank Statement Accounting Bank Account Signing Authorities
Cash Positioning Intra-Day Activities
31
-
8/12/2019 Gl Preso(AGIS)
32/67
Payments
Funds Capture Dashboard
32
h
-
8/12/2019 Gl Preso(AGIS)
33/67
Cash Management
Bank Account Transfers
33
-
8/12/2019 Gl Preso(AGIS)
34/67
Cash Management (contd)
International Bank Account Number (IBAN) Support Bank Identifier Code (BIC) Support
Payment Group based Bank Statement Reconciliation
EDIFACT Bank Statement Format Update
Load Bank Statement for Current Date Manual Entry in Cash Position
34
-
8/12/2019 Gl Preso(AGIS)
35/67
General Ledger
Centralized Accounting Setup
Data Access Sets
Ledger / Ledger Set Architecture
Replacement for Disabled Accounts
Improvements to Financial Statement Generator Reporting to Display Content Set Values
Reporting to Support Drill-Down for non-contiguous account ranges
Streamlined Excel-based Financial Statement Publishing
35
-
8/12/2019 Gl Preso(AGIS)
36/67
General Ledger
36
-
8/12/2019 Gl Preso(AGIS)
37/67
eBusiness Tax
Configuration Options and Provider ServiceSubscriptions
Tax Configuration Manager
Tax Determination Services
Tax Simulator
Tax Reporting
Centralized Tax Record Repository for Audit and
Reporting
Guided Configurations
37
-
8/12/2019 Gl Preso(AGIS)
38/67
Advanced Global Intercompany System
Intercompany Balancing
Intercompany Invoicing
Intercompany Reconciliation
Manual Intercompany Transactions
38
-
8/12/2019 Gl Preso(AGIS)
39/67
Assets
Enhanced Mass Additions Interface for Legacy Conversions
Automatic Preparation of Mass Additions
Enhanced functionality for Energy Industry
Automatic Depreciation Rollback
Enhanced Logging for Asset Transaction and Programs
39
-
8/12/2019 Gl Preso(AGIS)
40/67
Procurement
SupplyChain
HumanCapital
Customer &Master Data
Management
Financials& Projects
ApplicationsTechnology
E-BusinessSuite12.1
Results:
Drive greater end user productivity
Reduce cost of ownership
Increase agility and lower integration
costs
Increase Value from Applications
40
-
8/12/2019 Gl Preso(AGIS)
41/67
Productive User Interfaces for Diverse Users
WHATImproved application usability through enhancements to native user interface
HOW
Type-ahead search
Dynamic Menus & Popups
Embedded OBIEE Analytics
Desktop Widgets
REST Services
RESULTS
Enhanced user productivity and more appealing user experience
Applicable to all existing and new EBS customers
41
-
8/12/2019 Gl Preso(AGIS)
42/67
3 steps to complete task
BEFORE -
Productive User Interfaces for Diverse Users
42
-
8/12/2019 Gl Preso(AGIS)
43/67
Single step to complete task
AFTER -
List of Value components most
frequently used by all users now
provides similar experience to
Google suggest
Inline list appears after user
types in 1 or more characters
and pauses
Reduces number of steps and
time taken to complete tasks
Quick inline access to desired
result
Productive User Interfaces for Diverse Users
43
-
8/12/2019 Gl Preso(AGIS)
44/67
BEFORE -
Productive User Interfaces for Diverse Users
44
-
8/12/2019 Gl Preso(AGIS)
45/67
AFTER -
New and Improved Menu
Main menu with new navigator reduces
number of clicks with the tree hierarchy Allows rapid cross-application navigation
Avoids navigation to Home Page eliminating
at least 2 server-side requests
Moved Favorites to the global menu to
improve manage favorites better
Productive User Interfaces for Diverse Users
45
-
8/12/2019 Gl Preso(AGIS)
46/67
Add and Manage Favorites - 3 steps to complete task
BEFORE -
Productive User Interfaces for Diverse Users
46
-
8/12/2019 Gl Preso(AGIS)
47/67
Add and Manage Favorites in a single click
AFTER -
Favorites
Productive User Interfaces for Diverse Users
47
12 1 2 and Later Usability & User
-
8/12/2019 Gl Preso(AGIS)
48/67
Pull Down menu navigation
AFTER -
Main Menu
12.1.2 and Later Usability & User
Experience
48
-
8/12/2019 Gl Preso(AGIS)
49/67
Oracle Business Intelligence Publisher for Oracle E-Business Suite
Drive Greater End User Productivity
49
-
8/12/2019 Gl Preso(AGIS)
50/67
Application Management
Pack
Centralized Management
Manage single / multiple Oracle E-Business Suite
systems from a single console
Proactive MonitoringProactively monitor Infrastructure and End User
experience through Service Level Management
Automated HOT Cloning
Automatically Clone Oracle E-Business Suitesystems through Clone Dashboard in HOT Mode
Customization Management
Automate packaging, deployment, migration of
customizations across Oracle E-Business Suite instances
Patch Automation
UI based impact analysis and deployment of patchacross EBS instances from a single console
Functional Setup Management
Manage, transport and document changes in functional
setups across Oracle E-Business Suite instances
Application Change
Management Pack
Reduce Cost of Ownership
50
-
8/12/2019 Gl Preso(AGIS)
51/67
E-Business Suite Support Timelines
51
2007 2008 2011
11.5.10
2012 2013
Premier
20142009
Extended Sustaining
2015 2016 2017
R12 Premier Extended Sustaining
R12.1 Premier Extended Sustaining
Nov 13
Jan 12 Jan 15
May 14 May 17
July 2012
2010
11i Premier Support Ended in November 2010.
Extended Support follows for 3 addtlyrs to bridge upgrade gap.
GA
GA
* More info: http://www.oracle.com/support/library/extended-support-faq.pdf
Uplift Fee waived until Nov 11*
instead of starting on Nov 10
-
8/12/2019 Gl Preso(AGIS)
52/67
Premier Support provides you with maintenance and support of your Oracle
Database, Oracle Fusion Middleware, and Oracle Applications for five yearsfrom their general availability date.
Premier Support
Stay competitive, with the freedom to upgrade on your timetable. If you take
advantage of Extended Support, it provides you with an extra three years of
support for specific Oracle releases for an additional fee.
Extended Support
Oracles Support Policy
52
Type of Support Services Offered under Premier and Extended Support :
Major product and technology releases
Technical support
Updates, fixes, security alerts, data fixes, and critical patch updates
Tax, legal, and regulatory updates
Upgrade scripts
Certification with most third-party products/versions*
Certification with most Oracle products
*Selected certifications under Extended Support
-
8/12/2019 Gl Preso(AGIS)
53/67
Plan| The Right Approach
Best Practices for Upgrading to R12
Supported Upgrade Paths
-
8/12/2019 Gl Preso(AGIS)
54/67
Notes:
1) Please see Metalink Note 403339.1 for supported combinations of Apps and RDBMS for R12 upgrade.
2) Release 11.5.10.2 includes systems installed with Rapid Install 11.5.10.2 and those upgraded by using the 11.5.10 CU2 maintenance pack.
Supported Upgrade Paths
-
8/12/2019 Gl Preso(AGIS)
55/67
Project Approach
Project Approach & Phases
1. Upgrade your Operating System
2. Upgrade your Database to 11g.X
3. Upgrade your eBusiness Suite Environment
No new functionality or modules, other than what is required byORACLE
4. Implement New Functionality
55
2)
Upgrade
DB
1) Upgrade
OS
3) Upgrade
EBS
4)
Deploy
New
Functions
-
8/12/2019 Gl Preso(AGIS)
56/67
Multiple Test Upgrades
Test Upgrade 1
Identify and document all required technical activities; patches,
scripts, etc to create a useable instance
Identify and document all pre and post upgrade functional activities;
data preparation, set ups for existing modules and set ups for new
modules All information is collected and consolidated into the upgrade
"playbookwhich is used for subsequent upgrade iterations
-
8/12/2019 Gl Preso(AGIS)
57/67
Multiple Test Upgrades
Additional Test Upgrades
Used to continue refining the technical and functional upgrade activities
Includes resolutions to SRs, scripts created, patches identified, etc
Used to create instances for functional testing, development activities
and integration testing
Timing of all tasks to assist with planning the production upgradetimeline and required blackoutperiod
-
8/12/2019 Gl Preso(AGIS)
58/67
Testing & Training
Test Script Creation & Testing
Use scripts from prior implementation or upgrade activities as
baseline scripts
Update scripts for new or updated functionality introduced in R12
Update scripts for business process changes
Solicit end user participation to develop and enumerate the scriptscenarios (Early and Often!)
Make sure all customizations are addressed and thoroughly tested
Training
Lead off with navigation training; R12 introduces look and feel
differences across all applications using OA Framework
Consider deltatraining approach; address changes introduced by
R12 versus the version being upgraded from
Highlight and address business process changes
-
8/12/2019 Gl Preso(AGIS)
59/67
Best Practices
Review Appropriate Oracle Documentation
Oracle Support Doc id: 394692.1
Upgrade Process
Tools Required
Number and Types of Tasks Involved
How your System and Products will Look in Release 12
-
8/12/2019 Gl Preso(AGIS)
60/67
Best Practices Pre-Upgrade
Pre-Upgrade Best Practices
Oracle Support Doc id: 394692.1
Use The Upgrade Manual Script (TUMS) to eliminate the tasks that
are not relevant for your system
Use Shared file system for Multi-node
Use Distributed AD for Multi-node Estimate table space sizes for test upgrade using Doc id: 399362.1
Performance of upgrade scripts can be significantly improved by
modifying specific parameters
-
8/12/2019 Gl Preso(AGIS)
61/67
Best Practices Pre-Upgrade
Perform Following Key Tasks which Substantially Reduce the
Downtime During Upgrade
Functional tasks listed in Reducing downtime section (Appendix E) in
R12 Upgrade manual
Upgrade by Requestsection (Appendix G) in R12 upgrade manual
Perform Following Tasks in Advance to Reduce Extended
Downtime
Convert to Multi Org
Convert to OATM (Oracle Applications Tablespace Model) Upgrade database to 11g.X
-
8/12/2019 Gl Preso(AGIS)
62/67
Best Practices Pre-Upgrade
Run Gather Schema Statistics Before Upgrade
Use Gather Auto option if your Database is already at 10g
Record Timing for Each Step During Test Upgrade
Make Sure you have Good Backup before Database Upgrade
and Also Before R12 Upgrade
-
8/12/2019 Gl Preso(AGIS)
63/67
Best Practices Pre-Upgrade
Add PL/SQL No Compile Option in R12 Upgrade Driver
This will save time during the upgrade
Saved 3 to 4 hours of upgrade downtime during internal test upgrades
Add extension plsql_no compile yesline in upgrade driver file to
enable PL/SQL no compile option
extension patch_type software base extension plsql_no compile yes
extension patchinfo maintpack 12.0.0
d h ll
-
8/12/2019 Gl Preso(AGIS)
64/67
Upgrade Challenges
Application Changes May Result in Business Process Changes
Some Changes are Significant
Migration of Existing Customizations
Changes in technology may not allow upgrade in a straightforward
manner and the migration path may not exist causing a re-write
Changes to the Oracle Application architecture and table structure
changes
Current staff may not be versed in the new technologies Training or Practices augmentation may be required
d h ll
-
8/12/2019 Gl Preso(AGIS)
65/67
Upgrade Challenges
3rd Party-Supplied Programs or Extensions may not be
Compatible or Certified with R12
Technology Changes XML (BI) Publisher
Migration away from Oracle Forms to OA Framework
User Re-training
S
-
8/12/2019 Gl Preso(AGIS)
66/67
Summary
Upgrading from Release 11i to 12.1 offers business value in all
product areas
Customers are successful on Release 12 and 12.1
While you plan your upgrade, consider opportunities to get
more return from your existing EBS 11i investments
Develop an upgrade plan that keeps you comfortably withinproduct support windows
66
-
8/12/2019 Gl Preso(AGIS)
67/67
Any Questions?
Lee BriggsPractice Director, Financials
Management
LBriggs@BizTech.com
Twitter: @BTLeeBriggs
mailto:LBriggs@BizTech.commailto:LBriggs@BizTech.com
top related