Oracle R12 Cash Management
Course Code: FCMR12
Duration: 1 day
Course Overview
Oracle R12 Cash Management Course Overview
The Oracle R12 Cash Management 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 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 functions of Accounts Payable and Accounts Receivable in the delegates' own organisation would be advantageous.
Follow-On Courses
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.
Course Contents
Oracle R12 Cash Management Training Course
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
- Define a Bank Payment
- Set Up Steps in Accounts Receivable
- Set Up Steps in Cash Management
- Set Up Bank Transaction Codes
- Exercises
- Set up a Cash Clearing Account
- Set up Receivables Activities
- Define a Receipt Class
- Set Up Oracle Cash Management
- Set Up Bank Transaction Codes
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
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
Oracle R12 Cash Management
Course Code: FCMR12
Duration: 1 day
RRP: £525.00 exc. VAT
Course Dates
Upcoming Scheduled Events - next 12 months
| Location | Start Date | Spaces | Book |
|---|---|---|---|
| London | 03 Dec 2018 |
Spaces
|
Book |
| London | 22 Feb 2019 |
Spaces
|
Book |
| London | 13 May 2019 |
Spaces
|
Book |
| London | 22 Jul 2019 |
Spaces
|
Book |
| Location | Start Date | Spaces | Book |
|---|---|---|---|
| London | 03 Oct 2019 |
Spaces
|
Book |
You can attend your training virtually using the London dates shown above.
Please contact us for more details on our Virtual training options or to discuss specific Virtual course dates to meet your requirements.
Course Reviews
Excellent and very helpful course instructor, always willing to assist with lots of questions. Good facilities and classroom environment. Met all requirements and highly recommended.
Kirk - Financial Operations Team Leader - Transport
A very well run course. The pace was perfect and the Trainer explained things in a very clear way. He made sure I understood and spent time answering any questions. I have taken away knowledge of all I wanted to know.
Anita - Government
Course Deliveries
Public Scheduled and Closed
Virtual
UK and Overseas
Oracle User Group - Membership Benefits
Certification
Our independent Oracle, Solaris & Red Hat Linux curriculums helps prepare delegates for official certification.
StayAhead
Flexibility
Cannot see a sutiable date?
Please call us and we will try an accommodateyour needs!
Our Course Curriculum
Linux, Red Hat, Oracle Linux, SUSE & LPI
Programming, Java, Python, Web Dev, SQL, NoSQL, MySQL & MariaDB
Oracle e-Business
Business Analysis, ITIL & Prince2
Our Ratings
Instructor
Quality
97.47%
Course
Practical
92.66%
Overall
Courseware
94.51%
Overall
Course
96.4%