R12 Oracle Cash Management Fundamentals   

What you will learn:

In this course, participants learn how to set up Oracle Cash Management and the other applications that integrate with it. They learn how to set up security profiles and security grants to control access to the application and set up access controls for multiple organizations. Participants learn how to create banks, bank branches and bank accounts; transfer cash between bank accounts; manage and reconcile bank statements; work with bank balances, and calculate interest. They learn how Cash Management uses Oracle Subledger Accounting to generate accounting entries. They lean how to create cash pools, generate cash positions and cash forecasts to manage their cash cycles.

Audience:

• End Users
• Functional Implementer

Prerequisites:

Required Prerequisites:

• Knowledge of accounting practices
• Functional knowledge of R12 navigation
• R12 Oracle Payables Management Fundamentals
• R12 Oracle Receivables Management Fundamentals
• R12 Oracle E-Business Suite Essentials for Implementers

Course Objectives:

• Set up security for bank account access
• Explain how to set up Oracle Cash Management and related applications
• Create bank accounts
• Transfer funds between bank accounts
• Reconcile bank statements
• Describe how to work with cash pools, cash positioning, and cash forecasting
• Describe the accounting events generated for bank activity
• Work with bank balances and calculate interest

Course Topics:

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

Cash Management Security

• Explaining how security works in Oracle Cash Management
• Creating security profiles
• Creating security grants

Setting Up Oracle Cash Management

• Describing how to set up Oracle General Ledger
• Describing how to set up related applications
• Describing how to set up Oracle Cash Management

Creating Bank Accounts

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

Bank Transfers

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

Managing Bank Statements

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

Reconciling Bank Statements

• 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

Cash Pools

• Creating cash pools
• Viewing cash pools
• Updating cash pools

Cash Positioning

• Creating cash positioning worksheets
• Generating cash positions from worksheets
• Generating a cash leveling proposal
• Viewing cash position results
• Exporting cash position results to your spreadsheet application
• Viewing cash positions in Discoverer

Cash Forecasting

• Defining a cash forecast template
• Generating a cash forecast
• Modifying a cash forecast
• Exporting a cash forecast to your spreadsheet application
• Identifying implementation considerations
• Using cash forecasting reports

Accounting Events

• Describing the accounting flow in Oracle Cash Management
• Describing the key concepts of Oracle Subledger Accounting
• Describing how to set up Oracle Subledger Accounting for Cash Management
• Creating manual journal entries

Balances and Interest

• Maintaining bank account balances
• Creating interest rate schedules
• Creating reports for interest calculations and account balances

Suggested Next Courses:

• R12 Oracle Subledger Accounting Fundamentals
• R12 Oracle Subledger Accounting Fundamentals