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