This Oracle Application Desktop Integrator (ADI) course is designed for end users, managers, financial professionals and technical support staff. It would be specially useful for those involved in the month end reporting cycle, where there is a requirement to process adjustments and accruals and produce custom period end reports.

• Starting ADI and Signing on
• Modifying the ADI Toolbar
• Creating and Customizing Journal Worksheets with the Journal Wizard
• Creating Journal Entries
• Uploading Journals from ADI to the General Ledger
• Creating and Altering Budget Worksheets with the Budget Wizard
• Inserting a New Budget Account
• Uploading Budgets from ADI to the General Ledger
• Defining and Submitting Reports in the Request Centre
• Formatting Report Output
• Creating and Applying Report Output Themes
• Viewing Report Output and Logs
• Monitoring and Cancelling Requests
• Defining Reports using the Report Wizard
• Changing Reports using the Report Wizard
• Linking ADI Reports to FSG Reports
• Using Drill Down with the Analysis Wizard

Session 1: OVERVIEW OF APPLICATIONS DESKTOP INTEGRATOR

• Introduction to ADI
• Overview and Benefits of ADI
• ADI Journal Functionality
• ADI Budget Functionality
• ADI Reporting Functionality
• Start ADI and Sign On
• The ADI Toolbar
• Modify the ADI Toolbar

Session 2: JOURNAL WIZARD

• The ADI Journal Process
• Create and Customize Single Journal Worksheets
• Create and Customize Multiple Journal Worksheets
• Upload Journals from ADI to the General Ledger
• Query the General Ledger to Find Uploaded Journals

Session 3: BUDGET WIZARD

• Create a Budget Worksheet
• Insert a New Budget Account
• Upload Budgets from ADI to the General Ledger

Session 4: DEFINE AND PUBLISH REPORTS

• Set Defaults for ADI
• Publish GL Reports into Excel via ADI

Session 5: REQUEST CENTRE

• Request Centre Functions
• The ADI Request Centre
• Define and Submit Reports
• Submit a Standard (Fixed Format) Report
• Submit a FSG Report
• Format Report Output
• Create and Apply Themes
• Create Report and Request Sets
• Publish a Report or Request Set

Session 6: ADI REPORT WIZARD

• Access the Report Wizard Toolbar
• The Report Wizard Toolbar
• Load an Existing FSG Report into the ADI Report Wizard
• Define a Report in ADI with Existing Reports Components
• Create a Report using the Report Wizard
• Create a Content Set in the ADI Content Set Generator

Session 7: ADI ANALYSIS WIZARD

• Analyze an ADI Report
• Drill Down to Summary and Detail Accounts
• Drill Down to Subledger Detail
• Export Details to Excel

Session 8: ADI EXERCISES

• FGLSM, Oracle General Ledger Setup & Management
• FAR, Oracle Accounts Receivable
• FAP, Oracle Accounts Payable
• FAM, Oracl;e Asset Management