Previous	Next		Contents	Index	Navigation	Glossary	Library

• Name and description

• Forecast period types, either GL periods or days

• Organization (applicable in multiple organizations environments)

• Set of books information

• Pay group

• Bank account

Once a template definition is complete, you can submit it to produce timely cash forecasts. This process gathers current source information from the selected Oracle Applications.

Forecasting Open Interface and Distributed Database Integration

You define your templates to include the Open Interface Inflow and Open Interface Outflow source types. You can then generate a cash forecast and Cash Management automatically retrieves information available from the external forecast sources you have defined.

See Also

Generating Cash Forecasts from Templates

Forecasting Open Interface

   To create a cash forecast template:

1. Navigate to the Forecast Templates window.

2. Choose New in the Find Forecast Templates window, or close or minimize the Find Forecast Templates window. (The Forecast Templates window is behind the Find Forecast Templates window.)

3. Enter a unique name for your template.

4. Enter a forecast period type of Days or GL Periods in the Forecast By field.

5. (Optional) Enter a description for your template.

6. 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.

7. If you chose to include overdue transactions, you must enter a value in the Cutoff Period field. The cutoff period determines how far back to include overdue transactions.

Note: Transaction volume increases with an increase in the cutoff period. If you choose a cutoff period that is very long and you are including many historical transactions, then the forecasts may take longer to generate.

8. Choose a transaction calendar in the Business Calendar field. If you do not choose a calendar in this field, then cash activity dates used in forecasting can be non-business days.

9. Choose the Columns button. The Forecast Template Columns window appears, where you enter forecast period ranges.

10. Enter a Column Number to specify the sequence of the columns (forecast periods). Values must be integers between 1 and 999. The Column Number indicates the sequence of the columns in the forecast.

Note: You can define up to 80 columns in a forecast template.

11. Enter the From and To specifications as periods or days, depending on how you defined your template. The values must be integers between 1 and 999. The From value must be less than or equal to the To value.

Note: These numbers define the forecast periods by indicating the specific date or period ranges for each column. For example, in the above window, the template is defined by GL periods, where each column represents one GL period. When submitting a forecast you specify GL Periods or Days, depending on the forecast template. If you submit by GL period you specify a start period, if you submit by Days, you specify a start date. See: Submit Forecast Window Reference.

12. Close, move, or minimize the Forecast Template Columns window.

13. Choose the Rows button on the Forecast Templates window. The Forecast Template Rows window appears.

14. Enter Rows. For each row enter the following:

• Enter a Row Number to specify the sequence of the source types. Values must be unique integers between 1 and 999. The Row Number indicates the sequence of the rows (source types) in the forecast.

• Select the Source type. Enter the available fields for the source type chosen. See Forecast Template Rows Window Reference, for information on the applicable and required fields for each source type.

15. Save your work. Cash Management validates required fields now.

Attention: You can add or delete rows and columns in a template, but your action will affect all cash forecasts previously generated using that template. Adding rows and columns to a previously-defined template generates forecast amounts of zero for the new cells in existing forecasts. Deleting rows and columns eliminates forecast amounts for the deleted cells.

See Also