Release 11i Financials

Document Sample
Release 11i Financials Powered By Docstoc
					                Welcome to:
                “Summer School” for Oracle 11i




                Your Instructor: Dorothy Sheets

                Independent Consultant
                Farmington Hills, MI
June 18, 2002                                     1
                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!

June 18, 2002   Dorothy Sheets, Independent Consultant           2
                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




June 18, 2002   Dorothy Sheets, Independent Consultant                 3
                Lesson 1: General Ledger
                 11i Differences (Brief)
                 Training and Implementation Considerations
                 Lessons Learned




June 18, 2002   Dorothy Sheets, Independent Consultant         4
                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



June 18, 2002   Dorothy Sheets, Independent Consultant            5
                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.

June 18, 2002    Dorothy Sheets, Independent Consultant                            6
                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

June 18, 2002   Dorothy Sheets, Independent Consultant                         7
                Lesson 2: Accounts Receivable
                 11i Differences (Brief)
                 Training and Implementation Considerations
                 Lessons Learned




June 18, 2002   Dorothy Sheets, Independent Consultant         8
                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


June 18, 2002   Dorothy Sheets, Independent Consultant        9
                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




June 18, 2002   Dorothy Sheets, Independent Consultant                10
                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




June 18, 2002   Dorothy Sheets, Independent Consultant        11
                Lesson 3: Fixed Assets
                 11i Differences (Brief)
                 Training and Implementation Considerations
                 Lessons Learned




June 18, 2002   Dorothy Sheets, Independent Consultant         12
                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

June 18, 2002   Dorothy Sheets, Independent Consultant          13
                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

June 18, 2002   Dorothy Sheets, Independent Consultant                     14
                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
June 18, 2002   Dorothy Sheets, Independent Consultant                     15
                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




June 18, 2002   Dorothy Sheets, Independent Consultant            16
                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

June 18, 2002   Dorothy Sheets, Independent Consultant      17
                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




June 18, 2002   Dorothy Sheets, Independent Consultant                        18
                Questions and Answers?

                 ???
                 E-mail: dsheets@ameritech.net
                 Office phone: 248-478-2177




June 18, 2002   Dorothy Sheets, Independent Consultant   19
                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!




June 18, 2002   Dorothy Sheets, Independent Consultant           20

				
DOCUMENT INFO