Session 1: AN OVERVIEW OF 11i REPORTING TOOLS
- Oracle General Ledger Reports
- Oracle General Ledger Standard Reports
- Financial Statement Generator
- Oracle Financial Analyzer
- Applications Desktop Integrator
- Oracle Discoverer
- RXi Reports Administration Tool
- Oracle Reports
- SQL Reports
- Comparison of Reporting Tools
Session 2: STANDARD GENERAL LEDGER REPORTS
- Overview
- Concurrent Manager
- Concurrent Processing Definitions
- Useful Standard Reports
- Submit Request Flow
- Run a Standard General Ledger Report
- Scheduling Options
- Completion Options
- View Requests
Session 3: THE FINANCIAL STATEMENT GENERATOR
- Introduction to FSG Reporting
- FSG Components
- Plan a FSG Report
- Use Row and Column Sets
- Define Row Sets
- Define Column Sets
- Generate an ad hoc FSG Report
- Define a FSG Report
- Run a FSG Report
- Use a Content Set
Session 4: OVERVIEW OF APPLICATIONS DESKTOP INTEGRATOR
- Introduction to ADI
- Advantages of Using ADI Reports
- Options for Creating a Report in ADI
- Starting ADI
- The ADI Toolbar
Session 5: DEFINING AND PUBLISHING REPORTS IN ADI
- Set Defaults for ADI
- Set FSG Options for ADI
- Publishing Reports in ADI
Session 6: PRODUCING REPORTS IN THE ADI REQUEST CENTRE
- Overview
- Request Centre Functions
- The ADI Request Centre
- Submitting Reports
- Submit a Standard (Fixed Format) Report
- Submit a Standard (Variable Format) Report
- Submit a Financial Statement or Ad Hoc Report
- Create and Apply Themes
- Report and Request Sets
Session 7: 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 8: PARENT CHILD PARAMETERS
- Review or Amend Parent/Child Parameters
- Define a New Parent Account
Session 9: 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 10: FSG AND ADI EXERCISES