Creating an Application

Follow these steps to create an application.

  1. If you purchased EPM Cloud before June 4, 2019, log in and click Start under Finance, click Planning and Budgeting, and then select Enterprise.
    If you purchased EPM Standard Cloud Service or EPM Enterprise Cloud Service after June 4, 2019, log in and click Select under Planning, click Start to create a Planning business process, and then select Module. For more information, seeNew EPM Cloud Services in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators to get started with the new services.
  2. Enter an application name and description and then click Next.
  3. Specify this information, noting that only monthly planning is supported.
    • Time Period—Select whether to set up the calendar for 12 month or 13 period planning. For information about planning with 13 periods, see About 13-Period Calendars.

    • Start and End year—Years to include in the application. Make sure to include the year that contains the historic actuals required for planning and analysis. For example, for an application beginning in 2020, select 2019 as the start year so that the latest actuals are available for trending and reporting purposes.

    • For 12 month calendars, select these options:
      • First Month of Fiscal Year—Month in which your fiscal year begins

      • Weekly distribution—Sets the monthly distribution pattern, based on the number of fiscal weeks in a month.

    • For 13-period calendars, select these options:
      • Distribution—Define the distribution of periods within quarters, indicating which quarter has four periods. (In a 13-period calendar, three quarters have three periods and one quarter has four periods.)

        For example, if you select 3-3-3-4, the additional period is added into the 4th quarter.

      • Fiscal Year Ends On— Define the end of the fiscal year by selecting the Day of the Week, and whether the end of the fiscal year is Last Occurring in the Fiscal Year or Closest to the Last Day of the Fiscal Year in the selected month.
      • Add Extra Week to Fiscal Period—Select which period should have five weeks. (With 13-period planning, each period is exactly four weeks long (except every five or six years, when one period has five weeks.)

      These options determine in which year the 53rd week occurs and how system member formulas are calculated.

      For example, if you define the end of the fiscal year as Friday, Last Occurring in the Fiscal Year, in December, and select 13 for Add Extra Week to Fiscal Period, the calendar is created with December 27 2019, which is the last Friday of December in 2019, as the last day of the fiscal year. Based on this date, subsequent year calendars are set up based on a 13 period calendar, adding the extra week that occurs every few years to the 13th period.


      Create Application options for 13 period applications

      Based on the selections in this example, FY19 has 52 weeks—13 periods with four weeks each. FY20 also has only 52 weeks—13 periods with four weeks each. FY21 has 53 weeks. Because we selected to add the extra week to period 13, the fifth week is in the last period (November 27 to December 31).

      After you create the application, you can preview the calendar and see each period's dates. To do so, on the Home page, click Application, then Overview, then Actions, and then 13 Period Preview Calendar. At the top, you can select the year's calendar to preview. Here is the calendar for FY21 for the example described. Note the fifth week in P13 (November 27 to December 31):


      13 Period Preview Calendar with 53 weeks
    • Main Currency—For a multicurrency application, this is the default reporting currency and the currency against which exchange rates are loaded.

    • Multicurrency—Multicurrency support is provided by the Currency dimension, and enables planning in different currencies.

      If you select Multicurrency, a member called No <Member> (for example: No Entity, No Period, No Version) is added to all dimensions to store currency information. You can’t edit or delete this member.

      Watch this tutorial video to learn more about multicurrency applications.

      video iconTutorial Video.

      For more information, see About Simplified Multicurrency.

    • Prefix—For 13-period applications, define the prefix for time periods. The default is TP. If you keep the default, time periods are named TP1, TP2, and so on.
    • Name of Input Cube—Name for data entry (block storage) cube. You can’t later change the cube name.
    • Name of Reporting Cube—Name for the reporting (aggregate storage) cube. You can’t later change the cube name.

    • Sandboxes—When you create an application, a block storage cube is created, which you can enable for sandboxes by selecting the Sandboxes option.

      If you create a custom block storage cube in the application, you can use sandboxes in that cube. When creating the custom cube, select Enable Sandboxes. (Sandboxes aren't supported in the cubes created by default for the modules.) To learn more about setting up and using sandboxes, see Administering Planning and Working with Planning.

  4. Click Next and then click Create.
For additional details about creating applications, see Administering Planning.