This course introduces core General Ledger functions within Oracle R12 Financials. Ideal for those new to Oracle Financials, it delivers essential skills for journal processing, reporting, and inquiry.
Oracle R12 General Ledger
Build your Oracle General Ledger knowledge
This two-day course covers the Oracle R12 General Ledger module, offering real-world practice in key financial tasks. It equips finance professionals and support staff with hands-on skills to increase efficiency and confidence.
Learning objectives
- Understand Oracle General Ledger keywords and concepts
- Configure accounting calendars and period structures
- Review and design account flexfields
- Navigate Oracle Financials effectively
- Perform ledger, budget and funds inquiries
- Create and manage various journal types
- Use Web ADI for journal, budget and currency uploads
- Reconcile journals and run reconciliation reports
- Execute month-end and year-end processes
- Design and publish financial reports using FSG and Report Manager
What you’ll learn
Develop essential Oracle R12 General Ledger skills from journal creation to report analysis, using practical labs to reinforce learning.
Navigation & Setup
Gain familiarity with Oracle R12’s user interface, terminology, and navigation features, including the Navigator tabs and Oracle Help tools. Learn to use profile options and flexfields, enter and find data, work with folders, and explore how to attach supporting documentation. These skills are critical for navigating the system confidently and laying a solid foundation for the rest of the course.
Journals & Reconciliation
Understand the different types of journals including manual, statistical, mixed, recurring, and reversing. Learn how to create, amend, and post journals, reconcile them and reverse reconciliations when needed. You'll also explore how to generate and manage journal templates, define reconciliation processes, and use practical lab exercises to reinforce your knowledge step by step.
Web ADI Tools
Explore how to use Oracle’s Web ADI tools to streamline data entry and reporting. Learn to upload journals and budgets via the Journal Wizard and Budget Wizard, and manage exchange rates using the Currency Rates Manager. These tools integrate Microsoft Excel with Oracle, enabling greater speed and accuracy in financial tasks while reducing manual data entry errors.
What’s included
- Two days of instructor-led training
- Hands-on access to live labs
- Comprehensive courseware
- Practical exercises and walkthroughs
Key facts
Ideal for
Finance professionals and support staff using Oracle Financials for journal entries, inquiries, and financial reporting.
Prerequisites
Basic understanding of your organisation's accounting processes.
Learning experience
Our experienced trainers and interactive labs create a focused, practical environment – so you can put theory into practice from day one.
FAQs
This Oracle R12 General Ledger course offers hands-on training in journal processing, inquiry techniques, and reporting tools within Oracle Financials.
What is Oracle R12 General Ledger?
Oracle R12 General Ledger is a core component of Oracle Financials that enables organisations to record, manage and report on financial data. It supports journal entry, reconciliation, and financial reporting tasks.
Who should take this Oracle R12 General Ledger course?
This course is ideal for finance professionals, systems administrators, and support teams new to Oracle Financials or responsible for financial reporting and journal processing.
Do I need prior Oracle experience to take this course?
No. This course is suitable for beginners and includes foundational navigation training to help you get started.
How do I create and post journals in Oracle R12?
The course walks you through creating manual, statistical, mixed, and reversing journals, as well as posting journal batches using Oracle's standard procedures.
What is Web ADI and how is it used in this course?
Web ADI (Application Desktop Integrator) allows users to upload journal and budget data directly from Excel. You'll learn to use the Journal Wizard, Budget Wizard, and Currency Rates Manager.
What our customers say
"I have taken a number of virtual training courses over the years and I have to say this one was the best delivery wise. Stuart was engaging and explanatory, extremely patient and no question seemed unimportant or ridiculous. "
Ju, Performance Analyst, Legal
"John made the subject matter interesting. The pacing was spot on and he clearly knew what he was talking about and was able to communicate that easily. Very pleased and would highly recommend. "
Gavin, Government
Why study with StayAhead
96% customer satisfaction
We combine experience and passion to deliver training that meets the highest standards
30+ years’ experience
Industry-leading specialists delivering high-impact IT training
Experiential instructor-led training
Courses are delivered by experienced instructors using hands-on, practical live labs