Oracle E-Business Suite R12 Cash Management Training

Oracle E-Business Suite R12 Cash Management training explains how to set up Oracle Cash Management and other applications that integrate with it. Under the guidance of the industry expert, the participants will learn how to create banks, open bank accounts, transfer funds between the different bank accounts, calculate bank balances and work on handling interests. How to generate cash forecast and set up security in accessing the bank accounts is also covered during the training.

At the completion of this core, the participants will inculcate the following skills:

• Describe the bank account model and reconcile bank accounts
• Create bank accounts, handle transactions, review errors, generate bank statement manually
• Manage cash pool, cash positioning, and cash forecast
• Provide security grants for account access
• Setup Oracle General Ledger and related applications
• Setup Oracle Subledger Accounting for Cash Management
• Update interest rates regularly, calculate interest and keep a check on account balances

Target audience

• End Users
• Functional Implementer

Prerequisites

The candidates with a basic understanding of accounting practices and functional knowledge of R12 navigations can go through this training.

Moreover, the knowledge of the following will be an added advantage:

• R12.x Oracle E-Business Suite Essentials for Implementers
• R12.x Oracle Receivables Management Fundamentals
• R12.x Oracle Payables Management Fundamentals

1. 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

2. Cash Management Security

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

3. 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

4. Creating Bank Accounts

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

5. Bank Transfers

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

6. Managing Bank Statements

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

7. Reconciling Bank Statements

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

8. Cash Pools

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

9. 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

10. 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

11. 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

12. Balances and Interest

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