Generating Cash Forecasts from Templates
Creating cash forecast templates allows you to preserve specifications for future use. You can run the calculations, or generate, cash forecasts as needed or regularly. You enter criteria like start date and exchange rate when you submit a forecast to generate exactly the forecast you need.
When you submit a cash forecast for calculation, Cash Management collects the necessary source data and summarizes the information as cash forecast amounts, based on the forecast period specifications. The forecast data is then available for update, inquiry or reporting purposes, or for export to any spreadsheet application.
Cash Management determines projected cash activity dates based on your specifications. For example, if the source type is AP Invoices, the expected cash activity date is based on either the discount date or the due date depending on your selection in the template. Refer to the Cash Forecasting Source Transaction Dates table.
When you generate a cash forecast you have the option of selecting one or more sources to be processed, by requesting the row number. You can submit separate processes to generate partial forecasts where Cash Management selects transactions from one source type at a time.
If you have created a forecast template that includes a user-defined source type, Cash Management creates a blank row for that source type when you generate a cash forecast. You can then enter amounts manually in the forecast amount cells using the Cash Forecasts window, or using a spreadsheet application on an exported cash forecast.
You might generate a new cash forecast because you have created a new template, or because you want to recalculate a forecast with different criteria.
You can generate forecasts in the following ways:
- Generate a new cash forecast from a template, with forecast amounts calculated automatically.
- Using the Submit Forecast window
- Using the Submit Request window
- Quickly create a manually entered cash forecast, with the rows and columns defined by a template.
Forecasting Open Interface and Distributed Database Integration
The Forecasting Open Interface allows you to utilize external sources of data as cash inflow and outflow data for the Cash Forecasting feature, providing you an enterprise-wide cash forecasting solution on a distributed database environment.
You can generate a cash forecast and the Forecasting Open Interface automatically retrieves information available from the external forecast sources you have defined.
See Also
Generating a Cash Forecast with Amounts Calculated Automatically
Creating a Manually Entered Cash Forecast
Exporting Cash Forecasts to Microsoft Excel Spreadsheets
Viewing Cash Forecasts
Cash Forecasting Reports
Forecasting Open Interface
Prerequisites for All Methods of Generating Cash Forecasts
Set up the Forecasting Open Interface if you plan to include external sources in your cash forecasts.
Define at least one cash forecast template.
Generating a Cash Forecast with Amounts Calculated Automatically
To create a cash forecast using the Submit Forecast window:
2. (Optional) Select the record of an existing cash forecast.
3. Choose Submit Forecast from the Oracle Applications Special menu. The Submit Forecast window appears.
To create a cash forecast using the Submit Request window:
1. Navigate to the Submit Request window.
2. Choose Request in the Type field.
3. Choose Cash Forecasting by GL Periods or Cash Forecasting by Days in the Name field, depending on the template you want to use. The Parameters window appears.
5. Select any print or run options.
Suggestion: Consider using report sets if you routinely generate a given set of cash forecasts.