EBS R12 Overview - PowerPoint PPT Presentation

Loading...

PPT – EBS R12 Overview PowerPoint presentation | free to download - id: 570dfe-NDEyN



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

EBS R12 Overview

Description:

E-Business Suite What s New in Release 12 Connie Barbon, Oracle Senior Sales Consultant * Efficiency: Additional attributes are available in the Mass Additions ... – PowerPoint PPT presentation

Number of Views:1337
Avg rating:3.0/5.0
Slides: 85
Provided by: CBar92
Learn more at: http://merriconsolutions.com
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: EBS R12 Overview


1
E-Business Suite
Whats New in Release 12
Connie Barbon, Oracle Senior Sales Consultant
2
AgendaWhats New in R12
ltInsert Picture Heregt
  • 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

3
New User Experience
4
A New User Experience for R12Accelerate 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 capabilities

5
New User Experience
New BackgroundPattern
NewButtons
NewColors
NewFonts
New Icons
6
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 options/rules
7
Superior Ownership Experience R12 - Single Page
for Accounting Setup
  • Legal Entities
  • Ledgers
  • Currencies
  • BalancingSegments
  • SubledgerAccounting
  • Operating Units
  • BalancingOptions

8
Oracle Financials
Whats New in Release 12
9
Whats New in R12 Financials
  • 6 Major Initiatives
  • Ledger and Ledger Sets
  • Subledger Accounting
  • MOAC
  • Intercompany
  • Tax Engine
  • Bank Model

10
ltInsert Picture Heregt
Ledgers and Ledger Sets
11
Ledgers in OracleA 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
  • 3 Cs Currency,
  • Calendar, Chart
  • Seeded Conventions
  • Standard Accrual
  • Standard Cash
  • Accrual w/ Encumbrance
  • Cash w/ Encumbrance
  • US Federal Accounting
  • China Standard Accrual

12
Multiple Accounting RepresentationsParallel
Financial Reporting with Ledgers
Ledger B
Ledger A
French Rules French COA French Calendar EUR
US GAAPUS COA US Calendar EUR
Single subledger transaction can create
multiple accounting representations and in
multiple currencies
Dr
Cr
Subledger Accounting
Payables Invoice
13
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

14
Ledger Sets Global Information At A Glance
Ledger Set
Ledger C
US GAAP US COA US Calendar USD
Ledger A
French Rules French COA French Calendar EUR
Ledger D
US GAAP US COA US Calendar AUD
  • 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
15
  • LEDGER SETS
  • Grouping of ledgers with the same chart of
    accounts and calendar/period type combination
  • Essentially treats multiple ledgers as one

16
Perform the Following Across LedgersUsing 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
    Responsibilities
  • View Journals and Account Balances Across Ledgers
  • Submit Standard Reports
  • Create Financial Statements that Include Data for
    Multiple Ledgers

17
Ledger Set Benefits
  • Shorter Close Process
  • Run month-end close processes across multiple
    ledgers simultaneously
  • Greater flexibility to decentralize/centralize
    accounting functions
  • The corporate office can control the period
    status for multiple subsidiaries at once
  • Real-Time Enterprise-Wide Visibility
  • Quickly report across the entire enterprise in
    real-time because no transfer of data is required
  • Reported results are accurate and timely because
    they are based on the transactional system, not a
    data warehouse

18
Ledger Set Benefits
  • More Efficient Access to Ledger Data
  • No need to change responsibilities to access data
    in different ledgers
  • Processing Efficiency
  • Essentially treats multiple ledgers as one and
    eliminates the overhead of having a high number
    of ledgers defined
  • Reduces the number of repetitive tasks that offer
    limited value and allows you to spend more time
    on value-added tasks
  • Reporting Efficiency
  • Obtain flash reports throughout the accounting
    cycle to proactively manage the business instead
    of waiting until the end of the month when the
    data collected is backward looking

19
Impacted ApplicationsLedger Sets
  • Ledger Sets used by General Ledger
  • Some AR and AP reports use Ledger Sets

20
Impact/Upgrade ConsiderationsLedger Sets
  • None All sets of books upgraded to ledgers
  • Only need to define ledger sets to obtain
    processing efficiencies

21
ltInsert Picture Heregt
Subledger Accounting
22
Subledger AccountingCentralized Rules, Common
Repository Global Control
  • Internal control and compliance with multiple
    accounting policies through user-defined
    accounting rules
  • Single source of truth for all subsystem
    accounting activity with a common data model and
    repository
  • Accounting, reconciliation and reporting
    facilitated by centralized data model
  • Streamline closing process with common posting
    engine
  • Auditable and transparent entries accessible with
    full drilldown

3rd Party Systems
Payables
Purchasing
Work in Process
23
Introduction to Subledger Accounting
  • Rule-based accounting engine, toolset
    repository supporting Oracle E-Business Suite
    modules
  • Allows multiple accounting representations for a
    single business event, resolving conflicts
    between corporate and local fiscal accounting
    requirements
  • Retains the most granular level of detail in the
    subledger accounting model, with different
    summarization options in the General Ledger,
    allowing full auditability and reconciliation
  • Introduces a common data model and UI across
    subledgers, replaces various disparate 11i
    setups, providing single source of truth for
    financial and management analysis

24
Introduction to Subledger AccountingDUAL POSTING
SIMULTANEOUSLY
Ledger FR Statutory GL Date 2-Mar-2006 Invoice
100 Supplier ABC Networks
Invoice Internal Identifier 1001
Invoice 100 ABC Networks 2 Monitors Marketing
1000 5 Printers Marketing 500 Freight
100 Tax
110 Total 1710
Invoice Internal Identifier 1001
Ledger US Corporate GL Date 2-Mar-2006 Invoice
100 Supplier ABC Networks
DR CR 1 Expense 01-EXP-200 1500 2
Freight 01-FR-200 100 3 Tax 01-TX-200
110 4 Liability 01-LIAB-200 1710
Invoice Line 1 Invoice Line 2
Invoice Line 3
Invoice Line 4
25
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 (Dont 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 applicable)

26
Streamline Accounting
27
Impacted Applications
  • General Ledger
  • Payables
  • Receivables
  • Projects
  • Assets
  • Costing
  • OPM
  • Public Sector/Federal
  • Payroll
  • Property Manager
  • Loans
  • Lease Management (Post R12)
  • Cash Management
  • Globalizations
  • Intercompany

28
Subledger Journal Entry more info
29
Subledger Entry vs. GL Journal EntriesMany to One
Controlled by GL JE Summarization setting for
each Subledger App (AP, AR, etc) Summarize by
GL Date, by GL Period, or No
Summarization
Invoice No 136274 GL Date 01/27/07 3rd
Party Fender 101.100.63580.0000.720.000.000 6,
000 EUR 101.100.22100.0000.000.000.000 6,000
EUR
SLA JE 1
Invoice No 131299 GL Date 01/27/07 3rd
Party Gibson 101.100.63580.0000.720.000.000 3,
000 EUR 101.100.22100.0000.000.000.000 3,000
EUR
SLA JE 2
Invoice No 116555 GL Date 01/27/07 3rd
Party Kramer 101.100.63580.0000.720.000.000 2,
000 EUR 101.100.22100.0000.000.000.000 2,000
EUR
SLA JE 3
Batch AP Invoices 27-Jan-07 GL Period
Jan-07 101.100.63580.0000.720.000.000 11,000
EUR 101.100.22100.0000.000.000.000 11,000 EUR
GL JE 1
30
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

31
ltInsert Picture Heregt
Multi-Org Access Control (MOAC)
32
MOAC Multi-Org Access ControlRole based access
to Operating Units
Perform multiple tasks across operating units
without changing responsibilities
Holland Legal Entity
Denmark Legal Entity
Belgium Legal Entity
Belgium Operating Unit
Denmark Operating Unit
Holland Operating Unit
Responsibility
Responsibility
Responsibility
33
Multi-Org Access Control SetupDefine Security
Profile
Specify Operating Units
Classify Organization as operating unit
34
MOACTypical Screen in daily use
Select Operating Unit during Input
35
ltInsert Picture Heregt
Advanced Global Intercompany System (AGIS)
36
Advanced Global Intercompany System Address the
Top Barrier to a Fast Close
Advanced GlobalIntercompanySystem
Web UI
Open Interfaces / API
  • Generate subledger invoices
  • Control transaction entry with Intercompany
    Calendar
  • Fully Configurable Approval Rules
  • Flexible Security Model
  • Centrally defined Intercompany Accounts

Excel (Web ADI)
37
Intercompany Journal Across Ledgers
38
Intercompany Due To / Due From lines
automatically generated
39
AR Invoice billed to SSC France from SSC US (NY)
40
ltInsert Picture Heregt
Tax Engine
41
Centralized Global TaxLess Complex Global Tax
Compliance
Business Needs
Solution
Automation
  • Tax content for certain countries
  • Vertex and Taxware integration for U.S.
  • Integrity checks during setup process

Constant Changes in Tax Laws and Regulations
  • Date effective setup
  • Tax rules flow for change or creating rules
  • Tax simulator for setup, rules, and transactions

Local Compliance
  • Tax registrations and tax reporting codes
  • Tax lines determine applicable taxes
  • Configurable tax reporting templates

Information Visibility
  • Single set up for all Oracle applications
  • Use of E-Business Suite components such as
    trading partner geography, trading partner
    classification, legal entity, inventory item
    categorization, and accounting event.

42
E-Business TaxCentrally manage tax transactions
across entire E-Business Suite
Purchasing
Internet Expenses
Internet Procurement
TaxTransactions
General Ledger
Payables
TaxSetup/Rules
Receivables
Inter-Company Invoicing
Order Management
43
eBusiness TaxTax determination, not just tax
codes
Before R12
R12
  • User determines tax by assigning Tax Codes
  • Tax rules in code
  • Global descriptive flexfields for
    country-specific tax attributes
  • Granular setup at OU level
  • eBTax determines tax based on facts about each
    transaction
  • Tax rules you can see
  • Tax attributes collected in fields on key
    entities
  • Configure tax rules once per regime and share
    with your legal entities
  • Facilitates compliance
  • Improves auditability

44
ltInsert Picture Heregt
Bank Model
45
Centralized BankingShared Services Disbursements
  • Bank account is now associated with LE entity
    rather than Operating Unit
  • Single bank account serves multiple Operating
    Units
  • For Internal Banks and Customer Supplier Banks
  • Enhanced Reconciliation

LE
OU A
OU B
OU C
Projects
Receivables
Projects
Receivables
Inventory
Work in Process
Assets
Payables
Purchasing
Payables
  • PLUS
  • Centralized Credit Card Model
  • Supplier Customer Banks in TCA

46
Bank Model Example of what you can doPay
invoices from different OUs with 1 instruction
  • New Payments Module
  • New Bank Module
  • New Bank Credit Card Features

47
BanksDefine Owner of Bank Account
Specify Legal Entity Owner

Where is Account used?
48
Select Multiple LEs, OUs, Currencies in single
Payment Run
49
ltInsert Picture Heregt
Miscellaneous Cool Stuff
50
Report Repository
Online file cabinet to where Financial Reports
are published
51
Add Report to Menu
52
(No Transcript)
53
Control Accounts
Control Account Prevents posting other than
automatically from Subledgers
54
Replacement Accounts
Replacement Account will be posted to in place of
Disabled Account
55
Payments Dashboard
Submit or Schedule Payment Process Request
56
Use Payment Template to Default values
Pay Multiple Legal Entities, Operating Units, and
Currencies in one Payment Run
57
Can do STP (Straight Thru Processing) or
Review/Edit selected Invoices
58
Pending Actions walks you through process
59
Positive Pay Program
60
Internet Expenses - Allocations
Edit Coding of Expense Lines
61
Allocate Expense Lines even to Projects
62
Internet Expenses Bar Coding
Bar Coding of Expense Reports
63
Cash Forecasting Seamless Integration GL, AR,
AP, OM, Payroll, Purchasing, Sales, Treasury
Receipts, Invoices
Payments, Invoices,Expense Reports
POs, Requisitions
Sales Opportunities
Labor, Usages, MiscBudgets, Billing Events
Sales Orders
Treasury Deals
Payroll Expenses
Budgets,Encumbrances
External Systems
64
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
Include/Exclude lines
65
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
66
Cash Leveling Proposal initiates Bank
Transfer
67
ltInsert Picture Heregt
Not Really R12 But still cool
68
Simplified Self-Service ReportingBI (XML)
Publisher
Benefits
Reporting Evolution
  • Put reporting in the hands of the business user
  • Create report formats using desktop tools (Adobe
    Acrobat, MS Word, MS Excel, and XSL Editors)
  • Publish in any format, to the web and
    electronically
  • Drive reporting consistency with one source of
    data
  • Replaces most standard reports with data extracts
    and templates
  • Merges custom templates and data extracts at
    run-time
  • Delivers output in PDF, HTML, RTF, Excel (HTML),
    or text for use with EFT and EDI transmissions

Oracles 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
69
Old Standard Reports
70
New Standard Reports (HTML)
71
Oracle BI Publisher
  • Many, many, many Standard Reports
  • Multiple formats per report
  • Merge Data with Contract Terms
  • User-defined templates
  • Boardroom Quality Output

72
Oracle Business IntelligenceComprehensive View
of Financial Performance
General Ledger Profitability Analytics Incorpora
tes 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 AnalyticsProvides 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 AnalyticsMonitors 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.
73
Oracle Business Intelligence
74
(No Transcript)
75
(No Transcript)
76
(No Transcript)
77
(No Transcript)
78
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
    software.
  • 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

79
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.

80
(No Transcript)
81
New in Financial Control ReportingHighly
automated financials processing drives
efficiencies
  • Centralized accounting setup
  • Streamlined multiple ledger processing and
    reporting
  • Parallel financial reporting
  • Automatic reporting currency conversion
  • Replacement for disabled accounts

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

FLEXIBILITY
  • Accounting and reporting sequencing
  • Journal line reconciliation

AUDITABILITY
82
New in Procure-to-PayIntegrated Suite Optimizes
Working Capital
  • Document line level entry and approval
  • Non-PO invoice accounting entry by approvers
  • Invoice dispute management
  • Real-time status of purchasing contract TCs and
    invoicing activity in Oracle Payables and
    Purchasing

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

COST SAVINGS
  • Streamlined supplier setup and maintenance as
    part of Trading Community Architecture (TCA)
  • Access to TCA features

INTEGRATION
83
New in Credit-to-CashAccelerate 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

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

BETTER CASH FLOW
  • Visibility to carry-forward balances with
    cycle-based billing
  • Payment application according to customer
    preferences

INDUSTRY SUPPORT
84
New in Cash and TreasuryOptimize 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

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

COMPLEXITY
  • Simplified reconciliation of bank statements to
    cash transactions in multiple organizations
  • Support for new bank account balance types in
    bank statement import
  • Bank account-level reconciliation options and
    tolerances

FLEXIBILITY
85
New in Asset ManagementMaximize return on assets
  • Automate legacy asset conversion with enhanced
    preparation of Mass Additions

EFFICIENCY
  • Perform rollback on select assets with Automatic
    Depreciation Rollback

PERFORMANCE
  • Group Assets to include Units of Production
    method
  • Energy straight-line depreciation method
  • Asset impairment of a producing asset

INDUSTRY SUPPORT
86
New in Travel ExpenseLower the total cost of
travel and expense
  • CONUS and OCONUS global per diem rates
  • Per diem and policy schedules

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

ACCURACY
  • Self-service cash advance application during
    entry
  • Bar code generation
  • Streamlined receipts management with receipts
    tracking and receipts missing capabilities

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

90
QA
About PowerShow.com