Previous	Next		Contents	Index	Navigation	Glossary	Library

Using sources from other Oracle Applications and from external systems, you can generate cash forecasts from previously-defined cash forecast templates. You can choose whether to forecast by days or periods, and choose how to organize each template with multiple GL sources and levels of detail. Automatic integration with Oracle Applications and other spreadsheet applications provides you with enterprise-wide cash information and management.

You create cash forecast templates, from which you can generate periodic cash forecasts projecting your cash flow and requirements. Once you have generated a cash forecast, you can modify, query, and report on it, and easily export it to Microsoft Excel or any spreadsheet application.

Oracle Cash Management lets you create an unlimited number of cash forecasts. A cash forecast is in a spreadsheet format, including rows (cash inflow or outflow) and columns (periods). Each row is a source type and each column a forecast period. At the intersection of each row and column are cells containing forecast amounts.

Cash Management lets you create forecasts using data across organizations, and in any currency. You can also use cash forecasting to help determine your degree of currency exposure.

You can submit cash forecasts with user currency exchange rates, minimizing exchange rate setup for what-if analysis.

You have the flexibility to include or exclude overdue transactions for all appropriate source transaction types in your forecasts.

Cash inflow information is immediately accessible to the cash forecast process in Oracle Cash Management from Oracle Receivables, Oracle Order Entry, and Oracle General Ledger. Cash outflow information comes from Oracle Payables, Oracle Purchasing, Oracle Payroll, and Oracle General Ledger. Using the Forecasting Open Interface, you can also include cash flows from external systems.

Oracle Applications Integration with Cash Forecasting

Oracle Applications Integration with Oracle Cash Management's Cash Forecasting
Cash	Source	Source Type	Description
I N F L O W	Receivables	AR Invoices	Unpaid invoices
		AR Receipts (Historical)	Cleared cash receipts, excluding reversed receipts
		AR Receipts (Future)	Uncleared cash receipts, excluding reversed receipts
	Order Entry	Sales Orders	Uninvoiced sales orders that are projected to be paid by customer, excluding commitments
	General Ledger	GL Cash Position	Cash balance to be used as the starting point of the projection
		GL Budgets	Revenue account budget amounts
	External Source	Open Interface Inflow	External forecast source inflow transactions
	User	User-defined Inflow	Manually entered cell amounts
O U T F L O W	Payables	AP Invoices	Unpaid invoices, excluding prepayments
		AP Payments (Historical)	Cleared disbursements, excluding void payments
		AP Payments (Future)	Uncleared disbursements, excluding void payments
	Payroll	Payroll (Historical)	Paid payroll
	Purchasing	Purchase Orders	Uninvoiced purchase orders
		Purchase Requisitions	Unordered requisitions
	General Ledger	GL Encumbrances	Unused portion of encumbered amounts for expenses and assets
		GL Budgets	Expense account budget amounts
	External Source	Open Interface Outflow	External forecast source outflow transactions
	User	User-defined Outflow	Manually entered forecast amounts

Forecasting Open Interface and Distributed Database Integration

You can generate a cash forecast that automatically includes cash flows from local and remote databases.

Cash Forecast Reporting and Spreadsheet Integration

See Also

Forecasting Open Interface