Welcome to:

1. Welcome to: “Summer School” for Oracle 11i Your Instructor: Dorothy Sheets Independent Consultant Farmington Hills, MI

2. Agenda/Topics to Be Covered • Instructor Introduction • Lesson 1: General Ledger • Lesson 2: Accounts Receivable • Lesson 3: Fixed Assets • Field Trip: What I Learned at OAUG-Toronto • Other Erudite Professors • Review • Questions and Answers • Graduation! Dorothy Sheets, Independent Consultant

3. Instructor: Dorothy Sheets • Independent Consultant • Custom Curriculum Development • Training (Implementation Team and End Users) • Implementation Services • 9+ Years Experience in Oracle Applications • Office: 248-478-2177 • E-mail: dsheets@ameritech.net Dorothy Sheets, Independent Consultant

4. Lesson 1: General Ledger • 11i Differences (Brief) • Training and Implementation Considerations • Lessons Learned Dorothy Sheets, Independent Consultant

5. GL: Differences (Brief) • Enhanced Subledger Inquiries and Drilldowns • Automatic Reversal of Journals • Account Hierarchy Manager Copy Feature • Improved Multi-currency Management • Global Consolidation System (GCS) • Optional Closing Journals • RXi Reports • Global Intercompany System (GIS) • AutoAllocation Workbench Dorothy Sheets, Independent Consultant

6. GL: Training and Implementation Considerations • Chart of Accounts • Psychology vs. physiology • What CAN you include vs. what SHOULD you include • ADI (Applications Desktop Integrator) • To use or not to use • Teach ADI and actual application (let users decide) • Proper setup of ADI is important • Hierarchy Manager (Parent/Child Relationships) • Planning, setup and use • FSG (Financial Statement Generator) • It’s still here & it still works • Teach power users how to build report components • Row sets, column sets, content sets, etc. Dorothy Sheets, Independent Consultant

7. GL: Lessons Learned • RESIST Temptation to Make NEW System Look Exactly Like OLD System • PLAN Accounting Flexfield Carefully • Consider all modules implemented, not just GL • UTILIZE Cross-validation Rules • Look at bad data in “old” system to help build these • FSG • Setup row sets & test with existing column sets • Setup column sets (copy and modify existing sets) • See Metalink for technical details on content sets • Journal Import • User interface written for low volume Dorothy Sheets, Independent Consultant

8. Lesson 2: Accounts Receivable • 11i Differences (Brief) • Training and Implementation Considerations • Lessons Learned Dorothy Sheets, Independent Consultant

9. AR: Differences (Brief) • Credit Card Processing • Credit Memo Workflow • Tax Enhancements • Improved Document Sequencing • Enhanced AutoAccounting • AutoInvoice Exception Handling • Cross Currency Lockbox • Archive & Purge Performance Improvement • T-accounts • RXi Reports Handle Multiple Currencies Dorothy Sheets, Independent Consultant

10. AR: Training and Implementation Considerations • Be Prepared to Re-engineer Business Processes • But we’ve always done it THAT way • Customer Master • Set standards and communicate them to users • Standard Reports – Test and Re-test • Review and Populate QuickCodes • Test Standard Interfaces for Accuracy • FROM Order Management • FROM Oracle Projects • TO Oracle General Ledger Dorothy Sheets, Independent Consultant

11. AR: Lessons Learned • Be Flexible • Train on How to Use Application • Train on How Jobs Will Change • Train on Collections Call Handling • QuickCode data is important here • Test and Re-test Standard Reports for Accuracy • Test and Re-test RXi Reports for Accuracy • Test and Re-test Standard and Custom Interfaces for Accuracy Dorothy Sheets, Independent Consultant

12. Lesson 3: Fixed Assets • 11i Differences (Brief) • Training and Implementation Considerations • Lessons Learned Dorothy Sheets, Independent Consultant

13. FA: Differences (Brief) • Rollback and Rerun Depreciation • Depreciation Separate from Closing Period • Mass Reclassification • What-if Depreciation Analysis on Future Assets • Maintain Asset Insurance Values • Enhanced Mass Transfers • Security by Book • T-accounts • RXi Reports • Maintain CIP Assets in Tax Book(s) • Short Tax Year Support • Asset Maintenance Dorothy Sheets, Independent Consultant

14. FA: Training and Implementation Considerations • Category, Asset Key and Location Flexfields • Psychology vs. physiology • Account Generator • Use “as-is” or modify to get results you want • Modifications done with Oracle Workflow • Teach Entire Asset Life Cycle • Additions, adjustments, transfers, depreciation, retirements & reinstatements • Teach Application Flows • Enter data in corporate books • Close corporate books • Mass copy data to tax books (from a CLOSED corp book to an OPEN tax book) • Close tax books Dorothy Sheets, Independent Consultant

15. FA: Lessons Learned • Review and Test Account Generator Defaults Including Interface to General Ledger • Watch Out for General Ledger “Rules” • Cross-validation rule “violations” • Modify Account Generator (if necessary) • Watch Out for Initial Run of FAGDA Process • Initial (first) run can run long, but DOES complete • Can delay your first depreciation run, so be prepared • See Metalink for technical details on FAGDA process • Test Interface from Oracle Projects • Test Interface from Oracle Payables • ADI: Decide Whether or Not to Use • Ensure accuracy of spreadsheet data Dorothy Sheets, Independent Consultant

16. Field Trip: What I Learned at OAUG-Toronto • Plan for Training • DO Training • Do MORE Training* • Next OAUG is October 27-30 in San Diego *See OAUG website (member area) for a complete listing of 11i presentations delivered in Toronto – www.oaug.org Dorothy Sheets, Independent Consultant

17. Other Erudite Professors • Cline Consulting and Training Solutions • Cindy Cline • Web: www.ccatsolutions.com • E-mail: cindycline@earthlink.net • FMT Systems • Faun deHenry • Web: www.fmtsystems.com • E-mail: faun@fmtsystems.com • O2works • Mark Clark • Web: www.o2works.com • E-mail: mclark@o2works.com • Vlamis Software Solutions • David Fuston • Web: www.vlamis.com • E-mail: dfuston@vlamis.com Dorothy Sheets, Independent Consultant

18. Review • 11i GL/AR/FA • Nice enhancements to already stable modules • Low incidence of TARS • They WORK! • OAUG-Toronto • All users (in sessions that I personally attended) said they would do MORE training • OAUG-San Diego • October 27-30 Dorothy Sheets, Independent Consultant

19. Questions and Answers? • ??? • E-mail: dsheets@ameritech.net • Office phone: 248-478-2177 Dorothy Sheets, Independent Consultant

20. Graduation! • Thanks VERY MUCH for Your Attention • Good Luck with Oracle 11i • Please Pick Up “Diploma” at Back Table • Presentation Will Be Available On-line at: • www.mi-oaug.org • Have a GREAT Summer, See You in September! Dorothy Sheets, Independent Consultant