The future of IBM Maximo: Work Centers and Inspections Can Transform Your Business

closeClose

R12.2 Oracle Cash Management Fundamentals

  • Tuition USD $1,848
  • Reviews star_rate star_rate star_rate star_rate star_half 486 Ratings
  • Course Code D103979GC10
  • Duration 2 days
  • Available Formats Virtual

This course will be applicable for customers who have implemented Oracle E-Business Suite Release 12 or Oracle E-Business Suite 12.1 or 12.2

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 Sub ledger Accounting to generate accounting entries. They learn how to create cash pools, generate cash positions and cash forecasts to manage their cash cycles. This course will be applicable for customers who have implemented Oracle E-Business Suite Release 12 or Oracle E-Business Suite 12.1.

Learn to:
  • Define banks
  • Create bank accounts
  • Create a bank transfer
  • Enter Bank Statement Information Manually
  • Create Bank Statement Cashflow from bank statements
  • Generate a Cash Forecast

Skills Gained

  • 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
  • Set up bank statement cashflows from bank file, payments, receipts, and miscellaneous transactions
  • Describe the SEPA Credit Transfer and its components
  • Set up security for bank account access
  • Explain how to set up Oracle Cash Management and related applications
  • Create bank accounts

Who Can Benefit

  • End User
  • Implementer

Prerequisites

Required Prerequisite

  • R12.2 Oracle Payables Management Fundamentals Ed 1
  • R12.2 Oracle Receivables Management Fundamentals Ed 1
  • R12.x Oracle E-Business Suite Essentials for Implementers TOD
  • Knowledge of accounting practices
  • Functional knowledge of R12 navigation

Course Details

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
    • Creating bank statement cashflows
  • 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
    • 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
  • 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
  • Creating bank statement cashflows

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
  • 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

How do I enroll?

A comprehensive listing of ExitCertified courses can be found here. You can register directly for the required course/location when you select "register". If you have any questions or prefer to speak with an ExitCertified education consultant directly, please submit your query here. A representative will contact you shortly.

How do I pay for a class?

You can pay at the time of registration using credit card (Mastercard/Visa/American Express) cheque or PO.

What if I have training credits?

ExitCertified honors all savings programs from the partners we work with. ExitCertified also offers training credits across multiple partners through our FLEX Account.

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Lunchtime?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

Instructor was engaging, very knowledgeable, and explained things clearly. Labs were helpful in getting used to the tools that were being taught. Course location (Atlanta Microtek facility) was very comfortably set up. I'd definitely recommend this to anyone learning a new skill. (I took the 3-day AWS Big Data training).

I had no problems signing up for and completing the course. The introduction was clear and helpful to get the course going. The course itself was excellent and very helpful.

Great first experience with ExitCertified. I look forward to many more trainings.

Tech Data provided me with all the resources required to familiarize myself with the TRIRIGA Lease module. The facilitator was very knowledgeable and provided comprehensive exercises and support to aid in my understanding of the application.

Well organized, but the training should have included lab times as well, labs won't be done during breaks.

1 options available

undo
  • Nov 12, 2020 Nov 13, 2020 (2 days)
    Location
    Virtual
    Language
    English
    Time
    06:00 AM 14:00 PM PST
    Enroll
    Enroll
Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward