11i Admin/Use Public Sector GL

In this course‚ participants from the Public Sector marketplace will learn how to set up and use Oracle Public Sector General Ledger to create journal entries‚ develop budgets and prepare and analyze financial reports. Participants will learn how to set up and use Oracle's budgetary control and encumbrance accounting features. Class exercises will guide them in defining the accounting structure‚ setting up the accounting calendar and establishing the appropriate financial controls and parameters. Participants will practice creating and maintaining manual and formula-based journal entries‚ producing budgets‚ accounting for interfund transactions and preparing standard and custom financial reports. Hands-on exercises will give the student an opportunity to practice performing functions such as reporting on multiple entities‚ consolidating financial results and implementing audit controls. Throughout this process‚ students swill gain experience using tools such as GL Desktop Integrator and Oracle Account Hierarchy Editor. Participants will also learn how Oracle's Public Sector General Ledger module integrates with Oracle Public Sector Payables, Oracle Public Sector Receivables‚ and Oracle Public Sector Purchasing.
Audience
Course Topics Navigating through the System Set of Books:

• Creating a set of books
• Setup considerations for setting up a basic chart of accounts structure

Journals

• Entering, posting, and reviewing journal entries and batches
• Reversing journal entries
• Defining and generating recurring journals and MassAllocation journals
• Importing journal entries from subledgers
• Using Oracle General Ledger Desktop Integrator, entering journals using a spreadsheet interface
• Defining an approval hierarchy to approve journal entries before posting

Budgeting:

• Creating a budget
• Defining a budget organization
• Entering budget amounts using different rules and methods
• Using Budget Wizard to enter budget amounts in a spreadsheet
• Uploading budgets to Oracle Public Sector General Ledger
• Performing budget inquiries
• Freezing budgets to prevent further modifications

Advanced Account Structure:

• Defining suspense and intercompany balancing accounts to ensure that your books remain in balance
• Creating rollup groups and summary account templates to enhance online inquiry and reporting capabilities
• Transferring and merging balances from one account to another account
• Defining financial controls for maximizing system efficiency

Reporting and Analysis Tools:

• Running standard reports
• Creating basic FSG reports using five required and optional report components
• Using Application Desktop Integrator (ADI) Report Wizard to define FSG reports
• Using ADI Request Centering to submit and publish reports to a spreadsheet and Web page
• Using ADI Analysis Wizard to drill down on amounts to perform account analysis
• Understanding the integration with Oracle Financial Analyzer

Multiple Company Accounting and Consolidation:

• Setting up and using CENTRA (Centralized Transaction Approval) to enter intercompany transactions between multiple
• Setting up the Global Consolidation System (GCS)
• Consolidating your subsidiaries sets of books by transferring balances to the parent set of books, creating

Implementation Considerations

• Using the Implementation Wizard to help participants implement Oracle General Ledger and other Oracle Applications
• Creating and setting up sets of books
• Setting up Oracle General Ledger

Course Objectives

• Set up and use Oracle Public Sector General Ledger