Highlight of R12 Changes in Oracle Financials

1
Highlight of R12 Changes in Oracle Financials

• Highlight of R12 Changes in Oracle Financials
• DARC, Ralph Doucette, Senior Principal Consultant
• March 12, 2007

2
AGENDA

• Ledgers
• Responsibilities
• Intercompany
• Sub Ledger Accounting
• Fixed Assets
• Payables Mass Additions (Assets)
• Banks, Tax , Suppliers
• QA

3
General Ledger

• General Ledger now has Ledgers. Replaces Set of
  Books.
• A ledger Determines the currency, Chart of
  Accounts, Accounting Method, Ledger Processing
  Options and Subledger accounting method.
• Ledgers are defined when you create accounting
  setups in Accounting Setup Manager.

4
General Ledger

• Ledger Sets - Assign to single Responsibility
• Logical grouping of ledgers with the same chart
  of Accounts and Calendar /Period type. The
  Calculation Basis for cross/multiledger Inquiry,
  Reporting, and shared services operations.
• Opening/Closing Period
• Creating period closing journals, Allocations
  Recurring Journals
• Translating Balances
• Reporting

5
Responsibilities

• Responsibilities
• One responsibility can now be used to access
  multiple legal entities and ledgers.
• Data Access Sets are used to control access.
• When submitting a concurrent request you can
  submit the report for one or all the
  ledgers/Legal entities that you have been given
  access to.
• GL data access profile option replaces GL set of
  books.

6
Intercompany New Features

• New separate product
• Name Advanced Global Intercompany System - AGIS
• Ability to create invoices (AR and AP)
• Multiple recipients Support
• Proration of transaction distribution amounts
• Upload Transaction Batches created in Excel

7
Intercompany Changed Features

• Reversal of batch/transaction
• Descriptive flexfield support
• Flexible Approval Rules and Workflow
  Notifications
• Document attachment
• Transaction security

8
SLA - Sub Ledger Accounting

• Oracle Subledger Accounting is a rules-based
  engine for generating accounting entries based on
  source transactions from ALL Oracle Applications

9
SLA - Sub Ledger Accounting
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

10
SLA - Sub Ledger 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 audit ability 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

11
SLA - Sub Ledger Accounting

• There are no SLA responsibilities
• Users do not login to SLA
• SLA is a service provided to Oracle Applications
• SLA forms and programs are embedded within
  standard Oracle Application responsibilities
  (e.g. Payables Manager)
• SLA provides the following services to Oracle
  Applications
• Generation and storage of detailed accounting
  entries
• Storage of Subledger balances (e.g. third party
  control account balances)
• Subledger accounting entries (with drilldown to
  transactions)
• Subledger reporting (e.g. Subledger journal
  reports, open account balances listing)

12
Fixed Assets
New and Changed Features forOracle Assets

• Sub Ledger Accounting Architecture and Inquiries
• Enhanced Mass Additions for Legacy conversions
• Automatic Preparation of Mass Additions
• Flexible Reporting using XML publisher
• Automatic depreciation rollback
• Enhanced functionality for Energy industry

13
Fixed Assets - SLA

• Oracle Assets is fully integrated with SLA, which
  is a common accounting platform for Sub Ledgers.
• Customers can use the seeded Account Derivation
  definitions or modify them as required.
• Continue to support Account Generator
  functionality for existing Asset Books.
• New SLA Accounting report and online account
  inquiry.

14
Fixed Assets

• Enhancements have been made to the
  FA_MASS_ADDITIONS table. New Attributes have been
  added
• Asset Life
• Depreciation Method
• Prorate Convention
• Bonus Rule Ceiling Name
• Depreciation Limit Plus others.
• Web ADI has also been upgraded to include the new
  Attributes.

15
Fixed Assets- New Web ADI spreadsheet with
Attributes
16
Fixed Assets

• New Automatic Preparation of Mass Additions
• This new feature consists of default rules and
  Public APIs that can be used by customers to
  complete the preparation of mass addition lines
  automatically.
• Auto populate required fields such as Expense
  Account, Asset Category etc.
• Avoid manual intervention during the Mass
  Additions prepare process
• Avoid customization and use public APIs to
  effect custom business logic.

17
Fixed Assets

• Assets now uses Flexible Reporting using XML
  publisher
• Major Asset Transaction reports have been
  modified to support XML publisher.
• Users can modify or use new templates to view
  report output.
•  

18
Fixed Assets

• XML reporting is available for the following
  thirteen asset reports
• Asset Transfers Report
• Transaction History Report
• Asset Reclassification Report
• Mass Additions Create Report
• Cost Adjustment Report
• Cost Summary Report
• CIP Summary Report
• Reserve Summary

• 9. Journal Entry Reserve Ledger
• Asset Additions Report
• CIP Capitalization Report
• Mass Additions Posting
• Asset Retirements

19
Fixed Assets

• Automatic Depreciation Rollback
• Depreciation is rolled back automatically by the
• system when any transaction is performed on
• an asset if the following conditions are met
• Depreciation has been processed in that period
• The period is not closed
• It is no longer required to run depreciation
  rollback program manually.
• Depreciation rollback is executed only on select
  assets as required and not on the entire Asset
  Book this enhances performance of the program.

20
Fixed Assets

• Enhanced functionality for Energy Industry
• Energy Units of Production Method for Group
  Assets
• Allow Production method for Group Assets
• Allow Production upload to Group Assets
• Energy Straight line Method
• Net Book Value / Remaining Life

21
Payables

• Enhanced Asset Tracking in Payables
• - Item Description
• - Manufacturer
• - Model
• -Serial Number
• -Warranty Number
• Enhanced Mass Additions
• -Asset Book
• -Asset Category
• -IPV/ERV distributions

22
Payables New Form
23
Payables New Form
24
TAX E-Business Tax

• New Product
• Infrastructure for Tax Knowledge Management
• Global System Architecture
• Configurable and Scalable
• Single Point Solution
• Tax Service to all E-Business Suite Business
  Flows
• One Application Interface

25
TAX E-Business Tax

• Complete global tax solution for the E-Business
  Suite
• Easy to use and configure. Provides guided and
  expert configuration options
• Easy to integrate with 3rd party tax vendors.
  Provides infrastructure to upload tax content
• Provides infrastructure to define and share or to
  define and individually own tax content , to
  simulate tax setup, transaction lines and tax
  calculation results.
• Enables users to create and maintain a variety of
  tax rules and determining factors, which can
  handle from very simple to very complex tax
  requirements
• Captures all relevant tax information in the Tax
  Repository
• Offers powerful and flexible tax reporting
  solution where users can use and/or modify the
  pre-defined tax reporting templates .

26
TAX E-Business Tax

• The New Oracle E-Business Tax Product will be
  delivered in a number of phases. The first phase,
  to be delivered in R12.0, will cover standard
  procure to pay and order to cash transaction
  taxes, with the exception of withholding taxes
  and those taxes handled by the Latin Tax Engine
  solution.

27
Banks
28
Suppliers

• Streamlined Supplier setup and maintenance as
  part of Trading Community Architecture (TCA)
• Oracle iSupplier Portal enables secure,
  self-service business transactions between
  companies and their suppliers.
• Oracle iSupplier Portal provides a collaborative
  platform for a buyer to manage relationships with
  their global supply base.

29
QUESTIONS ANSWERS

• My e-mail rdoucette_at_darc.com