Oracle E-Business Suite R12 Financials

Oracle Apps and Middleware

Oracle E-Business Suite R12 Financials

The Oracle eBusiness Suite EBS r12 (formerly called Oracle Financials) is the premier accounting and financial ERP, one of the most flexible and robust packages ever created.  The main areas of Oracle eBusiness Suite includes General Ledger (GL), Accounts Receivable (AR), Accounts Payable (AP), Fixed assets (FA) and Financial Intelligence (FI), Inventory Management,

Basic Concepts of R12

    Architectural Overview – System Administration
    UI Navigation changes in R12 Vs 11i
    Flex fields
    Access and Controls
    Functional overview of Products
    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

Payables:

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

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

Oracle Payments(IBY):

    Funds 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

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

DATA MODEL:

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

Multi Org Access Control(MOAC):

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

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

Cash Management:

    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

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

iModules:

    I Receivables
    I Supplier Portal

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

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

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

Financial Statement Generator:

    Prepare Income statement
    Balance Sheet

  • Course Package:0
  • Course Duration:40 hours
  • Buy
  • Apply Now
  • 138

Back to Top
Content