This is a three-day interactive training course created keeping in view the basics and the advanced concepts in Subledger Accounting. Training consists of intensive exercises to ensure you learn and master Subledger Accounting for use in implementation projects.
Preview
After learning the basics, you will then learn the advanced features of Oracle Subledger Accounting. You will learn how to use the Accounting Methods Builder (AMB) to create and modify subledger journal line setups and application accounting definitions [ AAD ].
We will then teach you the importance of Create Accounting Program & how it operates to create journals in XLA. After the Journal Entries are created in SLA, those are then transferred to General Ledger in either summary or detailed mode. We will explain how the transfer modes are controlled at various levels.
We will end this course after explaining the advanced R12 SLA features such as custom sources, business flows, multi period accounting, sequences and the diagnostic framework.
Learn To:
- Create and modify the setup for subledger journal entries and application accounting definitions for Oracle subledger applications.
- Create journal entries and transfer them to General Ledger.
- Inquire and report on subledger journal entries.
- Understand how Oracle Subledger Accounting integrates with the Oracle eBusiness Suite applications.
- Understand the major features of Oracle Subledger Accounting.
- Use Accounting Methods Builder (AMB) to create and modify subledger journal line setups and application accounting definitions.
Course Contents
Day 1
Overview of Oracle Subledger Accounting SLA in R12
What Is Subledger Accounting?
Understanding what is a Subledger?
Create Accounting and Transfer Journal Entries to General Ledger
Create Accounting Program
Draft Accounting and Online Accounting
Straight-Through Accounting by akin to garbage in garbage out
Overriding Straight-Through Accounting
Transfer Journal Entries to GL Program
Transfer Journal Entries to Oracle General Ledger
Journal Inquiries in SLA
Accounting Events Inquiry Process
Viewing Subledger Journal Entry Lines
Subledger Journal Entry Lines Inquiry Process
Drilldown from GL
Building Blocks of SLA
Accounting Methods Builder (AMB)
Copy and Modify Functionality to extend standard SLA
Transaction Chart of Accounts
Accounting Chart of Accounts
Application Accounting Definitions & its customizations
Day 2
Reporting in SLA
Various Reports in SLA
SLA Period Close Exceptions Report
Create Manual SLA Journal Entries
Subledger Journal Entries Overview
Creating Subledger Journal Entries
Reviewing and Completing Subledger Journal Entries
Duplicating Subledger Journal Entries
Other Subledger Accounting Concepts
Custom Sources overview - When to use and benefits
Business Flows concepts
Multiperiod Accounting concepts
Accrual Reversals concepts
Diagnostic Framework explained
Journal Entry Sequencing explained
Key tables explained such as xla_events, xla_transaction_entities, xla_ae_lines etc
Hands On Labs
Instructor will give various exercises to the trainees to perform hands on labs. This will give the trainees real life experience of SLA & its use cases in Oracle EBS. You will be creating custom Journal Line Types, creating custom Account Derivation Rules and mapping sets. You will be able to see the net effect of your changes in the journals that get created in SLA & General Ledger