Boston Computer School

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 Sheeta