Oracle Financials is the most flexible accounting and financial ERP which provide organisations with solutions to a wide range of accounting system issues, regardless of the size of the business. This course helps the students to learn customising the Oracle eBusiness Suite to match specific business processes, the workflow within the AR, GL, AP and FA modules, ledger and invoice management and use DBI for financials summaries and reporting.

CERTIFYING BODY

  • ORACLE

CAREER PROSPECTS

This course suits everyone want to work with breakthrough ideas that forge their better future.

  • Oracle Financials Functional Analyst
  • Oracle Financials Support Consultant
  • Oracle Financials Functional Consultant

SYLLABUS

Basic Concepts of R12

  • Architechtural Overview – System Administrator
  • Flexfields
  • Access and Controls
  • Functional Overview of Products
  • Concepts of LE/OU/Chart of Accounts
  • Differences between R11 Vs 11i
  • Creation of Users and assignment of Responsibilities

Creation Of New Organisation

  • Design of Business Model
  • Creation of Business Group
  • Mapping of LE and OU with BG
  • Accounting Setup Manager
  • Defining 4 C’s = Currency/ Calendar/Convention/Chart of Accounts
  • Defining Buyer:Job, Role & Position
  • Defining Purchasing Options
  • Defining Payables Options
  • Creation of Master item in Inventory
  • OU Level Options

Paybles

  • Creation of Invoices(Types of Invoices)
  • Prepayment Application and Unapplication
  • Payment of Invoices- Full and Partial
  • Invoice Accounting
  • Payables Options
  • Financials Options
  • System Hold and Manual Holds

Paybles Intigration Areas

  • Procure to Pay (end to end flow)
  • Creation of PO
  • Receipt
  • Invoice Matching and Payment for the same
  • 2/3 way matching with PO
  • Auto Invoice from PO

Isupplier Portal Full Access

  • Creation of isupplier portal
  • Supplier PO Management
  • Advanced Shipment Notifications/ASBN
  • Shipment Notifications
  • Consumption Work Orders
  • Receipts from ASN and ASBN

Data Model Analysis

  • AP Backend data model
  • Tables impacted on updation

Multi Org Access Control(Moac)

  • 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
  • Deletion

E-business Tax

  • Regime to Rate Setup
  • Manual Over rides
  • Set up Tax rate for an item or OU
  • Tax Applicability in AR and AP

Cash Management

  • Creation of Banks/Branches/Accounts
  • Distinction between Internal bank accounts and external bank accounts
  • Controls in Cash Management
  • Reconcilation Manual and Auto Reconciliation

Cash Management (Advanced Topics)

  • Pooling and Intermediate Accounts
  • Back end SQL data model for internal and external bank accounts
  • Cash Clearing

Sales Order Management Integration with Financial Modules

  • Auto Import Orders
  • Creation of Invoices in AR usin import from OM
  • Payment of Sales Order using Crediit card

Inventory

  • Creation of Master Items
  • Templates in Inventory
  • Use of these items in PO and Sales Order

Consignment goods
Upgraded Transactions

  • Migration from R12 to Fusion
  • Period Close exception reports

Ecommerce Integration With ORACLE Application

  • Integration with third Party payment systems
  • EDI transmission of AP Payment documents
  • Configuring the payment system
  • Servlet and Transmission

Subledger Accounting Methods (SLAM)

  • Accounting Events Definition
  • Accounting Events in Payables
  • Accounting Events in Receivables

ORACLE Payments(IBY)

  • Funds Capture
  • Configuring the payment sytem account
  • Creation of Payees
  • Collection of money via bank accounts and credit card
  • Automatic Receipts
  • Funds Capture Process Manager
  • Backend SQL Data Model for AR to IBY Integrations
  • Funds Disbursement
  • Creation of Payment Process Profile
  • Mapping PPP and Payment Documents with Internal bank Accounts
  • Payment Process Request Templated and Submission
  • Payment Statuses
  • Electronic and Printed Payments
  • Payments- Actions
  • Terminate
  • Void and Stop Payments
  • Void by overflow
  • SEPA = Single Euro Payments Area Payments
  • Bank Charge Bearer Calculation
  • Backend SQL Data Model for AP to IBY Integrations
  • Evaluated Receipt Settlement (ERS)

AP Reports
AR Reports
IBY Reports

  • Separate Remittance Advice
  • Positive Pay File
  • Payment Instruction register
  • E commerce(EDI) gateway Integration
  • Distinction between Inter company and Intra company
  • Inter company transactions
  • FND logs and Trace guidelines from backend

Real Time Case Studies

  • MOAC- Multi Org
  • Diff between R12 and 11i
  • Diff between R12 and Fusion

Implemantaion Checklist

  • Pain Points in implementation
  • Setup Profile Options

Computer Training institute for Oracle, Best Computer training institutes for Oracle in ameerpet, Training institutes for Oracle in ameerpet, Training for Oracle, Best training institutes in ameerpet for Oracle.