Financials Planning and Forecast Preparation

You can configure the time frame and granularity for plans for each module. You can have a different time frame and granularity for each module and for each year.

To configure the time frame and granularity for plans:

  1. In Current Fiscal Year, select the current fiscal year.
  2. From Period, select the current actual month. For 13-period applications, select the current period. You need to update this value on a monthly basis.
  3. From Plan Start Year, indicate if planners will plan in the current or next fiscal year.
  4. Click Plan, and then the Years column to select the number of years to configure. For example, to configure the first five years of a ten year application, select 5 Years.
  5. Select the planning basis for each year that you are configuring. If plans will be prepared at the same frequency each year, click All, and then select the frequency (for example, Monthly). If plans will be prepared at different frequencies in certain years, select the frequency in each year’s row. For example, to plan monthly in FY20 but quarterly in FY21, select Monthly in the row for FY20 and Quarterly in the row for FY21. For 13-period applications, you select 13 Periods instead of Monthly.
  6. Click Forecast and repeat these steps to specify the forecasting basis.

    When you select Quarterly as the planning basis for Forecast for the first year, the provided valid intersections are set up so that forecast data entry is allowed only in the appropriate periods; quarterly forecast periods prior to the current month can't be updated. The substitution variable OEP_CurQtr is provided whenever you enable Quarterly planning.

    For Financials, if you've enabled weekly planning, you can optionally select Past Periods Read Only. When you select this option, past periods at the weekly level are read-only for the Forecast scenario. For example, if Current Year is FY21, Current Month is Mar and Current Week is Week10, if you select Past Periods Read Only, Weeks 1-10 for FY21 are not editable.

    This checkbox is displayed only on the Forecast tab when weekly planning in Financials is enabled.

  7. For Financials, if you enabled Rolling Forecast, click Rolling Forecast to select the basis for continuous planning. Select the planning frequency (monthly or quarterly), the number of periods, and the number of actual periods.

    For Financials, you can also select a weekly planning frequency and choose whether to plan at a weekly level for 13, 26, or 52 weeks.

    The number of actual periods defines how many time periods of actual data to show in forms and dashboards in conjunction with the rolling forecast time periods.

    The Rolling Forecast Range is updated based on your selections.

    If you are using a 12-period calendar with 53 weeks, Rolling Forecast Range is updated to include Week 53 in ranges that include it.

    When you configure rolling forecast, forms and dashboards are set up based on the planning frequency and number of periods. When you change the current planning period, the rolling forecast forms and dashboards are updated—time periods are added or dropped and actuals time periods are updated to reflect the new rolling forecast range.

    You can plan using a combination of standard forecasting and rolling forecasting.

  8. If you enabled weekly planning for Financials, specify the current week. You need to update this value on a weekly basis.

    • In 13-period applications, there is a 53rd week every five to six years, based on the options you selected in Create Application.
    • In 12-period applications, on the Plan and Forecast tabs, a 53rd week is added to the Current Week list in the year and period determined by your selections when you enabled 53 weeks.
  9. If you enabled Budget Revisions, click the Adopted Budget tab to specify the planning basis for each year of your adopted budgets. This determines the timeframe allowed for budget revisions, which can be different than the timeframe allowed for your budget cycle.

This configuration task sets all required substitution variables.


If you want to create or edit rules to customize your planning and forecasting tasks, you can use Planning Formula Expressions in your rules to call the configured time horizon information such as [[PlanningFunctions.getModuleStartPeriod("ModuleName","ScenarioName")]] and [[PlanningFunctions.isPlanStartYearSameAsCurrentFiscalYear("ModuleName")]].

Module names are not case sensitive and must be enclosed in double quotation marks:

  • Capital

  • Financials

  • Projects

  • Workforce

See Scenarios in Designing with Calculation Manager for Oracle Enterprise Performance Management Cloud .