Oracle E-Business Suite R12: General Ledger and Payables Fundamentals

Exam Number:	1Z0-215
Associated Certifications:	Oracle E-Business Suite R12 Financials Certified Expert Consultant, Payables Oracle E-Business Suite R12 Financial Management Implementation Specialist – General Ledger Oracle E-Business Suite R12 Financial Management Implementation Specialist – Payables OPN Certified Specialist
Exam Price:	$195 US
Exam Registration:	Register Registration now open.

Duration:

150 minutes

Number of Questions:

110

Passing Score:

General Ledger: 62%
Payables: 62%

Candidates will receive a beta exam score report approximately 10 weeks after the close of the Beta Exam.
Passing score subject to change. View Details

Passing score subject to change. View Details

Recommended Training and Preparation

R12 Oracle General Ledger Management Fundamentals
AND
R12 Oracle Payables Management Fundamentals

Training Opportunities for Oracle Partner Network Members

Additional Information & Resources

Exam Topics

Click the category would you like to see
General Ledger - Payables 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 integration of Oracle General Ledger with Oracle Subledgers & non-Oracle systems
[ ]	Explain implementation considerations for setting up and using Oracle General Ledger and Oracle eBusiness Suite
[ ]	Describe an overview of Accounting Setup Manager, currency concepts, budgeting, EPB, reporting & analysis

Basic Journal Entries
[ ]	Describe how journal entries are positioned in the accounting cycle
[ ]	Describe the different Journal Posting options
[ ]	Define how to perform Account Inquiries & Drilldown to Oracle Subledger Applications
[ ]	Import journal entry information using the GL_INTERFACE table
[ ]	Plan the key elements of Web Applications Desktop Integrator (Web ADI)
[ ]	Define Web ADI setup options for key flexfields
[ ]	Utilize Web ADI profile options, forms functions, menus, and responsibilities

Advanced Security
[ ]	Manage Data Access Security for Legal Entities and Ledgers
[ ]	Explain key Advanced Security setups and process
[ ]	Manage Data Access Sets
[ ]	Control security of Management Reporting

Multi-Currency
[ ]	Explain Multi-Currency concepts
[ ]	Use Currency Rate Manager
[ ]	Perform Foreign currency journals Entry
[ ]	Perform Revaluation of foreign currency balances
[ ]	Translate functional balances into foreign currency
[ ]	Describe overview of Secondary Tracking Segment
[ ]	Use Foreign Currency Reports

Financial Reporting
[ ]	Explain the positioning of Financial Reporting within the Oracle General Ledger business flow
[ ]	Build basic reports
[ ]	Use key elements of the Financial Statement Generator (FSG) for creating financial reports
[ ]	Use Standard listing reports available for FSG report definitions
[ ]	Create FSG Reports with XML Publisher
[ ]	Use Web ADI for Financial Reporting
[ ]	Explain key implementation issues regarding Oracle General Ledger financial reporting

Accounting Setup Manager
[ ]	Describe the components of Ledger Processing options
[ ]	Describe Secondary Ledgers & Reporting Currencies
[ ]	Describe Accounting Setup considerations with one legal entity
[ ]	Describe Accounting Setup considerations with multiple legal entities
[ ]	Describe Accounting Setup considerations with no legal entities

Accounting Setups
[ ]	Create Accounting Setups
[ ]	Describe the various Subledger Accounting Options
[ ]	Perform the Primary Ledger Setup steps
[ ]	Describe Ledger Balancing Segment Value Assignments
[ ]	Perform the Secondary Ledger Setup steps
[ ]	Complete Accounting Setup

Advanced Journal Entries
[ ]	Create Recurring Journals
[ ]	Formulate Mass Allocation Journals
[ ]	Describe AutoAllocations and related implementation considerations
[ ]	Explain AutoScheduling
[ ]	Describe the Journal Scheduling process
[ ]	Describe key issues and considerations when implementing Advanced Journal Entry
[ ]	Describe the business benefits of using Oracle General Ledger's Advanced Journal Entry functions

Consolidations
[ ]	Explain overview of Consolidations and their positioning within the Oracle General Ledger business flow
[ ]	Identify the key implementation issues regarding consolidations
[ ]	Use the features and functionality of Global Consolidation System (GCS)
[ ]	Use the elements of the Consolidation Workbench
[ ]	Create eliminating entries
[ ]	Use Standard reports and inquiry options available for consolidations

Ledger
[ ]	Describe the elements required to create a ledger within Oracle General Ledger
[ ]	Describe the basic components of Accounting Setup
[ ]	Describe the important elements for creating a Chart of Accounts structure
[ ]	Creating a new Accounting Flexfield structure
[ ]	Utilize the Account Hierarchy Manager to view and maintain Accounting Flexfield values

Summary Accounts
[ ]	Explain summary accounts and how they are used in General Ledger
[ ]	Define How Parent Values/ Rollup Groups are used in General Ledger
[ ]	Determine how Summary Templates are used
[ ]	Use Budgetary Control & maintain Summary accounts
[ ]	Plan and maintain Summary Account structures

Financial Budgeting
[ ]	Explain the anatomy of a budget
[ ]	Explain the components of budget accounting cycle
[ ]	Define budget and budget organization
[ ]	Explain Budget Entry methods
[ ]	Apply Budget Rules
[ ]	Transfer budget amounts
[ ]	Perform budget review and correction
[ ]	Translate budget balances
[ ]	Review balances in Master/Detail budgets
[ ]	Create budgets with Budget Wizards
[ ]	Use available Standard budget reports
[ ]	Plan Budget implementation requirements

Period Close
[ ]	Explain the accounting cycle
[ ]	Perform key steps in the close process
[ ]	Perform journal import of subledger balances
[ ]	Perform Subledger Reconciliation
[ ]	Explain the Period Closing Process and Reports
[ ]	Consolidate account balances

Procure to Pay Overview
[ ]	Describe the procure-to-pay process flow
[ ]	Describe the key areas in the procure-to-pay process
[ ]	Describe how the procure-to-pay process fits into the Oracle E-Business Suite of applications

Transaction Taxes in Payables
[ ]	Compute transaction taxes for invoices
[ ]	Insert manual tax lines and update transaction tax lines
[ ]	View tax summary and details
[ ]	Identify key reports related to transaction taxes
[ ]	Describe setup options in EB Tax & Payables
[ ]	Describe transaction taxes in Payables
[ ]	Describe treatment of different types of taxes (offset tax, recoverable tax, tax on prepayment, and others)

Withholding Tax
[ ]	Identify the withholding tax process
[ ]	Use withholding tax options
[ ]	Process manual withholding tax invoices
[ ]	Create withholding tax on Standard Invoices, Recurring Invoices and Application of Prepayment
[ ]	Process automatic withholding tax invoices

Advances and Progressive Contract Financing
[ ]	Describe the purpose of complex service contracts
[ ]	Identify advances, contract financing and progress payment invoices
[ ]	Calculate retainage
[ ]	Recoup prepaided amounts for complex service contract
[ ]	Calculate tax

Payables Overview
[ ]	Describe the Payables process flow
[ ]	Describe the key areas in the Payables process
[ ]	Identify Payables integration points
[ ]	Identify open interfaces to import data into Payables
[ ]	Set up and use Multiple Organization Access Controls (MOAC)

Suppliers
[ ]	Define suppliers and supplier sites
[ ]	Identify key reports related to suppliers and supplier sites
[ ]	Describe setup options - Purchasing
[ ]	Describe additional implementation considerations related to suppliers
[ ]	Describe setup options - Receiving
[ ]	Describe setup options - Others

Payments
[ ]	Describe the payment process
[ ]	Set up banks and bank accounts
[ ]	Enter single payments
[ ]	Process multiple payments
[ ]	Review and adjust payments
[ ]	Set up and create bills payable
[ ]	Create, apply, and release holds on prepayments
[ ]	Reconcile payments with Oracle Cash Management
[ ]	Use key standard reports
[ ]	Describe key setup options
[ ]	Describe additional implementation considerations related to payments
[ ]	Describe Payment Manager

Invoices
[ ]	Import/Enter invoices and invoice distributions
[ ]	Match to purchase orders
[ ]	Validate invoices
[ ]	Apply and release holds
[ ]	Describe invoice approval workflow
[ ]	Describe key reports
[ ]	Describe setup options
[ ]	Describe additional implementation considerations related to invoices

Expense Reports and Credit Cards
[ ]	Process various types of expense report
[ ]	Enter expense report templates
[ ]	Enter expense reports
[ ]	Apply advances
[ ]	Process procurement cards and credit cards

Period Close
[ ]	Describe activities to be performed during the Period Close process in Payables and Purchasing
[ ]	Reconcile accounts payable transactions for the period
[ ]	Identify key programs and reports related to Period Close
[ ]	Describe setup options related to Period Close
[ ]	Describe additional implementation considerations related to Period Close
[ ]	Explain the prerequisites for the Period Close process
[ ]	Transfer from Payables to General Ledger

Oracle Certification Program Fraudulent Activity Policy

Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.

If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate's Oracle Certified Associate, Oracle Certified Professional and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate's employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle's authorized vendors, and may be required to pay additional fees for services rendered.

View the Oracle Certification Program Candidate Agreement which requires your agreement before the start of each exam.