Courses
SAP
- SAP ABAP
- SAP BASIS
- SAP SECURITY
- SAP NETWEAVER
- SAP XI
- SAP FICO
- SAP FSCM
- SAP MM
- SAP WM
- SAP PP
- SAP SRM
- SAP BW
- SAP BI
- SAP BPC
- SAP MDM
- SAP SD
- SAP CRM
- SAP BO
- SAP HR
- SAP HR-ABAP
- SAP GRC
- SAP HCM
- SAP APO
- SAP EP ADMIN
- SAP IS UTILITIES
- SAP PLM
- SAP SCM
- SAP PC
- SAP QM
- SAP IS RETAIL
- SAP EP JAVA WEBDYNPRO
- SAP HANA
- SAP PS
- SAP PI
- SAP IS OIL & GAS
- SAP CS
Oracle
- ORACLE 10 g
- ORACLE APPS DBA
- ORACLE APPS FINANCIALS
- ORACLE APPS TECHNICAL
- ORACLE BPEL
- ORACLE OAF
- ORACLE APPS FINANCE FUNCTIONAL R12
- OBIEE
- ORACLE 11G
- ORACLE DBA
- PL-SQL
- ORACLE HRMS
- ORACLE ADF
Other Technologies
- MS.NET
- SHARE POINT
- JAVA
- SAS
- SAS BI
- SAS OC
- QA TESTING
- SQL SERVER
- TIBCO
- SIEBEL CRM
- SIEBEL ANALYTICS
- UNIX SHELL
- BIZTALK SERVER
- CCNA
- SAS FINANCIAL MANAGEMENT
- AJAX
- LINUX
- SALES FORCE
- CCNP
- MCSE
- VMWARE
- PEOPLESOFT HRMS TECHNICAL
- CRYSTAL-REPORTS
- PMP
- TERA DATA
- WEBSPHERE
- ANDROID
- HADOOP
Data Warehousing
- INFORMATICA
- COGNOS
- DATA STAGE
- BUSINESS OBJECTS
- BUSINESS ANALYST
- COGNOS TM1
- AB INITIO
- MICROSTRATEGY
- COGNOS PLANNING AND BUDGETING
- HYPERION ESSBASE
- HYPERION DATA RELATIONSHIP MANAGEMENT
- HYPERION FINANCIAL MANAGEMENT
- HYPERION INTERACTIVE REPORT
- HYPERION FINANCIAL DATA QUALITY MANAGEMENT
- HYPERION PLANNING
- HYPERION FINANCIAL REPORT
Oracle Apps Finance Functional R12
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