R12.2 Oracle Cash Management Fundamentals

Objectifs de la formation

Dans ce cours, les participants apprennent à configurer et à utiliser Oracle Cash Management pour gérer les cycles de trésorerie. Grâce à des exercices pratiques, les participants apprennent à créer des comptes bancaires pour leur organisation, à rapprocher les comptes bancaires et à prévoir la trésorerie. Ce cours s’adresse aux clients qui ont mis en œuvre Oracle E-Business Suite Release 12 ou Oracle E-Business Suite 12.1.

Public

Cette formation Oracle Cash Management Fundamentals s’adresse aux utilisateurs finaux. 

Prérequis

Savoir naviguer sur Oracle Applications. Avoir des connaissances en comptabilité. Comprendre l’anglais et son vocabulaire spécifique IT.

Vous souhaitez faire vérifier vos prérequis ? Contactez-nous pour l’organisation d’un entretien téléphonique avec un de nos consultants formateurs.

Programme de la formation

Oracle Cash Management Overview

• Objectives
• Cash Management Integration
• Overview of Bank Account Model
• Setting Up for Reconciliation
• Reconciliation
• Reconciliation: Bank Statement Information
• Reconciliation: Integration
• Reconciliation: Oracle Receivables and Payables
• Reconciliation: Oracle Payroll, Oracle Treasury, and Oracle General Ledger
• Reconciliation: Oracle Payments
• Cash Forecasting
• Cash Positioning
• Cash Pools
• Oracle Cash Management Reports and Programs

Cash Management Security

• Objectives
• Cash Management Security Model
• Bank Account Maintenance Security
• Implementing Bank Account Maintenance Security
• Creating Bank Account Security Grants
• Bank Account Access Security Components
• Bank Account Access Security
• MOAC and Cash Management
• Multiple Organizations Access Control Setup – Set Profile Options
• Cash Management Security Profiles and Reconciling Bank Statements
• Setting Up Security

Setting Up Oracle Cash Management

• Objectives
• Setting Up Oracle General Ledger
• Setting Up Oracle Payables
• Setting Up Oracle Receivables
• Setting Up Oracle Payroll
• Setting Up Oracle Treasury
• Setting Up Oracle Cash Management: System Parameters
• Setting Up Oracle Cash Management: Bank Transaction Codes
• Setting Up Oracle Cash Management: Bank Statement Open Interface
• Setting Up Oracle Cash Management: Reconciliation Open Interface
• Setting Up Oracle Cash Management: External Cashflow Open Interface
• Setting Up Oracle Cash Management: Sequential Document Numbering

Creating Bank Accounts

• Objectives
• Overview of Bank Account Model
• Defining Banks
• Defining Bank Branches
• Linking Bank and Branches in Oracle Treasury
• Creating Bank Accounts: Selecting Branch, Legal Entities, and Functions
• Creating Bank Accounts: Adding Account Attributes
• Creating Bank Accounts: Adding Account Controls
• Creating Bank Accounts: Adding Account Access
• Adding Bank Account to Organization Payment Method in Oracle Payroll
• Defining Bank Transaction Codes
• Maintaining Bank Account Signing Authorities
• Bank Account Signing Authorities: Setting Up Prerequisites
• Bank Account Signing Authorities: Entering Signing Authority
• Bank Account Signing Authorities: Updating Signing Authority
• Bank Account Signing Authorities: Viewing Signing Authority

Cash Transactions

• Objectives 
• Setting Up Bank Transfers
• Bank Transfers Process Flow
• Creating a Bank Transfer
• Authorizing a Bank Transfer
• Integrating with Payments
• Creating Journal Entry Rules
• Setting Up Transaction Subtypes
• Setting Up Payment Templates 
• Cashflows
• Creating Bank Statement Cashflows from Bank File

Managing Bank Statements

• Objectives
• Entering Bank Information
• Loading the Bank Statement Open Interface
• Loading Bank Statement Open Interface: Using the Bank Statement Loader       Program
• Loading Bank Statement Open Interface: Using a Custom Loader Program
• Loading Bank Statement Open Interface: Intra-Day Bank Statement Loader       Program
• Loading Bank Statement Open Interface: XML Bank Statements
• Importing Bank Statements
• Importing Bank Statements: Bank Statement Validation
• Reviewing and Correcting Bank Statement Interface Errors
• Entering Bank Statements Manually

Reconciling Bank Statements

• Objectives
• Single European Payments Area (SEPA) Credit Transfer
• SEPA Credit Transfer: Bank Identifier Code (BIC) Validation
• SEPA Credit Transfer: International Bank Account Number (IBAN) Validation
• SEPA Credit Transfer: Enable Reconciliation at Payment Group Level
• SEPA Credit Transfer: Reconciliation logic for Manual Reconciliation
• SEPA Credit Transfer: Reconciliation logic for Automatic Reconciliation
• Reconciling Bank Statements Automatically
• Reconciling Sweep Transactions
• Defining Reconciliation Tolerances
• Multicurrency Matching and Clearing
• Value Date Support
• Reviewing Reconciliation Errors
• Reconciling Bank Statements Manually 
• Reviewing Reconciled Transactions 
• Unreconciling Transactions
• Creating Payments and Receipts
• Creating Miscellaneous Transactions
• Recording Exceptions
• Entering Reversals
• Reconciling Corrections and Adjustments to Bank Errors: Reversal
• Reconciling Corrections and Adjustments to Bank Errors: Adjustment
• AutoReconciliation Matching
• Manual Reconciliation Matching
• Manually Clearing and Unclearing
• Transferring Bank Reconciliation Transactions to Your General Ledger
• Archiving and Purging
• Archiving and Purging: Archiving and Purging Automatically

Cash Pools

• Objectives
• Creating Cash Pools  
• Viewing and Updating Cash Pools

Cash Positioning

• Objectives
• Creating Cash Position Worksheets
• Creating Cash Position Worksheets: Source Transaction Dates
• Creating Cash Position Worksheets: Overdue Transactions
• 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

• Objectives
• Overview of Cash Forecasting
• Sources for Cash Forecasting 
• Cash Forecasting and Cash Positioning
• Defining a Cash Forecast Template
• Generating a Cash Forecast 
• Generating a Cash Forecast: Multicurrency Forecasts 
• Modifying a Cash Forecast
• Exporting Cash Forecasts to Your Spreadsheet Application
• Implementation Considerations
• Using Cash Forecasting Reports

Accounting Events

• Objectives
• Overview of Accounting and Cash Management
• Oracle Subledger Accounting
• Oracle Subledger Accounting Integration
• Subledger Accounting: Key Concepts
• Subledger Accounting: Key Concepts in Cash Management
• Subledger Accounting: Setup and Process
• Subledger Accounting Process for Cash Management
• Creating Manual Journal Entries

Appendix A: Balances and Interest

• Objectives
• Tracking Bank Balances by Account
• Tracking Bank Balances for Multiple Accounts
• Bank Balance Types
• Viewing Actual, Historic, and Projected Balances
• Entering Account Balances Manually or Uploading Automatically
• Creating and Assigning Interest Rate Schedules to Bank Accounts
• Reusing Interest Rate Schedules
• Calculating Interest on Bank Accounts
• Creating Reports for Account Balances and Interest Calculations

Méthodes pédagogiques

Alternance d’apports théoriques et d’exercices avec un vaste choix d’exercices pratiques et de scénarios d’atelier permettent de mettre en œuvre les connaissances acquises.

La dernière version du support en anglais est accessible en ligne. Vous aurez à votre disposition un accès contenant tous les matériels de cours de votre formation, ainsi qu’un accès à 5 h de visionnage d’une autre formation de votre choix dans la même thématique. L’ensemble sera disponible pendant 90 jours.

Méthodes d’évaluation des acquis

Afin d’évaluer l’acquisition de vos connaissances et compétences, il vous sera envoyé un formulaire d’auto-évaluation, qui sera à compléter en amont et à l’issue de la formation.
Un certificat de réalisation de fin de formation est remis au stagiaire lui permettant de faire valoir le suivi de la formation.