Oracle Financial Application | Welcome to breEDU

Email: admin@breedu.com Call Us: 510.259.9696

Oracle Financial Application

Course Description:

This course aims to teach students the concepts of finance, accounting, and how to use the Oracle Finance Application system.

Learning OFA will help you:

  • Work Smarter: Increase efficiency and reduce back-office costs with standardized processes for shared services, productivity tools, and integrated performance management
  • Work Globally: Manage your global finance organization from a single, integrated system and comply with multiple legislations, accounting standards, and policies
  • Work Securely: Facilitate financial control and corporate governance with a holistic approach to compliance and risk management

How is the Job Market?

  • Java is the world’s #1 programming language
  • 40 of the top 40 high technology companies run Oracle
  • 30 of the top 30 Electronic OEMs run Oracle applications and technology
  • 8 of the top 10 Semiconductor companies run Oracle applications
  • 14 of the top 25 High Technology Distributors run Oracle applications
  • 10 of the top 10 Fabless Semiconductor companies run Oracle applications
  • 8 of the top 10 Electronic Manufacturing Services (EMS) companies run Oracle applications
  • 9 of the top 10 Software companies run Oracle applications
Who Should Attend:
  • Accounting and Financial Professional
  • General Ledger / Consolidation Accountants
  • AR / AP specialist
  • Controller (Superuser)
  • FP&A
  • IT Professional
  • BSA (Business System Analyst)
  • Oracle Developer / DBA who wants to learn financial terminology and processes
Instructor:

MBA/CPA, over 15 years Oracle ERP experience in Finance / Accounting, Manufacturing and Supply Chain Planning in both business aspect and implementation aspect. She has implemented full-suite financial modules, Oracle Shop Floor management, Oracle discrete manufacturing, and Oracle Supply Chain Management for multi-billion dollar worldwide (multi-currency) companies.

Hours:

80 hours (please call for more details)

Course Content

1. E-Business Suite Essentials for Implementers
Overview of E-Business Suite

  • Describe the footprint of R12 E-Business SuiteIdentify the benefits of R12 E-Business Suite
  • Explain the business architecture of R12 E-Business Suite and the design principles on which it is based
  • Describe the technical architecture, including the components involved in communications between the desktop tier, the application tier and the database tier
  • Explain the importance of the network that R12 E-Business Suite is based on

Shared Entities and Integration

  • Describe shared entities
  • Describe the individual shared entities owned by various R12 modules
  • Explain key business flows in R12 E-Business Suite (e.g.: Order to Cash, Procure to Pay) and the modules involved
  • Describe the integration points between modules related to the business flow

Fundamentals of Multi-OrgFundamentals of Flexfields

  • Describe Multi-Org and identify the modules that have Multi-Org capabilities
  • Identify the business needs which can be addressed with multi-org enhancement
  • Describe the components of a multi-org organizational model
  • Describe balanced entities and explain when they should be used.
  • Explain data security in multi-org
  • Describe the different levels of cross-organizational reporting
  • Identify the benefits of cross-functional reporting
  • Enable Multi-org and add to the organization structure

Fundamentals of Flexfields

  • Describe Flexfields
  • Explain the benefits of flexfields
  • Classify types of flexfields
  • Compare features of key and descriptive flexfields
  • Explain components of key and descriptive flexfields
  • Describe the validation of input using value sets
  • Describe the types of value set
  • Define and enter values in a value set
  • Plan and define key flexfields
  • Plan and define descriptive flexfields

Fundamentals of System Administration

  • Describe the R12 E-Business Suite security model
  • Define new application users
  • Describe a responsibility and its components
  • Define a new responsibility using menu exclusions
  • Discuss securing and exclusion attributes
  • Define a menu structure
  • Describe profile hierarchy types
  • Set profile options

Fundamentals of Workflow & Alerts

  • Discuss the advantages of a workflow-driven business process
  • Explain the components that make up workflow architecture
  • Explain the Business event system functions
  • Explain the Business event system architecture
  • Monitor a workflow-based business process
  • Describe key implementation considerations for workflow
  • Describe the classify alerts
  • Explain the difference between Alerts and Workflows

2.Oracle General Ledger Fundamentals
Oracle General Ledger Process

  • Identify the steps required to complete the accounting cycle using Oracle General Ledger
  • Describe how Oracle General Ledger integrates with other Oracle eBusiness applications
  • Describe the implementation considerations for setting up and using Oracle General Ledger and the Oracle eBusiness Suite
  • Describe the Functions and Features of Oracle General Ledger

Set of Books

  • Describe the elements required to create a set of books within Oracle General Ledger
  • Explain the steps for Creating a Set of Books
  • Identify key implementation issues involved when creating a set of books in Oracle General Ledger
  • Identify the attributes, options and settings required to define the Accounting Flexfield
  • Define an accounting calendar and enable predefined currencies
  • Create a set of books in Oracle General Ledger
  • Utilize the Account Hierarchy Editor feature of Applications Desktop Integrator to view and maintain Accounting Flexfield values

Basic Journal Entries

  • Describe how journal entries are positioned in the accounting cycle
  • Identify the types of journal entries
  • Create manual journal entries
  • Post journal entries using various posting options
  • Perform account inquiries
  • Perform drilldowns to Oracle subledger applications
  • Create reversing entries
  • Use ADI to create journal entries
  • Import journal entry information using the GL_INTERFACE
  • Describe the setup options available to process journal entries
  • Identify reports, listings and inquiry options available for journal entries
  • Identify the profile options necessary to process journal entries
  • Identify the key implementation issues regarding journal entries and General Ledger
  • Identify the key elements of Applications Desktop Integrator (ADI)
  • Setup ADI security
  • Setup database connections
  • Setup the ADI toolbar, general ledger and language options
  • Identify ADI profile options
  • Perform ADI diagnostic system checks

Summary Accounts

  • Describe summary accounts and how they are used in General Ledger
  • Describe the difference between Summary accounts and Parent values
  • Define rollup groups for summary account creation and assign parent values to rollup groups
  • Determine the number of summary accounts created by a template using a specific formula
  • Enter summary account templates to create summary accounts
  • Maintain summary accounts
  • Describe key implementation considerations in planning summary accounts

Advanced Journal Entries

  • Describe, create and generate the three types of recurring Journals
  • Enumerate the steps to define Mass allocations and define mass allocation journals
  • Describe the features of AutoAllocations
  • Describe AutoScheduling and Journal Scheduling
  • Describe the features and process of Journal Approval
  • Identify the key issues and considerations when implementing the Auto Allocation workbench and Journal Entry Automation

Intercompany

  • Describe the solutions to account for intercompany transactions
  • Describe the set up steps for Intercompany Accounting
  • Enter Intercompany Transactions

Global Intercompany System

  • Describe GIS (Global Intercompany System)
  • Set up GIS Subsidiaries
  • Create GIS Transaction Types
  • Define GIS Clearing Accounts
  • Define Autoaccounting Rules Enter and report on GIS Transactions

Financial Budgeting

  • Explain the anatomy of a budget
  • Enumerate the budget accounting cycle
  • Define a budget and budget organization
  • Enumerate the budget entry methods
  • Apply budget rules and enter budget journals
  • Perform transfer of budgets
  • Freeze and unfreeze budgets and Review and correct budgets
  • Translate budget balances
  • Perform budget inquiry
  • Review balances in Master/Detail budgets
  • Create a budget worksheet in Budget Wizard
  • Upload budgets from Budget Wizard and external sources
  • Describe budget reporting methods
  • List standard budget reports
  • Plan budget implementation requirements

Multi-Currency

  • Describe the foreign currency concepts
  • Explain Multiple Currency Accounting
  • List the steps that need to be completed before entering foreign currency transactions
  • Enter foreign currency journals and explain conversion
  • Revalue foreign currency balances
  • Explain MRC Revaluation against Primary Currency Description
  • Describe Currency rates manager
  • Translate functional balances into foreign currency
  • Set up and describe Secondary tracking segment
  • Describe Foreign currency Listings and reports and MRC profile options

Consolidations

  • Explain Consolidations and Consolidation tools
  • Identify the key implementation issues regarding consolidations
  • Identify the features and functionality of Global Consolidation System (GCS)
  • Describe Interface data Transformer with examples
  • Describe the elements of the Consolidation Workbench
  • Define consolidation mapping
  • List the steps to be done before transferring balances from subsidiary set of booksCreate eliminating entries
  • Identify reports and inquiry options available for consolidations

Period Close

  • Explain the accounting cycle
  • Identify steps in the close process
  • Perform journal import of subledger balances
  • Reconcile to the subledger: P2P Period Close and reports
  • Reconcile to the subledger: O2C Period Close and reports
  • Reconcile to the subledger: Projects Period Close
  • Run revaluation
  • Close the period
  • Consolidate account balances
  • Inquire and run reports on final balances

Financial Reporting

  • Explain Online Enquiry and Standard Reports and Listings
  • Identify the basic report building concepts
  • Explain the elements of the Financial Statement Generator (FSG necessary to create financial reports
  • Create basic FSG report definitions
  • Identify listing reports available for FSG report definitions
  • Identify profile option settings required to implement financial reporting
  • Utilize the Report Wizard of ADI to create FSG report definitions
  • Utilize the ADI Request Center to submit and publish financial reports
  • Utilize the ADI Analysis Wizard to view account balance and detail information
  • Explain other reporting tools (Discoverer, OFA, E-Business Intelligence, Rxi reports)
  • Describe XBRL Reporting language
  • Identify the key implementation issues regarding Oracle General Ledger financial reporting

3.Oracle Payables Fundamentals
Procure to Pay Lifecycle Overview

  • Describe the key areas in the procure to pay process
  • Describe how the procure to pay process fits into the Oracle eBusiness suite of applications

Payables Overview

  • Describe the key areas in the Payables process
  • Identify Payables integration points
  • Explain Payables open interfaces

Suppliers

  • Set up and Define suppliers
  • Set up and Define supplier sites
  • Adjust supplier details
  • Describe key reports
  • Explain and setup Financials Options
  • Explain and setup Payable Options
  • Setup Lookup codes and Profile options
  • Explain additional implementation considerations

Invoices

  • Import/Enter invoices
  • Create Invoice Batches and enter Invoice Header and Distributions and enter Recurring Invoices
  • Apply prepayments and advances
  • Match to purchase orders
  • Apply and release holds
  • Explain invoice approval workflow
  • Validate invoices for payment
  • Describe the types of accounting flows
  • Explain key reports
  • Identify and set up Profile Options, and Financials, Purchasing and Payables options specific to Invoices
  • Explain additional implementation considerations

Quick Invoices

  • Describe and use Quick Invoices
  • Enter invoice records
  • Enter purchase order matched invoice records
  • Enter price corrections
  • Find and modify invoice records
  • Add invoice records to an existing Quick Invoices Batch
  • Create invoices from quick invoice records

Payments

  • Describe the process of issuing payments
  • Describe the Payment workbench, and identify the Payment methods and disbursement types
  • Set up bank accounts
  • Create and Process Manual and Quick Payments and process refunds
  • Process payment batches
  • Process stop and void payments
  • Identify key reports
  • Identify and set up Financials and Payables options specific to Payments
  • Explain additional implementation considerations
  • Explain Internal Controls for Payment processing and Integration Partners for check printing

Expense Reports and Credit Cards

  • Describe the expense report process
  • Enter expense report templates
  • Enter expense reports and apply holds
  • Apply advances, modify, review and Pay expense reports
  • Run Expense Report Import program and purge Expense Reports
  • Identify key expense related reports
  • Describe Procurement Cards Process flow
  • Set up credit card programs

Period Close

  • Describe the period closing process in Payables and Purchasing
  • Identify the activities in the period close process
  • Reconcile accounts payable transactions for the period and close the PO period
  • Identify Key accounts and accrual accounting for Period end
  • Identify key reports
  • Setup Financials, Purchasing and Payables options relevant to Period close
  • Explain additional implementation considerations

Appendix 1 Invoice Tax

  • Set up supplier tax information
  • Describe supplier and supplier sites regions relevant to Taxes
  • Identify tax validations
  • Enter tax types tax codes, and tax groups including Offset, VAT and use taxes
  • Submit invoice validations
  • Use tax control methods
  • Identify tax code defaults and describe deriving tax from a natural account
  • Identify 1099 reportable suppliers and related reports
  • Identify key standard reports

Appendix 2 Withholding Tax

  • Define Withholding tax
  • Setup withholding tax options and define withholding tax codes and groups
  • Process manual withholding tax invoices and create withholding tax invoices
  • Process automatic withholding tax invoices
  • Identify standard key reports

4.Oracle Receivables Fundamentals
Order to Cash Lifecycle

  • Describe the key areas in the Order to Cash Life Cycle
  • Describe the integration between the applications

Order Receivables Process

  • Describe the Receivables Process and its key areas

Manage Parties and Customer Accounts

  • Create profile classes and assign them to customer accounts
  •  Create and maintain party and customer account information
  •  Define TCA party paying relationships
  •  Merge parties and/or customer accounts
  •  View party and customer account information
  •  Define setup options

Process Invoices Using AutoInvoice

  • Describe the AutoInvoice process
  •  Implement AutoInvoice
  •  Correct errors by using AutoInvoice Exception Handling
  •  Match to purchase orders

Process Invoices

  • Indicate where the processing of Invoices fits into the receivables process
  •  Enter and complete invoices
  •  Create Invoice Batches and View Currency details
  •  Enter and complete invoices
  •  Create Invoices with rules and run Revenue Recognition Program
  •  Correct Invoices: debit memo, credit memo, make adjustments and on-account credits, create refunds, void transactions
  •  Define Transaction types
  • Print Transactions and Consolidated Billing
  • Use event-based revenue management
  •  Identify XML receivables documents
  •  Describe promised commitment accounts

Bill Presentment Architecture

  • Explain bill presentment architecture processes
  •  Register data sources
  •  Create templates to present bills
  •  Define rules to assign templates to customers
  •  Print BPA invoices

Credit Management

  • Setup for credit management
  •  Define Customer Profile Class
  •  Process Credit Reviews
  •  Use workflow and lookups
  •  Review credit management performance
  •  Define and identify Credit hierarchy

Implement Customer Invoicing

  • Enter set up information relating to invoicing
  •  Set up optional set ups for transactions
  •  Describe the major implementation considerations in customer invoicing

Receipts

  •  Describe the Receipt Process
  •  Create receipts and receipt batches
  •  Apply receipts using different methods
  •  Create Chargebacks, Adjustments and Claims
  •  Use balance segments
  •  Create and use Autolockbox

Implement Receipts

  • Enter setup information relating to receipts
  •  Enter setup information relating to cross currency receipts and set up System and Profile Options
  •  Describe Receipts implementation considerations
  •  Set up Lockbox Integration and Function Security

Tax Accounting Process 

  • Explain the Tax Accounting Process
  • Define General Tax Setup Steps
  • Enter Tax Adjustments
  • Explain Tax Reporting Ledger

Period Closing Process

  • Define the various actions required to close a period in the Order to Cash eBusiness flow
  • Reconcile transactions and Describe the available reports to assist in the closing process
  • Run in the Revenue Recognition program and the General Ledger interface program

Bank Reconciliation

  • Explain reconciliation and the key concepts of reconciliation integration
  • Set up for bank reconciliation
  • Describe the Bank Statement Open Interface
  • Enter bank statements manually
  • Archive and purge bank statements
  • Reconcile transactions automatically
  • Clear and unclear transactions manually
  • Record exceptions
  • Explain Value Date
  • Describe bank reconciliation reports


© Copyright 2014 breEDU.com. All rights reserved.

Bay Area Web Design by Verecom.com