Wednesday, 6 April 2016

Oracle Application ERP training-Apps finance functional online training

SPECTO ITS provides a broad range of training services on Oracle Application ERP training-Apps finance functional online training and a best practices approach. From last-minute fill-ins to long-term strategic staffing plans; from a single high-level executive placement to a project team of specialists, we've developed effective strategies for finding and screening the most qualified staff based on our clients' needs.

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)
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
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