Training Square
Call: 0207 256 2268

Oracle Financials Release 12

You are here: Home >> Oracle Financials Release 12 >>

Oracle Financials Release 12

Certification

  • Oracle Financials Release 12

 

Course Length

  • 6 Weeks

Locations

  • Liverpool Street
  • London Bridge
  • Moorgate

Delivery

  • Instructor led hands-on

Includes

  • Books, CDs, Manual, Notes & Unlimited Lab Access & VAT
Reserve Your Place
or
Book Online
Time Table of Oracle Financials Release 12

or

  ENQUIRE

Oracle E-Business Fundamentals

E-Business Suite

  • Benefits of E-Business Suite
  • Business architecture of E-Business Suite and the design principles on which it is based
  • Technical architecture, including the components involved in communications between the desktop tier, Application tier and the database tier

Shared Entities and Integration

  • Shared entities
  • Individual shared entities owned by various modules
  • Key business flows in E-Business Suite (e.g.: Order to Cash, Procure to Pay) and the modules involved
  • Integration points between modules related to the business flow

Fundamentals of Multi-Org

  • Multi-Org and identify the modules that have Multi-Org capabilities
  • Identify the business needs which can be addressed with multi-org enhancement
  • components of a multi-org organizational model
  • balanced entities and explain when they should be used.
  • Explain data security in multi-org
  • 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

  • Flexfields
  • Explain the benefits of flexfields
  • Classify types of flexfields
  • Compare features of key and descriptive flexfields
  • Explain coponents of key and descriptive flexfields
  • validation of input using value sets
  • 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

  • E-Business Suite security model
  • Define new application users
  • a responsibility and its components
  • Define a new responsibility using menu exclusions
  • Discuss securing and exclusion attributes
  • Define a menu structure
  • 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
  • key implementation considerations for workflow
  • classify alerts
  • Explain the difference between Alerts and Workflows

Daily Business Intelligence (DBI)

  • features of Daily Business Intelligence
  • Explain the relationship of Daily Business Intelligence to the E-Business Suite
  • components of a DBI report

 

Oracle General Ledger

Oracle General Ledger Process

  • Oracle General Ledger Overview
  • General Ledger integrates with other Oracle eBusiness applications
  • Implementation considerations for setting up and using Oracle General Ledger and the Oracle eBusiness Suite
  • Functions and Features of Oracle General Ledger

Set of Books

  • Elements required to create a set of books within Oracle General Ledger
  • Creating a Set of Books
  • 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

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

  • summary accounts and how they are used in General Ledger
  • 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
  • key implementation considerations in planning summary accounts

Advanced Journal Entries

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

Intercompany

  • Solutions to account for intercompany transactions
  • Set up steps for Intercompany Accounting
  • Enter Intercompany Transactions

Global Intercompany System

  • 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
  • budget reporting methods
  • List standard budget reports
  • Plan budget implementation requirements

Multi-Currency

  • 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
  • Currency rates manager
  • Translate functional balances into foreign currency
  • Set up and Secondary tracking segment
  • 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)
  • Interface data Transformer with examples
  • elements of the Consolidation Workbench
  • Define consolidation mapping
  • List the steps to be done before transferring balances from subsidiary set of books
  • Create 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)
  • XBRL Reporting language
  • Identify the key implementation issues regarding Oracle General Ledger financial reporting

Oracle Payables

Procure to Pay Lifecycle Overview

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

Payables Overview

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

  • 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

  • process of issuing payments
  • 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

  • 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
  • Procurement Cards Process flow
  • Set up credit card programs

 

Period Close

  • 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

Invoice Tax

  • Set up supplier tax information
  • 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 deriving tax from a natural account
  • Identify 1099 reportable suppliers and related reports
  • Identify key standard reports

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

Oracle Receivables

Order to Cash Lifecycle

  • key areas in the Order to Cash Life Cycle
  • integration between the applications
  • Order Receivables Process
  • 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

  • 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
  • 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
  • major implementation considerations in customer invoicing

Receipts

  • 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
  • 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 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
  • 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
  • bank reconciliation reports

Price Includes: £2500

  • Hands-on tutor led training
  • Unlimited practice lab access
  • Books, cds and Manuals
  • VAT
  • Refreshments
  • Completion Certificate

Course Description

Oracle Financial provides the miracle solutions when it comes to accouting and managment. Over the decades Oracle Financia has become a heart of business and Oracle has been leader in the industry.

Time table

      Call us on 0207 256 2268...
Training Square London

Career Package

  • Red Hat Admin Networking
  • £1800
  • MCSA Microsoft Windows Server 2012
  • £1750
  • Oracle OCA and OCP Certification
  • £2500
    • Total £6950
    • Offer £6500
    • Save £450
BOOK ONLINE

Specialised Package

  • Red Hat Admin Networking
  • £1800
  • Oracle OCA and OCP Certification
  • £2500
    • Total £5300
    • Offer £5000
    • Save £300
BOOK ONLINE

Professional Package

  • MCSA Microsoft Windows Server 2012
  • £1750
  • Oracle OCA and OCP Certification
  • £2500
    • Total £5150
    • Offer £5000
    • Save £150
BOOK ONLINE

GRAB THE DEAL

Call: 0207 256 2268


 
 
 
 
 

Trained Delegates from:

Training Square Client, delegates logo

Request Brochure

Call: 0207 256 2268
 
 
 
 
  Course Title: Oracle Financials Release 12
 
Autodesk Authorized training centre
Oracle
SymReg Partner
Cisco Certified