Oracle E-Business Suite 11i Financials Certified Professional Consultant (E-Business OCP Certification) Getting certified in some professional areas is no longer a question of choice, but a necessity! Oracle Financials is one such area. Oracle Financials play a big role in the information infrastructures of many companies, and a solid understanding of that environment can pay very large dividends Employers expect you to have a certification before they employ you. Or if your company is one of the many using Oracle Financials or is planning to implement them, then this certification is for you. This course offered in London, is taught in 12 classes. It is instructor led with emphasis on providing hands-on training to you. This training course will help you prepare for four exams that constitute the Oracle Certified Professional Financial Applications. Financials 11i 3 Exams Required: • Oracle E-Business Fundamentals Exam: 1Z0-200 • Oracle General Ledger 11i Fundamentals 1Z0-211 • Oracle Payables 11i Fundamentals 1Z0-212             Or • Oracle Receivables 11i Fundamentals 1Z0-213 Oracle Financial 11i OCP Certification £1490 Oracle Financial 11i + Oracle Database OCP Certification £2000 Oracle Financial 11i + Sage Line 50 £1600		End 2 End Process Enrolment Phone or In Person Course Fee £1490 Books or Course Material Included         Hands-on instructor led Training for 12 Classes         Unlimited Practice Hours         Oracle Financial Consultant

Course Content

Oracle E-Business Fundamentals Exam: 1Z0-200

E-Business Suite
Benefits of 11i E-Business Suite
Business architecture of 11i 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 11i modules
Key business flows in 11i 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
11i 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

11i 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 11i Fundamentals 1Z0-211

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 11i Fundamentals 1Z0-212

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 11i Fundamentals 1Z0-213

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