Oracle Finance Course

by Vibrant Technologies & Computers

Module

Title

Contents

Module 1:

Basic Concepts of R12

Architectural Overview - System Administration UI Navigation changes in R12 Vs 11i
Flex fields
Creation of requisition
Access and Controls
Concepts of LE/OU/Chart of Accounts
Differences between R11 Vs 11i-sneek peek review
Creation of Users and assignment of Responsibilities Profile Options and security controls

Module 2:

Payables

Invoice Vs Inv Batch Creation of Invoices (All types of Invoices)
Prepayment Application and Unapplication
Payment of Invoices- Full and Partial
Invoice Accounting
Financials Options
System Hold and Manual Holds
Distribution Set Vs Distribution Accounts
Retainage Release Calculation
WH Taxes
Recurring Invoices
Supplier Setup
Multi Currency payments

Module 3:

Payables Intergration Areas

Procure to Pay (end to end flow)
Creation of PO
Receipt
Inspection
Invoice Matching and Payment for the same
2/3/4 way matching with PO
Auto Invoice from PO
Automatic Offset
Creation of isupplier portal
Supplier PO Management
Data Model Analysis
AP Backend data model
Tables impacted on updation
Retainage Release
Fixed Assets Integration

Module 4:

Oracle Payments(IBY)

IFunds Disbursement
Changes in R12 Vs 11i
Role of New Payment Set up Administrator
Creation of Payment Process Profile
Creation of Payment methods
Mapping PPP and Payment Documents with Internal bank Accounts
Payment Process Request Templated and Submission
Manual Vs Automatic completion
Overview of Federal formats
Scheduling Requests in Real time
Assignment of Bank Accounts and PPP
Paying different supplier and OU's in single pay run
Review proposed payments
Add & Remove invoices during payments Electronic and Printed Payments
Multi Currency Payments
Validations during payment
Resolve document & payment validation errors
Payment Limits
MOAC Payments
Decentralised AP and Payments
Centralized AP and Payments
Terminate
Void and Stop Payments
Void by overflow
Skipped documents

Module 5:

Funds Capture

Process flow for funds capture
Auths Vs Settlements
Credit Card Creation
Brand activation Vs Inactivation's
Assignment of credit card and Bank accounts to customer
Encryption Vs Masking
Creation of Funds Capture Process Profile
Creation of Payee
Mapping FCPP, PSA and Payees with OU
Transaction testing auths & settlements
Auth Capture
Credit Card refund
Invoking FC from AR/OM and collections

Module 6:

Data Model

Data Model Analysis for Funds Disbursement
Data Model Analysis for Funds Capture

Module 7:

Multi Org Access Control (MOAC)

Changes in 11i Vs R12
Security Profile Options
Security list maintenance
Assigning security to users and responsibilities

Module 8:

Fixed Assets

Asset Books vs Finance Book
Asset Creation
Calculation of Depreciation
Paying a capital asset PO via AP
Mass Addition
Retirement
Transfer of Asset
Group Vs Member Assets

Module 9:

Cash Managements

Changes in R12 Vs 11i
Creation of Banks/Branches/Accounts
Distinction between Internal bank accounts and external bank accounts
Controls in Cash Management
Reconciliation Manual and Auto Reconciliation
UMX Security Controls
Back end SQL data model for internal and external bank accounts
Cash Clearing
Bank Account Transfers
Cash Positioning and Forecasting

Module 10:

Accounts Receivable

Creation of Transaction
Receivable Options
Receipt Manual Vs Automatic
Receipt Application Vs Unapplication
Remittances
Refund Manual Vs Credit Card
Charge Back
Customer setups
Auto Cash Rule set
Balance Forward Billing
Type of Transactions and set off with Credit Memo
Accounts Overview

Module 11:

iModules

iReceivables iSupplier Portal

Module 12:

Sale Order Management integration with Financial Modules (AR)

Auto Import Orders
Creation of Invoices in AR using import from OM
Payment of Sales Order using Credit card

Module 13:

Sublegder Accounting Methods (SLAM)

Architectural Overview
Even Model in R12 Vs 11i
Accounting Events Definition
Accounting Events in Payables
Accounting Events in Receivables
Modifying seeded AAD, JLT and JLD

Module 14:

Oracle General Ledger

Creation of Ledger
Accounting Setup Manager
Open and Close periods
Mapping of 4 C's =Currency, Calendar, COA and Convention
Primary and Secondary Ledger
Reporting Currency Ledger
Transfer/Post Accounting entries to GL
Creation of recurring journals
Data Conversion Levels
COA Mapping
Ledger Vs Ledger Sets
Consolidations
Data Access Set Vs Definition Access Set
Budgets
Consolidations

Module 15:

Financial Statement Generator

Prepare Income statement
Balance Sheets