Oracle Financials R12

Version: R12
Duration: Approximately 45+ Hours
Author: Prasad Anguluri

Please note: In our Oracle financials training, we drive the student to create an entire company of their choice while we walk through a new company implementation end-to-end from requirements gathering to end user testing. This allows the student to encounter almost any possible scenarios and learn to act in real time. ANG is the only company that enables a student to configure, implement and test Oracle Financials so comprehensively.

Modules Covered: General Ledger (GL), Accounts Receivable (AR), Accounts Payable (AP), Fixed assets (FA), Cash Management (CM) Report Manager (RM) and System Administration, Web ADI, Sub Ledger Accounting concepts.

Access by subscription

Access Oracle Financials by subscribing to the complete course or to each module.

Enroll in Complete Course or Module

GL
Oracle Financials R12 Module 1: General Ledger (GL)
Module 1 Oracle Financials GL Configuration Videos
This section has all videos relating to GL Configuration.
Unit 1 Oracle Apps Multi Organisation Structure
Unit 2 GL Configurations COA Value Set
Unit 3 GL Configuration Part II
Unit 4 Setting up Legal Entity, Ledger & Operating Unit
Unit 5 Define GL Responsibility & Open GL Period
Module 2 Oracle Financials GL Advance Features & Testing Videos
This section has all videos relating to GL Testing.
Unit 1 Ledger Sets & Access Sets
Unit 2 GL Drilldown & Reports Multi Output
Unit 3 Enter to Reversal Post
Unit 4 Journal Inquiry etc
Unit 5 GL Standard Reporting
Module 3 Oracle Financials GL Miscellaneous Videos
This section has all videos relating to Miscellaneous topics in GL .
Unit 1 GL Consolidations, Revaluation & Translation
Unit 2 Journal Approvals & Inter-Company Balancing
Unit 3 Financial System Generator (FSG)
Module 4 Oracle Financials GL Downloadable Documents
This section has all downloadable documents relating to GL.
Unit 1 General Ledger (GL): Downloads
Module 5 Oracle Financials GL Quiz
This section comprises of all GL quizes.
Unit 1 GL Exam Download
Unit 2 GL Quiz

Course Overview

  • The Heart of Accounting System & Overview of GL Concepts
  • Overview of General Ledger and project requirements
  • Configuring GL Module from scratch
  • Defining Accounting Flexi field- Set Of Books
  • Defining various types of Journals & Security Rules
  • Interfaces in General Ledger Module
  • Relationship with Other Financials Modules
  • Standard GL reports
  • Running Business Test Scripts for GL
Subscribe to this module
AP
Oracle Financials R12 Module 2: Accounts Payable (AP)
Module 1 Oracle Financials AP Configuration Videos
This section comprises of Oracle Financials AP Configuration Videos.
Unit 1 Introduction to Inventory Organisation
Unit 2 Payment Terms & Tolerances
Unit 3 Global Setups & Financial Options: Part I
Unit 4 Financial Options: Part II
Unit 5 Payable System Setup
Unit 6 Payable Options
Unit 7 Assigning Legal Entity
Unit 8 Bank Account Setup
Unit 9 Aging Periods
Unit 10 Lookups
Unit 11 Tax Codes, Payable Period Opening & It's Importance
Unit 12 Supplier Definition: Intro, 11i vs R12, Defaults etc.
Module 2 Oracle Financials AP Testing Videos
This section comprises of Oracle Financials AP Testing Videos.
Unit 1 Supplier Invoice to Payment
Unit 2 Distribution Sets
Unit 3 Supplier Invoices Entry, Validate, Holds, Accounting etc.
Unit 4 Recurring Invoice
Unit 5 Batch Validation
Unit 6 Invoice Hold Report
Unit 7 Entering Credit Memo
Unit 8 Supplier Invoice Batch Payment Process
Unit 9 Payment Process Request Template Definition & Payments
Unit 10 Supplier Invoice via Quick Payment / Manual Check
Unit 11 Voiding Supplier Payment
Unit 12 Payable Reports
Unit 13 Find Unpaid Invoice & Do Manual / Quick Pay
Unit 14 Supplier Prepayment
Unit 15 Create Accounting
Unit 16 Cancel Invoices
Unit 17 Invoice Reversal
Unit 18 Supplier Quick Invoices
Module 3 Oracle AP Miscellaneous
This section comprises of Miscellaneous AP videos.
Unit 1 Other Miscellaneous Setups
Unit 2 AP - PO Matching Concepts
Module 4 Oracle Financials AP Downloadable Documents
This section has all downloadable documents relating to AP.
Unit 1 Accounts Payable (AP): Essential Downloads
Module 5 Oracle Financials AP Quiz
This section comprises of AP quizzes.
Unit 1 AP Demo Unit

Subscribe to this module

Course Overview

  • Overview of Payables Concepts
  • Overview of payables project requirements
  • Configuring AP Module from scratch
  • Creating Various types of Invoices
  • Approving an Invoice
  • Payables Data model
  • Relationship with Other Financials Modules
  • Standard AP reports
  • Running Business Test Scripts for AP
FA
Oracle Financials R12 Module 3: Fixed Assets (FA)
Module 1 Oracle Financials FA Configuration Videos
This section comprises of Oracle Financials FA Configuration Videos.
Unit 1 Introduction, FA Key Flexfields & Location Flexfied
Unit 2 FA Category Flexfield & Enter FA Key Flexfields Values
Unit 3 System Controls & Book Controls
Unit 4 Defining Asset Categories, Setting Up Asset Books, Assigning Categories to Books & FA Profile Values
Unit 5 Depreciation Methods
Unit 6 Financial & Pro Rate Calendars
Module 2 Oracle Financials FA Testing Videos
This section comprises of Oracle Financials FA Testing Videos.
Unit 1 Quick Addition
Unit 2 Detailed Asset Addition
Unit 3 Asset Addition from Accounts Payable to Fixed Asset
Unit 4 Depreciation Projection
Unit 5 Asset Warrenties
Unit 6 Transfer Assets
Unit 7 Reclassify Assets
Unit 8 Cost-In-Progress Addition
Unit 9 Running Depreciation
Unit 10 Create Accounting & General Ledger Entries Review
Unit 11 Retirement of Asset & Accounting Entries
Unit 12 Tax Book Definition, Transferring Assets to Tax Book and Testing Tax Book
Module 3 Oracle Financials FA Downloadable Documents
This section has all downloadable documents relating to FA.
Unit 1 Fixed Asset (FA): Essential Downloads
Module 4 Oracle Financials FA Quiz
This section comprises of all FA quizes.
There are no units in this module.
Subscribe to this module
AR
Oracle Financials R12 Module 4: Accounts Receivable (AR)
Module 1 Oracle Financials AR Configuration Videos
This section comprises of Oracle Financials AR Configuration Videos.
Unit 1 Introduction to AR-BR100, Replicate Seeded Data, Multi-Org Flag & Importance
Unit 2 System Options
Unit 3 Auto Accounting & It's Importance
Unit 4 Transaction Types
Unit 5 Transaction Sources
Unit 6 Memo Lines
Unit 7 Remit To Address
Unit 8 Tax Profile
Unit 9 Receivable Activities
Unit 10 Payment Terms
Unit 11 Approval Limits
Unit 12 Receipt Classes
Unit 13 Receipt Sources
Unit 14 Statement Cycles
Unit 15 Collectors
Unit 16 Customer Profile Classes
Unit 17 Sales Person
Unit 18 Quick Codes
Unit 19 Order Management Item Validation Organization
Unit 20 Profile Options
Unit 21 Create Customer
Unit 22 Customer Update
Module 2 Oracle Financials AR Testing Videos
This section comprises of Oracle Financials AR Testing Videos.
Unit 1 Introduction to AutoInvoice
Unit 2 Transactions with Batch
Unit 3 Transaction without Batch
Unit 4 Invoice Print Quick Review
Unit 5 Invoice Adjustment
Unit 6 Credit Memo & Application
Unit 7 Debit Memo
Unit 8 Standard Receipt
Unit 9 Receipt Reversal
Unit 10 Receipt Batch & Miscellaneous Receipt
Unit 11 Create Accounting
Unit 12 Standard Reports & AR Reconciliation
Module 3 Oracle Financials AR Lockbox Videos
This section comprises of AR Lockbox Videos.
Unit 1 Introduction
Unit 2 Lockbox Process & Overall Steps
Unit 3 Implementation Steps
Unit 4 Implementation Steps, MD50, Team Change Request
Unit 5 Configuring Lockbox
Unit 6 Testing
Module 4 Oracle Financials AR Downloadable Documents
This section has all downloadable documents relating to AR.
Unit 1 Accounts Receivable (AR): Essential Downloads
Unit 2 Accounts Receivable Lockbox (AR Lockbox): Essential Downloads
Module 5 Oracle Financials AR Quiz
This section comprises of all AR quizzes.
There are no units in this module.
Subscribe to this module
CM
Oracle Financials R12 Module 5: Cash Management (CM)
Module 1 Oracle Financials CM Configuration Videos
This section comprises of Oracle Financials CM Configuration Videos.
Unit 1 Introduction to CM-BR100, Setups, Auto Reconciliation
Unit 2 Bank Reconciliation
Unit 3 Testing
Module 2 Oracle Financials CM Downloadable Documents
This section comprises of documents relating to Cash Management.
Unit 1 Cash Management (CM): Essential Downloads
Subscribe to this module
Sys Admn

This is a Complementary Module that is available with purchase of  Complete Oracle Financials Course.


Oracle Financials R12 Module 7: System Administration and Application Object Library
Module 1 ANG Oracle Financials R12 System Administration and Application Object Library Module
Module Description
Unit 1 Introduction
Unit 2 User Maintenance
Unit 3 Responsibility Definition
Unit 4 Request Group Definition
Unit 5 System Profile Options
Unit 6 Menu and Functions
Unit 7 Concurrent Requests & Parent ID
Unit 8 Concurrent Programs Definition
Unit 9 Reports in System Administrator
Unit 10 Miscellaneous Items in System Administrator

Misc. (RICE, AIM...)

This is a Complementary Module that is available with purchase of Complete Oracle Financials Course.


Oracle Financials R12 Module 6: Misc (RICE, AIM, SQL, ETC..)
Module 1 Oracle Financials Misc. : RICE Videos
This section comprises of videos for Oracle Financials Misc. : RICE
Unit 1 R.I.C.E Introduction & Importance
Unit 2 (R) Reports
Unit 3 (I) Interfaces
Unit 4 (C) Conversions
Unit 5 How do we handle Conversions on a Project?
Unit 6 (E) Extensions
Module 2 Oracle Financials Misc. : AIM Videos
This section comprises of videos for Oracle Financials Misc. : AIM
Unit 1 What is Oracle AIM (Application Implementation Methodology)
Unit 2 AIM Software
Unit 3 Home Page Structure
Unit 4 Project Phases
Unit 5 Processes and Quality Assurance
Unit 6 Testing Phases, CRP to Production
Module 3 Oracle Financials Misc. : SQL Videos
This section comprises of videos for Oracle Financials Misc. : SQL
Unit 1 Introduction, Importance, Testing Commands & How it can help Functional Consultant
Unit 2 Steps for Installing SQL Developer (3.1)
Unit 3 Steps for Installing Oracle 10g client, SQL Plus, TOAD
Unit 4 SQL: Commands
Module 4 Oracle Financials Misc. : Oracle Support
This section comprises of videos for Oracle Financials Misc. : Oracle Support
Unit 1 Introduction & How Oracle Corporation helps EBS Customers
Unit 2 Other Useful Information
Module 5 Oracle Financials Misc. : Journal Entries
This section comprises of videos for Oracle Financials Misc. : Journal Entries
Unit 1 P2P Journal Entries
Module 6 Sub Ledger Accounting (SLA)
This section has all videos relating to Sub Ledger Accounting (SLA).
Unit 1 Sub Ledger Accounting (SLA)
Module 7 Other Important Topics
This section comprises of Videos covering some other important topics.
Unit 1 R12 Report Manager
Unit 2 R12 EBusiness Tax
Unit 3 Accounting Basics Class by Prasad
Module 8 Oracle Financials Misc. (RICE, AIM, SQL, ETC..) Downloadable Documents
This section has all downloadable documents relating to RICE, AIM, SQL, ETC...
Unit 1 Oracle Financials Misc. (RICE, AIM, SQL etc.) Downloadable Documents