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

This configuration task sets all required substitution variables.

In Capital, forms and rules allow different planning years for the Plan and Forecast scenarios.

During Capital Planning and Forecast Preparation configuration, instead of setting the &OEP_YearRange substitution variable for both Plan and Forecast scenario, Capital configures business rules to use methods that read the start year and end year from the Planning and Forecast Preparation configuration separately for each scenario. Forms are created to display data based on the start and end periods for the scenario.

To create custom rules for Capital, use these functions rather than the &OEP_YearRange substitution variable:

  • [[PlanningFunctions.getModuleStartYear("CAPITAL",{Scenario})]]—Returns start year of given scenario

  • [[PlanningFunctions.getModuleENDYear("CAPITAL",{Scenario})]]—Returns end year of given scenario

To create custom forms for Capital, use ILvl0Descendants of "All Years" instead of &OEP_YearRange.


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 .