Oracle Cash Management User's Guide

[Pages:261]Oracle r Cash Management User's Guide

RELEASE 11 March 1998

Enabling the Information AgeTM

Oracle (R) Cash Management User's Guide Release 11

The part number for this volume is A58471?01.

Copyright E 1995, 1998, Oracle Corporation. All rights reserved.

Major Contributors: Christopher Andrews, Frank Colligan,Tracy Drinkwater

Contributors: John Adams, Amy Beaulieu, J?rg Janke, Chang?Ok Kawamoto, Hildegard K?hne, Sharmilla Natu, Kai Pigg, Maria Quinlan, Sally Screven, Sarah Seeland

The Programs (which include both the software and documentation) contain proprietary information of Oracle Corporation; they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright, patent and other intellectual property law. Reverse engineering of the Programs is prohibited. No part of this document may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle Corporation.

The information contained in this document is subject to change without notice. If you find any problems in the documentation, please report them to us in writing. Oracle Corporation does not warrant that this document is error free.

RESTRICTED RIGHTS LEGEND Programs delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the Programs shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, Programs delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the Programs shall be subject to the restrictions in FAR 52.227?14, Rights in Data ?? General, including Alternate III (June 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA 94065."

The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail?safe, back up, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs.

Oracle is a registered trademark, and ConText, Enabling the Information Age, Oracle7, Oracle8, Oracle Access, Oracle Alert, Oracle Alliance, Oracle Application Object Library, Oracle Card, Oracle ConText, Oracle Discoverer, Oracle Financials, Oracle Graphics, Oracle Imaging, Oracle Masters, Oracle Work in Process, Oracle Workflow, SmartClient, PL/SQL, Pro*C, SQL*Forms, SQL*Loader, SQL*Menu, SQL*Net, SQL*Plus, SQL*Report, SQL*TextRetrieval, and Oracle Web Employees are trademarks or registered trademarks of Oracle Corporation.

All other company or product names are mentioned for identification purposes only, and may be trademarks of their respective owners.

Contents

Chapter 1

Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ix About This User's Guide . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . x Assumptions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xi Do Not Use Database Tools to Modify Oracle Applications Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xi Other Information Sources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xii Related User's Guides . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xii About Oracle . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvi Thank You . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvi

Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 ? 1 About Oracle Cash Management . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 ? 2

About Bank Reconciliation . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 ? 2 Bank Statements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 ? 5 Bank Statement Lines . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 ? 5 Bank Statement Error Reconciliation . . . . . . . . . . . . . . . . . . . . 1 ? 6 Bank Statement Transaction Codes . . . . . . . . . . . . . . . . . . . . . . 1 ? 6 Matching Bank Statement Lines with Transactions . . . . . . . . 1 ? 6 Matching Criteria for Oracle Payables Transactions . . . . . . . 1 ? 7 Matching Criteria for Oracle Receivables Transactions . . . . . 1 ? 8 Matching Criteria for Miscellaneous Transactions . . . . . . . . . 1 ? 8 Matching Criteria for General Ledger Journals . . . . . . . . . . . 1 ? 9 Multi?Currency Handling . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 ? 9 Integration with Oracle Receivables and Payables . . . . . . . . 1 ? 12

Chapter 2

Oracle Payables Reconciliation Accounting . . . . . . . . . . . . . . . . . . 1 ? 15 Oracle Payables Reconciliation Examples . . . . . . . . . . . . . . . . 1 ? 17

Oracle Receivables Reconciliation Accounting . . . . . . . . . . . . . . . 1 ? 20 Oracle Receivables Reconciliation Examples . . . . . . . . . . . . . 1 ? 21 Using Cash Management with Automatic Clearing . . . . . . . 1 ? 23

About Cash Forecasting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 ? 26

Setting Up . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 ? 1 Setting Up Oracle Cash Management . . . . . . . . . . . . . . . . . . . . . . . 2 ? 2

Cash Management Setup Checklist . . . . . . . . . . . . . . . . . . . . . 2 ? 4 Setting Up Oracle Cash Management to Use with Oracle

Payables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 ? 9 Setting Up Oracle Cash Management to Use with Oracle

Payables or Oracle Receivables . . . . . . . . . . . . . . . . . . . . . . . . . . 2 ? 10 Setting Up Oracle Cash Management to Use with Oracle

Receivables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 ? 11 System Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 ? 13

System Parameter Window Reference . . . . . . . . . . . . . . . . . . . 2 ? 14 Bank Transaction Codes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 ? 18 Bank Statement Open Interface . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 ? 22

Bank Statement Headers Interface Table . . . . . . . . . . . . . . . . . 2 ? 23 Required Columns . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 ? 23 Optional Columns . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 ? 24 Bank Statement Lines Interface Table . . . . . . . . . . . . . . . . . . . . 2 ? 25 Required Columns . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 ? 25 Optional Columns . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 ? 26 Reconciliation Open Interface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 ? 28 Program Submission . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 ? 28 Preparing to Use Reconciliation Open Interface . . . . . . . . . . . 2 ? 28 CE_999_INTERFACE_V Description . . . . . . . . . . . . . . . . . . . . 2 ? 29 Package CE_999_PKG Description and Modifications . . . . . 2 ? 32 Forecasting Open Interface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 ? 36 Providing an Open Interface to Forecast from External

Applications . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 ? 36 Forecasting in a Distributed Environment . . . . . . . . . . . . . . . 2 ? 36 Program Submission . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 ? 37 Preparing to Use the Forecasting Open Interface . . . . . . . . . . 2 ? 37 Define External Source Types and Selection Criteria . . . . . . . 2 ? 37 Define Value Sets for Selection Criteria . . . . . . . . . . . . . . . . . . 2 ? 38 Define Forecast Selection Criteria Descriptive Flexfield

Segments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 ? 38

Chapter 3 Chapter 4

Define External Source Views . . . . . . . . . . . . . . . . . . . . . . . . . . 2 ? 39 Associate External Forecast Source Types with Views . . . . . 2 ? 40 Sequential Document Numbering . . . . . . . . . . . . . . . . . . . . . . . . . . 2 ? 42

Loading Bank Statements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 ? 1 Loading Bank Statement Open Interface . . . . . . . . . . . . . . . . . . . . 3 ? 2 Importing Bank Statements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 ? 5

About Bank Statement Validation . . . . . . . . . . . . . . . . . . . . . . . 3 ? 6 Bank Statement Header Validation . . . . . . . . . . . . . . . . . . . . . . 3 ? 7 Control Total Validation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 ? 7 Statement Line Validation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 ? 8 Multi?Currency Validation . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 ? 8 Reviewing Bank Statement Interface Errors . . . . . . . . . . . . . . . . . . 3 ? 10 Correcting Bank Statement Interface Errors . . . . . . . . . . . . . . . . . . 3 ? 13 Entering Bank Statements Manually . . . . . . . . . . . . . . . . . . . . . . . . 3 ? 15 Entering Bank Statement Lines . . . . . . . . . . . . . . . . . . . . . . . . . 3 ? 18 Updating Bank Statements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 ? 20

Reconciling Bank Statements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 ? 1 Reconciling Bank Statements Automatically . . . . . . . . . . . . . . . . . 4 ? 2

Reconciliation Tolerances . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 ? 6 Posting Amount Differences Within Tolerances . . . . . . . . . . . 4 ? 7 Multi?Currency Matching . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 ? 8 Multi?Currency Clearing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 ? 10 Reviewing Reconciliation Errors . . . . . . . . . . . . . . . . . . . . . . . . 4 ? 13 Reconciling Bank Statements Manually . . . . . . . . . . . . . . . . . . . . . 4 ? 14 Creating Reconciled Bank Statement Lines . . . . . . . . . . . . . . . 4 ? 19 Finding Available Detail and Batch Transactions for

Reconciliation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 ? 20 Reconciling Available Transactions and Batches . . . . . . . . . . 4 ? 24 Reviewing Reconciled Transactions . . . . . . . . . . . . . . . . . . . . . 4 ? 28 Changing the Reconciliation Status . . . . . . . . . . . . . . . . . . . . . 4 ? 31 Using Attachments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 ? 32 Creating Payments and Receipts Transactions . . . . . . . . . . . . . . . . 4 ? 34 Creating Miscellaneous Transactions . . . . . . . . . . . . . . . . . . . . . . . 4 ? 36 Recording Exceptions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 ? 39 Entering Reversals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 ? 42 Reconciling Corrections and Adjustments to Bank Errors . . . . . . 4 ? 45 AutoReconciliation Matching . . . . . . . . . . . . . . . . . . . . . . . . . . 4 ? 46

Chapter 5 Chapter 6

Manual Reconciliation Matching . . . . . . . . . . . . . . . . . . . . . . . 4 ? 47 Manually Clearing and Unclearing . . . . . . . . . . . . . . . . . . . . . . . . . 4 ? 49 Marking a Bank Statement as Complete . . . . . . . . . . . . . . . . . . . . . 4 ? 52 Transferring Bank Reconciliation Transactions to Your

General Ledger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 ? 53 Oracle General Ledger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 ? 53 How Using Cash Management Affects Your Closing Process . . . 4 ? 54 Archiving and Purging Imported Bank Statements . . . . . . . . . . . 4 ? 56

Cash Forecasting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 ? 1 Cash Forecasting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 ? 2 Creating Cash Forecast Templates . . . . . . . . . . . . . . . . . . . . . . . . . . 5 ? 3

Forecasting Open Interface and Distributed Database Integration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 ? 3

Cash Forecasting Source Transaction Dates . . . . . . . . . . . . . . 5 ? 7 Forecasting Overdue Transactions . . . . . . . . . . . . . . . . . . . . . . 5 ? 9 Forecast Template Rows Window Reference . . . . . . . . . . . . . 5 ? 10 Forecast Template Rows Window ? Source Type

Characteristics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 ? 10 Forecast Template Rows Window Reference . . . . . . . . . . . . . 5 ? 12 Generating Cash Forecasts from Templates . . . . . . . . . . . . . . . . . . 5 ? 17 Forecasting Open Interface and Distributed Database

Integration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 ? 18 Prerequisites for All Methods of Generating Cash

Forecasts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 ? 18 Generating a Cash Forecast with Amounts Calculated

Automatically . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 ? 18 Submit Forecast Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 ? 20 Creating a Manually Entered Cash Forecast . . . . . . . . . . . . . . 5 ? 22 Modifying Cash Forecast Templates and Cash Forecasts . . . . . . . 5 ? 24 Modifying Templates . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 ? 24 Modifying Forecasts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 ? 25 Exporting Cash Forecasts to Microsoft Excel Spreadsheets . . . . . 5 ? 31

Inquiry and Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 1 Inquiry . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 2

Viewing Bank Statement Reconciliation . . . . . . . . . . . . . . . . . 6 ? 2 Viewing Available Transactions . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 6 Viewing Cash Forecasts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 9 Cash Management Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 12 Submitting Requests . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 12

Appendix A

Cancelling Requests . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 13 Monitoring Requests . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 13 Defining Request Sets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 13 Cash Forecasting Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 15 Cash Forecast Report . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 15 Report Submission . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 15 Selected Report Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 15 Cash Forecast Execution Report . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 16 Report Submission . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 16 Statements Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 17 AutoReconciliation Execution Report . . . . . . . . . . . . . . . . . . . 6 ? 17 Report Submission . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 17 Selected Report Headings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 17 Bank Statement Detail Report . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 17 Report Submission . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 18 Selected Report Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 18 Selected Report Headings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 18 Bank Statement Summary Report . . . . . . . . . . . . . . . . . . . . . . . 6 ? 18 Report Submission . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 18 Selected Report Headings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 18 Bank Statements by Document Number Report . . . . . . . . . . 6 ? 19 Report Submission . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 19 Selected Report Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 19 GL Reconciliation Report . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 19 Report Submission . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 19 Selected Report Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 20 Transactions Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 21 Cash in Transit Report . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 21 Report Submission . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 21 Selected Report Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 21 Transactions Available for Reconciliation Report . . . . . . . . . . 6 ? 21 Report Submission . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 22 Selected Report Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 22 Cash Management Listings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 23 Bank Transaction Codes Listing . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 23 Report Submission . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 23 Selected Report Headings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 23 Cash Management Programs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 24 Program Submission . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 ? 24

Navigation Paths . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . A ? 1

Appendix B Appendix C

Cash Management Window Navigation Paths . . . . . . . . . . . . A ? 2

Profile Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . B ? 1 Setting Profile Options for Cash Management . . . . . . . . . . . . B ? 2

Function Security in Oracle Cash Management . . . . . . . . . . . . . C ? 1 Function Security in Cash Management . . . . . . . . . . . . . . . . . . . . . C ? 2 Glossary Index

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download