Welcome to
This presentation is the property of its rightful owner.
Sponsored Links
1 / 20

Welcome to: PowerPoint PPT Presentation


  • 68 Views
  • Uploaded on
  • Presentation posted in: General

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

Download Presentation

Welcome to:

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: [email protected]

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: [email protected]

  • FMT Systems

    • Faun deHenry

    • Web: www.fmtsystems.com

    • E-mail: [email protected]

  • O2works

    • Mark Clark

    • Web: www.o2works.com

    • E-mail: [email protected]

  • Vlamis Software Solutions

    • David Fuston

    • Web: www.vlamis.com

    • E-mail: [email protected]

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: [email protected]

  • 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


  • Login