Show findcourses.co.uk as: Mobile

Oracle Cash Management

StayAhead Training
Course summary
1 day
525 GBP excl. VAT
Open / Scheduled
Next available date: 25/10/2019 09:30 - London
Course Dates
London
25/10/2019 09:30 
525 GBP
29/11/2019 09:30 
525 GBP
16/01/2020 09:30 
525 GBP
02/04/2020 09:30 
525 GBP
02/07/2020 09:30 
525 GBP
05/10/2020 09:30 
525 GBP

Course description

S5
Oracle Cash Management Course Overview

This course is designed to give delegates the knowledge to set up and use Oracle Cash Management. They will learn how to import bank statements, reconcile them and post updated information to the Oracle General Ledger. Delegates will also learn how to create cash forecasts.

The delegate will learn and acquire skills as follows:

  • Setting up a Cash Clearing Account
  • Setting up Receivables Activities
  • Defining a Receipt Class
  • Setting up Cash Management
  • Setting up Bank Transaction Codes
  • Entering Payments - Cheque Run
  • Entering Receipt Batches
  • Importing a Bank Statement File
  • Automatically Reconciling to an Imported Bank Statement
  • Manually Reconciling Remaining Statement Lines
  • Manually Entering a Bank Statement
  • Defining a Forecast Template
  • Generating a Forecast
Who will the Course Benefit?

This Oracle Cash Management course is designed for implementation team members, managers and end users of Oracle Cash Management.

Course Objectives

By the end of this course delegates will have the skills to carry out the initial set up steps and to use Oracle Cash Management for daily bank reconciliation and the creation and running of cash forecasts. They will also understand the integration between Oracle Cash Management and Oracle Payables and Receivables.

Requirements

A general awareness of the Accounts Payable and Accounts Receivable functions in the delegate's own organization would be advantageous.

Follow-On Courses
  • Oracle Accounts Payable
  • Oracle Accounts Receivable
  • Oracle Asset Management
Notes:
  • Course technical content is subject to change without notice.
  • Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.
Oracle Cash Management Training Course

Course Contents - DAY 1

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: OVERVIEW OF ORACLE CASH MANAGEMENT

  • Cash Management Business Functions
    • Bank Reconciliation
    • Cash Forecasting
  • Cash Transaction Sources
  • The Need for Cash Management

Session 2: BANK RECONCILIATION

  • Overview of Bank Reconciliation
  • Reconciliation Process

Session 3: CASH MANAGEMENT SET UP

  • Set Up Steps in Accounts Payable
  • Set Up a Cash Clearing Account
  • Set Up Steps in Accounts Receivable
  • Set Up Steps in Cash Management
  • Set Up Bank Transaction Codes
  • Exercises
    • Set up a Cash Clearing Account
    • Define a Bank Payment
    • Set up Receivables Activities
    • Define a Receipt Class
    • Set Up Oracle Cash Management
    • Set Up Bank Transaction Codes
Oracle Cash Management Training Course

View Course Contents - DAY 1 (continued)

Session 4: RECONCILIATION

  • Import a Bank Statement File
  • Automatically Reconcile to an Imported Bank Statement
  • Manual Reconciliation of Remaining Statement Lines
  • Exceptions
  • Reconcile Journal Entries
  • Reconcile Payments
  • Reconcile Receipts
  • Reconcile Other Transactions
  • Create a Miscellaneous Transaction
  • Create a Receipt
  • Create a Payment
  • Post to the General Ledger
  • Reconciliation Open Interface
  • Reconcile Tolerances
  • Unreconcile Lines
  • Delete Statement Lines
  • Clearing
  • Exercises
    • Enter and Submit Payment Batch
    • Format and Confirm Payment Batch
    • Enter Receipt Batches
    • Import a Bank Statement File
    • Automatically Reconcile to Imported Bank Statement
    • Create a Miscellaneous Activity
    • Reconcile Receipts
    • Reconcile a GL Journal Entry
    • Reconcile a Manually Raised Cheque
    • Manual Reconciliation of Remaining Statement Lines

Session 5: BANK STATEMENT INTERFACE

  • Bank Statements
  • Bank Statement Load
  • Bankline Statement File Format
  • Field Mapping
  • Set Up Steps for SQL*Loader
  • Set Up Transaction Codes
  • SQL*Loader Import Script

Session 6: ENTER AND UPDATE MANUAL BANK STATEMENTS

  • Enter a Bank Statement Manually
  • Enter Bank Statement Lines
  • Update a Bank Statement
  • Exercises
    • Manually Enter a Bank Statement
    • Receipt Exceptions
    • Recalculate

Session 7: CASH FORECASTING

  • Create a Forecast Template
  • Generate a Forecast
  • Drill Down From a Forecast
  • Export a Forecast
  • Create a New Forecast by Making a Duplicate
  • Amend a Template
  • Delete a Forecast
  • Delete a Forecast Template
  • Exercises
    • Define a Forecast Template
    • Generate a Forecast
Oracle Cash Management Training Course

View Course Contents - DAY 1 (continued)

Session 8: CASH MANAGEMENT INTERFACES

  • Reconciliation Open Interface
  • Forecasting Open Interface

Session 9: INQUIRIES AND REPORTS

  • Inquiries
    • Inquire on a Bank Statement
    • Inquire on Available Transactions
    • Inquire on Payments
    • Inquire on Receipts
    • Inquire on Bank Transmissions
  • Reports
    • Bank Statement Reports
    • Cash Forecasting Reports
    • Bank Reconciliation Reports
  • Exercises
    • Run Inquiries
    • Run Reports

Expenses

£525.00

Continuing Studies

Follow on courses: Oracle Accounts Payable, Oracle Accounts Receivable, Oracle Asset Management

About provider

StayAhead Training - Unix, Linux, MySQL, Java, CSS, HTML, Oracle, RedHat, Linux, Solaris, PHP, Perl, Python, Programming

StayAhead Training established 1992, is recognised as one of the leading independent IT Training specialists in the UK and the first choice provider for many of UK's largest organisations. Located in 7 training centres throughout the UK:  London, Birmingham, Manchester,...


Read more and show all courses with this provider

Customer Outreach Award

customer-outreach-badge-2019

We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Request info

Fill out your details to find out more about Oracle Cash Management.

  Contact the provider

  Get more information

  Register your interest

Contact info

StayAhead Training

6 Long Lane, Barbican
EC1A 9HF London

 Show phone number
www.stayahead.com


Request Information

Find out more about this Oracle Cash Management course - simply fill out your details:

Reviews

There are no reviews available yet.

U.K. L&D Report: 2019 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!

uk-ld-report-2019

Learn more