Setting up the Forecast Range

Configure the forecast time frame for Daily and Periodic cash forecasting.

To configure the time frame for forecasts:

  1. From the Home page, click Application and then click Configure.
  2. Click Forecast Range Setup.
  3. In Forecast Start Day, select an option:
    • Specific Date—Specify a different start date, for example, if you are in the implementation phase and you want a future start day for your production phase, or when the forecast start day is a future date due to holidays. The specific date can't be beyond 30 days of the system date.
    • System Date—The default. In general, Oracle recommends that you use the system date for your production environment.

    With every daily maintenance window, the date rolls over. The current rolled over date and data becomes the forecast start date, and the previous day becomes the Actuals. These changes are reflected in the Rolling Forecast form.

  4. In Daily Rolling Forecast, if your application was enabled for daily forecasting:
    1. Select the Number of Forecast Days. The Rolling Forecast Range is updated based on the Forecast Start Day and the Number of Forecast Days.
    2. Select the Number of Actual Days to define the number of actual days for variances and reporting. The Actual Rolling Forecast Range is updated based on the Forecast Start Day and the Number of Actual Days.

      Even though the actual date range displays based on your selection, you can upload more historical periods for actual data if you have it.

  5. In Periodic Rolling Forecast, if your application was enabled for periodic forecasting:
    1. Select the Number of Forecast Periods. The Rolling Forecast Range is updated based on the Forecast Start Day and the Number of Forecast Periods.
    2. Select the Number of Actual Periods to define the number of actual periods for variances and reporting. The Actual Rolling Forecast Range is updated based on the Forecast Start Day and the Number of Actual Periods.
  6. Click Save.

Based on the forecast range, substitution variables and valid intersection combinations are updated.

Additionally, the rolling forecast form and some of the historical variance forms and dashboards are defaulted with date ranges based on the forecast range setup.

Note:

If you change the forecast range, you must run the Daily Process Forecast / Periodic Process Forecast rules again to see the change reflected in the Rolling Forecast form.