Session 1: INTRODUCTION
- Oracle General Ledger - Keywords and Concepts
- Transactions
- Balances
- Overview of the General Ledger
- Chart of Accounts
- Accounts and Periods
- Set of Books
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
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 Data
- 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
- Create a Formula Recurring Journal Template Through AutoCopy
Session 7: 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 8: 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
- 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 9: AN OVERVIEW OF REPORTING TOOLS
- Oracle General Ledger Reports
- Oracle General Ledger Standard Reports
- Financial Statement Generator
- Oracle Financial Analyzer
- Application Desktop Integrator
- Oracle Discoverer
- RXi Reports Administration Tool
- Oracle Reports
- SQL Reports
- Comparison of Reporting Tools
Session 10: 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 11: INTRODUCTION TO FSG REPORTING
- FSG Components
- Plan a 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 a FSG Report
- Run an FSG Report
- Use a Content Set
Session 12: OVERVIEW OF APPLICATIONS DESKTOP INTEGRATOR
- Overview to ADI
- Advantages of Using ADI Reports
- Options for Creating a Report in ADI
- Starting ADI
- The ADI Toolbar
Session 13: DEFINING AND PUBLISHING REPORTS IN ADI
- Set Defaults for ADI
- Set FSG Options for ADI
- Reports in ADI
Session 14: PRODUCING REPORTS IN THE ADI REQUEST CENTRE
- Request Centre Functions
- The ADI Request Centre
- Submit Reports
- Submit a Standard (Fixed Format) Report
- Create and Apply Themes
- Report and Request Sets
Session 15: THE ADI REPORT WIZARD
- Access the Report Wizard Toolbar
- The Report Wizard Toolbar
- Create a Report Using the Report Wizard
- Define a Report in ADI with Existing Reports Components
Session 16: PARENT CHILD PARAMETERS
- Review or Amend Parent/Child Parameters
- Define a New Parent Account
Session 17: ROLL UP GROUPS
- Roll Up Groups and Budget Inquiries
- Define a Roll Up Group
- Assign Roll ID Groups to Account Segment Values
- Create a Summary Account Template
Session 18: 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
- Define and Publish an ADI Report
- Produce Reports in the ADI Request Centre
- The ADI Report Wizard