Counterhouse Consultants Limited
Oracle Financials R12.x
Cash Management
Training Manual for Implementers I
Table of Content
Introduction
Define Cash Management Responsibility and User
Set Profile Options
Define System Parameters
Create Bank, Bank Branches and Bank Accounts
Create Bank
Create Bank Branch
Create Bank Account
Create Cash Forecast Template
1. Introduction
Oracle Cash Management is an enterprise cash management solution that helps you effectively manage and control
your cash cycle. It provides comprehensive bank reconciliation and flexible cash forecasting. Oracle Cash Management
facilitates:
Bank Reconciliation
Bank Statements management
Matching Bank Statement Lines with Transactions
Multi-Currency Handling
Oracle Payables Reconciliation Accounting
Oracle Receivables Reconciliation Accounting
Oracle Payroll Reconciliation
Using Cash Management with Automatic Clearing
Cash Forecasting
2.0 Define Cash Management Responsibility and User
You have to define a cash management responsibility and assign the responsibility to a user.
Path: System Administrator (N)>Security>Responsibility>Define
Enter the following:
Field Value
Responsibility Name XXC CASH MANAGEMENT
Application Cash Management
Responsibility Key XXC_CASH_MANAGEMENT
Description XXC Cash Management Responsibility
Data group
Name Standard
Application Cash Management
Menu CE_SUPERUSER
Request Group
Name All Reports
Application Cash Management
Save your work and close the form
To assign the responsibility to a user, go to:
Path: System Administrator (N)>Security>User>Define
Query a user (XXCOUNTERHOUSE) and assign the responsibility to it.
Save your work and close the form
3.0 Set Profile Options
During your implementation, you set a value for selected profile options to specify how your Cash Management application controls access to and
processes data. You will set MO: Operating Unit profile option to control which operating unit a particular responsibility corresponds to.
Path: System Administrator (N)>Profile>Options
Enter the following:
Field Value
Application Cash Management
Responsibility XXC CASH MANAGEMENT
Profile MO: Operating Unit
Set the MO: Operating Unit for XXC CASH MANAGEMENT to “XXC Operating Unit”
Save your work and close the form.
Click on Find (B)
4.0 Define System Parameters
Use the System Parameters window to configure your Cash Management system to meet your business needs. System parameters determine, for example,
which ledger Cash Management uses, the default options for manual reconciliation windows, and the control settings for the Auto Reconciliation program.
Prerequisites:
Define Ledger in General Ledger.
Choose a primary ledger for your operating unit in Payables and Receivables.
Switch responsibility to XXC CASH MANAGEMENT
Path: XXC Cash Management (N)>Setup>System>System Parameters
Enter the following:
Field Value
Legal Entity XXCOUNTERHOUSE LE (select it from the LOV)
Begin Date 01-JAN-2013
System Controls
Show cleared Transactions Yes
Show Void Payments Yes
Allow Adding Lines to Imported Statements No
Signing Authority Approval Choose Manually Controlled
Archive/Purge
Purge No
Archive No
Lines Per Commit No
Cash Management Transactions
Exchange Rate Type XXCOUNTERHOUSE
Bank Statement Cashflow Rate Date Cashflow Date
Bank Transfer Rate Date Transfer Date
Authorization Not Required
Cash Management Transaction (T)
Save your work and close the form.
5.0 Create Bank, Bank Branches and Bank Accounts
5.1 Create Bank
The Bank Account model allows users to define and keep track of all bank accounts in the e-Business Suite in one place and explicitly grant account access
to multiple operating units/functions and users. Bank accounts for internal use are consolidated in:
Payables
Receivables
Treasury
Global Financials
CRM
The first step in the bank account creation is the bank definition.
Path: XXC Cash Management (N)>Setup>Banks>Banks
Click on Create (B)
Enter the following
Field Value
Country Nigeria
Bank Name XXC Bank Nigeria Plc
Short Bank Name XXCB
Bank Number 6732
Click on Create (B) to enter the bank address details
Field Value
Country Nigeria
Address Line 1 31 Wellington Layout
Address line 2 Ikeja
City Lagos
State Lagos
Click on Save and Next (B)
Click on Save and Next (B)
Click on Create Contact (B) to enter the bank contact
Field Value
Prefix Ms.
First Name Kate
Last Name Adamawa
Job Title Code Officer
Job Title Officer
Start Date 01-Jan-2013
Purpose Business Click on Apply (B)
Format HMTL Mail
Email kadamawa@xxcbanknigeriaplc.com
Click on Finish (B) to successfully save your work.
5.2 Create Bank Branch.
On the confirmation home page, click on create Branch icon
Click on Continue (B) and enter the following Click on Save and Next (B)
Field Value
Branch Name Wellington Branch
Branch Number 456
Branch Type OTHER
Click on Create (B) to enter the bank branch contact information
Field Value
Country Nigeria
Address Line 1 31 Wellington Layout
Address line 2 Ikeja
City Lagos Click on Finish (B)
State Lagos
Click on Apply (B)
5.3 Create Bank Account
After creating the bank branch, on the confirmation page click on Create Account
icon
Select XXC Operating Unit as the Bank Account Owner, check Payables and
Receivables and click on Next (B). By checking Receivables and Payables, you are
instructing the system that the bank account will only be used for payables and
receivables transactions.
Click on Continue (B)
Enter the following
Field Value
Account Name XXCOUNTERHOUSE Current Account
Account Number 0987654321
Currency NGN
Start Date 01-Jan-2013
Enter the Cash account and click on Finish (B)
Click on Save and Next (B)
You will receive a confirmation message that your account has been created.
6.0 Create Cash Forecast Template Click on Next (B)
Path: XXC Cash Management> Cash Forecasting
From Add Row of Source Type select User-defined Inflow and click on Go (B)
Click on Forecast Template (T) and also click on Create Template (B) Enter 5 on Row Number field and click on Apply (B)
Enter the following
Field Value
Template Name XXC Cash Forecast template
Description XXC Cash Forecast template
Forecast By Days
Business Calendar Five Day Week
Click on Next (B) to define the column
Click on Finish (B)
To run the forecast, search for the forecast template “XXC Cash Forecast Template”.
Click on Run Forecast icon
Click on Submit
Click on View Forecast
