R12.x Oracle General Ledger Management Fundamentals
Duration : 5 Days (40 Hours)
R12.x Oracle General Ledger Management Fundamentals Course Overview:
The Oracle R12.x General Ledger Management Fundamentals course provides users with a comprehensive understanding of the Oracle General Ledger application. It covers essential setup, features, and functionality within Oracle General Ledger.
The course begins by introducing the basics of Oracle’s GL structure and organization and then progresses to cover more advanced GL features, such as multi-currency, budgeting, and analysis tools. By the end of the course, users will have a thorough understanding of Oracle GL and a basic knowledge of setting up and using the various features available in Oracle’s GL application.
Intended Audience:
- Application Developers
- Functional Implementers
- System Administrators
- Finance Professionals
- Corporate training personnel
- Individuals involved in Oracle General Ledger projects
- Participants with prior knowledge of Oracle Applications
- Individuals with basic accounting understanding
- Participants seeking to learn Oracle General Ledger without prior experience.
Learning Objectives of R12.x Oracle General Ledger Management Fundamentals:
1. Learn how to set up, update and manage the Oracle R12 General Ledger product.
2. Gain familiarity of how to utilize the Oracle R12 General Ledger product throughout the accounting, budgeting, and reporting processes.
3. Understand how the Oracle R12 General Ledger product will affect day-to-day operations & financial management.
4. Master key General Ledger concepts such as chart of accounts, account segments, Ledger sets, period close process, posting profiles, currency conversion, revaluation, financial statements & budgeting.
5. Discover how to leverage the FLEXFIELDS, Value Sets, and various General Ledger structures to tailor your own General Ledger environment specific to the needs of your business.
6. Analyze the flow of the accounting entries in the R12 General Ledger
7. Generate reports using Journals, Account Analysis, Trial Balance, Period Close Reports, and Budget Reports.
8. Learn various accounting procedures including mass allocations, encumbrances, transactions, consolidations and intercompany accounting.
9. Understand how to migrate from 11i to R12 Oracle General Ledger product.
10. Get started with Enterprise Performance Management (EPMA) including running of reports, journal entry creation and loading to GL.
Module 1: Oracle General Ledger Process
- Understanding the General Ledger Functions and Features
- Analyzing the General Ledger Accounting Cycle
- Reviewing General Ledger Integration Points
- Generating Standard Reports and Listings
Module 2: Ledger
- Describing the Elements Required to Define Ledgers
- Identifying Attributes, Options and Settings to Define the Accounting Flexfield
- Defining an Accounting Calendar
Module 3: Using Accounting Setup Manager
- Creating Accounting Setups
- Creating Accounting Setup Structures
- Completing Accounting Options
- Analyzing Reporting Currencies
Module 4: Basic Journal Entries
- Describing how Journal Entries are Positioned in the Accounting Cycle
- Identifying Attributes, Options and Settings to Define the Accounting Flexfield
- Defining an Accounting Calendar
- Creating Manual Journal Entries
- Posting Journal Entries
- Performing Accounting Inquiries
- Performing Drilldowns to Oracle Sub-ledger applications
- Creating Reversing Entries
Module 5: Summary Accounts
- Understanding how Summary Accounts are used in General Ledger
- Defining Rollup Groups for Creating Summary Accounts
- Assigning Parent Values to Rollup Groups
- Entering Summary Account Templates
- Discussing Implementation Considerations
Module 6: Advanced Journal Entries
- Understanding Advanced Journal Entries Functions
- Understanding the Business Benefits of Advanced Journal Entries
- Understanding Recurring Journals
- Understanding Mass Allocation Journals
- Understanding Auto-Allocations
- Understanding Journal Scheduling
- Understanding Journal Approval
Module 7: Advanced Security
- Describing Data Access Security for Legal Entities and Ledgers
- Understanding Management Reporting and Security
Module 8: Financial Budgeting
- Understanding Anatomy of a Budget
- Completing the Budget Accounting Cycle
- Discussing Budget Entry Methods
- Uploading Budget Amounts
- Transferring Budget Amounts
- Freezing and Unfreezing Budget Amounts
Module 9: Multi-Currency
- Defining Foreign Currencies
- Entering Foreign Currency Journals
- Revaluing Foreign Currency Balances
- Translating Balances Into Foreign Currency
Module 10: Consolidations
- Identifying Consolidations Across the General Ledger Business Process
- Understanding Key Implementation Issues Across Consolidations
- Understanding the Global Consolidation System
- Defining the Elements of the Consolidation Workbench
Module 11: Period Close
- Understanding the Accounting Cycle
- Understanding Steps in the Close Process
- Performing Journal Import of Sub-ledger Balances
- Generating Revaluation
- Understanding the Closing Period
- Consolidating Account Balances
Module 12: Financial Reporting
- Identifying Financial Reporting Across the General Ledger Business Process
- Understanding Basic Report Building Concepts
- Understanding the Financial Statement Generator
- Generating Financial Reports using the Standard Request Submission Form
Module 13: Oracle Advanced Global Intercompany System
- Setting Up Intercompany and Intracompany Balancing
- Setting Up Advanced Global Intercompany System
- Setting up Intercompany Security
- Setting up Approvals Management
R12.x Oracle General Ledger Management Fundamentals Course Prerequisites:
1. Basic knowledge of personal computers, including the Windows operating system
2. Basic knowledge of relational databases
3. Basic knowledge of Oracle R12.x General Ledger Setup
4. Working knowledge of Financial Accounting
5. Understanding of basic concepts in the R12.x Oracle Navigation and Terminology
Discover the perfect fit for your learning journey
Choose Learning Modality
Live Online
- Convenience
- Cost-effective
- Self-paced learning
- Scalability
Classroom
- Interaction and collaboration
- Networking opportunities
- Real-time feedback
- Personal attention
Onsite
- Familiar environment
- Confidentiality
- Team building
- Immediate application
Training Exclusives
This course comes with following benefits:
- Practice Labs.
- Get Trained by Certified Trainers.
- Access to the recordings of your class sessions for 90 days.
- Digital courseware
- Experience 24*7 learner support.
Got more questions? We’re all ears and ready to assist!
Request More Details
