Oracle E-Business Suite: Financials

 

 


The Oracle R12 E-Business Suite Payables certification endorses the high-level of IT practitioner expertise in the successful design and implementation of Oracle R12 E-Business Suite Payables and managing the accounts payable processes. The R12 Oracle: Receivables certification endorses the high-level of IT practitioner expertise in the successful design and implementation of R12 Oracle Receivables and managing the accounts receivables processes. Classroom training for the exam is available through Oracle University.

 

  • Oracle E-Business Suite R12: E-Business Essentials for Implementers
  • Oracle E-Business Suite R12: General Ledger
  • Oracle E-Business Suite R12: Payables Fundamentals
  • Oracle E-Business Suite R12: Receivables Fundamentals

 

R12 Oracle E-Business Suite Essentials for Implementers

What you will learn:

Students will learn how to access and navigate within the R12 Oracle E-Business Suite and will understand how to enter data, retrieve information in the form of a query, and access online help. This course also provides an introduction into shared entities, key business flows, functions and integration points between products within the R12 Oracle E-Business Suite. The R12 Oracle E-Business Suite Essentials for Implementers course provides a prerequisite functional foundation for all R12 E-Business Suite Fundamentals offerings. Demonstrations and hands-on practice activities reinforce the fundamental concepts.

Learn To:

  • Identify features of Multiple Organizations and Multiple Organization Access Control (MOAC), and their enhanced reporting benefits to a shared service enterprise
  • Describe the features of R12 Oracle Workflow
  • Define key and descriptive Flexfields
  • Navigate R12 Oracle Applications
  • Explore major architectural components of R12 Oracle E-Business Suite
  • Basic concepts of R12 Oracle System Administration

Audience:

  • Functional Implementer
  • End Users
  • Navigate within R12 Oracle E-Business Suite
  • Understand conceptually the major architectural components of R12 Oracle E-Business Suite
  • Describe features and benefits of Multiple Organization Access Control (MOAC)
  • Define key and descriptive Flexfields
  • Identify shared entities across R12 Oracle E-Business Suite
  • Learn the key features and benefits of R12 Oracle Work-flow
  • Describe basic concepts of R12 Oracle System Administration
  • Create Oracle Alerts and test a Periodic Alert
  • Course purpose
  • Course topics
  • More help
  • Logon and off of Oracle Applications
  • Using forms & menus
  • Entering data using forms
  • Searching forms
  • Accessing Online Help
  • Introduction to R12 Footprint
  • Benefits of R12 Footprint
  • R12 E-Business Suite Architecture
  • Basic Technical Architecture
  • Overview of Oracle file system and directories
  • Shared entities and Non-key shared entities
  • Overview of E-Business Suite business flows and Integration
  • Application Security Overview
  • Function Security
  • Data Security
  • Profile Options
  • Standard request submission (SRS)
  • Basics of Flexfields
  • Define Value sets
  • Define Key Flexfields
  • Define Descriptive Flexfields
  • Flex field enhancements in R12
  • Introduction to Multiple-Organization and Multiple- Organization Access control (MOAC)
  • Types of organizations supported in the Multi-Org model
  • Multiple-Organization Access Control Setup and Process
  • Reporting across entities
  • Key Implementation consideration
  • Overview of Work-flow
  • Oracle Work-flow Home Pages
  • Work-list WebPages
  • Work-flow Monitor WebPages
  • Overview of Alerts
  • Difference between work-flows & alerts
  • Overview of Daily Business Intelligence
  • Overview of Fusion Business Intelligence

Course Objectives: Course Topics:

Overview of Essentials for Implementers

Navigating in R12 Oracle Applications

Introduction to R12 Oracle Applications

Shared Entities and Integration

Fundamentals of System Administration

Fundamentals of Flexfields

Fundamentals of Multiple-Organization and Multiple-Organization Access Control (MOAC)

Fundamentals of Oracle Work-flow & Alerts

Fundamentals of Daily Business Intelligence and Oracle Fusion Business Intelligence

R12 Oracle General Ledger Management Fundamentals

 

 

What you will learn:

This course will enable the user to maximize accounting process efficiencies across the enterprise while still achieving a high level of information and setup security.

Additionally, this course will teach the fundamental improvements in Oracle General Ledger enabling students to perform simultaneous accounting for multiple reporting requirements and access and process data for multiple ledgers and legal entities at the same time using the power of ledger sets.

Learn To:

  • Understand the steps for completing the full accounting cycle
  • Understand the ledger concept
  • Understand the various implementation considerations
  • Understand how Oracle General Ledger integrates with the eBusiness Suite of applications
  • Understand the capabilities of securing data within Oracle General Ledger

Audience:

  • Functional Implementer
  • End Users
  • Project Manager
  • R12 Oracle E-Business Suite Essentials for Implementers
  • Understand how to navigate Oracle Applications
  • Possess accounting knowledge
  • Identify the steps required to complete the accounting cycle
  • Describe the implementation considerations
  • Understand how Oracle General Ledger integrates with the eBusiness Suite of applications
  • Understanding the General Ledger Functions and Features
  • Analyzing the General Ledger Accounting Cycle
  • Reviewing General Ledger Integration Points
  • Generating Standard Reports and Listings
  • Understanding the required Accounting Setups
  • Describing Reporting Currencies
  • Describing Accounting Setup Considerations
  • Describing the Elements Required to Define Ledgers
  • Identifying Attributes, Options and Settings to Define the Accounting Flexfield
  • Defining an Accounting Calendar
  • Describing how Journal Entries are Positioned in the Accounting Cycle
  • Identifying the Types of Journal Entries
  • Creating Manual Journal Entries
  • Posting Journal Entries
  • Performing Accounting Inquiries
  • Performing Drilldowns to Oracle Sub-ledger applications
  • Creating Reversing Entries
  • Creating Accounting Setups
  • Creating Accounting Setup Structures
  • Completing Accounting Options
  • Analyzing Reporting Currencies
  • Understanding how Summary Accounts are used in General Ledger
  • Defining Rollup Groups for Creating Summary Accounts
  • Assigning Parent Values to Rollup Groups
  • Entering Summary Account Templates
  • Discussing Implementation Considerations
  • Understanding Advanced Journal Entries Functions
  • Understanding the Business Benefits of Advanced Journal Entries
  • Understanding Recurring Journals
  • Understanding Mass Allocation Journals
  • Understanding Auto-Allocations
  • Understanding Journal Scheduling
  • Understanding Journal Approval
  • Describing Data Access Security for Legal Entities and Ledgers
  • Understanding Management Reporting and Security
  • Understanding Anatomy of a Budget
  • Completing the Budget Accounting Cycle
  • Discussing Budget Entry Methods
  • Uploading Budget Amounts
  • Transferring Budget Amounts
  • Freezing and Unfreezing Budget Amounts
  • Defining Foreign Currencies
  • Entering Foreign Currency Journals
  • Revaluing Foreign Currency Balances
  • Translating Balances Into Foreign Currency
  • Identifying Consolidations Across the General Ledger Business Process
  • Understanding Key Implementation Issues Across Consolidations
  • Understanding the Global Consolidation System
  • Defining the Elements of the Consolidation Workbench
  • Understanding the Accounting Cycle
  • Understanding Steps in the Close Process
  • Performing Journal Import of Sub-ledger Balances
  • Generating Revaluation
  • Understanding the Closing Period
  • Consolidating Account Balances
  • Identifying Financial Reporting Across the General Ledger Business Process
  • Understanding Basic Report Building Concepts
  • Understanding the Financial Statement Generator
  • Generating Financial Reports using the Standard Request Submission Form
  • Understanding the differences between Intercompany and Intracompany transactions
  • Understanding the setups required to perform intercompany and intracompany transactions.
  • Creating manual Intercompany and Intracompany transactions.

Prerequisites:

Required Prerequisites:

Suggested Prerequisites:

Course Objectives: Course Topics:

Oracle General Ledger Process

Accounting Setup Manager

Ledger

Basic Journal Entries

Using Accounting Setup Manager

Summary Accounts

Advanced Journal Entries

Advanced Security

Financial Budgeting

Multi Currency

Consolidations

Period Close

Financial Reporting

Intercompany and Intracompany

R12 Oracle Payables Management Fundamentals

 

 

What you will learn:

In this course, participants learn how to set up and use Oracle Payables to manage the accounts payable process. They learn how to create and manage suppliers and supplier bank accounts, process individual and recurring invoices, match invoices to purchase orders or receipts, use multiple distribution methods, and process various types of payments. Other topics included in the course cover how Payables integrates with other Oracle Applications, how to import invoices or employee expense reports, and how to use invoice approval.

Learn To:

  • Manage Suppliers
  • Process Invoices and Payments
  • Generate Key Payables Reports
  • Approve Invoices for Payment
  • Process, Stop, and Void Payments
  • Set Up Bank Accounts

Audience:

  • End Users
  • Project Manager
  • Functional Implementer
  • R12 Oracle E-Business Suite Essentials for Implementers
    • Understanding Managing Suppliers
    • Understanding how to Process Invoices and Payments
    • Generating Key Payables Reports
    • Approving Invoices for Payment
    • Process, Stop, and Void Payments
    • Setting Up Bank Accounts
    • Processing Pay Runs
    • Closing Payables Periods
    • View Accounting
    • Describing the Procure to Pay Process Flow
    • Describing how the Procure to Pay Process Fits Across the eBusiness Suite Applications
    • Overview of Payables Processes
    • Understanding Supplier Entry
    • Understanding Invoice Entry
    • Understanding Payments
    • Analyzing Payables Integration Points
    • Using Payables Open Interfaces to Import Data
    • Understanding the Procure to Pay Lifecycle
    • Defining Supplier and Supplier Sites
    • Identifying the Key Reports
    • Understanding Setup Options
    • Analyzing Implementation Considerations
    • Importing and Entering Invoices and Invoice Distributions
    • Matching Invoices to Purchase Orders
    • Validating Invoices
    • Applying and Releasing Holds
    • Understanding the Invoice Approval Workflow
    • Generating Key Reports
    • Analyzing Setup Options
    • Analyzing Implementation Considerations
    • Describing the Payments Process
    • Setting Up Banks and Bank Accounts
    • Entering Single Payments
    • Processing Multiple Payments
    • Understanding how to Review Payments
    • Understanding how to Adjust Payments
    • Analyze Setting up and Creating Bills Payable
    • Creating, Applying, and Releasing Holds on Prepayments
    • Describing the Expense Reports Process
    • Understanding how to Enter Expense Report Templates
    • Entering Expense Reports
    • Understanding how to Apply Advances
    • Identifying the Key Expense Reports
    • Understanding how to Set Up Credit Card Programs
    • Describing the Period Closing Process in Payables
    • Describing the Period Closing Process in Purchasing
    • Reconciling Payables Transactions for the Period
    • Identifying Key Programs and Reports
    • Understanding Setup Options
    • Understanding Implementation Considerations
    • Describing How to Enable 1099 Suppliers
    • Entering Invoices for 1099 Suppliers
    • Updating the 1099 Information
    • Understanding the 1099 Setup Options
    • Understanding Implementation Considerations
    • Describing how Transaction Taxes are Calculated
    • Inserting Manual Tax Lines
    • Updating Transaction Tax Lines
    • Viewing Tax Summary and Details
    • Identifying Key Reports
    • Understanding Setup Options
    • Identifying the Withholding Tax Process
    • Using Withholding Tax Options
    • Processing Manual Withholding Tax Invoices
    • Creating Withholding Tax Invoices
    • Processing Automatic Withholding Tax Invoices
    • Analyzing Standard Key Reports
    • Understanding the Purpose of Complex Service Contracts
    • Identifying Advances, Contract Financing, and Progress Payment Invoices
    • Calculating Retainage

Prerequisites:

Required Prerequisites:

Course Objectives: Course Topics:

Procure to Pay Overview

Payables Overview

Suppliers

Invoices

Payments

Expense Reports and Credit Cards

Period Close

1099 Reporting

Transaction Taxes in Payables

Withholding Tax

Advances and Progressive Contract Financing

Recouping Prepaid Amounts for Complex Service Contract

 

R12 Oracle Receivables Management Fundamentals

 

 

What you will learn:

In this course, students will learn how to set up and use Oracle Receivables to manage receivables processing. Students learn how to manage parties and customer accounts, how to process invoices using Auto-Invoice, how to enter and complete invoices, and to perform other relevant invoice actions.

Students will also learn bill presentment architecture processes, setup for credit management, the receipt process, tax processing, and period closing.

Students will learn how the Receivables application fits into Oracle’s e-Business Suite of applications. This is accomplished through a series of tutorials, supplemented with hands-on exercises.

Learn To:

  • Understand the Order to Cash Lifecycle
  • Understand the Oracle Receivables Process
  • Manage Parties and Customer Accounts
  • Process Invoices Using Auto-Invoice
  • Explain Bill Presentment Architecture Processes
  • Setup Credit Management

Audience:

  • Functional Implementer
  • End Users
  • R12 Oracle E-Business Suite Essentials for Implementers
  • R12 Oracle Financials Functional Migration Fundamentals
  • Thorough knowledge of the overall Oracle Receivables Process
  • Ability to navigate Oracle applications
  • Understand the overall order to cash process from Order Entry through Bank Reconciliation
  • Understand key areas in the Order to Cash Life Cycle
  • Explain how the Receivables processing is positioned within the Order to Cash Life Cycle
  • Describe the overall Receivables process
  • Manage parties and customer accounts
  • Describe the Auto-Invoice process
  • Explain bill presentment architecture processes
  • Understand Credit Management
  • Identify credit management processing
  • Understand setup information related to invoicing
  • Describing the receipt process
  • Understand setup information related to receipts
  • Understand the tax accounting process
  • Understand Sub-ledger Accounting as it relates to period closing
  • Describing the overall Order to Cash Process from Order Entry through Bank Reconciliation
  • Discussing the key areas in the Order to Cash Life Cycle
  • Describing the integration between the applications
  • Explaining where the Receivables processing is positioned within the Order to Cash Life Cycle
  • Describing the overall Receivables Process
  • Discussing the key areas in the Receivables Process
  • Defining the Features to Enter and Maintain Party and Customer Account Information
  • Defining the Features to Enter and Maintain Party and Customer Account Information
  • Creating Profile Classes and Assigning hem to Customer Accounts
  • Creating and Maintaining Party and Customer Account Information
  • Enabling Customer Account Relationships
  • Defining TCA Party Paying Relationships
  • Merging Parties and Customer Accounts
  • Viewing Party and Customer Account Information
  • Describing the Auto-Invoice Process
  • Using Auto-Invoice
  • Correcting Errors Using Auto-Invoice Exception Handling
  • Describing How Processing Invoices Fits into the Receivables Process
  • Entering and Completing Invoices
  • Correcting Invoices
  • Printing Transactions and Statements
  • Using Event-Based Management
  • Demonstrating Promised Commitment Accounts
  • Explaining the Bill Presentment Architecture Processes
  • Registering Data Sources
  • Creating Templates to Present Bills
  • Defining Rules to Assign Templates to Customers
  • Printing BPA Invoices
  • Understanding Setup Steps for Credit Management
  • Demonstrating Credit Profile Changes
  • Identifying Credit Management Processing
  • Using Workflow and Lookups
  • Reviewing Credit Management Performance
  • Applying Credit Hierarchy
  • Entering Setup Information related to Invoicing
  • Understanding Key Implementation Considerations in Customer Invoicing
  • Describing the Receipt Process
  • Applying Receipts Using Different Methods
  • Creating Charge-backs, Adjustments, and Claims
  • Using Balancing Segments
  • Applying Non-Manual Receipts
  • Entering Setup Information for Receipts
  • Discussing the Implementation Considerations
  • Understanding the Tax Accounting Process
  • Understanding Oracle E-Business Tax Setups for Receivables
  • Managing Tax Accounts and Tax Adjustments
  • Understanding Sub-ledger Accounting Related to Period Closing
  • Defining Various Actions Required to Close a Period in the Order to Cash E-Business Flow
  • Describing Available Reports Assisting in the Closing Process
  • Explaining How to Run the Revenue Recognition Program and the General Ledger Interface Program.

Prerequisites:

Required Prerequisites:

Suggested Prerequisites:

Course Objectives: Course Topics:

Order to Cash Lifecycle Overview

Overview of Oracle Receivables Process

Manage Parties and Customer Accounts

Process Invoices Using Auto-Invoice

Process Invoices

Bill Presentment Architecture

Credit Management

Implement Customer Invoicing

Receipts

Implement Receipts

Tax Processing

Period Closing