Oracle Cash Management User Guide

Skip Headers

Title and Copyright Information

Send Us Your Comments

Preface

Overview

About Oracle Cash Management

About Bank Reconciliation

About Bank Statements

Matching Bank Statement Lines with Transactions

Multi-Currency Handling

Integration with Oracle Receivables, Payables, Payroll, and Treasury

Oracle Payables Reconciliation Accounting

Payables Reconciliation Examples

Oracle Receivables Reconciliation Accounting

Receivables Reconciliation Examples

Using Cash Management with Automatic Clearing

Oracle Payroll Reconciliation

Oracle Treasury Reconciliation

About Cash Forecasting

Oracle Applications Integration with Cash Forecasting

Oracle Projects Integration With Cash Forecasting

External Cashflow Open Interface and Distributed Database Integration

Cash Forecast Reporting and Spreadsheet Integration

System Setup

Setting Up Oracle Cash Management

Related Product Setup Steps

Cash Management Setup Checklist

Setting Up Oracle Payables for Oracle Cash Management Integration

Setting Up Oracle Payables or Oracle Receivables for Oracle Cash Management Integration

Setting Up Oracle Receivables for Oracle Cash Management Integration

Setting Up Oracle Payroll for Oracle Cash Management Integration

Setting Up Oracle Treasury for Oracle Cash Management Integration

System Parameters

System Parameters Window Reference

Cash Management Security

Bank Transaction Codes

Bank Statement Open Interface

Bank Statement File Formats

Bank Statement Mapping

Using a Custom Loader Program

Bank Statement Headers Interface Table

Bank Statement Lines Interface Table

Reconciliation Open Interface

Program Submission

Using Reconciliation Open Interface to Reconcile Treasury Settlements

Using Reconciliation Open Interface to Reconcile External Transactions

CE_999_INTERFACE_V Description

Package CE_999_PKG Description and Modifications

Installing External Cash Flow Open Interface Objects in Remote Databases

External Cashflow Open Interface

Program Submission

Preparing to Use the External Cashflow Open Interface

Sequential Document Numbering

Cash Transaction Subtypes

Bank Account Setup

Bank Account Model Overview

Define Bank Branches

Bank and Account Administration: Define Bank Accounts

Banks, Bank Branch, and Bank Accounts Window References

Oracle Intercompany Setup Steps

Oracle Payments Setup Steps

Maintaining Bank Account Signing Authorities

Cash Pools

Overview of Single European Payments Area (SEPA)

Bank Identification Code (BIC)

International Bank Account Number (IBAN)

SEPA Credit Transfer

Managing Bank Statements

Entering Bank Statements

Loading the Bank Statement Open Interface Tables

The Bank Statement Loader Program

To Run the Bank Statement Loader Program

Bank Statement Loader Program Parameters

Using a Custom Loader Program

Automatic Bank Transmission Feature

Retrieving Bank Statements and Payment Exceptions

Intra-Day Bank Statement Loader Program

Submitting the Intra-Day Bank Statement Loader Program

Receiving XML Bank Statements

Setting Up Your System to Receive XML Bank Statements

Processing XML Bank Statements

Importing Bank Statements

About Bank Statement Validation

Reviewing Bank Statement Interface Errors

Statement Interface Window Reference

Reviewing Interface Errors Online for a Specific Statement Line

Bank Statement Line Interface Window Reference

Correcting Bank Statement Interface Errors

Entering Bank Statements Manually

Bank Statement Window Reference

Entering Bank Statement Lines

Bank Statement Interface Lines Window Reference

Updating Bank Statements

Creating Cashflows from Bank Files

Reconciliation Setup

Reconciling Bank Statements Automatically

Submit Automatic Reconciliation Window Reference

Reconciling Sweep Transactions

Reconciliation Tolerances

Multi-Currency Matching

Multi-Currency Clearing

About Value Dates

Reviewing Reconciliation Errors

Reconciling Bank Statements Manually

Creating Reconciled Bank Statement Lines

Finding Available Detail and Batch Transactions for Reconciliation

Reconciling Available Transactions and Batches

Available Transactions Window Reference

Reconciling an Available Remittance or Payment Batch

Available Batches Window Reference

Reviewing Reconciled Transactions

Reconciled Transactions Window Reference

Changing the Reconciliation Status

Using Attachments

Creating Payments and Receipts Transactions

Creating Miscellaneous Transactions

Miscellaneous Receipts Window Reference

Recording Exceptions

Entering Reversals

Reversals Window Reference

Reconciling Corrections and Adjustments to Bank Errors

Manually Clearing and Unclearing

Clear Transactions Window Reference

Default Dates Window Reference

Unclearing Payments and Receipts

Unclear Transactions Window Reference

Marking a Bank Statement as Complete

Transferring Bank Reconciliation Transactions to Your General Ledger

How Using Cash Management Affects Your Closing Process

Archiving and Purging Imported Bank Statements

Cash Forecasting

Cash Forecasting

Creating Cash Forecast Templates

Cash Forecasting Source Transaction Dates

Forecasting Overdue Transactions

Forecast Template Rows Page Reference

Generating Cash Forecasts from Templates

Submission Parameters

Cash Forecast Results

Calculation of Opening and Closing Bank Account Balances and GL Cash Position in Cash Forecasting

Source Transaction Details Page Reference

Modifying Cash Forecast Templates and Cash Forecasts

Modifying Forecast Amounts on an Existing Cash Forecast

Add Rows or Columns Page Reference

Purging Cash Forecasts

Exporting Cash Forecasts to Your Spreadsheet Application

Viewing Cash Forecasts in Discoverer

Security in Cash Forecasting

Cash Positioning

Cash Positioning

Creating Cash Position Worksheets

Cash Positioning Source Transaction Dates

Overdue Transactions In Cash Positioning

Cash Position Prior Day Cash Flow and Overdue Transactions Program

Cash Position Worksheet Page Reference

Generating Cash Positions From Worksheets

Calculation Of Opening and Closing Bank Account Balances in Cash Positioning

Balance Gapping in Cash Positioning

Generating a Cash Leveling Proposal

Viewing Cash Position Results

Cash Position Results Page: Currency View, Bank Account View, and Cash Pool View Reference

Source Transaction Details Page Reference

Intra-Day Activities and Net Cash Flow Detail Page Reference

Available Liquidity Section Details

Modifying Cash Position Worksheets and Cash Position Results

Exporting Cash Position Results to Your Spreadsheet Application

Viewing Cash Positions in Discoverer

Security in Cash Positioning

Bank Account Balances and Interest Calculations

Bank Account Balances

Maintaining Balances By Account

Maintaining Balances For Multiple Accounts

Balance Reporting

Interest Rate Schedule

Interest Calculation

Cash Transactions

Bank Account Transfers

Payment Templates

Creating Bank Account Transfers Manually

Viewing, Updating, and Canceling Bank Account Transfers

Authorizing Bank Account Transfers

Processing Payments

Generating Accounting Entries

Cashflows

Accounting

Subledger Accounting (SLA) Introduction

Accounting Events

Accounting Definitions

Managing Journal Entries

Inquiry and Reports

Inquiry Overview

Viewing Bank Statement Reconciliation

Viewing Available Transactions

Viewing Bank Account Transfers

Viewing Cashflows

Viewing Bank Account Balances

Viewing Interest Schedules

Viewing Bank Information

Viewing Bank Accounts

Viewing Payments and Receipts

Cash Management Reports

Common Report Parameters

Common Report Headings

Cash Forecasting Reports

Cash Forecast Report

Cash Forecast Execution Report

Purge Cash Forecasts Report

Statements Reports

Archive/Purge Bank Statements Report

AutoReconciliation Execution Report

Bank Statement Detail Report

Bank Statement Loader Execution Report

Bank Statement Summary Report

Bank Statements by Document Number Report

GL Reconciliation Report

Bank Statement Cashflow Creation Execution Report

Sweep Transactions Generation Execution Report

Transactions Reports

Cash in Transit Report

Cleared Transactions Report

Transactions Available for Reconciliation Report

Batches Available for Reconciliation Report

Payment Exceptions Report

Balances Reports

Bank Account Balance Single Date Report

Bank Account Balance Day Range Report

Bank Account Balance Actual vs Projected Report

Cash Management Listings

Bank Transaction Codes Listing

Cash Forecast Template Listing

Cash Management Programs

Navigation Paths

Cash Management Window Navigation Paths

Profile Options

Setting Profile Options for Cash Management

Profile Options Summary

Profile Options in Cash Management

Profile Options Affecting, But Not Owned By, Cash Management

Function Security in Oracle Cash Management

Function Security in Cash Management

Bank Statement Mapping Templates

BAI2 Mapping Template

SWIFT940 Mapping Template

EDIFACT - France Mapping Template

XML Mapping Rules

XML Mapping Rules for Statement Header Information

XML Mapping Rules for Statement Line Information

Country Specific Bank Account Validations

Introduction

Bank Account Validation by Country

Index

Oracle Cash Management User Guide

Contents