Oracle Apps Functional Training

Oracle Applications is an ERP Software and the financial applications that are integrated and which use modularization approach. Oracle apps functional consultant would be working towards operations, business suite and has capabilities to understand business flows, design and run queries. The course is customized and evolve learning methodologies which help catalyse the conditions the way trainee can drive successful career. Oracle apps functional online training teach oracle framework and workflow across different financial modules in oracle e-business suite.

Oracle Apps Functional Training Overview

Our functional training help trainees to enhance responsibilities like requirement gathering, functional gap analysis, module setup, writing training guides and production support as per industry requirements. The sessions are interactive with regular assignments that accelerate the learning approach and focused on exploring the path of skills of every student by certified 13+ year experienced oracle apps consultant.

Oracle Apps Functional Training Curriculum

R12 Summary Course Content

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

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

Topics- 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 Integration Areas

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

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

Topics– Decentralised AP and Payments, Centralized AP and Payments, Terminate, Void and Stop Payments, Void by overflow, Skipped documents.

Funds Capture

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

Topics- Data Model Analysis for Funds Disbursement, Data Model Analysis for Funds Capture.

Multi Org Access Control (MOAC):

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

Fixed Assets

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

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

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

Topics- I Receivables, I Supplier Portal.

Sale Order Management integration with Financial Modules (AR)

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

Sublegder Accounting Methods (SLAM)

Topics- 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:

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

Topics- Prepare Income statement, Balance Sheet