welcome to n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Welcome to: PowerPoint Presentation
Download Presentation
Welcome to:

Loading in 2 Seconds...

play fullscreen
1 / 20

Welcome to: - PowerPoint PPT Presentation


  • 94 Views
  • Uploaded on

Welcome to:. “Summer School” for Oracle 11i. Your Instructor: Dorothy Sheets. Independent Consultant Farmington Hills, MI. Agenda/Topics to Be Covered. Instructor Introduction Lesson 1: General Ledger Lesson 2: Accounts Receivable Lesson 3: Fixed Assets

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Welcome to:' - ashley


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
welcome to

Welcome to:

“Summer School” for Oracle 11i

Your Instructor: Dorothy Sheets

Independent Consultant

Farmington Hills, MI

agenda topics to be covered
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

instructor dorothy sheets
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

lesson 1 general ledger
Lesson 1: General Ledger
  • 11i Differences (Brief)
  • Training and Implementation Considerations
  • Lessons Learned

Dorothy Sheets, Independent Consultant

gl differences brief
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

gl training and implementation considerations
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

gl lessons learned
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

lesson 2 accounts receivable
Lesson 2: Accounts Receivable
  • 11i Differences (Brief)
  • Training and Implementation Considerations
  • Lessons Learned

Dorothy Sheets, Independent Consultant

ar differences brief
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

ar training and implementation considerations
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

ar lessons learned
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

lesson 3 fixed assets
Lesson 3: Fixed Assets
  • 11i Differences (Brief)
  • Training and Implementation Considerations
  • Lessons Learned

Dorothy Sheets, Independent Consultant

fa differences brief
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

fa training and implementation considerations
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

fa lessons learned
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

field trip what i learned at oaug toronto
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

other erudite professors
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

review
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

questions and answers
Questions and Answers?
  • ???
  • E-mail: dsheets@ameritech.net
  • Office phone: 248-478-2177

Dorothy Sheets, Independent Consultant

graduation
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