R12i Oracle General Ledger Fundamentals - Functional Foundation

R12i Oracle General Ledger Fundamentals - Functional Foundation
Teacher: Kabeer Khan
Released: October 19, 2021
Level: Beginner
Certificate: Finish lessons
Table of Contents
Description
Teacher
Intro GL Foundation
Introduction to the Course and Course Objectives - Intro GL Foundation
Basic Accounting and Financial Management Concepts
What is a General Ledger and SubLedgers?
Journal Entries
Journal, Ledgers and T-Accounts
Trial Balance and Adjustments
Financial Statements - Income Statement, Balance Sheet, Statement of Retained Earnings
The Accounting Process
Introduction to General Ledger and Multi-Org Architecture
Example of a Business Scenario
Introduction to General Ledger
Business Group
Legal Entities
Legal Entity Configurator
Ledgers
Secondary Ledgers
Reporting Currencies
Ledger Sets
Operating Units
Inventory Organizations
Subinventory
Multi-Org Structure
Accounting Setups
Business Scenario Solution in Oracle E Business Suite
Accounting Setup Steps
Steps for Creating an Accounting Setup Structure
Chart of Accounts (COA) and COA Examples from real-life implementations
Setting up Chart of Accounts
Setting Up Accounting Structure for our Business Scenario
Defining Flexfield Qualifiers and freezing Accounting Structure
Defining Account Combinations
Define Period Types and Accounting Calendars
Define or Enable Currencies
Define Currency Conversion Rate Types and Rates
Define Legal Entities
Create Accounting Setups and Configurations
Completing rest of the Ledger Accounting Setups
Define Operating Unit and Assigning it to Primary Ledger
Completing Legal Entity Setups for all other Legal Entities
Completing Ledger and Operating Unit Setups for all other Legal Entities
Information on further reading and documentation references
Multi Org Access Control, Responsibility and User Setup
Overview of Oracle Multi Org Access Control (MOAC) and General Ledger Security
Setting up Security Profiles for MOAC in Oracle HRMS
Creating new Responsibilities and setting up System Profile Options in Oracle Systems Administration
Creating Employee and completing associated setups in Oracle HRMS
Creating User and assigning Responsibility, and validating setups
Journal Entry
Accounting Cycle for Journal Entries
Journal Entry Types
Journal Creation Methods
Journal Components
Period Statuses
Entering Journal Entries - Batches, Header and Lines
Journal Sequences - for Accounting and Reporting Journals
Sequence Setup Process
Setting up Journal Sequences for GL Journals Posting
Viewing T Accounts and completing Journal Posting Process
Automatic Journal Creation in Reporting Currencies Ledger
Setting up Sequences for Sub-Ledger Accounting Journals
Invoice creation and checking automatic Sequencing for Subledger Journals
Generating Trial Balance Report for Primary Ledger
Account Enquiry and Journal Enquiry
Reversing Journal Entries
Reversing Journal Batches
Accounting Security
Ledger Sets - Accounting Security module
Setting up Ledger Sets
Opening Periods across Ledgers using Ledger Sets
Account Inquiry using Ledger Sets
Data Access Sets
Setting up Data Access Sets and securing Balancing Segments
Segment Value Security Rules
Setting up Segment Value Security Rules
Cross Validation Rules
Setting Up Cross Validation Rules
Comparison of Rules - Data Access Sets, Segment Value Security Rules and Cross Validation Rules
Account Hierarchy Manager
Journal Entry across Reporting Ledger and Subledgers
Reporting Across Ledgers
Journal Entry Standard Reports
Journal Entry Database Flow
Journal Components and DB Tables
Oracle Database Entity-Relationship Diagram for Journal Entry