Oracle Applications Customer Council ppt

1
Oracle General Ledger GL Desktop Integrator
2
Post-to-Analysis
3
CENtralized TRansaction Approval
Close Your Books Faster

• An Intercompany Control System which
  allows you to centrally enter, approve, and
  identify manual inter- company transactions in
  a controlled manner across the enterprise.

4
CENtralized TRansaction Approval
Close Your Books Faster

• Record Transactions Across Sets of Books
• Even if use different calendars, charts of
  accounts and currencies
• Online Audit Trail
• Streamlines I/C Reconciliation

5
Post-to-Analysis
6
Journal Approval System
Lower Administrative Costs

• Based on Workflow Technology
• Tailor rules to address unique business needs
• Additional Level of Control
• Hierarchy based upon HR employee / manager
  relationship
• Specify authorization limits for each user

7
Journal Enhancements
Lower Administrative Costs

• AutoPost Criteria Sets
• Group journals by source, category, and effective
  date
• AutoPost at different frequenciesfor different
  criteria sets
• AutoCopy MassAllocations/ MassBudgets
• Ease creation of similar allocations/budgets

8
Mass Maintenance
Lower Administrative Costs

• Move / Merge Existing Accounts Balances
• Create New Accounts Based on Existing Accounts

From Depts 100 and 200
To Dept 500
01.100.000.1000 100 01.200.000.1000 75
01.200.010.2000 100
01.500.000.1000 175 01.500.010.2000 100
9
Mass Maintenance
Lower Administrative Costs

• Effect High Volume Modifications
• Chart of Account Reorganizations
• Corporate Restructuring
• Reclassifications
• Reversible Function
• Drill to Source Balances
• Provides Audit Trail

10
Post-to-Analysis
11
Multiple Reporting Currencies
Make Better Decisions

• Provides Multi-Currency Representations of
  Transactions
• Link Multiple Sets of Books with Different
  Reporting Currencies
• Automatically Replicate Transactions upon Posting

12
Euro Support

• Supports Fixed EURO NCU
  Conversion Factors
• Compliant withEURO TriangulationRules
• Use with MRC to Smooth Transition to EURO
  Accounting Requirements

13
Multi-Currency Enhancements
Lower Administrative Costs

• Cross-Currency Rates
• Enter conversion rates between any two
  currencies
• Single Daily Rates For Entire Install
• Simplifies maintenance
• Daily Rates Interface Table
• Standard API for importing daily currency rates

14
Post-to-Analysis
15

• Announcing . . .

The Global Consolidation System
16
The Consolidation Process
There are actually SEVEN tasks involved in the
consolidation process. Most consolidation
systems, however, only address a subset of these
tasks.
Analyze
Report
Eliminate
Transfer Data
Prepare Data
Map Data
Define Consolidation COA
17

Central Point of Control
Close Your Books Faster
Consolidation Workbench State Controller

• Consolidation Sets
• Comprehensive View of All Subsidiaries
• Latest Status for Each Subsidiary
• Color-Coded Workflow
• Blue Recommended
• Gray Not recommended
• Red Warning

18

Central Point of Control
Close Your Books Faster

• Consolidation Hierarchy Viewer

• A Graphical View of the Entire Consolidation
  Structure

19
Targeted Business Intelligence
Close Your Books Faster

• Flexible Mapping Rules
• Define General Subsidiary to Parent Relationship
• Specify Exception Cases

• Leverage Summary Account Efficiencies
• Automatically Derive Business Dimensions
• Consolidation Audit Reports

20
Post-to-Analysis
21
Enhanced Drilldown
Make Better Decisions

• New Drill Paths . . .
• From Account Balances To Complete Journal
  Entries
• From Translated Balances to Functional Balances
• Between Consolidated Entities

22
Cross-Enterprise Visibility
Make Better Decisions

• Drill From the Consolidated Parent to . . .
  
• Any Subsidiary
• Any Account
• Any Journal
• Any Subledger Transaction

23
We Interrupt This Program To...
Product Update

• Explain What ADI Is!!!
• Applications Desktop Integration (ADI) is a
  family of products which include
• GL Desktop Integrator
• Request Center
• Future Desktop Integration Functionality
• Fixed Assets

24
After the Close
Make Better Decisions and Lower Administrative
Costs
Here is the News!
Please Explain!
What Should I Do?
Request Center
Analysis Wizard
Financial Analyzer
25
Reporting

• FSG Report Title
• Moved from Row Set to Report Definition Level
• Easier Report Identification for Separate Reports
  using same Row Set

26
After the Close - Report
Lower Administrative Costs
After the close, you need to distribute results
in a timely and cost effective manner. With
Centralized Report Management, you can publish
reports anywhere -- more quickly and at a lower
cost than ever before! Request Center !
Here is the News!
27
After the Close - Report
Lower Administrative Costs

• Submit, Monitor, Publish from the Desktop
• Publish Financial (FSG) Reports AND Standard
  Reports From ANY Application
• Apply Themes for Automatic Formatting
• Replace Reports to Update Management Reporting
  Packages
• Fast Server-Based Reporting Engine
• And

28
After the Close - Report
Lower Administrative Costs

• Web Publishing
• Publish, Subscribe, and Pull On Demand
• Eliminates Manual Report Distribution
• Publish Once, Read Often
• No Lost Email or Missing Printouts
• Offload Report Viewing from Production
  Environment
• Lowers the Cost of Month End Reporting!

29
After the Close - Analyze
Make Better Decisions

• Optionally Include a Spreadsheet in Web Page for
  Download
• Drill Down via Analysis Wizard
• Information Filtered Using Security Rules
• Expand Analysis by Changing Drill Context
• Effectively creating NEW REPORTS on the fly!

30
Financial Analyzer Integration
Make Better Decisions

• Share Data and Structures
• Reduces Maintenance
• Reduces Reconciliation Issues
• Multiple Balance Transfers
• Any Balance Type
• Functional, Statistical, Average,
• Encumbrance
• Any Currency
• Detail Balances or Summary Balances
• Automatically Load Balances from GL to OFA

31
Financial Analyzer Integration
Make Better Decisions

• Automation Means Tighter Integration!

AutoLoad
BudgetWriteback
32
Oracle Receivables
33
Oracle Receivables - R11 Checklist

• Desktop Documents
• Customer Query
• Cross Currency Receipts
• AutoLockbox Enhancements
• Payment Application Rule Sets
• Notes Receivable
• Multiple Reporting Currencies
• Inquiry Only Menu

• Transaction Interface
• Tax Inclusive
• User-Definable Tax Hierarchy
• Account Method VAT
• Flexible Invoice Print
• Multi-Organization Enhancements
• User-Definable Dunning
• Dunning History

34
Order-to-Cash
Collections
Legacy System
Payment Receipt and Application
Invoice Generation
35
Automatic Transaction Processing
Lower Administrative Costs

• AutoInvoice
• Significant performance improvements since 10.7
• Transaction Interface
• Create, modify and delete transactions
• Real-time

36
Tax Inclusive
Lower Administrative Costs

• Provide invoices to your customers with tax
  included in individual unit amounts

37
Tax Inclusive
Lower Administrative Costs
38
Cross-Product Tax
Lower Administrative Costs Close Your Books Faster

• User-Definable Tax Hierarchy
• Account Method VAT
• New Variable Format Report
• U.S. Sales Tax Report

39
Flexible Invoice Print
Lower Administrative Costs

• Custom format your invoices
• New views to make invoice customizations simple
• Use any reporting tool

40
Multi-Organization Enhancements
Lower Administrative Costs

• Assign a default salesperson at the customer site
  level
• Create centralized statement and dunning sites
  for customers

41
Order-to-Cash
Collections
Legacy System
Payment Receipt and Application
Invoice Generation
42
Dunning Enhancement
Improve Cash Management Make Better
Decisions

• Create custom dunning letters
• Develop an unlimited number of dunning letters
• Create and modify letters on-line
• View dunning history in new window

43
Customer Query
Lower Administrative Costs

• Look up a customer based on a phone number
• View all customers within a given city, state,
  county, province, country, postal code or area
  code

44
Inquiry Only Menu
Lower Administrative Costs

• Allow employees to view information in the
  Receivables system without the ability to make
  any changes

45
Order-to-Cash
Collections
Legacy System
Payment Receipt and Application
Invoice Generation
46
Cross Currency Receipts

• Issue an invoice in one currency and receive
  payment in another currency
• Offers flexible billing and receiving
• Aids in transition to the euro
• Supports floating and fixed rate currencies

47
AutoLockbox
Lower Administrative Costs

• Increase hit rate of matching receipts to
  transactions
• Match using transaction, sales order, purchase
  order, consolidated bill or custom number
• Develop custom matching through open PL/SQL
  interface
• Allow receipts to be partially applied when there
  is an invalid transaction number
• Determine treatments of unapplied amounts
• Use Autocash rules for partial unapplied amounts

48
Payment Application Rule Sets
Lower Administrative Costs

• Control how payments are applied to your
  transaction balances by defining application rule
  sets
• Determine order of line, tax, freight and charges
• Define how the payment will be prorated among
  line types
• Assign application rule sets to transaction types
  and/or at system level

49
Notes Receivable
Improve Cash Management

• Process future dated checks and promissory notes
  as notes receivable
• Create note
• Note reaches maturity
• Clear note by running the Automatic Clearing
  program

50
Multiple Reporting Currencies
Make Better Decisions

• Report and Account Your Business in Multiple
  Currencies at Transaction Level
• Account in multiple functional currencies...
  automatically!
• Inquire and report in multiple functional
  currencies