Cash Management

THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM ONLY.
COPYING eKIT MATERIALS FROM THIS COMPUTER IS STRICTLY PROHIBITED
D66103
Edition 1.0
March 2010
D60083GC10
Activity Guide
R12.x Oracle Cash
Supplemental Practices
Management Fundamentals -
Oracle University and Cyret Technologies India Privat Limited use only
THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM ONLY. COPYING eKIT MATERIALS FROM THIS COMPUTER IS STRICTLY PROHIBITED
Copyright © 2010, Oracle. All rights reserved.
Disclaimer
This document contains proprietary information and is protected by copyright and other intellectual property laws. You may copy and
print this document solely for your own use in an Oracle training course. The document may not be modified or altered in any way.
Except where your use constitutes "fair use" under copyright law, you may not use, share, download, upload, copy, print, display,
perform, reproduce, publish, license, post, transmit, or distribute this document in whole or in part without the express authorization
of Oracle.
The information contained in this document is subject to change without notice. If you find any problems in the document, please
report them in writing to: Oracle University, 500 Oracle Parkway, Redwood Shores, California 94065 USA. This document is not
warranted to be error-free.
Restricted Rights Notice
If this documentation is delivered to the United States Government or anyone using the documentation on behalf of the United
States Government, the following notice is applicable:
U.S. GOVERNMENT RIGHTS

The U.S. Government’s rights to use, modify, reproduce, release, perform, display, or disclose these training materials are restricted
by the terms of the applicable Oracle license agreement and/or the applicable U.S. Government contract.
Trademark Notice
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective
owners.
Author
Mathew Daniel, Melanie Heisler
Technical Contributors and Reviewers
David Barnacle, Byung-Hyun Chung, Ivy Farren, Suzanne Miller, Parthasawarthy Ramaratnam,
Lata Sundar, Kathryn Wohnoutka
This book was published using: Oracle Tutor

Table of Contents
R12.x Oracle Cash Management Fundamentals - Supplemental Practices ...............................................1-1

R12.x Oracle Cash Management Fundamentals Supplemental Practices......................................................1-3
Oracle Cash Management Overview .............................................................................................................1-4
Practice - Create a New User.....................................................................................................................1-5
Solution: Create a New User .....................................................................................................................1-7
Practice - Create GL Account Cash Values ...............................................................................................1-9
Solution: Create GL Cash Accounts..........................................................................................................1-11
Cash Management Security ...........................................................................................................................1-13
Guided Demonstration - Create Security Profile .......................................................................................1-14
Guided Demonstration - Create Security Grants .......................................................................................1-16
Creating Bank Accounts ................................................................................................................................1-18
Practice - Create an Internal Bank Account...............................................................................................1-19
Solution: Create an Internal Bank Account ...............................................................................................1-24
Practice - Set up Bank Transaction Codes.................................................................................................1-30
Solution: Set up Bank Transaction Codes (Required) ...............................................................................1-32
Bank Transfers...............................................................................................................................................1-34
Practice - Create a Bank Transfer ..............................................................................................................1-35
Solution: Create a Bank Transfer...............................................................................................................1-36
Practice - Set Up a Transaction Subtype....................................................................................................1-38
Solution: Set Up a Transaction Subtype ....................................................................................................1-39
Practice - Set Up a Payment Template ......................................................................................................1-40
Solution: Set Up a Payment Template .......................................................................................................1-41
Managing Bank Statements ...........................................................................................................................1-42
Practice - Enter a Cash Journal (Required)................................................................................................1-43
Solution: Enter a Cash Journal (Required) ................................................................................................1-44
Practice - Pay Invoices in Payables (Required) .........................................................................................1-45
Solution: Pay Invoices in Payables (Required)..........................................................................................1-48
Practice - Set Up Receipt Classes ..............................................................................................................1-52
Solution: Set Up Receipt Classes (Required) ............................................................................................1-55
Practice - Enter Receipts (Required)..........................................................................................................1-58
Solution: Enter Receipts (Required) ..........................................................................................................1-60
Practice - Enter a Bank Statement (Required) ...........................................................................................1-63
Solution: Enter a Bank Statement (Required)............................................................................................1-66
Reconciling Bank Statements ........................................................................................................................1-70
Guided Demonstration - Understanding the Matching Process (Required)...............................................1-71
Practice - Reconcile your Bank Statement (Required) ..............................................................................1-74
Solution: Reconcile Your Bank Statement (Required) ..............................................................................1-77
Practice - Run Reports (Required).............................................................................................................1-80
Solution: Run Reports (Required) .............................................................................................................1-82
Cash Pools .....................................................................................................................................................1-84
Guided Demonstration - Create Notional Cash Pool .................................................................................1-85
Cash Forecasting ...........................................................................................................................................1-86
Practice - Create a Cash Forecast Template ..............................................................................................1-87
Solution: Create a Cash Forecast Template ...............................................................................................1-90
Practice - Generate a Cash Forecast ..........................................................................................................1-93
10. Solution: Generate a Cash Forecast................................................................................................1-95
Practice - Run a Cash Forecast Report ......................................................................................................1-97
Solution: Run a Cash Forecast Report .......................................................................................................1-98
Cash Positioning............................................................................................................................................1-99
Guided Demonstration - Creating Cash Position Worksheet.....................................................................1-100
Balances and Interest .....................................................................................................................................1-101
Guided Demonstration - Viewing Actual, Historical, and Projected Balances..........................................1-102
Copyright © Oracle 2010. All rights reserved.
R12.x Oracle Cash Management Fundamentals - Supplemental Practices Table of Contents

i
ii

Preface
Profile
Before You Begin This Course
• Thorough knowledge of Oracle Applications.
• Working experience with Cash Management.
Prerequisites
• There are no prerequisites for this course.
How This Course Is Organized
R12.x Oracle Cash Management Fundamentals is an instructor-led course featuring lecture and
hands-on exercises. Online demonstrations and written practice sessions reinforce the concepts
and skills introduced.

iii
Related Publications
Oracle Publications
Title Part Number
Oracle Cash Management User Guide E13483-03
Additional Publications
• System release bulletins
• Installation and user’s guides
• Read-me files
• International Oracle User’s Group (IOUG) articles
• Oracle Magazine

iv
Typographic Conventions
Typographic Conventions in Text
Convention Element Example
Bold italic Glossary term (if The algorithm inserts the new key.
there is a glossary)
Caps and Buttons, Click the Executable button.
lowercase check boxes, Select the Can’t Delete Card check box.
triggers, Assign a When-Validate-Item trigger to the ORD block.
windows Open the Master Schedule window.
Courier new, Code output, Code output: debug.set (‘I”, 300);
case sensitive directory names, Directory: bin (DOS), $FMHOME (UNIX)
(default is filenames, Filename: Locate the init.ora file.
lowercase) passwords, Password: User tiger as your password.
pathnames, Pathname: Open c:\my_docs\projects
URLs, URL: Go to http://www.oracle.com
user input,
User input: Enter 300
usernames
Username: Log on as scott
Initial cap Graphics labels Customer address (but Oracle Payables)
(unless the term is a
proper noun)
Italic Emphasized words Do not save changes to the database.
and phrases, For further information, see Oracle7 Server SQL Language
titles of books and Reference Manual.
courses, Enter [email protected], where user_id is the
variables name of the user.
Quotation Interface elements Select “Include a reusable module component” and click Finish.
marks with long names
that have only This subject is covered in Unit II, Lesson 3, “Working with
initial caps; Objects.”
lesson and chapter
titles in cross-
references
Uppercase SQL column Use the SELECT command to view information stored in the
names, commands, LAST_NAME
functions, schemas, column of the EMP table.
table names
Arrow Menu paths Select File > Save.
Brackets Key names Press [Enter].
Commas Key sequences Press and release keys one at a time:
[Alternate], [F], [D]
Plus signs Key combinations Press and hold these keys simultaneously: [Ctrl]+[Alt]+[Del]

v
Typographic Conventions in Code

Convention Element Example
Caps and Oracle Forms When-Validate-Item
lowercase triggers
Lowercase Column names, SELECT last_name
table names FROM s_emp;
Passwords DROP USER scott
IDENTIFIED BY tiger;
PL/SQL objects OG_ACTIVATE_LAYER
(OG_GET_LAYER (‘prod_pie_layer’))
Lowercase Syntax variables CREATE ROLE role

italic
Uppercase SQL commands and SELECT userid
functions FROM emp;
Typographic Conventions in Oracle Application Navigation Paths

This course uses simplified navigation paths, such as the following example, to direct you
through Oracle Applications.
(N) Invoice > Entry > Invoice Batches Summary (M) Query > Find (B) Approve
This simplified path translates to the following:
1. (N) From the Navigator window, select Invoice then Entry then Invoice Batches
Summary.
2. (M) From the menu, select Query then Find.
3. (B) Click the Approve button.
Notations:
(N) = Navigator
(M) = Menu
(T) = Tab
(B) = Button
(I) = Icon
(H) = Hyperlink
(ST) = Sub Tab

vi
Typographical Conventions in Oracle Application Help System Paths

This course uses a “navigation path” convention to represent actions you perform to find
pertinent information in the Oracle Applications Help System.
The following help navigation path, for example—
(Help) General Ledger > Journals > Enter Journals
—represents the following sequence of actions:
1. In the navigation frame of the help system window, expand the General Ledger entry.
2. Under the General Ledger entry, expand Journals.
3. Under Journals, select Enter Journals.
4. Review the Enter Journals topic that appears in the document frame of the help system
window.

vii
viii

R12.x Oracle Cash
Management Fundamentals -
Supplemental Practices
Chapter 1
Copyright © Oracle, 2010. All rights reserved.
R12.x Oracle Cash Management Fundamentals - Supplemental Practices

Chapter 1 - Page 1
Chapter 1 - Page 2
Practices
Chapter 1 - Page 3
R12.x Oracle Cash Management Fundamentals Supplemental
Oracle Cash Management Overview
Chapter 1 - Page 4
Practice - Create a New User

Overview
In this practice, you define a new user.
Assumptions
• Replace XX with your terminal number or initials.
• You must have access to an Oracle Application Vision database or comparable training
or test instance at your site on which to complete this practice.
Tasks
Sign on
Field Value
User Name OPERATIONS
Password welcome
Responsibility System Administrator
1. Navigate to the Users window.
2. Enter your user details:

Field Value
User Name XXUSER
Password welcome (tab, re-enter to
verify)
Person Stock, Ms. Pat

Chapter 1 - Page 5
3. Enter the responsibilities for this user:

Responsibility Security Group
Cash Management, Vision Operations Standard
(USA)
General Ledger, Vision Operations Standard
(USA)
Payables, Vision Operations (USA) Standard
Receivables, Vision Operations Standard
(USA)
System Administrator Standard
Human Resources, Vision Enterprises Standard
Treasury, Vision Operations (USA) Standard
4. Save. Sign on as your new user.

Chapter 1 - Page 6
Solution: Create a New User

Tasks
Sign on
Field Value
User Name OPERATIONS
Password welcome
Responsibility System Administrator
Add a User
1. Navigate to the Users window.
• (N) Security : User > Define
2. Enter your user details:

Field Value
User Name XXUSER
Password welcome (tab, re-enter to
verify)
Person Stock, Ms. Pat (click (B)
OK to the message about
the person being attached
to other responsibilities
Add Responsibilities
3. Add the following responsibilities to your new username:

Responsibility Security Group
Cash Management, Vision Operations Standard
(USA)
General Ledger, Vision Operations Standard
(USA)
Payables, Vision Operations (USA) Standard
Receivables, Vision Operations Standard
(USA)
System Administrator Standard
Human Resources, Vision Enterprises Standard
Treasury, Vision Operations (USA) Standard

Chapter 1 - Page 7
• Click (I) Save.
• Close the Form.
Log In as New User
4. (M) File > Exit Oracle Applications.
• Click (B) OK.
Click (H) Logout (upper right corner of the form).
5. Log in to the system again with your newly created User ID and password.
6. System will prompt you to create a new password.

− Current Password = welcome
− New Password = XXuser
− Re-enter New Password = XXuser
7. Click (B) Submit.

Chapter 1 - Page 8
Practice - Create GL Account Cash Values

Overview
In this practice, you set up a payment template.
Assumptions
Tasks
Set Up New GL Cash Account Values
1. Responsibility = General Ledger, Vision Operations (USA)
• (N) Setup > Financials > Flexfields > Key > Values
2. Use the following table to set up new GL accounts to be used for financial transactions:
Assigned Student Cash Cash Clearing/ Confirmed Receipts/

Number Unidentified Receipts
1 1111 1251
2 1112 1252
3 1113 1253
4 1114 1254
5 1115 1255
6 1116 1256
7 1117 1257
8 1118 1258
9 1119 1259
10 1121 1261
11 1122 1262
12 1123 1263
13 1124 1264
14 1125 1265
15 1126 1266

Chapter 1 - Page 9
16 1127 1267
17 (or Instructor) 1128 1268
3. Select the option for Value Set.
• Value Set = Operations Account
• Click (B) Find.
4. Place the cursor in the field for value and click (I) New.
• Value for Cash = Table
• Description = XX Student Cash (XX represents your assigned number)
• Flexfield Qualifiers follow:

− Allow Budgeting = Yes
− Allow Posting = Yes
− Account Type = Asset
− Reconcile = No
− Third Party Control Account = No
− Click the (B) Ok
• Click (I) Save.
5. Repeat the previous steps to add the value for “Cash Clearing/Confirmed
receipts/Unidentified Receipts.” (Change the description to XXStudent Clearing Cash; XX
represents your assigned number.)
6. When you close the window to return to the Navigator, click (B) OK in the dialog box.

Chapter 1 - Page 10
Solution: Create GL Cash Accounts

Set Up New GL Cash Account Values
1. 1. Responsibility = General Ledger, Vision Operations (USA)
• (N) Setup >Financials > Flexfields > Key > Values
2. Use the following table to set up new GL accounts to be used for financial transactions:
Assigned Student Cash Cash Clearing/ Confirmed Receipts/

Number Unidentified Receipts
1 1111 1251
2 1112 1252
3 1113 1253
4 1114 1254
5 1115 1255
6 1116 1256
7 1117 1257
8 1118 1258
9 1119 1259
10 1121 1261
11 1122 1262
12 1123 1263
13 1124 1264
14 1125 1265
15 1126 1266
16 1127 1267
17 (or Instructor) 1128 1268
3. Select the option for Value Set.
• Value Set = Operations Account
• Click (B) Find.

Chapter 1 - Page 11
4. Place the cursor in the field for value and click (I) New.
• Value for Cash = Table
• Description = XX Student Cash (XX represents your assigned number.)
• Flexfield Qualifiers follow:

− Allow Budgeting = Yes
− Allow Posting = Yes
− Account Type = Asset
− Reconcile = No
− Third Party Control Account = No
− Click (B) OK.
• Click (I) Save.
5. Repeat the previous steps to add the value for “Cash Clearing/Confirmed
receipts/Unidentified Receipts.” (Change the description to XX Student Clearing Cash; XX
represents your assigned number.)
6. When you close the window to return to the Navigator, click (B) OK in the dialog box.

Chapter 1 - Page 12
Cash Management Security
Chapter 1 - Page 13
Guided Demonstration - Create Security Profile

Overview
In this guided demonstration, we create a security profile.
Responsibility: Human Resources, Vision Enterprises
1. Log in using:
− User Name: operations
− Password: welcome
Note: You can use the User ID and Password created in the prior lab.
2. (N) Human Resources, Vision Enterprises.
3. (N) Security > Profile.
4. In the Security Profile window, enter the following information:

Field Name Value
Name XXPayroll
Business Group Vision Corporation
View Employees All
View Contingent Workers All
View Applicants All
View Contacts All
View Candidates All
5. On the Organization Security tab, enter the following information:

Field Name Value
Security Type Secure organizations by organization hierarchy and/or organization list
Classification Operating Unit
Organization Name Vision Operations
6. Click (I) Save.
7. Navigate to (M) View > Requests.
8. Select (B) Submit a New Request.
9. Click (B) OK.

Chapter 1 - Page 14
10. In the Submit Requests window, enter Security List Maintenance in the Name field and
enter the following parameters:
− Generate Lists for: One Named Security Profile
− Security Profile: XXPayroll
− Process: Current and Terminated people
11. Click (B) OK.
Note: Do nit submit another request.
13. Click (M) View > Requests (B) Find.
14. Confirm the process completed normally.
15. Close all windows and return to the Navigator.

Chapter 1 - Page 15
Guided Demonstration - Create Security Grants

Overview
In this guided demonstration, we create security grants using the CE UMX Security Wizard.
Responsibility: User Management
1. Log in using:
− User Name: sysadmin
− Password: sysadmin
2. (N) User Management.
3. (N) Roles and Role Inheritance
4. Enter Cash Management in the Name field and click (B) Go.
5. Click (I) Update for the Cash Management, Vision Operations (USA) role.
6. Click (B) Security Wizards (category should be Miscellaneous) in the Update Role: Cash
Management, Vision Operations (USA) page,.
7. Click (I) Run Wizard for CE UMX Security Wizard.
8. Click (B) Add Legal Entities. Select and add the following legal entities:
− Vision Operation (add if it is not displayed)
− Vision Corporation
9. For Vision Operations, select Use, Maintenance, and Bank Account Transfers check boxes
to grant Cash Management, Vision Operations (USA) access to view all bank accounts in
this legal entity, ability to create and update bank accounts, and the ability to reconcile bank
accounts.
For Vision Corporation, select the Use check box only. This role will only be able to view
and reconcile bank statement lines for cashflows for this legal entity.

Chapter 1 - Page 16
10. Click (B) Apply.
Chapter 1 - Page 17
Creating Bank Accounts
Chapter 1 - Page 18
Practice - Create an Internal Bank Account
Overview
In this practice, you create a bank account.
Assumptions
Tasks
Responsibility: Cash Management, Vision Operations (USA)
Create a Bank
1. Navigate to Manage Banks and Branches.
2. Create a new bank and enter the following data:

Field Name Value
Country United States
Bank Name XXBank
3. On the bank address page, enter the following data:

Field Name Value
Address Line 1 1 Main Street
City San Francisco
County San Francisco
State CA
Postal Code 94105
Status Active
Create a Bank Branch
4. Create a bank branch for the created bank.

− Country = United States
− Bank Name = XXBank

Chapter 1 - Page 19
5. Enter the following bank branch data:

Field Name Value
Branch Name XXBranch
Branch Type ABA
Create Bank Account
6. Navigate to the Manage Bank Accounts window.
7. Create a bank account with the following data.

Field Name Value
Bank Name XXBank
Bank Branch XXBranch
8. Define the Account Owner and Use information.

− Bank Account Owner = Vision Operations
− Account Use
− Payables = Checked
− Receivables = Checked
9. Enter the following information on the Account Information page:

Field Name Value
Account Name XXDisbursement/Deposit
Account Number XX-1234-5678
Currency USD
Use Multiple Currencies Checked
Account Type Checking
Description Cash Disbursement Account
10. Enter the following information in the General Controls section of the Account Controls
page:
Field Name Value
Cash (will have to create, click magnifying glass) 01-000-Table-0000-000
Bank Charges 01-720-7870-0000-000
Foreign Exchange Charges 01-000-2580-0000-000
Netting Account No
Cash Clearing (will have to create, click magnifying glass) 01-000-Table-0000-000
Bank Errors 01-720-7870-0000-000

Chapter 1 - Page 20
11. Enter the following information in the Payables Controls section of the Account Controls
page:
Field Name Value
Multiple Currency Payments Checked
Allow Zero Payments Not Checked
Pooled Account Not Checked
Maximum Outlay 1,000,000.00
Minimum Payment 5.00
Maximum Payment 200,000.00
12. Enter the following information in the Reconciliation Controls section:

Field Name Value
Payables Matching Order 1 Transaction
Payables Matching Order 2 Batch
Receivables Matching Order Batch
13. Enter the following information in the Auto Reconciliations Payments section:
Field Name Value
Tolerance Amount 100.00
Tolerance Percentage 10
14. Click (B) Add Organization Access.

− Account Use
− Organization = Vision Operations
15. Set up the Accounts for Receivables:

Field Name Value
Factored Receipts 01-000-1245-0000-000
BR Short Term Debt 01-000-2110-0000-000
Unidentified Receipts 01-000-Table-0000-000
Confirmed Receipts 01-000-Table-0000-000
Remitted Receipts 01-000-1245-0000-000
AR Short Term Debt 01-000-2110-0000-000
Unapplied Receipts 01-000-1240-0000-000
On Account Receipts 01-000-1240-0000-000
Unearned Discounts Unearned Discounts

Chapter 1 - Page 21
Earned Discounts Earned Discounts

Claimed Investigation Claim Investigation
Create Payment Documents
16. In the Manage Bank Accounts window, query and select the bank account you created.
17. Create a Check stock using the following information.
− Name = XXAP Check Stock
− Paper Stock Type = Prenumbered Stock
− Format = External Check Format
− First Available Document Number = 1000
− Last Available Document Number = 1100
Set Up the Second Bank Account
18. Create a second bank account with the following data:

Field Name Value
Bank Name XXBank

− Account Use
Field Name Value

nd
Account Name XX2 Account
Account Number XX-9876
Currency USD
Use Multiple Checked
Currencies
page:
Field Name Value

Chapter 1 - Page 22
Cash 01-000-Table-0000-000
Bank Charges 01-720-7870-0000-000
Netting Account No
Cash Clearing 01-000-Table-0000-000
Bank Errors 01-720-7870-0000-000

− Account Use

Chapter 1 - Page 23
Solution: Create an Internal Bank Account

Create a Bank
1. Navigate to Manage Banks and Branches.
• (N) Setup > Banks: Banks
2. Click (B) Create.
3. Select Create a New Bank and enter the following data:

Field Name Value
Bank Name XXBank
4. Click (B) Save and Next.
5. On the Create Bank: Bank Address page, click (B) Create.
6. Enter the following data:

Field Name Value
Address Line 1 1 Main Street
City San Francisco
County San Francisco
State CA
Postal Code 94105
Status Active
7. Click (B) Apply.
8. Click (B) Finish
Create a Bank Branch
9. Click (T) Bank Branches.
11. Enter the following Bank Branch Information:

− Country = United States

Chapter 1 - Page 24
12. Click (B) Continue.
13. Select the Create New Branch option.
14. Enter the following bank branch data:
Field Name Value
Branch Name XXBranch
Branch Type ABA
15. Click (B) Finish.
Create Bank Account
16. Navigate to the Home page, and then navigate to the Manage Bank Accounts window.
• (L) Home
• (N) Setup > Banks: Bank Accounts
18. Enter the following data.

Field Name Value
Bank Name XXBank

− Account Use
21. Click (B) Next.

Field Name Value
Account Name XXDisbursement/Deposit
Account Number XX-1234-5678
Currency USD

Chapter 1 - Page 25
Use Multiple Currencies Checked

page:
Field Name Value
Cash (will have to create, click magnifying glass) 01-000-Table-0000-000
Bank Charges 01-720-7870-0000-000
Netting Account No
Cash Clearing (will have to create, click magnifying glass) 01-000-Table-0000-000
Bank Errors 01-720-7870-0000-000
25. Enter the following information in the Payables Controls section of the Account Controls
page:
Field Name Value
Multiple Currency Payments Checked
Allow Zero Payments Not Checked
Pooled Account Not Checked
Maximum Outlay 1,000,000.00
Minimum Payment 5.00
Maximum Payment 200,000.00
26. Enter the following information in the Reconciliation Controls section:

Field Name Value
Payables Matching Order 1 Transaction
Payables Matching Order 2 Batch
Receivables Matching Order Batch
27. Enter the following information in the Auto Reconciliations Payments section:
Field Name Value
Tolerance Amount 100.00
Tolerance Percentage 10

Chapter 1 - Page 26

− Account Use
31. Set up the Accounts for Receivables:
Field Name Value
Factored Receipts 01-000-1245-0000-000
BR Short Term Debt 01-000-2110-0000-000
Unidentified Receipts 01-000-Table-0000-000
Confirmed Receipts 01-000-Table-0000-000
Remitted Receipts 01-000-1245-0000-000
AR Short Term Debt 01-000-2110-0000-000
Unapplied Receipts 01-000-1240-0000-000
On Account Receipts 01-000-1240-0000-000
Unearned Discounts Unearned Discounts
Earned Discounts Earned Discounts
Claimed Investigation Claim Investigation
32. Review the GL Accounts for Payables
Create Payment Documents
36. In the Manage Bank Accounts window, query the bank account you created.
− (N) Setup > Banks : Bank Accounts
− Account Name = XXDisbursement/Deposit
− Click (B) Go.
37. Select the option for your bank account and click (B) Manage Payment Documents.
39. Create a Check stock using the following information.

− Name = XXAP Check Stock

Chapter 1 - Page 27
− Paper Stock Type = Prenumbered Stock

− Format = External Check Format
− First Available Document Number = 1000
− Last Available Document Number = 1100
Set Up the Second Bank Account
41. (H) Bank Accounts (on the left side near the top of the form)
43. Enter the following data:

Field Name Value
Bank Name XXBank

− Account Use
46. Click (B) Next.
Field Name Value

Account Name XX2nd Account
Account Number XX-9876
Currency USD
Use Multiple Checked
Currencies
48. (B) Save and Next
page:

Chapter 1 - Page 28
Field Name Value

Cash 01-000-Table-0000-000
Bank Charges 01-720-7870-0000-000
Netting Account No
Cash Clearing 01-000-Table-0000-000
Bank Errors 01-720-7870-0000-000

− Account Use
55. Click (H) Home.

Chapter 1 - Page 29
Practice - Set up Bank Transaction Codes

Overview
In this practice, you set up Bank Transaction Codes.
Assumptions
• Replace XX with your terminal number.
Tasks
Set Up Bank Transaction Codes
Bank Transaction Codes
1. Responsibility = Cash Management, Vision Operations (USA)
2. Navigate to the Bank Transaction Codes window.
3. Select the XXDisbursement/Deposit bank account for which to set up the transaction code.
4. In the Bank Transaction Codes window, enter transaction types and codes according to the
following table.
Type Code Description Trans. Recon. Match. Corr. Create Activity Receipt
Source Sequence Against Method Class
Method
Paym 100 Regular AP 1
ent Payment Paymen
ts
Misc 110 Bank 2 Misc
Paym Charges
ent
Misc 115 Correction 3 Stmt Both
Paym
ent
Paym 120 Journal Journal 4
ent Payment
Paym 130 EFT/Wire AP 5
ent Payment Paymen

Chapter 1 - Page 30
Method
ts
Recei 200 Regular AR 6
pt Receipt Receipt
s
Misc 210 Misc 7 Misc
Recei Receipt
pt
Recei
pt
Recei 220 Journal Journal 9
pt Receipt
Misc 310 Interest 10 Misc Yes Interest XXCash
Recei Income Misc
pt
Rejec 600 Rejected 11
ted
Stopp 700 Stopped AP 12
ed Paymen
ts
NSF 800 NSF 13
Note: The float handling parameter (in the System Options window) specifies whether to
reconcile statement lines with effective dates later than the current date. The number of days
greater than the current date to look for can be specified in the Float field.

Chapter 1 - Page 31
Solution: Set up Bank Transaction Codes (Required)

Tasks
Set Up Bank Transaction Codes
Bank Transaction Codes
2. Navigate to the Bank Transaction Codes window:
• (N) Setup > Banks > Bank Transaction Codes
3. Select XXDisbursement/Deposit bank account.
4. In the Bank Transaction Codes window, enter transaction types and codes according to the
following table.
Method
Pay 100 Regular AP 1
ment Payment Payme
nts
Misc 110 Bank 2 Misc
Pay Charges
ment
Pay
ment
Pay 120 Journal Journal 4
ment Payment
Pay 130 EFT/Wire AP 5
ment Payment Payme
nts
Rece 200 Regular AR 6
ipt Receipt Receipt
s
Misc 210 Misc 7 Misc
Rece Receipt
ipt
Rece

Chapter 1 - Page 32
Method
ipt
Rece 220 Journal Journal 9
ipt Receipt
Misc 310 Interest 10 Misc Yes Interest XXCashMis
Rece Income c
ipt
Reje 600 Rejected 12
cted
Stop 700 Stopped AP 13
ped Payme
nts
NSF 800 NSF 14
5. Click (I) Save.
Note: The float handling parameter (in the System Options window) specifies whether to
reconcile statement lines with effective dates later than the current date. The number of days
greater than the current date to look for can be specified in the Float field.

Chapter 1 - Page 33
Bank Transfers
Chapter 1 - Page 34
Practice - Create a Bank Transfer

Overview
In this practice, you create a bank transfer.
Assumptions
Tasks
Create a Transaction Subtype
Create a Payment Template
Create a Bank Transfer

Chapter 1 - Page 35
Solution: Create a Bank Transfer

Create a Transaction Subtype
1. Navigate to the Cash Transaction Subtypes page.
• (N) Setup > System > Transaction Subtype
2. Click (B) Create and enter the following data.

Field Name Value
Subtype Name XX Transportation Expense
3. Click (B) Apply.
4. Close the window.
Create a Payment Template
5. Navigate to the Payment Templates page.
• (N) Setup > System > Payment Template

Field Name Value
Template Code XX Template One
Transaction Subtype Name XX Transportation Expense
Repetitive Code No
Currency USD
Transfer Amount 1000
Source Bank Account Number XX-1234-5678
Destination Bank Account Number XX-9876
7. Click (B) Apply.
Create a Bank Transfer
9. Navigate to the Bank Account Transfers page.
• (N) Bank Account Transfers

Chapter 1 - Page 36
10. Click (B) Create and select the following data.

Field Name Value
Transaction Subtype Name XX Transportation Expense
Payment Template XX Template One
Transfer Date Current Date
Transfer Amount (should 1000
default)
Source Bank Accoutn XX-1234-5678
(should default )
Destination Bank (should XX-9876
default)
11. (T) Payment Details
• Payment Method = Check
Close all windows and return to the Navigator
Note: Next logical step would be to validate the transfer.

Chapter 1 - Page 37
Practice - Set Up a Transaction Subtype

Overview
In this practice, you set up a transaction subtype.
Assumptions
Tasks
Set Up a Transaction Subtype
1. Responsibility = Cash Management, Vision Operations (USA).
2. Navigate to the Cash Transaction Subtype page using the Setup: System menu.
4. Enter the Subtype Name.
5. Click (B) Apply.

Chapter 1 - Page 38
Solution: Set Up a Transaction Subtype

Set Up a Transaction Subtype
2. Navigate to the Cash Transaction Subtype page using the Setup: System: Transaction
Subtype menu.

Field Name Value
Subtype Name XXBASubtype
Description Transaction
subtype to be used
for bank account
transfers.
4. Click (B) Apply.
5. Close the window

Chapter 1 - Page 39
Practice - Set Up a Payment Template

Overview
In this practice, you set up a payment template.
Assumptions
Tasks
Set Up a Payment Template
1. Responsibility = Cash Management, Vision Operations (USA).
2. Navigate to the Payment Templates page using the Setup: System menu.
4. Select the Template Code and Currency.
5. Select the Source Bank Account Number and the Destination Bank Account Number.
6. Click (B) Apply.

Chapter 1 - Page 40
Solution: Set Up a Payment Template

Set Up a Payment Template
2. Navigate to the Payment Templates page using Setup: System: Payment Template.
3. Click (B) Create and enter the following data:

Field Name Value
Template Code XXBASubtype
Currency USD
Source Bank XX-124-5678
Account Number
Destination Bank XX-9876
Account Number
4. Click (B) Apply.

Chapter 1 - Page 41
Managing Bank Statements
Chapter 1 - Page 42
Practice - Enter a Cash Journal (Required)

Overview
In this practice, you create a journal entry to establish a cash balance.
Assumptions
Tasks
Enter a Journal
2. Navigate to the Enter Journals window.
• (N) Journals > Enter
3. Click (B) New Journal.

− Journal = XXEstablish Cash Balance
− Period = Current period
− Effective Date = Yesterday’s Date
− Category = Balance Forward
− Currency = Use default currency
4. Enter the following journal.
Line Account Debit Credit Description

10 01-000-Table-0000-000 5000 XX
20 01-000-3200-0000-000 5000 Equity
Note: Replace “Table” with your cash account.
5. Click (I) Save.
6. Click (B) Post.

Chapter 1 - Page 43
Solution: Enter a Cash Journal (Required)

Tasks
Enter a Journal
2. Navigate to the Enter Journals window.
• (N) Journals > Enter
3. Click (B) New Journal.

− Journal = XXEstablish Cash Balance
− Period = Current period
− Effective Date = Yesterday’s Date
− Category = Balance Forward
− Currency = Use default currency
4. Enter the following journals:
Line Account Debit Credit Description

10 01-000-Table-0000-000 5000 XX
20 01-000-3200-0000-000 5000 Equity
Note: Replace “Table” with your cash account.
5. Click (I) Save.
6. Click (B) Post.

Chapter 1 - Page 44
Practice - Pay Invoices in Payables (Required)

Overview
In this practice, you pay invoices in the Payables application.
Assumptions
Tasks
Enter invoices to be paid by a regular payment
1. Responsibility = Payables, Vision Operations (USA).
2. Navigate to the Invoices window:
• (N) Invoices > Entry > Invoices

− Type = Standard
− Trading Partner = Capp Consulting
− Site – CAPP CONSULTING (Click (B) OK to the message about the
Prepayment.)
− Date = Yesterday’s Date
− Invoice Num = XX-1
− Invoice Amount = 1627.50
− Terms = Immediate
− Payment Method = Check
3. Click (T) Lines

− Amount = 1500
− Distribution Account = 01-110-7110-0000-000
− Note: System should generate the tax of 127.50 during the validation. If the tax is
not generated, add a second line to the invoice as an item and use the same
distribution account.
4. Click (I) Save.

Chapter 1 - Page 45
5. Repeat the above steps to enter the following invoices. Verify that your invoice numbers and
amounts are the same as the following table:
Invoice Invoice Terms Payment Line Item Account

Num Amount Method Amount
XX-2 2712.50 Immediate Check 2500.00 01-110-7110-0000-000
XX-4 5425 Immediate Check 5000.00 01-110-7110-0000-000
− Note: System should generate the taxes during the validation. If the tax is not
generated, just add the difference as a second item line to the invoice item and use
the same distribution account.
Validate invoices
6. Select all invoices.
• Select (M) Edit > Select All.
7. Click (B) Actions.

− Validate = Checked
8. Click (B) OK.
9. Check to make sure that all invoices are validated.
Generate accounting
10. To generate accounting, select all invoices first:

− Create Accounting = Checked
− Final Post = Selected
• Click (B) OK.
12. Click (B) OK.
Pay Each Invoice Separately
13. Pay Each Invoice Separately

− In the Invoices window, select the first invoice.

Chapter 1 - Page 46

− Pay in Full = Checked
15. Click (B) OK.

− Type field = Quick
− Payment Date = Yesterday’s Date
− Bank Account = XX Disbursement/Deposit
− Payment Document = XX AP Check Stock
− Payment Process = Long Check Format
−

17. Click (B) OK.
18. Save
19. Close the Payments window.
20. Save
21. Repeat the above steps for the remaining invoices.

Chapter 1 - Page 47
Solution: Pay Invoices in Payables (Required)

Tasks
Enter Invoices to Be Paid by a Regular Payment
1. Responsibility = Payables, Vision Operations (USA).
2. Navigate to the Invoices window:
• (N) Invoices > Entry > Invoices

− Type = Standard
− Trading Partner = Capp Consulting (Click (B) OK to the message about the
prepayment.)
− Site = CAPP CONSULTING
− GL Date = Yesterday’s Date
− Invoice Num = XX-1
− Invoice Amount = 1627.50
− Terms = Immediate
3. Click (T) Lines

− Amount = 1500
− Distribution Account = 01-110-7110-0000-000
Note: Tax will be generated at the time of validation. If the tax is not
automatically generated, then add an extra line for the tax amount. .
4. Click (I) Save.
5. Repeat above steps to enter the following invoices. Verify that your invoice numbers and
amounts are the same as the following table:


Chapter 1 - Page 48

XX-4 5425 Immediate Check 5000.00 01-110-7110-0000-000

Chapter 1 - Page 49
Validate invoices
6. Select all invoices.

− Validate = Checked
8. Click (B) OK.
9. Check to make sure that all invoices are validated.
Generate accounting
10. To generate accounting, select all invoices first:

• Click (B) OK.
12. Click (B) OK.
Pay Each Invoice Separately
13. Pay Each Invoice Separately

− In the Invoices window, select the first invoice.

− Pay in Full = Checked
15. Click (B) OK.

− Type field = Quick
− Payment Date = Yesterday’s Date
− Bank Account = XXDeposit/Disbursement

Chapter 1 - Page 50

− Payment Document = XX AP Check Stock
− Payment Process Profile = Long Check Format

• Click (B) OK.
17. Click (B) OK.
18. Close the Payments window.
19. Repeat the above steps for the remaining invoices
When finished paying all the checks, close the windows and return to the Navigator..

Chapter 1 - Page 51
Practice - Set Up Receipt Classes

Overview
In this practice, you set up Bank Transaction Codes and Receipt Classes.
Assumptions
Tasks
Set Up Receipt Classes
A. Set up Miscellaneous Receipt Class
1. Create the XXCashMisc Receipt Class Method.
2. Responsibility = Receivables, Vision Operations (USA)
3. Navigate to the Bank Transaction Codes window.
4. Enter the following fields in the Receipt Class region:

− Name = XXCashMisc
− Creation Method = Manual
− Remittance Method = No Remittance
− Clearance Method = By Matching
5. Enter the following fields in the Receipt Method region:

− Printed Name = XXCashMisc
− Effective Dates = Yesterday’s Date
6. Associate XXDisbursement/Deposit bank account with this Receipt Method.
• Click (B) Bank Accounts.
7. Enter the following fields in the Remittance Banks window:
• Click (I) New.

− Operating Unit = Vision Operations
− Branch Name = XXBranch

Chapter 1 - Page 52
• Click (T) GL Accounts

− Cash = 01-000-Table-0000-000
− Receipt Confirmed = 01-000-Table-0000-000
− Bank Charges = 01-720-7870-0000-000
− Unapplied Receipts = 01-000-1240-0000-000
− Unidentified Receipts = 01-000-Table-0000-000
− On Account Receipts = 01-000-1240-0000-000
− Unearned Discounts = Unearned Discounts
− Earned Discounts = Earned Discounts
− Claim Investigations = Claim Investigation
B. Set up Cash Receipt Class
10. Enter following fields in the Receipt Class region:

− Name = XXCash
− Remittance Method = Standard
11. Enter following fields in the Receipt Method region:

− Name = XXCheck
− Printed Name = XXCheck
• Click (I) New.

− Bank Name = XXBANK

− Cash = 01-000-Table-0000-000
− Receipt Confirmation = 01-000-Table-0000-000
− Remittance = 01-000-1245-0000-000

Chapter 1 - Page 53
− Bank Charges = 01-720-7870-0000-000


Chapter 1 - Page 54
Solution: Set Up Receipt Classes (Required)

Tasks
Set Up Receipt Classes
A. Set up Miscellaneous Receipt Class
1. Create the XXCashMisc Receipt Class Method.
• (N) > Setup > Receipts > Receipt Classes
4. Enter the following fields in the Receipt Class region:

− Remittance Method = No Remittance
5. Enter the following fields in the Receipt Method region:

− Printed Name = XXCashMisc
6. Click (I) Save.
• Click (I) New


− Cash = 01-000-Table-0000-000
− Receipt Confirm = 01-000-Table-0000-000
− Bank Charges = 01-720-7870-0000-000

Chapter 1 - Page 55

9. Click (I) Save.
B. Set up Cash Receipt Class
• (N) > Setup > Receipts > Receipt Classes
11. Enter following fields in the Receipt Class region:

− Name = XXCash
12. Enter the following fields in Receipt Method region:

− Name = XXCheck
− Printed Name = XXCheck
13. Click (I) Save.
• Click (I) New.

− Batch Date = Yesterday’s Date
• Click (T) GL Accounts.

− Cash = 01-000-Table-0000-000
− Receipt Confirmation = 01-000-Table-0000-000
− Remittance = 01-000-1245-0000-000

Chapter 1 - Page 56
− Bank Charges = 01-720-7870-0000-000

16. Click (I) Save.

Chapter 1 - Page 57
Practice - Enter Receipts (Required)

Overview
In this practice, you enter receipts.
Assumptions
Tasks
Enter Receipts
2. Navigate to the Receipts window:
• (N) Receipts > Receipts

− Receipt Method = XXCheck
− Receipt Date = Yesterday’s Date
− Maturity Date = Yesterday’s Date
− Receipt Number = RXX-1
− Receipt Amount = 3000
− Customer Name = Business World (1608).
3. Click (I) Save.
4. Repeat the above steps to enter receipts #2 and #3. Verify that your receipts and amounts are
the same as the following table:
Invoice Num Amount

RXX-2 4000
RXX-3 5000
Enter and Approve a Remittance Batch
5. Navigate to the Remittances window:
• (N) Receipts > Remittances

− Batch Type = Remittance

Chapter 1 - Page 58
− Batch = Yesterday’s Date

− GL = Yesterday’s Date
− Receipt Class = XXCash
− Bank = XXBank
− Branch = XXBranch
− Account Number = XX-01
− Deposit Number = DEPXX (This is case-sensitive.)
6. Click (B) Manual Create.
7. Click (T) Main.
8. Query your receipts.
(Hint: [F11], XX% in Receipt Method field, [Ctrl + F11])
9. Select the check boxes to the left of your receipt numbers.
• Click (B) Format.
• Click (B) Yes.
• Click (B) OK.
10. Monitor your Request.
• Select (M) View > Requests.
• Click (B) Find.
11. Select Automatic Remittances Creation Program.
• Click (B) View Output.
12. Verify 3 Remittances for a total of 12,000.

Chapter 1 - Page 59
Solution: Enter Receipts (Required)

Tasks
Enter Receipts
2. Navigate to the Receipts window:
• (N) Receipts > Receipts

− Receipt Date = Yesterday’s Date
− Maturity Date = Yesterday’s Date
− Receipt Number = RXX-1
− Receipt Amount = 3000
− Customer Name = Business World (1608).
3. Click (I) Save.
4. Repeat the above steps to enter receipts #2 and #3. Verify that your receipts and amounts are
the same as the following table:
5.
Invoice Num Amount

RXX-2 4000

Chapter 1 - Page 60
RXX-3 5000
Enter and Approve a Remittance Batch
6. Navigate to the Remittances window:
• (N) Receipts > Remittances
− Batch Type = Remittance
− Batch Date = Yesterday’s Date
− Receipt Class = XXCashReceipts
− Bank = XXBank
− Branch = XXBranch
− Account Number = XX-01
− Deposit Number = DEPXX (this is case sensitive!)
7. Click (B) Manual Create.
8. Select (T) Main.
9. Query your receipts. (Hint: [F11], XX% in Receipt Method field, [Ctrl + F11])

Chapter 1 - Page 61
10. Select the check boxes to the left of your receipt numbers.
• Click (B) Format.
• Click (B) Yes.
• Click (B) OK.
11. Monitor your Request.
• Click (B) Find.
12. Select Automatic Remittances Creation Program.
13. Verify 3 Remittances for a total of 12,000.

Chapter 1 - Page 62
Practice - Enter a Bank Statement (Required)

Overview
In this practice, you enter the following Bank Statement:
Trans Date Trans Description Amt Balance Comment
Num
01-XXX-YY Beginning 0 Beginning Balance
Balance
01-XXX-YY Deposit (GL 5000 5000 Journal entry
Journal)
DD-Mon-YY DEPXX Deposit 12000 17000 Normal deposit
DD-Mon-YY 1000 Payment 1727.50 15272.50 Bank mistake should be
1500
DD-Mon-YY 1000 Correction -100 15372.50 Correction of bank
mistake
DD-Mon-YY 1001 Payment 2712.50 12660 Normal payment
DD-Mon-YY 1002 Payment 3797.50 8862.50 Normal payment
DD-Mon-YY Bank Charge 50 8812.50 Bank charge added
manually
DD-Mon-YY Interest Earned 100 8912.50 Interested added
automatically
DD-Mon-YY 4 Payment 5425 3487.50 Original payment 5000
28-XXX-YY Ending Balance 3487.50 Ending Balance
Assumptions
Tasks
Enter a Bank Statement
2. Navigate to the Reconcile Bank Statements window:

Chapter 1 - Page 63
• (N) Bank Statements > Bank Statements and Reconciliation
• Click (B) New.

− Account Number = XX-1234-5678
− Date = Yesterday’s date
− Statement Number = Accept the default
3. In the Control Totals region, enter the control totals based on your bank statement.
− Opening Balance = 0
− Receipts = 17100
− Payments = 1361250
− Closing Balance = 3487.50
4. Enter Bank Statement Lines.
• Click (B) Lines.
• Click (B) New.
Line Type Code Trans Amount Description

Num
1 Receipt 220 XX 5000 Deposit (GL
Journal)
2 Receipt 200 DEPXX 12000 Deposit
3 Payment 100 1000 1727.50 Payment
4 Misc 115 1000 -100 Correction
Payment
7 Misc 110 50 Bank Charge
Payment
8 Misc 310 100 Interest
Receipt Earned
9 Payment 100 1003 5427 Payment
5. Click (I) Save.
Run the Cash in Transit Report
6. Navigate to the Request Submission window.
• (N) Other > Concurrent
7. Click (B) Submit a New Request.

Chapter 1 - Page 64
8. Click (B) OK to submit a single request.

− Name = Cash in Transit Report
− Bank Account Number = XX, XXDisbursement/Deposit
− Transaction Type = All
− GL Date = Accept default
9. Click (B) OK.
Note: Do not submit another request.
11. Close forms until you are back in the Navigator.
12. View the Cash in Transit Report.
• Click (B) Find.
13. Select the Cash in Transit Report.
Note: After these items are cleared and reconciled, they will no longer display in the Cash
in Transit Report.

Chapter 1 - Page 65
Solution: Enter a Bank Statement (Required)

Tasks
Enter a Bank Statement
2. Navigate to the Reconcile Bank Statements window:
• Click (B) New.

− Date = Yesterday’s Date
− Statement Number = Accept the default
3. In the Control Totals region, enter control totals based on your bank statement.
− Opening Balance = 0
− Receipts = 17100
− Payments = 1361250
4. Enter Bank Statement Lines.
• Click (B) Lines.

Num
1 Receipt 220 XX 5000 Deposit (GL
Journal)

Chapter 1 - Page 66

Num
2 Receipt 200 DEPXX 12000 Deposit
4 Misc 115 1000 -100 Correction
Payment
7 Misc 110 50 Bank Charge
Payment
8 Misc 310 100 Interest
Receipt Earned
5. Click (I) Save.
Run the Cash in Transit report
6. Navigate to the Request Submission window.
• (N) Other > Concurrent
7. Click (B) Submit a New Request.

− Name = Cash in Transit Report
− Bank Account Number = XX, XXDisbursement/Deposit
− Transaction Type = All

Chapter 1 - Page 67
− GL Date = Accept Default
9. Click (B) OK.
11. Click (B) Find.
12. (B) Refresh until the request completes
13. Select Cash in Transit Report.
Note: After these items are cleared and reconciled, they will no longer display in the Cash
in Transit report.

Chapter 1 - Page 68
Chapter 1 - Page 69
Reconciling Bank Statements
Chapter 1 - Page 70
Guided Demonstration - Understanding the Matching Process

(Required)
Overview
In this demonstration, you learn about the matching process.
Assumptions
Tasks
Understanding the Matching Process
1. Understanding the Matching Process in Payables
The Oracle Cash Management AutoReconciliation program fully matches Oracle Payables
transactions against bank statement lines if the transactions meet the following criteria:
• The transaction currency is the same as the bank statement line currency.
• For payment batches (such as EFT batches), the reference or payment batch name
matches the statement line transaction number, and the transaction amount is within the
reconciliation tolerance.
• For the detail payment transactions and stopped transactions, the matching sequence is
the same. First the program tries to match against the invoice number and supplier bank
account, and then just the invoice number, and finally the payment number. Also, the
transaction amount is within the reconciliation tolerance.
• For stopped transactions, the payment must first be stopped or voided in Oracle
Payables.
2. Understanding the Matching Process in Receivables
The Oracle Cash Management AutoReconciliation program fully matches Oracle

Receivables transactions against bank statement lines if the transactions meet the following
criteria:
• The transaction currency is the same as the bank statement line currency.

Chapter 1 - Page 71
• For remittance batches (such as direct debit batches), the remittance batch deposit
number or receipt batch name matches the statement line transaction number, and the
transaction amount is within the reconciliation tolerance.
• For detail remittance transactions, NSF, and rejected transactions, the matching
sequence is the same. First the program tries to match against the invoice number and
customer bank account, and then just the invoice number, and finally the receipt
number. Also, the transaction amount is within the reconciliation tolerance.
• For NSF or rejected transactions, the receipt must first be reversed in Oracle
Receivables.
3. Understanding the matching process for Miscellaneous Transactions
The Oracle Cash Management AutoReconciliation program matches miscellaneous

transactions if the transactions meet the following criteria:
• If the transaction type matches to regular miscellaneous transactions:
• The transaction amount is within the reconciliation tolerance.
• The receipt number matches the statement line transaction number.
• If the transaction type matches to correction statement lines:
• For reversal corrections, the statement line has the same transaction number, same
amount, and opposite transaction type (for example, miscellaneous receipt and
miscellaneous payment).
• For adjustment corrections, the statement line has the same transaction number, and
has a transaction type of payment, receipt, miscellaneous payment, or miscellaneous
receipt, and the net amount is within the reconciliation tolerance.

Chapter 1 - Page 72
4. Understanding the matching process for general ledger
The Oracle Cash Management AutoReconciliation program matches Oracle General Ledger
journal transactions if the transactions meet the following criteria:
• The journal line is posted.
• The journal line description matches the statement line transaction number.
5. Understanding the matching process for Cash Management Cash Flows
• Bank Reference Number in cash flow matches the statement line transaction number.
• The transaction amount is within the reconciliation tolerance.

Chapter 1 - Page 73
Practice - Reconcile your Bank Statement (Required)

Overview
In this practice, you reconcile your Bank Statement.
Assumptions
• Instructor will set Matching Order (System Parameters) to Batch for Receivables and
Transaction for Payables. Instructor will also set Tolerances for Percent to 1 and
Amount to 5 (System Parameters, (T) AutoReconciliation) and AP Tolerances
Differences to Errors.
Tasks
Use the AutoReconciliation Program to Reconcile Your Bank Account Statement
1. Navigate to the Submit Request window:
• (N) Other > Programs > Run
− Request Name = AutoReconciliation
− Select the parameters according to the following table:
Parameter Value
Bank Branch Name XX Branch
Bank Account Number XX-1234-5678
Statement Number From Leave Blank
Statement Number To Leave Blank
Statement Date From Leave Blank
Statement Date To Leave Blank
GL Date Accept the default
Organization Vision Operations (Operating
Unit)
Receivable Activity
Payment Method Leave Blank
NSF Handling No Action

Chapter 1 - Page 74
3. Click (B) OK to close the Parameters window.
5. Review the Results of AutoReconciliation.
• Click (B) Find.
6. Select AutoReconciliation Execution Report.
• Click (B) View Output and verify results.
View Status of Bank Statement Lines
7. Navigate to the Bank Statement window:
8. Select (M) View > Find.

9. Click (B) Review to view the status of your bank reconciliation.
10. Click (B) Lines.
11. Click (B) Reconciled.

− Note the Amount Reconciled value.
Hint: In Oracle Accounts Receivable, if you are trying to reconcile your bank statement and
several receipts on the statement do not show as "Available in Cash Management, verify that
you have the system parameter "Show Cleared Transactions" selected.
Add the Bank Charge
12. Select the line with the bank charge.

− Select Miscellaneous
− Activity = Bank Charges
− Receipt Number = Accept Default
− Date = Accept Default
− Receipt Method = XXCash Misc
− Amount = -50

Chapter 1 - Page 75
14. (B) Create

− Answer “Yes” to the question to reconcile the receipt to the statement line
15. Close the Miscellaneous Receipts window.
Note: All bank statement lines should now be reconciled.
Complete the Bank Statement Reconciliation
16. Close the bank statement lines window.
− Complete = Checked
17. Save your work.
18. Return to the Navigator.

Chapter 1 - Page 76
Solution: Reconcile Your Bank Statement (Required)

Use the AutoReconciliation Program to Reconcile Your Bank Account Statement
1. Navigate to the Submit Request window:

− Request Name = AutoReconciliation
− Enter the parameters according to the following table:
Parameter Value
Bank Branch Name XX Branch
Bank Account Number XX-1234-5678
Statement Number From Leave Blank
Statement Number To Leave Blank
Statement Date From Leave Blank
Statement Date To Leave Blank
GL Date Accept the default
Organization Vision Operations
(Operating Unit)
Receivable Activity Leave Blank
Payment Method Leave Blank
NSF Handling No Action
3. Click (B) OK to close the Parameters window.
5. Review the Results of AutoReconciliation.
• Click (B) Find.
6. Select AutoReconciliation Execution Report.
• Click (B) View Output and verify results.

Chapter 1 - Page 77
View Status of Bank Statement Lines
7. Navigate to the Bank Statement window:
8. Select (M) View > Find.

9. Click (B) Review to view the status of your bank reconciliation.
10. Click (B) Lines.
11. Click (B) Reconciled.

− Note the Amount Reconciled value.
Hint: In Oracle Accounts Receivable, if you are trying to reconcile your bank statement
and several receipts on the statement do not show as "Available in Cash Management, verify
that you have the system parameter "Show Cleared Transactions" selected.
Add the Bank Charge
12. Select the line with the bank charge.

− Select Miscellaneous
− Activity = Bank Charges
− Receipt Number = Accept
− Date = Accept Default
− Receipt Method = XXCash Misc
− Amount = -50

− Select “Yes” to the question to reconcile the receipt to the statement line.
15. Close the Miscellaneous receipts window.
Note: All bank statement lines should now be reconciled.

17. Save your work.

Chapter 1 - Page 78

19. Save your work.
20. Return to the Navigator.

Chapter 1 - Page 79
Practice - Run Reports (Required)

Overview
In this practice, you run the General Ledger Reconciliation report.
Assumptions
Instructor will create accounting and confirm that all journals have been posted.
Tasks
1. Responsibility = Payables, Vision Operations (USA)
2. Navigate to the Standard Request Submission form.
• (N) Other > Requests > Run
3. Run the Concurrent Program called “Create Accounting.”
4. Use the following Parameters:

− Ledger = Vision Operations
− End Date = Last Day of the current period
− Mode = Final
− Errors Only = No
− Report = Summary
− Transfer to the General Ledger = Yes
− Post in the General Ledger = Yes
− Include User Transaction Identifiers = No
5. Repeat the same steps for Receivables; use the responsibility “Receivables, Vision
Operations (USA).
6. Verify that all Journal Entries have been posted.

− Switch to the responsibility General Ledger, Vision Operations (USA)
− (N) Journals > Enter > Post
− Period = Current Period
− (B) find
− Select the options for all journals that are retrieved.
− (B) Post

Chapter 1 - Page 80
− Confirm that all journals for Vision Operations have been posted before proceeding
to the next step.
Students can resume running the General Ledger Reconciliation report.

− Name = General Ledger Reconciliation Report
− Bank Account Number = XX-1234-5678
− Period Name = Current Period
− Report Type = Detail
10. Click (B) OK.
12. Monitor your request until it completes successfully, then click (B) View Output to review
the results.

Chapter 1 - Page 81
Solution: Run Reports (Required)
Instructor will create Accounting and confirm that all journals have
been posted.
Tasks
1. Responsibility = Payables, Vision Operations (USA)
• (N) Other > Requests > Run
3. Run the Concurrent Program called “Create Accounting.”
4. Use the following Parameters:

− Ledger = Vision Operations
− End Date = Last Day of the current period
− Mode = Final
− Errors Only = No
− Report = Summary
− Transfer to the General Ledger = Yes
− Post in the General Ledger = Yes
− Include User Transaction Identifiers = No
5. Repeat the same steps for Receivables; use the responsibility “Receivables, Vision
Operations (USA)
6. Verify that all Journal Entries have been posted.

− Switch to the responsibility General Ledger, Vision Operations (USA)
− (N) Journals > Enter > Post
− Period = Current Period
− (B) find
− Select the options for all journals for Vision Operations that are retrieved
− (B) Post
− Confirm all journals have been posted before proceeding to the next step
Run the General Ledger Reconciliation Report

Chapter 1 - Page 82

− Name = General Ledger Reconciliation Report
− Bank Account Number = XX-1234-5678
− Period Name = Current Period
− Closing Balance = 3487.50Report Type = Detail
10. Click (B) OK.
12. Monitor your request until it completes successfully, and then click (B) View Output to
review the results.
Close all windows and return to the Navigator.

Chapter 1 - Page 83
Cash Pools
Chapter 1 - Page 84
Guided Demonstration - Create Notional Cash Pool

Overview
In this practice, you create a notional cash pool.
Assumptions
Tasks
Create Notional Cash Pool
1. Create a notional cash pool using the following data.

Field Name Value
Cash Pool Name XXCashPool
Concentration Account (use Legal Entity Vision XX 2nd Account
Operations as search criteria)
Effective From Date Current Date
Effective To Date Year end Date
Note: You can only select bank accounts that you have access to that have not been assigned
to other cash pools, and for which the Interest Rounding and Interest Includes options have
been assigned as a part of the Interest Rate Schedule.
2. Click (B) Next.
3. Click (B) Add Sub Accounts.

− Use Legal Entity Vision Operations as search criteria.
− Select XXSubAccount.
4. Click (B) Next.

Chapter 1 - Page 85
Cash Forecasting
Chapter 1 - Page 86
Practice - Create a Cash Forecast Template

Overview
In this practice, you create a forecast template.
The corporate controller has asked you to determine the cash inflow and outflow for the next six
months for the following sources:
− AP Invoices for Vision Operations
− AR Invoices for Vision Operations
− Purchase Orders for Vision Operations
− Purchase Requisitions for Vision Operation
− Sales Orders for Vision Operations for all sales orders with “Entered” Date Type
Assumptions
Tasks
Define a Forecast Template
1. Navigate to the Forecast Templates page and create a forecast template with the following
information:
− Template Name = XXCashForecast
− Description = XXCash Forecast
− Forecast By = GL Periods
− Overdue Transactions = Exclude
Note: Choose Include or Exclude in the Overdue Transactions field to determine whether to
include or exclude open transactions that have a cash activity date before the forecast start
date. Overdue transactions are collected into one forecast period, displayed as the Overdue
column in the Cash Forecast Amounts window and the Cash Forecast Report.
2. Click (B) Next.
Add Sources - Supplier Invoices
3. Add a row for Supplier Invoices source type with the following information:
− Row Number = 1
− Description = Supplier Invoices (All)

Chapter 1 - Page 87

− Sets Of Books = Vision Operations (USA)
− Discount = None
− Include Transactions on Hold
− Lead time = 0 (Value Defaults. Used for Sales entries.)
Note: By choosing None, you are assuming the most conservative position in regards to
cash outflow. You’re assuming you’ll never take discounts for the purpose of the forecast.
Add Customer Invoices
4. Add a row for Customer Invoices source type with the following information:
− Row Number = 2
− Description = Customer Invoices (All)
− Include Dispute = No
− Use Average Payment = No
− Lead time = 0
Add Purchase Orders
5. Add a row for Purchase Orders source type with the following information:
− Row Number = 3
− Description = Purchase Orders (Approved)
− Use Payment Terms = N0
− Lead time = 0
− Status = Approved
− Include Temporary Labor = Yes
Note: Lead time is the number of days that need to be added to the transaction date to
calculate the projected cash transaction date. The value must be a positive, whole number,
or zero.
Add Purchase Requisitions
6. Add a row for Purchase Requisitions source type with the following information:
− Row Number = 4
− Description = Purchase Requisitions (Approved)
− Lead Time = 0

Chapter 1 - Page 88
Add Sales Orders
7. Add a row for Sales Orders source type with the following information:
− Row Number = 5
− Description = Sales Orders (Entered)
− Use Payment Terms = No
− Lead Time = 0
− Status = Entered
− Date Type = Entered
Note: Date Type is the expected cash activity date to use when calculating forecast
amounts.
8. Apply the information you entered.
Define Column Details
9. Enter the forecast periods for the template according to the following table:
Column From To
Number
1 1 1
2 2 2
3 3 3
4 4 4
5 5 5
6 6 6

Chapter 1 - Page 89
Solution: Create a Cash Forecast Template

Responsibility = Cash Management, Vision Operations (USA)
Define a Forecast and Add Sources
1. Navigate to the Forecast Templates page
• (N) Cash Forecasting > (T) Forecast Templates.
2. Click (B) Create Template.
3. Enter the following information:

− Description = XXCash Forecast
− Overdue Transactions = Exclude
3. Click (B) Next.
Add Supplier Invoices
4. Select Supplier Invoices.

− Add Row of Source Type = Supplier Invoices
5. Click (B) Go.

− Row Number = 1
− Description = Supplier Invoices (All)
− Ledger = Vision Operations (USA)
− Discount = None
− Include Transaction on Hold = No
− Lead time = 0 (Value Defaults. Used for Sales entries.)
Note: By choosing None, you are assuming the most conservative position in regards to
cash outflow. You’re assuming you’ll never take discounts for the purpose of the forecast.
6. Click (B) Apply.
Add Customer Invoices
7. Select Customer Invoices

− Add Another Row of Source Type = Customer Invoices
8. (B) Go
− Row Number = 2
− Description = Customer Invoices (All)

Chapter 1 - Page 90

− Include Dispute = No
− Use Average Payment days = No
− Lead time = 0
9. Click (B) Apply.
Add Purchase Orders
10. Select Purchase Orders

− Add Another Row of Source Type = Purchase Orders
11. (B) Go. Enter the following:

− Row Number = 3
− Description = Purchase Orders (Approved)
− Use Payment Terms = No
− Lead time = 0
Note: Lead time is the number of days that need to be added to the transaction date to
calculate the projected cash transaction date. The value must be a positive, whole number,
or zero.
Add Purchase Requisitions
13. Select Purchase Requisitions

− Add Another Row of Source Type = Purchase Requisitions
14. Click (B) Go. Enter the following:

− Row Number = 4
− Description = Purchase Requisitions (Approved)
− Lead Time = 0

Chapter 1 - Page 91
Add Sales Orders
16. Select Sales Orders

− Add Another Row of Source Type = Sales Orders
17. Click (B) Go. Enter the following:

− Row Number = 5
− Description = Sales Orders (Entered)
− Operating Unit =Vision Operations
− Use Payment Terms = Yes
− Lead Time = 0
− Status = Entered
− Date Type = Entered
Note: Date Type is the expected cash activity date to use when calculating forecast amounts.
19. Click (B) Next.
Define Column Details
20. Enter column details.

Chapter 1 - Page 92
Practice - Generate a Cash Forecast

Overview
In this practice, you generate a cash forecast.
The corporate controller has asked you to run the XX Cash Forecast to determine the cash inflow
and outflow for the next six months.
Assumptions
Tasks
Run a Forecast
1. Navigate to the Forecasts page and run the XX Cash Forecast template using the following
parameters:
Parameter Value
Template Name XXCashForecast
Calendar Name Accounting
Forecast Currency USD
Source Currency USD
Factor Unit
Starting Period Jan-07
Source Currency Type Entered
Request by Row No
View Opening Balance By None
When "Source Currency Type" is set to FUNCTIONAL, user has to provide exchange
information regardless of the value of "Forecast Currency." "Source Currency" User does
not have to provide exchange information only if "Source Currency Type" is set to
ENTERED and the "Forecast Currency" and "Source Currency" are the same.

Chapter 1 - Page 93
Review Your Forecast
2. After the Run Forecast process is complete, review your forecast.

Chapter 1 - Page 94
10. Solution: Generate a Cash Forecast

Run a Forecast
1. Navigate to the Forecasts page.
(N) Cash Forecasting
2. (T) Forecast Templates, in the Search parameters, enter:

Click (B) Go.
3. Click (I) Run Forecast. Enter the following parameters:

− Calendar Name = Accounting
− Forecast Currency = USD
− Source Currency = USD
− Template Name = XXCash Forecast
− Factor = Unit
− Start Period = Jan-07
− Source Currency Type= Entered
− Request by Row = No

Chapter 1 - Page 95
Review Your Forecast
5. On the Forecasts page, refresh the processing status until the forecast is complete.
Click (B) Refresh Processing Status.
6. Review your forecast by clicking the link for the forecast name.

Chapter 1 - Page 96
Practice - Run a Cash Forecast Report

Overview
In this practice, you generate a Cash Forecast Report for your Cash Forecast.
Assumptions
Tasks
1. Navigate to the Submit Requests window.
2. Run the Cash Forecast Report for the cash forecast you created in the previous practice.
3. Review the output.

Chapter 1 - Page 97
Solution: Run a Cash Forecast Report

Run a Forecast
1. Navigate to Submit Requests.
(N) Other > Programs >Run
2. Navigate to the Submit Requests window.
(N) Other > Request > Run

− Name = Cash Forecast Report
3. In the Parameters window, select the forecast report created in the previous lab:
4. Submit your request.

− Select a single request and click (B) OK.
5. Monitor your request until it completes successfully and review the output.

Chapter 1 - Page 98
Cash Positioning
Chapter 1 - Page 99
Guided Demonstration - Creating Cash Position Worksheet

Overview
In this practice, you create cash position worksheets.
Assumptions
Tasks
1. Navigate to the (N) Cash Position Worksheet Search and Results page.
2. Click Create Worksheet.
3. Enter XXWorksheet 1 for your worksheet name.
4. Enter 20 as the number of columns that is required to be displayed.
5. Select ‘Yes’ for the Use Calculated Prior Day Cash Flow and Overdue Transactions
Balances option.
6. Keep the default values for Cash Inflow and Cash Outflow.
7. Click Apply.

Chapter 1 - Page 100
Balances and Interest

Guided Demonstration - Viewing Actual, Historical, and Projected

Balances
Overview
In this practice, you view and update the actual, historical, and projected balances.
Assumptions
Tasks
1. Navigate to the (N) Bank Balances (T) Maintenance > Bank Account Balances page.
2. Enter Legal Entity, Bank Name, Currency, Account Name, or Account Number as search
criteria.
3. Click Go.
4. Select the account you want to update and click Update icon for either Historical Balances
or Projected Balances.
5. Enter the appropriate date range, if the desired balance dates are not displayed automatically,
and click Go.
6. Enter or update the account balance.
7. Click Apply.


Cash Management

Uploaded by

Copyright:

Available Formats

Cash Management

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Cash Management

Uploaded by

Copyright:

Available Formats

THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM ONLY.

COPYING eKIT MATERIALS FROM THIS COMPUTER IS STRICTLY PROHIBITED

Copyright © 2010, Oracle. All rights reserved.

Restricted Rights Notice

U.S. GOVERNMENT RIGHTS

Mathew Daniel, Melanie Heisler

Technical Contributors and Reviewers

Lata Sundar, Kathryn Wohnoutka

This book was published using: Oracle Tutor

R12.x Oracle Cash Management Fundamentals - Supplemental Practices ...............................................1-1

Copyright © Oracle 2010. All rights reserved.

R12.x Oracle Cash Management Fundamentals - Supplemental Practices Table of Contents

R12.x Oracle Cash Management Fundamentals - Supplemental Practices Table of Contents

• Working experience with Cash Management.

• There are no prerequisites for this course.

How This Course Is Organized

Copyright © Oracle 2010. All rights reserved.

R12.x Oracle Cash Management Fundamentals - Supplemental Practices Table of Contents

• System release bulletins

• Installation and user’s guides

• International Oracle User’s Group (IOUG) articles

Copyright © Oracle 2010. All rights reserved.

R12.x Oracle Cash Management Fundamentals - Supplemental Practices Table of Contents

Copyright © Oracle 2010. All rights reserved.

R12.x Oracle Cash Management Fundamentals - Supplemental Practices Table of Contents

Typographic Conventions in Code

Lowercase Syntax variables CREATE ROLE role

Typographic Conventions in Oracle Application Navigation Paths

This simplified path translates to the following:

2. (M) From the menu, select Query then Find.

3. (B) Click the Approve button.

(ST) = Sub Tab

Copyright © Oracle 2010. All rights reserved.

R12.x Oracle Cash Management Fundamentals - Supplemental Practices Table of Contents

Typographical Conventions in Oracle Application Help System Paths

The following help navigation path, for example—

—represents the following sequence of actions:

2. Under the General Ledger entry, expand Journals.

3. Under Journals, select Enter Journals.

Copyright © Oracle 2010. All rights reserved.

R12.x Oracle Cash Management Fundamentals - Supplemental Practices Table of Contents

R12.x Oracle Cash Management Fundamentals - Supplemental Practices Table of Contents

Copyright © Oracle, 2010. All rights reserved.

R12.x Oracle Cash Management Fundamentals - Supplemental Practices

Oracle Cash Management Overview

Practice - Create a New User

1. Navigate to the Users window.

2. Enter your user details:

Copyright © Oracle, 2010. All rights reserved.

R12.x Oracle Cash Management Fundamentals - Supplemental Practices

3. Enter the responsibilities for this user:

4. Save. Sign on as your new user.

Copyright © Oracle, 2010. All rights reserved.

R12.x Oracle Cash Management Fundamentals - Supplemental Practices

Solution: Create a New User

1. Navigate to the Users window.

• (N) Security : User > Define

2. Enter your user details:

3. Add the following responsibilities to your new username:

Copyright © Oracle, 2010. All rights reserved.