EBS R12 Overview (PowerPoint)

Document Sample
EBS R12 Overview (PowerPoint) Powered By Docstoc
					                              E-Business Suite
What’s New in Release 12
Connie Barbon, Oracle Senior Sales Consultant
 What‟s New in R12
                                       <Insert Picture Here>

• Overview
• Financials
  • 6 Major Initiatives
  • Other “cool stuff”
  • Not really R12…
• Q&A

• Additional content on Projects and Human
  Capital Management included in slide deck
New User Experience
 A New User Experience for R12
 Accelerate global roll-outs with simplified user interface and business flows

                                                         • Reduced pop-ups and
                                                            duplicate screens
                                                         • Re-designed and streamlined
                                                            entire workflows
                                                         • Reduced the number of steps
                                                            to complete key tasks
                                                         • Improved overall look & feel
                                                            and visual style
                                                         • Increased personalization

                           Improved Workflow in Targeted Areas
• Campaign Management           • Financial Consolidation          • Self-Service Purchasing
• Customer Support              • Online Candidate Registration    • Sourcing
• Collections & Payments        • Absence Management               • Supplier Collaboration
• Loan Management               • Salary Administration            • Business Intelligence
New User Experience
         New Background



                New                    New
               Fonts                  Icons
    11i User Experience - example
•    Define/Assign Set of Books, Specify Conversion options/rules

                                                   Defining a set of books
                                                   takes 5 tabs to
                                                   accommodate all fields
                                                   and rules

                                                            Multiple steps
                                                            required to assign
                                                            sets of books and
                                                            specify conversion
Superior Ownership Experience
R12 - Single Page for Accounting Setup
                                   •Legal Entities
Oracle Financials
What’s New in Release 12
   What‟s New in R12 Financials

6 Major Initiatives
1. Ledger and                               General Ledger
                                           Ledger & Ledger Sets
   Ledger Sets
2. Subledger            Dr   Cr
                                        Subledger Accounting (SLA)
                               Tax                     Inter                        Bank
                              Engine                 Company
4. Intercompany                                                                     Model

5. Tax Engine
6. Bank Model         Multi-Org
                                   Inventory         Receivables             Projects

                      Work in Process       Purchasing            Payables
                          <Insert Picture Here>

Ledgers and Ledger Sets
  Ledgers in Oracle
  A set of accounting information for a legal or business entity

 Each ledger is associated with a Chart of accounts, Calendar,
 Currency, and Subledger Accounting Convention for which
 accounting information is recorded

11i & Prior = Sets of Books          R12 = Ledgers
      3 C‟s: Currency,                    4 C’s:
      Calendar, Chart              Currency, Calendar,
      Seeded Conventions:           Chart, Convention
   •Standard Accrual
   •Standard Cash
   •Accrual w/ Encumbrance
   •Cash w/ Encumbrance
   •US Federal Accounting
   •China Standard Accrual
Multiple Accounting Representations
Parallel Financial Reporting with Ledgers

   Ledger A                  Ledger B
French Rules                US GAAP
French COA                  US COA
French Calendar             US Calendar
EUR                         EUR
                                          Single subledger
                                             can create
                  Dr   Cr                      multiple
              Subledger                   representations
              Accounting                   and in multiple

           Payables Invoice
Multiple Ledgers
Primary Ledger
   • the main “Activity” Ledger
   • Usually in the local currency
   • For Operational reporting

Secondary Ledger (ex. France requires Statutory Chart)
   • Differs from Primary Ledger by Chart, Calendar, and/or Convention
   • For Statutory, Tax or Consolidated reporting

Reporting Currency Ledger
   • Differs from Primary Ledger by Currency ONLY
   • Just a translation of the Primary Ledger – no rules required
   • For Consolidated reporting
     Ledger Sets
     Global Information At A GlanceShare:
                                              Ledger Set            Chart of Accounts

                                                             Ledger C

                                                            US GAAP
                                                            US COA
   Ledger A              Ledger B                           US Calendar
French Rules            US GAAP                             USD
French COA              US COA
French Calendar         US Calendar
EUR                     EUR                                  Ledger D
                                                            US GAAP
                                                            US COA
                                                            US Calendar
 Key benefits to many Ledgers in one set
 • Decision-driving business information always available
 • Simpler processing and General Ledger management
 • Data and definitions that can be shared and secured           Reporting Currency
•Grouping of ledgers
with the same chart
of accounts and
calendar/period type

•Essentially treats
multiple ledgers as
Perform the Following Across Ledgers
Using Ledger Sets

  • Open/Close Periods
  • Create Journals
     • Allocations Across Ledgers
     • Recurring Journals for All Ledgers
     • Elimination Sets for All Ledgers
  • Translate and Revalue Balances
  • View Information without Changing
  • View Journals and Account Balances
    Across Ledgers
  • Submit Standard Reports
  • Create Financial Statements that Include
    Data for Multiple Ledgers
Impacted Applications
Ledger Sets

 • Ledger Sets used by General Ledger
 • Some AR and AP reports use Ledger Sets
Impact/Upgrade Considerations
Ledger Sets

  • None; All sets of books upgraded to ledgers
  • Only need to define ledger sets to obtain
    processing efficiencies
                       <Insert Picture Here>

Subledger Accounting
    Subledger Accounting
    Centralized Rules, Common Repository: Global Control

                                                                             • Internal control and
                                                                               compliance with multiple
                                                                               accounting policies through
                            General Ledger
                             General Ledger
                                                                               user-defined accounting rules
                                                         3 r d Party         • Single source of truth for all
                                                                               subsystem accounting
     Dr       Cr   SLA = Centralized Accounting Model,
                                                                               activity with a common data
                     Rules, Engine and Repository                              model and repository
                                                                             • Accounting, reconciliation
                                                                               and reporting facilitated by
                                                                               centralized data model
                                                                             • Streamline closing process
                             Inventory      Receivables           Projects
                                                                               with common posting engine
3 r d Party
                                                                             • Auditable and transparent
                   Work in Process Purchasing            Payables              entries accessible with full
 Introduction to Subledger Accounting

                               Ledger: FR Statutory
                               GL Date: 2-Mar-2006           Invoice Internal Identifier: 1001
                               Invoice# 100
Invoice #100                      Ledger: US Corporate          Invoice Internal Identifier: 1001
                               Supplier: ABC Networks
                                  GL Date: 2-Mar-2006
ABC Networks
                                  Invoice# 100
                                  Supplier: ABC Networks

2 Monitors – Marketing $1000                                               DR            CR
5 Printers – Marketing $ 500                                                    Invoice Line 1

                                   1 Expense 01-EXP-200      $1500              Invoice Line 2
Freight              $ 100
                                   2 Freight 01-FR-200       $100               Invoice Line 3
Tax                  $ 110
                                   3 Tax     01-TX-200       $110               Invoice Line 4
Total                $1710
                                   4 Liability 01-LIAB-200                 $1710
Transactions vs. Accounting
• SLA provides a distinction between a transaction and the
  accounting representation of the transaction
  (there can be multiple representations of one transaction)

• Accounting distributions did not necessarily go away
    • Needed for upgrade customers
    • Needed as starting point for SLA (Don’t want to force customers to
      define their own SLA rules)
    • In some cases, necessary to allow user input

• Most default SLA rules just „pass through‟
  the distribution accounts (where
Streamline Accounting
Impacted Applications

 •   General Ledger   • Payroll
 •   Payables         • Property Manager
 •   Receivables      • Loans
 •   Projects         • Lease Management
 •   Assets             (Post R12)
 •   Costing          • Cash Management
 •   OPM              • Globalizations
 •   Public           • Intercompany
Subledger Journal Entry – more info
        Subledger Entry vs. GL Journal Entries
        Many to One

           Invoice No: 136274      GL Date: 01/27/07     3rd Party: by GL
SLA                                                     Summarization setting for
JE #1      101.100.63580.0000.720.000.000                EUR
                                                  6,000 each Subledger App
               101.100.22100.0000.000.000.000           (AP, EUR
                                                      6,000 AR, etc):
                                                        Summarize by GL Date,
           Invoice No: 131299      GL Date: 01/27/07 by GL Period, or
                                                         3rd Party: Gibson
                                                        No Summarization
JE #2      101.100.63580.0000.720.000.000         3,000 EUR
               101.100.22100.0000.000.000.000         3,000 EUR

           Invoice No: 116555    GL Date: 01/27/07     3rd Party: Kramer
JE #3      101.100.63580.0000.720.000.000         2,000 EUR
               101.100.22100.0000.000.000.000         2,000 EUR

           Batch: AP Invoices 27-Jan-07     GL Period: Jan-07
JE #1      101.100.63580.0000.720.000.000         11,000 EUR
               101.100.22100.0000.000.000.000         11,000 EUR
Upgrade Considerations
 • By default, the R12 upgrade migrates at least 6
   periods of accounting entries from each application
   to the SLA data model.
    • You can modify this if desired.

 • For prior periods, the historical data is preserved.
   You can drill from General Ledger to the historical
   transactions using standard GL drilldown
                           <Insert Picture Here>

Multi-Org Access Control
MOAC: Multi-Org Access Control
Role based access to Operating Units

       Perform multiple tasks across operating units
             without changing responsibilities

  Belgium           Holland          Denmark
                                                     Functional Tasks
 Legal Entity      Legal Entity      Legal Entity     Order Management
                                                      Dunning, Collections,
  Belgium            Holland         Denmark          Requisition, Demand &
Operating Unit    Operating Unit    Operating Unit     Purchase Orders
                                                      Receiving & Drop Ship
Responsibility    Responsibility
            Single Responsibility   Responsibility    Invoice Receipt,
                                                      Customer Data
                                                      Accounting Setup
   Multi-Org Access Control Setup
   Define Security Profile

Specify Operating Units

as operating
Typical Screen in daily use

              Select Operating Unit
                  during Input
                             <Insert Picture Here>

Advanced Global
Intercompany System (AGIS)
  Advanced Global Intercompany System
  Address the Top Barrier to a Fast Close
                               Advanced Global
  Web UI                                                                  Subledger
                                                                          Invoices &

Interfaces /
                          Generate subledger invoices                   Online
                          Control transaction entry with             Reconciliation
  Excel                    Intercompany Calendar                       Reporting
(Web ADI)                 Fully Configurable Approval Rules
                          Flexible Security Model
                          Centrally defined Intercompany                   XML
                           Accounts                                       Publisher

                                Dr   Cr

               General    Subledger
               Ledger     Accounting            Receivables    Payables
Journal Across
 Intercompany Due To /
     Due From lines
automatically generated
AR Invoice billed to
 SSC France from
   SSC US (NY)
             <Insert Picture Here>

Tax Engine
  E-Business Tax
  Centrally manage tax transactions across entire E-Business Suite
                                                • Single Repository of
                                                 transactions for global
      Internet      Purchasing                   business insight
     Expenses                                   • Centralized rules applied
                                                 to transactions to manage
                                                 globally and reduce risk
                  Tax                           • Automation of tax
Ledger                                           processes on transactions
                                     Payables    to improve operational
                                                • Improved Reporting
                                                • Effective Date Setup
                                Invoicing       • Extensible architecture
                                                 that supports additions,
                                                 e.g.   Self-assessed
                                                        Use Tax
      eBusiness Tax
      Tax determination, not just tax codes…

Before R12                             R12

•   User determines tax by assigning   •   eBTax determines tax based on
    Tax Codes                              facts about each transaction

•   Tax rules in code                  • Tax rules you can see
• Global descriptive flexfields for    • Tax attributes collected in fields on
    country-specific tax attributes        key entities

                                       • Configure tax rules once per regime
• Granular setup at OU level               and share with your legal entities

                                       Facilitates compliance
                                       Improves auditability
             <Insert Picture Here>

Bank Model
Centralized Banking
Shared Services Disbursements
                                                             • Bank account is now
                                                               associated with LE entity
                          LE                                   rather than Operating Unit
                                                             • Single bank account
     OU A                OU B             OU C
                                                               serves multiple Operating
                                                             • For Internal Banks and
                                                               Customer & Supplier
    I nv entory            Receivables
                           Rec eivables      Projects
                                             P rojects
                                                             • Enhanced Reconciliation
    Work in                                     A s sets
                  Purchasing     Payables
                                 Pay ables
    P rocess
                                                            Centralized Credit Card Model
                                                            Supplier & Customer Banks in TCA
Bank Model: Example of what you can do
Pay invoices from different OUs with 1 instruction
                                   • New Payments Module
        OU A
                                   • New Bank Module
                                   • New Bank & Credit Card
        OU B

        OU C                Single
                           Payment       Bank          Payments

                                          Sub Ledger
Banks                          Specify Legal Entity
Define Owner of Bank Account         Owner

    Where is Account
Select Multiple LE‟s,
OU‟s, Currencies in
single Payment Run
                <Insert Picture Here>

Cool Stuff…
Report Repository

                    Online “file cabinet” to
                       where Financial
                    Reports are published
Add Report to Menu
Control Accounts

                     Control Account –
                   Prevents posting other
                     than automatically
                      from Subledgers
Replacement Accounts

                       Replacement Account
                        will be posted to in
                         place of Disabled
Payments Dashboard

          Submit or Schedule Payment
              Process Request
                        Use Payment Template to
                             Default values

  Pay Multiple Legal
  Entities, Operating
Units, and Currencies
 in one Payment Run
Can do STP (Straight Thru
Processing) or Review/Edit
    selected Invoices
Pending Actions walks you
    through process
Positive Pay
Internet Expenses - Allocations

                        Edit Coding of
                        Expense Lines
Allocate Expense Lines
   * even to Projects
Internet Expenses – Bar Coding

                         Bar Coding of
                        Expense Reports
Robust Cash Forecasting
Cash Forecasting is a planning Tool that helps you anticipate the flow of Cash in
& out of your business, allowing you to project your cash needs.

 Specify Sources

                                                        Drill down to
                                                     transaction details
Flexible Cash Positioning
Cash Positioning is a planning tool that allows you to view your daily cash
position by Bank Acct, Cash Pool, or Currency.

                                                                    Automatically generate
                                                                        cash transfers

                                                                Drill down to details

          View by currency, bank
           account or cash pool

                                      Save Projected
                                   Balances for Reporting

                                                            Online refresh capabilities
 “Cash Leveling”
Proposal – initiates
  Bank Transfer
                   <Insert Picture Here>

Not Really R12 –
But still cool…
  Simplified Self-Service Reporting
  BI (XML) Publisher
        Reporting Evolution                                   Benefits

   • Replaces most standard reports              • Put reporting in the hands of
     with data extracts and                        the business user
     templates                                   • Create report formats using
   • Merges custom templates and                   desktop tools (Adobe
     data extracts at run-time                     Acrobat, MS Word, MS Excel,
                                                   and XSL Editors)
   • Delivers output in PDF, HTML,
     RTF, Excel (HTML), or text for
                                                 • Publish in any format, to the
                                                   web and electronically
     use with EFT and EDI
     transmissions                               • Drive reporting consistency
                                                   with one source of data

“Oracle’s new XML Publisher is visionary and empowers end users. This new capability
gives customers the look and feel of Excel with a desktop publishing look to reports, and
enables users to create their own reports, minimizing the dependency on the IT staff.”
                                                 -- Sean Malinski, Accenture Partner, Global
                                                    Business Solutions - Oracle Practice
Old Standard Reports
New Standard Reports (HTML)
Oracle BI Publisher

 • Many, many, many Standard Reports
 • Multiple formats per report
 • Merge Data with Contract Terms
 • User-defined templates
 • Boardroom Quality Output
Oracle Business Intelligence
Comprehensive View of Financial Performance

            General Ledger & Profitability Analytics
            Incorporates detail-level general ledger transactions and cash flow analysis
            across locations, customers, products, sales territories, distribution channels,
            and business units.
            Identifies the customers and transactions that are providing maximum profits
            by product, location, department, and geographic detail. When combined with
            Marketing Analytics, it enables analysis of Campaign ROI and assists in
            customer segmentation.

            Payables Analytics
            Provides visibility into payments due to suppliers and expense line detail so
            managers can manage cash outflows and control expenses. When combined
            with Supply Chain Analytics, it allows full procurement analysis from
            Requisition to Check.

            Receivables Analytics
            Monitors collections processes to show what customers buy and how they
            pay, enabling managers to identify overdue balances and other receivables
            bottlenecks. When combined with Oracle Sales Analytics and Oracle Order
            Management & Fulfillment Analytics, it enables more efficient management of
            the entire Lead to Cash process.
Oracle Business Intelligence
 User Productivity Kit (UPK)
What is UPK …
… a comprehensive, cost-effective solution that helps your
  organization quickly create critical documentation, training,
  and support materials needed to drive project team and
  increase user productivity throughout the lifecycle of your

• You Perform a transaction, Record it, and Publish it
       •   Training Guides
       •   Web-based Training
       •   Job Aids
       •   Test Scripts

WORKS WITH 11.5.9 and above
   UPK Playback Modes

• See It!
  Enables you to learn by watching an animated demonstration of
  tasks being performed in a simulated environment.

• Try It!
  Enables you to learn interactively in a simulated environment. The
  Player provides you with instructions as to what needs to be done to
  complete a task, but you perform the actual steps.

• Know It?
  Enables you to test knowledge gained from training. You are
  instructed to complete the steps for a particular task and are scored
  on how accurately you complete the steps.

• Do It!
  Guides you in the performance of the actual task in a production
  environment. You learn by completing the actual task.
    New in Financial Control & Reporting
    Highly automated financials processing drives efficiencies

• Centralized accounting setup
• Streamlined multiple ledger processing and reporting
• Parallel financial reporting                                EFFICIENCY
• Automatic reporting currency conversion
• Replacement for disabled accounts

• Data security across legal entities, ledgers or balancing
  segment values                                              FLEXIBILITY
• Control Accounts

• Accounting and reporting sequencing
• Journal line reconciliation
    New in Procure-to-Pay
    Integrated Suite Optimizes Working Capital

• Document line level entry and approval
• Non-PO invoice accounting entry by approvers
• Invoice dispute management                              PRODUCTIVITY
• Real-time status of purchasing contract T&Cs and
 invoicing activity in Oracle Payables and Purchasing

• Self-service opportunities via iSupplier Portal to a
  broader set of their suppliers                          COST SAVINGS
• Self service entry extended to receipt matched,
  complex Work Purchase Orders, and non-PO invoices

• Streamlined supplier setup and maintenance as part of
  Trading Community Architecture (TCA)                    INTEGRATION
• Access to TCA features
      New in Credit-to-Cash
      Accelerate cash cycle and manage revenue with fiscal discipline

•   Daily revenue recognition
•   Deferral reason for goods and services
•   COGS and revenue matching
•   Line level cash application

• More efficient payment application with Oracle Payments
• More targeted and efficient collections with configurable
  matrix                                                      BETTER CASH FLOW
• Credit recommendation enhancements
• Conversion of delinquent receivables to payment plans

• Visibility to carry-forward balances with cycle-based
  billing                                                     INDUSTRY SUPPORT
• Payment application according to customer preferences
    New in Cash and Treasury
    Optimize Cash and Treasury Operations

• Centralized and consolidated bank model
• Single bank account shared by multiple organizations
• Bank account transfers directly in Cash Management
• Funds optimization with cash pooling and zero balancing

• Configurable and centralized payments engine
• Full audit trail and control with single point of payment
• Straight through processing (STP) for payments              COMPLEXITY
• Real-time visibility into cash inflows and outflows
• Large library of payment formats and validations

• Simplified reconciliation of bank statements to cash
  transactions in multiple organizations
• Support for new bank account balance types in bank          FLEXIBILITY
  statement import
• Bank account-level reconciliation options and tolerances
    New in Asset Management
    Maximize return on assets

• Automate legacy asset conversion with enhanced
 preparation of Mass Additions                           EFFICIENCY

• Perform rollback on select assets with Automatic
 Depreciation Rollback

• Group Assets to include “Units of Production” method
• Energy straight-line depreciation method               INDUSTRY SUPPORT
• Asset impairment of a producing asset
    New in Travel & Expense
    Lower the total cost of travel and expense

• CONUS and OCONUS global per diem rates                   LOWER COSTS
• Per diem and policy schedules

• Expense splitting across multiple accounting segments
• Enhanced cost center and projects approvals

• Self-service cash advance application during entry
• Bar code generation
• Streamlined receipts management with receipts tracking
 and receipts missing capabilities
                <Insert Picture Here>

Why Upgrade ?
Why Upgrade
Straight Talk from Customers
   “We have 60 sets of books and see tremendous efficiencies with running
   processes across these sets of books using Ledger Sets.”

   “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

   “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.”

   “The ability to access multiple operating units with a single responsibility can
   simplify SOX compliance monitoring.”

   “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 customizations in 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.”
   “Banks, taxes, payments, and accounting – everything that becomes centralized
   will bring tremendous efficiencies to our organization.”
                         Evolution of Oracle Financials
 Base Differentiators…                New in 11i.10…                       New in R12…
• Daily business intelligence   • Compliance-driven financial      • Ledgers and ledger sets
  for financials                  consolidation and reporting      • Centralized rules-based
• Global single instance and    • Enterprise planning and            accounting engine
  shared service center           budgeting                        • Single, global tax engine
  support                       • Audit operations, compliance     • Unified bank account model
• Global language, currency       and certification management     • Centralized payments engine
  and regulatory support        • Web services for financials      • Common global intercompany
• Unified data model            • XBRL financial reporting           system
• Industry leading              • Enhanced bill presentment:       • Shared services support with
  performance and scalability     user definable formats and         multi-org access
• Unified customer model with     online drill down capabilities   • Improved user experience
  data quality management       • Enhanced credit, collections,
  tools                                                            • Centralized data model for
                                  and trade management               suppliers and banks
• Integrated collections          integration flow
                                                                   • Accounting & consolidation
  management                    • Self-service asset management      engine for Financial Services
• Online receipt and dispute    • Enhanced credit card business    • Multi-dimensional profitability
  management                      flow management                    analysis
• Online supplier procurement   • Cash positioning and             • Fusion Middleware certification
  and payment management          forecasting                      • Enhanced integration repository
• Property and real estate      • Supplier open interface
  management                                                       • Retek integration