Oracle Cash Management Overview

Describing the bank account model
Describing the key concepts of reconciling bank accounts
Explaining the key concepts of cash pools, cash positioning, and cash forecasting
Explaining the key concepts of cash pools, cash positioning, and cash forecasting

Defining banks
Defining bank branches
Creating bank accounts
Defining bank transactions codes
Defining bank account signing authorities

Describing how to set up bank transfers
Creating a bank transfer
Settling a bank transfer
Creating a bank account transfer template

Entering and importing bank statements
Describing the Bank Statement Open Interface
Reviewing and correcting bank statement errors
Entering bank statements manually

Reconciling bank statements manually and automatically
Recording exceptions and reversals
Creating bank statement cashflows
Reconciling corrections and adjustments to bank errors
Clearing and unclearing transactions
Transferring bank reconciliation transactions to your general ledger
Explaining archiving and purging

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

• Describing the Payables process flow
• Describing the key areas in the Payables process
• Identifying Payables integration points
• Identifying Payables open interfaces

• Defining suppliers
• Defining supplier sites
• Identifying key reports
• Using setup options
• Identifying implementation considerations

• Importing and entering invoices and invoice distributions
• Applying prepayments and advances
• Matching invoices to purchase orders
• Applying and releasing holds
• Understanding invoice approval workflow
• Validating invoices for payment
• Using Quick Invoices
• Entering invoice records
• Entering purchase order matched invoice records
• Entering price corrections
• Finding and modifying invoice records
• Adding invoice records
• Creating invoices from invoice records

• Describing the process of issuing payments
• Setting up bank accounts
• Processing single payments
• Processing payment batches
• Processing stop and void payments

• Describing the expense report process
• Entering expense report templates
• Entering expense reports
• Applying advances
• Identifying key expense related reports
• Setting up credit card programs

• Describing the period closing process in Payables and Purchasing
• Reconciling accounts payable transactions for the period

• Setting up supplier tax information
• Describing supplier and supplier sites regions
• Identifying tax validations
• Entering taxes on invoices
• Identifying tax types, tax codes, and tax groups
• Submitting invoice validations
• Using tax control methods
• Identifying tax code defaults
• Identifying the withholding tax process
• Using withholding tax options
• Processing manual withholding tax invoices
• Creating withholding tax invoices
• Processing automatic withholding tax invoices

• E-Business Suite Integration
• Implementation Considerations for Oracle Financials
• Oracle Assets Setup Steps
• Implementing Oracle Assets
• Adding Assets Manually
• Mass Asset Additions
• Acquire and Build CIP Assets
• Reconciling Data in Oracle Assets

• Oracle Assets Setup Steps
• Setup Steps Flow
• Setting Up Key Flexfields
• Location Key Flexfield
• Creating Key Flexfield Combinations
• Specifying System Controls
• Setting Up Asset Calendars
• Maintaining an Audit Trail

• Asset Books Regions
• Calendar Region
• Accounting Rules Region
• Organizations and Security by Book
• Security by Book Setup Steps
• Troubleshooting Security by Book
• Implementation Considerations for Security by Book
• Asset Categories

• Asset Life Cycle
• Adding Assets Manually
• Detailed Asset Additions
• Asset Cost Terminology
• Accumulated Depreciation Considerations
• Manual Asset Additions Journal Entries

• Mass Asset Additions Process
• Using the Mass Additions Interface Table
• Tracking Expensed Items in Oracle Assets
• Changing Asset Information
• Accounting for Cost Adjustments
• Purge Mass Additions
• Creating Assets Using ADI
• ADI Upload to Oracle Assets

• Adding and Capitalizing a CIP Asset
• Acquire and Build CIP Assets
• Automatically Adding CIP Assets to Tax Books
• Modifying the Cost of CIP Assets
• Recording a CIP Asset Addition
• Capitalizing a CIP Asset
• Reversing a Capitalized Asset
• CIP Assets and Oracle Projects

• Single Asset Reclassification
• Mass Reclassification
• Inheriting Depreciation Rules
• Choosing to Expense or Amortize Depreciation Adjustments
• Amortizing Adjustments Using a Retroactive Start Date
• Asset Revaluation
• Performing Physical Inventory
• Physical Inventory Reconciliation

• Elements of Depreciation
• Depreciation Setup Areas
• Basic Depreciation Calculation
• Depreciation Methods
• Entering Production Information
• Prorate Conventions
• Run Depreciation Process
• Depreciation Forecasts

• Tracking Asset Retirements
• Overview of Retiring an Asset
• Restrictions on Retirements and Reinstatement
• Reinstating Retired Assets
• Retirement Processing Flow
• Recording Retirements
• Retirement Reports

• Setting Up Asset Accounting
• Assets Journal Entries Flow
• Account Generator
• Reconciling Data in Oracle Assets
• Generating Reports to Reconcile to the General Ledger

• Viewing Asset Information Online
• Types of Asset Inquiries
• Asset Inquiry Options
• iAssets Search for Assets
• iAssets Setup Steps
• iAssets Setup Steps-Rules
• iAssets Setup Steps-Profile Options
• Oracle Assets Reporting

• Creating a Tax Book
• Prerequisites for Setting Up Tax Book Asset Categories
• Entering Information in Tax Books
• Updating a Tax Book Manually
• Tax Book Upload Interface
• Deferred Depreciation
• Adjusting Accumulated Depreciation

• Identify the elements required to create a Set of Books within Oracle General Ledger
• Understand the attributes, options and required settings to define the Accounting Flexfield
• Using Hierarchical Security Support
• Define accounting calendars
• Enable predefined currencies
• Define a General Ledger Set of Books
• Utilize the ADI Account Hierarchy Editor to view and maintain accounting flexfield values
• Identify the key implementation issues regarding creating a Set of Books in Oracle General Ledger

• Understand where journal entries are positioned in the accounting cycle
• Identify the types and components of journal entries
• Journal Import Currency End Date Bypass
• Enter manual journal entries
• Post journal entries using various available options
• Using Journal Reference Date
• Perform an account inquiry
• Drill down to Oracle subledger applications
• Reverse journal entries
• Use the ADI Journal Wizard to create journal entries
• Import journal entry information using the GL_INTERFACE
• Identify the Setup Options to process journal entries
• Identify reports, listings and inquiry options available for journal entries
• Segment Value Security for Journals Reports
• Identify the Profile Options necessary to process journal entries
• Identify the Key Implementation issues regarding Oracle General Ledger journal entries

• Identify where Multi-Currency is positioned within the Oracle General Ledger business flow
• Define additional currencies
• Define conversion rate types and enter conversion rates
• Understand the Oracle General Ledger revaluation process and the streamlined revaluation process
• Understand the Oracle General Ledger translation process
• Identify reports and listings available regarding Multi-Currency
• Identify Profile Options settings required to process multiple currencies
• Identify the Key Implementation issues regarding Oracle General Ledger multiple currencies

• Set up and use intercompany balancing
• Set up and use global Intercompany system

• Identify where Consolidations is positioned within the Oracle General Ledger business flow
• Identify the features and functionality of the Global Consolidation System (GCS)
• Understand the elements of the Consolidation Workbench
• Process consolidation elimination entries
• Identify consolidation reports and inquiries available
• Identify the key implementation issues regarding Oracle General Ledger consolidations

• Identify the key elements of the Oracle budgeting process
• Define a budget
• Create budget organizations
• Using the ADI Budget Wizard to enter budget amounts
• Perform budget inquiries
• Identify budget reports and listings
• Identify the key implementation issues regarding Oracle General Ledger budgeting

• Identify the basic report building concepts
• Create basic FSG report definitions
• FSG Hierarchical Security Support
• FSG Report Set Enhancements
• Fiscal Year-End Amount Type in FSG Reports
• Utilize the report wizard of ADI to create FSG report definitions
• Identify the key implementation issues regarding Oracle General Ledger financial reporting

• Introduction to Subledger Accounting

• Create Accounting Program Overview
• Draft Accounting and Online Accounting
• Straight-Through Accounting
• Transfer Journal Entries to GL Program Overview
• Transfer Journal Entries to General Ledger Program

• Accounting Events Inquiry Process
• Viewing Subledger Journal Entry Lines
• Subledger Journal Entry Lines Inquiry Process
• Drilldown from GL

• Accounting Methods Builder (AMB) Overview
• AMB Process
• Copy and Modify Functionality
• Transaction Chart of Accounts
• Accounting Chart of Accounts
• Application Accounting Definition

• Subledger Accounting Reports Overview
• Custom Parameters
• Journal Entries Report
• Subledger Period Close Exceptions Report

• Subledger Journal Entries Overview
• Creating Subledger Journal Entries
• Reviewing and Completing Subledger Journal Entries
• Duplicating Subledger Journal Entries

• Custom Sources
• Business Flows
• Multiperiod Accounting
• Accrual Reversals
• Diagnostic Framework Overview
• Journal Entry Sequencing

• Order to Cash Lifecycle
• Overview of Receivables Process
• Overview of the Transaction Process
• Overview of Other Invoice Operations
• Overview of Adjustments
• Overview of the AutoInvoice Process
• Overview of the Receipts and Remittances
• Overview of Collections and Tax

• Party Model Overview
• Profile Classes
• Multiple Sites and Business Purposes: Centralized and Decentralized Example
• Data Quality Management
• Dun & Bradstreet Integration
• Merge Parties or Customer Accounts
• Reports
• Required Setup Steps for Customers

• Overview of Application Integration
• Customer Entry Methods
• Order Management Process
• Pricing Process
• Shipping Process
• AutoInvoice Process
• Receivables Process

• Oracle Receivables Overview
• Transaction Overview
• Invoice Entry Methods
• Entering Sales Credits
• Creating Invoice Batches
• Creating Debit Memos and Creating Adjustments
• Voiding Transactions
• Reports and Printing Transactions

• AutoInvoice Process and Integration
• Defining Transaction Batch Sources
• Defining Transaction Flexfields
• Determining Tax Liability
• Managing AutoInvoice System Options
• Correct Errors Overview
• AutoInvoice Exception Handling Windows

• Required Setup Steps for Transactions
• Auto Accounting
• Payment Terms
• Remit-to Addresses
• Accounting Rules
• Setting Up Document Sequencing
• Setting Up Gapless Transaction Numbering
• Consolidated Billing Invoices

• Overview of Receipts
• Creating Batches
• Applying Receipts to an Invoice
• Criteria for Mass Applying Receipts
• Applying Cross Currency Receipts
• Entering Discounts
• Overview of Receipt Setup
• Types of Receivables Activities
• Receipt Class, Payment Method and Bank Account Relationship
• Defining Bank Accounts
• Defining Receipt Classes
• System Options for Accounting
• Profile Options
• Functional Security

• Order Management Global Taxes Overview
• Receivables Global Tax Overview
• Value Added Tax Overview
• US Sales Tax Overview
• Tax Partner Process Overview
• Other Taxes in Oracle Applications
• Tax Setup Steps
• Defining Tax Preferences, Defaults and Rules

• Period Closing Process
• Overview of Ordering to Period Closing
• Standard Reports
• Reconciling Inventory Transactions
• Running Revenue Recognition
• Transferring to the General Ledger
• Running the Journal Import Program