Oracle Apps Finance Functional R12 Course

ORACLE

ORACLE – APPS FINANCE FUNCTIONAL R12 COURSE CONTENT

1. R12 Summary Course Content
   •  Payables (AP)
   •  Receivables (AR)
   •  General Ledger (GL)
   •  Fixed Assets (FA)
   •  Cash Management (CE)
   •  Multi Org Access Control (MOAC)
   •  Sub Ledger Accounting (SLA)
2. R12 Detailed Course Content: 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
3. 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
4. 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
5. 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
6. 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
7. DATA MODEL:
   •  Data Model Analysis for Funds Disbursement
   •  Data Model Analysis for Funds Capture
8. Multi Org Access Control(MOAC):
   •  Changes in 11i Vs R12
   •  Security Profile Options
   •  Security list maintenance
   •  Assigning security to users and responsibilities
9. 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
10. 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
11. 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
12. iModules:
    •  I Receivables
    •  I Supplier Portal
13. 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
14. 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
15. 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
16. Financial Statement Generator:
    •  Prepare Income statement
    •  Balance Sheet