11i Financial Certification

Oracle E-Business Suite 11i Financials Certified Professional Consultant
[Oracle E-Business Fundamentals1Z0-200 +
Oracle General Ledger 11i Fundamentals1Z0-211 +
Oracle Receivables 11i Fundamentals1Z0-213] = Oracle 11i Financials Certified Professional Consultant, Receivables (OCP)

For Payables: Oracle Payables 11i Fundamentals1Z0-212

Exam: 1Z0-200
Exam Price: $95.00 USD
Duration:90 minutes
Number of Questions:64
Passing Score:55%

Exam Topics
Overview of 11i E-Business Suite
Describe the footprint of 11i E-Business Suite
Identify the benefits of 11i E-Business Suite
Explain the business architecture of 11i 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 11i E-Business Suite is based on

Shared Entities and Integration
Describe shared entities
Describe the individual shared entities owned by various 11i modules
Explain key business flows in 11i 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-Org

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 coponents 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 11i 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

11i Daily Business Intelligence (DBI)

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



Exam:1Z0-211

Exam Price: $195 USD
Duration: 90 minutes
Number of Questions: 76
Passing Score: 63%


Exam Topics
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 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)
Describe XBRL Reporting language
Identify the key implementation issues regarding Oracle General Ledger financial reporting


Exam: 1Z0-213

Exam Price: $195 USD
Duration: 90 minutes
Number of Questions: 76
Passing Score: 55%


Exam Topics
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



Exam: 1Z0-212

Exam Price: $195 USD
Duration: 90 minutes
Number of Questions: 62
Passing Score: 61%


Exam Topics
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