EBS GL-SLA
Summary
GL and SLA consist of 4 Volumes cut out from 21 Volume Book Set on Oracle (eBusiness Suite R12) Financials
A unique book set on a Complex Subject of Oracle ERP. Suitable for Trainees and Professionals like CAs, MBAs, CMAs or other Finance Professionals, working in Oracle ERP. A great opportunity to head start your Oracle ERP career.
The 21 Volume Book Set for eBusiness Suite R12 Financials is suitable for
- Trainees and Professionals like CAs, MBAs, CMAs
- Other Finance Professionals, working in Oracle ERP.
- A great Opportunity to Head Start your Oracle ERP Career.
Step by Step Visual Guide to perform Oracle R12 EBS Functionalities including abundant snaps of actual Oracle EBS R12 screens.
800+ Pages
1500+ Oracle EBS Snaps
Covers Setups/Configurations and Transactions.
Oracle General Ledger – 3 Volumes (Includes AGIS)
Oracle Subledger Accounting – 1 Volume
List of Chapters and Topics – GL & SLA
Creating Chart of Accounts
Value Sets and Values
Flexfield Qualifiers and Segment Qualifiers
Parent and Child Values, Account Hierarchy Manager
Security Rules
Cross Validation Rules
Creating Primary Ledgers
Setting up Legal Entity, Primary Ledger and GL Responsibility
Profile Options
Manual Journals
Journal Sources and Categories
Account Aliases
Daily Currency Exchange Rates
Foreign Currency Journals
Journal Approvals
Supervisory Hierarchy
Approval Limits
Approval Profile Options
Setting up Approvals
Approval Transaction Flow
Approval Communication History
Creating Document Sequences
Document Sequences and Categories
Sequence Assignments
Document Sequence Profile Options
Journal Sequence Number Generation
Recurring Journals
Recurring Journal Formula
Generating Recurring Journals
Recurring Journal Formula based on Account Balances
Simple Allocations using Recurring Journals
Journal Reversals
Reversing a Journal
Marking Journals for Reversal
Setting up Auto Reversing Journals
Reversal Profile Options
Reversal Concurrent Program
Uploading Journals using WebADI
WebADI Profile Options
Downloading WebADI Templates
Setting up Excel
Setting up Browser
Entering/Copying Journals in Excel
Uploading Journals
Journal Line Reconciliation
Concept: Zero Balance Accounts
Example: Accrual Accounts
Reconciliation Segment Qualifier
Reconciliation References
Enabling Journal Line Reconciliation
Simulating Manual Journal for Receipt Accruals
Simulating Manual Journal for Invoices
Performing Reconciliation
Reporting Un-reconciled Lines
Reporting Reconciled Lines
Setting up SLA for JL Reconciliation
Create Custom SLAM, AAD, JLD etc
Determine Sources for Reconciliation References
Setup SLA (Receipt Side) for Importing Recon References
Setup SLA (Invoice Side) for Importing Recon References
Assign Custom SLAM to Ledger
Journal Line Reconciliation with PO-INV-AP-GL Flow
Creating Purchase Orders
Receiving Material
Generating Receipt Accruals SLA & GJ Journal
Entering Invoice in Payables
Match Invoice to Receipt
Generate Invoice SLA and GL Journal
Importing Reconciliation References in GL
Reconciling Receipt JE Lines with Invoice JE Lines
Reporting Un-reconciled Transactions
Accruals and Un-invoiced Receipts
Auto Reconciliation of JE Lines
Reconciliation Rules
Executing Automatic Reconciliation
Verification of Reconciled Lines
Reporting Un-reconciled Lines
Mass Allocation
Cost Allocation Ratios
STAT Journals
Mass Allocation Formula
Generating Mass Allocation Journal
Reporting Currency Ledgers
Currency Rate Types and Daily Rates
Creating Reporting Ledgers
Data Conversion Levels
Data Conversion Initialization
Journal Conversion to Reporting Currency
Subledger Journal Conversion to Reporting Currency
Translation and Reporting Currency Ledgers
Secondary Ledgers
Multi-Country GAAP Compliance
Subledger Accounting Methods
Creating a COA Map
Creating Secondary Ledgers
Setting up Secondary Ledger Responsibility
Primary to Secondary Ledger Mapping
Journal Conversion Rules
Transaction Flow of Secondary Ledger Journals
Translation
Setting up Translation Options
Performing Translation
Reporting on Translation
Translation Reporting Currency Ledgers
Revaluation
Foreign Currency Balances
Performing Revaluation
Revaluation Journal
Consolidation
Creating Consolidation Ledger
Setting up COA Map
Setting up Consolidation Rules
Running Consolidation
Consolidation Journal
Intercompany and Intracompany
Setting up Intracompany Balancing Rules
Intracompany Balancing through Parent Companies
Intercompany Segment
Auto creation of Intercompany Journal Lines
Intercompany in Multiple Ledgers
Budgeting and Budgetary Control
Enabling Budgets and Budgetary Journals
Defining Budget and Budget Organization
Setting up Account Ranges and Assignments
Setting up Budgetary Control Level
Entering Budget Amounts and Creating Budget Journals
Encumbrance Journals
PO, Requisition Encumbrance
Invoice Encumbrance
Budgetary Control Groups
Budgeting on Summary Accounts
Creating Summary Accounts
Creating Summary Budgets
Entering Budget Amounts at Detailed Level
Transaction Flow of Summary Account Budgets
Accounting Configurations
Accounting Setups in General Ledger
Accounting Setups in Receivables/Payables
Accounting Setups in Assets/Cash
Accounting Setups in Purchasing/Inventory
Accounting Defaulting
Accounting Events & Journals
Accounting Journals in General Ledger
Accounting Events/Journals in Receivables/Payables
Accounting Events/Journals in Assets/Cash Management
Accounting Events/Journals in Purchasing/Inventory
Summary of Accounting Setups
Key Accounts required for Setting up Financials
Financial Statement Generators
Defining Row Sets
Defining Column Sets
Defining Reports
Defining Row Orders
Segment Override on Column Set
Segment Override on Reports
Using Column Offsets for Relative Period Reporting
Control Values and Budget Amounts
Creating Content Sets
FSGs with Content Sets
Publishing FSGs
Creating Balance Sheet, Profit & Loss A/c and Schedule
Summary Accounts & Rollup Groups
Creating Summary Templates
Balances of Summary Accounts
Creating Rollup Groups
Using Rollup Groups in Summary Accounts
Data Access Sets
Securing Data with Data Access Sets
Defining and Assigning Access Sets
Profile Options
Definition Access Sets
Creating Definition Access Sets
Assigning Definition Access Sets
Securing Data Elements
Data Access Sets V/s Definition Access Sets
Advanced Global Intercompany System
Setting up Intercompany System Options
Setting up Intercompany Transaction Types
Setting up Intercompany Accounts
Setting up Intercompany Organizations and Users
Setting up Intercompany Invoicing
AGIS Transaction Flow
Creating Outbound Transactions
Receiving and Approving Inbound Transactions
Generating Intercompany Journals
Initiating Transactions Requiring AP/AR Invoicing
Receiving and Approving Inbound Transactions
Generating Receivables Invoices
Generating Payables Invoices
Intercompany Accounting
AGIS & SLA Integration
AGIS Transaction Account Definition
Creating Account Derivation Rules (ADRs) for Intercompany
Generating I/C Receivables/Payables through ADRs
Generating Distributions through ADRs
List of Chapters/Topics – SLA
Subledger Accounting (SLA)
Introduction and Accounting Flow
Subledger Journals and GL Journals
SLA Structure
Subledger Accounting Method (SLAM)
Associating SLAM with Ledger
Subledger Accounting Methods
Understanding Application Accounting Definitions (AADs)
Understanding Journal Line Definition (JLDs)
Understanding Journal Line Types (JLTs)
Understanding JLT Conditions and Accounting Attributes
How JLD Builds a CCID
Understanding Account Derivation Rules (ADRs)
Understanding Seeded Sources and Custom Sources
Subledger Accounting Methods in Secondary Ledgers
Account Derivation Rules
Creating an ADR
Creating a Custom SLAM
Creating a Custom AAD
Creating Required Custom JLDs
Associating Custom JLDs with Custom AADs
Associating Custom AADs with Custom SLAM
Validating Custom AADs
Associating Custom SLAM with Ledger
Perform Accounting Cycle with Custom SLAM/AAD/JLD and ADR
Mapping Sets
Creating Mapping Sets for Custom Accounting Logic
Creating Input Output Co-relation
Associating Mapping Set with ADR
How Mapping Sets allow Custom Accounting without a line of Code
Performing Accounting Cycle using Mapping Sets in ADR
Business Flow
Introduction to ‘Business Flow’ in SLA
Understanding Prior Entry Business Flow Method
Understanding Same Entry Business Flow Method
Payables Automatic Offsets using Same Entry Method
Inheritance of Segment Values in Same Entry Method
Journal Line Descriptions
Understanding Journal Line Descriptions
Building Custom Journal Line Descriptions for Imported Journals
Performing Transaction Cycle with Custom Descriptions
Accounting and Reporting Sequences
What are Accounting and Reporting Sequences
Creating Accounting Sequence
Creating Reporting Sequence
Assigning Sequences
Create SLA and JL Journals to test Sequence Generation
Multi-Fund Receivables
What is Multi-Fund Receivables
Receivables Invoices with Multiple Balancing Segment Values
Using SLA to handle Multi-Fund Receivables
Multi-Fund Accrual – Balancing Method
Multi-Fund Accrual – Account Method
Financial Accounting Hub (FAH) Setups
Concepts: SLA Integration with Custom/External Applications
Registering Application
Creating FAH Setup Environment
Application Objects
Transaction Objects
Creating Event Model
Creating Process Categories
Accounting Event Class Options
FAH – Create SLA Structure
Creating Account Derivation Rules (ADR)
Creating Journal Line Types (JLT)
Accounting Sources and Accounting Attributes
Creating Journal Line Definitions (JLD)
Creating Application Accounting Definition (AAD)
Incorporating AAD in Subledger Accounting Method
FAH – Create Accounting Process
Event Capture
Populating SLA Journals in XLA Tables
Populating GL Interface
Journal Import and Posting
Registering ‘Create Accounting Process’
21 Volume Book Set on Oracle eBusiness Suite R12 Financials
Click to see Details of the Entire EBS Book Set
