Oracle General Ledger & GL Desktop Integrator

1. Oracle General Ledger & GL Desktop Integrator

2. Post Subledger Spreadsheet Journal Multi-Currency Intercompany Transaction Post-to-Analysis

3. CENTRA 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 Subledger Spreadsheet Journal Multi-Currency Intercompany Transaction 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 Subledger Spreadsheet Journal Multi-Currency Intercompany Transaction 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. Report Consolidate Analyze Budget Writeback 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 Sets • Comprehensive View of All Subsidiaries • Latest Status for Each Subsidiary • Color-Coded Workflow • Blue = Recommended • Gray = Not recommended • Red = Warning Consolidation Workbench & State Controller

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. Report Consolidate Analyze Budget Writeback 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 SummaryBalances • Automatically Load Balances from GL to OFA

31. Financial Analyzer Integration Make Better Decisions • Automation Means Tighter Integration! AutoLoad BudgetWriteback

32. Oracle Receivables

33. Transaction Interface Tax Inclusive User-Definable Tax Hierarchy Account Method VAT Flexible Invoice Print Multi-Organization Enhancements User-Definable Dunning Dunning History Desktop Documents Customer Query Cross Currency Receipts AutoLockbox Enhancements Payment Application Rule Sets Notes Receivable Multiple Reporting Currencies Inquiry Only Menu Oracle Receivables - R11 Checklist

34. Order Processing PROJECT PROJECT PROJECT Assets Cash Account Receivable Land Total Assets Liability Account Payable Notes Payable Total Liability Stockholder’s Equity Contributed Capital Retained Earnings Total Stockholder’s Equity $4,456 $5,714 $ 981 --------- $11,151 ====== $3,830 $ 416 --------- $4,246 ====== $2,365 $ 367 --------- $2,732 ====== Assets Cash Account Receivable Land Total Assets Liability Account Payable Notes Payable Total Liability Stockholder’s Equity Contributed Capital Retained Earnings Total Stockholder’s Equity $4,456 $5,714 $ 981 --------- $11,151 ====== $3,830 $ 416 --------- $4,246 ====== $2,365 $ 367 --------- $2,732 ====== Assets Cash Account Receivable Land Total Assets Liability Account Payable Notes Payable Total Liability Stockholder’s Equity Contributed Capital Retained Earnings Total Stockholder’s Equity $4,456 $5,714 $ 981 --------- $11,151 ====== $3,830 $ 416 --------- $4,246 ====== $2,365 $ 367 --------- $2,732 ====== Projects 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. Unit Price Extended Amount Item no. Description Quantity World Atlas 2 $50.00 $100.00 15138 Multimedia Monitor $300.00 $300.00 1 P66238 $400.00 Subtotal 40.00 Tax $440.00 Total Unit Price Extended Amount Includes Tax Item no. Description Quantity World Atlas 2 $50.00 $110.00 X 15138 1 Multimedia Monitor $300.00 $300.00 P66238 Subtotal $410.00 30.00 Tax $440.00 Total 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 Processing PROJECT PROJECT PROJECT Assets Cash Account Receivable Land Total Assets Liability Account Payable Notes Payable Total Liability Stockholder’s Equity Contributed Capital Retained Earnings Total Stockholder’s Equity $4,456 $5,714 $ 981 --------- $11,151 ====== $3,830 $ 416 --------- $4,246 ====== $2,365 $ 367 --------- $2,732 ====== Assets Cash Account Receivable Land Total Assets Liability Account Payable Notes Payable Total Liability Stockholder’s Equity Contributed Capital Retained Earnings Total Stockholder’s Equity $4,456 $5,714 $ 981 --------- $11,151 ====== $3,830 $ 416 --------- $4,246 ====== $2,365 $ 367 --------- $2,732 ====== Assets Cash Account Receivable Land Total Assets Liability Account Payable Notes Payable Total Liability Stockholder’s Equity Contributed Capital Retained Earnings Total Stockholder’s Equity $4,456 $5,714 $ 981 --------- $11,151 ====== $3,830 $ 416 --------- $4,246 ====== $2,365 $ 367 --------- $2,732 ====== Projects 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 Processing PROJECT PROJECT PROJECT Assets Cash Account Receivable Land Total Assets Liability Account Payable Notes Payable Total Liability Stockholder’s Equity Contributed Capital Retained Earnings Total Stockholder’s Equity $4,456 $5,714 $ 981 --------- $11,151 ====== $3,830 $ 416 --------- $4,246 ====== $2,365 $ 367 --------- $2,732 ====== Assets Cash Account Receivable Land Total Assets Liability Account Payable Notes Payable Total Liability Stockholder’s Equity Contributed Capital Retained Earnings Total Stockholder’s Equity $4,456 $5,714 $ 981 --------- $11,151 ====== $3,830 $ 416 --------- $4,246 ====== $2,365 $ 367 --------- $2,732 ====== Assets Cash Account Receivable Land Total Assets Liability Account Payable Notes Payable Total Liability Stockholder’s Equity Contributed Capital Retained Earnings Total Stockholder’s Equity $4,456 $5,714 $ 981 --------- $11,151 ====== $3,830 $ 416 --------- $4,246 ====== $2,365 $ 367 --------- $2,732 ====== Projects 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. Vision Enterprises Financial Statement at December 31, 1997 JOURNAL Vision Enterprises Financial Statement at December 31, 1997 Assets Cash Account Receivable Land Total Assets Liability Account Payable Notes Payable Total Liability Stockholder’s Equity Contributed Capital Retained Earnings Total Stockholder’s Equity $4,456 $5,714 $ 981 --------- $11,151 ====== $3,830 $ 416 --------- $4,246 ====== $2,365 $ 367 --------- $2,732 ====== Vision Enterprises Financial Statement at December 31, 1997 Assets Cash Account Receivable Land Total Assets Liability Account Payable Notes Payable Total Liability Stockholder’s Equity Contributed Capital Retained Earnings Total Stockholder’s Equity $4,456 $5,714 $ 981 --------- $11,151 ====== $3,830 $ 416 --------- $4,246 ====== $2,365 $ 367 --------- $2,732 ====== Assets Cash Account Receivable Land Total Assets Liability Account Payable Notes Payable Total Liability Stockholder’s Equity Contributed Capital Retained Earnings Total Stockholder’s Equity $4,456 $5,714 $ 981 --------- $11,151 ====== $3,830 $ 416 --------- $4,246 ====== $2,365 $ 367 --------- $2,732 ====== PAYMENT ? 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