Session 1: INTRODUCTION
- Oracle General Ledger - Keywords and Concepts
- Transactions
- Balances
- Overview of the General Ledger
- New Features in Release 12
- Chart of Accounts
- Accounts and Periods
- Ledgers and Ledger Sets
Session 2: ACCOUNTING CALENDARS
- Accounting Periods
- Accounting Calendars
- Posting Account Balances
- Oracle General Ledger Features
Session 3: ACCOUNT FLEXFIELD DESIGN
- Key Flexfield Overview
- Account Code Combinations Review High-Level Invoice Information
Session 4: NAVIGATION
- Login and Logout of Oracle =
- The Navigator Functions Tab
- The Navigator Top Ten List
- The Navigator Documents Tab
- The Navigator Processes Tab
- Oracle Window Features and Terminology
- Oracle Form Features and Terminology
- Flexfields
- Icons
- Enter and Find Data
- Attachments
- Folders
- Profile Options
- Oracle Help
Session 5: GENERAL LEDGER INQUIRIES
- General Ledger Inquiries
- Funds Available Inquiries
- Inquiring on Actuals
- Inquiring on Encumbrances
- Inquiring on Budgets
Session 6: JOURNALS
- Create a Manual Journal
- Create a Statistical Journal
- Create a Mixed Journal
- Create a Reverse Journal
- Generate a Reverse Journal
- Find and Amend a Journal
- Post a Journal Batch
- Create a Fixed Recurring Journal Template
- Generate a Recurring Journal Template
- Create a Formula Recurring Journal Template
- Journal Reconciliation
Session 7: WEB ADI
- Use the Journal Wizard to enter and upload a journal
- Use the Budget Wizard to enter and upload budgets
- Use the Currency Rates Manager to enter and upload exchange rate information
Session 8: JOURNAL RECONCILIATION
- Set up Journal Reconciliation
- Reconcile Journals
- Run Reconciliation Reports
- Reversal of Reconciliation process
Session 9: MONTH AND YEAR END PROCESS OVERVIEW
- Month and Year End Process Overview
- Oracle Data Flow Across Ledgers
- Steps for General Ledger Month and Year End
Session 10: GENERAL LEDGER USER EXERCISES
- Run a Trial Balance Summary Report
- Inquire on Account - Actual Amounts
- Inquire on Account - Actual v Budget Amounts
- Inquire on Journals
- Enter a Journal - (standard and via Journal Wizard)
- Post Journals
- Enter Journal Batches
- Reverse an Existing Journal
- Post the Reversal
- Define Recurring Journals
- Generate a Recurring Journal
- Create a Folder Definition
- Run Standard Reports
Session 11: OVERVIEW OF REPORTING TOOLS
- Overview
- Oracle General Ledger StandardReports
- Report Categories
- Financial Statement Generator
- Oracle Financial Analyzer
- Oracle Discoverer
- RXi Reports Administration Tool
- Oracle Reports
- SQL * Plus Reports
- Comparison of Reporting Tools
Session 12: STANDARD GENERAL LEDGER REPORTS
- Concurrent Manager
- Concurrent Processing Definitions
- Useful Standard Reports
- Submit Request Flow
- Run a Standard General Ledger Report
- Scheduling Options
- Completion Options
- View Requests
Session 13: THE FINANCIAL STATEMENT GENERATOR
- Introduction to FSG Reporting
- FSG Components
- Plan an FSG Report
- Sets
- Predefined Row and Column Sets
- Define Row and Column Sets
- Generate an Ad Hoc FSG Report
- Define Row Sets
- Define Column Sets
- Define an FSG Report
- Run an FSG Report
- Use a Content Set
Session 14: REPORTING WITH REPORT MANAGER
- Overview of Report Manager
- Report Manager structure and access
- Publish a report to Reports Repository
- View a report in Reports Repository
- Publish a report from eBusiness homepage
- Analyse a financial report with Report Manager
Session 15: FSG EXERCISES
- Define a Row Set
- Define a Column Set
- Define an FSG Report
- Run an FSG Report
- View Report Requests
- Define a Content Set
- Define Display Groups and Display Sets
- Define a Row Order
Session 16: REPORT MANAGER EXERCISES
- Publish a report from a form function
- Analyse Report Output
- Export Analysis to MS Excel
- View a Report from Repository Management