Introduction

This tutorial introduces you to the Cloud EPM business processes. You also learn how to create Planning business processes in Cloud EPM Service subscriptions.

Background

Oracle Cloud EPM provides end-to-end business processes, such as Planning, to meet the requirements of most organizations and ensure a connected and agile experience across multiple business processes.

Prerequisites

A Cloud EPM Service instance allows you to deploy and use one of the supported business processes. To deploy another business process, you must request another Cloud EPM Service instance or remove the current business process. The business processes that you deploy share the same identity domain to facilitate user management and assigning of roles. Access to resources belonging to a business process is individually controlled for each business process.

Planning is a budgeting and forecasting solution that integrates financial and operational planning processes and improves forecast accuracy.

Cloud EPM Hands-on Tutorials may require you to import a snapshot into your Cloud EPM Enterprise Service instance. Before you can import a tutorial snapshot, you must request another Cloud EPM Enterprise Service instance or remove your current application and business process. The tutorial snapshot will not import over your existing application or business process, nor will it automatically replace or restore the application or business process you are currently working with.

Before starting this tutorial, you must:

  • Have Service Administrator access to a Cloud EPM Enterprise Service instance for the respective sections of the tutorial. The instance should not have a business process created.
  • Download and save the following files to a local folder:
    • LCM snapshot for migration in the Cloud EPM Standard Service instance: ModPlnStd.zip
    • OTL file for creating the business process: Sales.otl
    • LCM snapshot for migration in the Cloud EPM Enterprise Service instance: P_Sample_LCM_v3.zip

Note:

If you run into migration errors importing the snapshot, re-run the migration excluding the HSS-Shared Services component, as well as the Security and User Preferences artifacts in the Core component. For more information on uploading and importing snapshots, refer to the Administering Migration for Oracle Enterprise Performance Management Cloud documentation.

Getting Started

In this section, you learn about Planning in the Cloud EPM Service.

Available Cloud EPM Subscriptions

Oracle Cloud Enterprise Performance Management provides end-to-end business processes to meet the requirements of most organizations and ensures a connected and agile experience across multiple business processes. The business processes and features available to you depend on the specific Cloud EPM subscription that you purchased.

  • The EPM Standard Subscription is a powerful, configurable suite of business processes. It is designed primarily for small and mid-sized businesses.
  • The EPM Enterprise Subscription comprises the full suite of Cloud EPM business processes supporting a comprehensive array of activities. It includes all functionalities of the EPM Standard subscription.

The following table outlines the key features available with Cloud EPM subscriptions.

Note:

  • AI and GenAI features are available exclusively with EPM Enterprise subscriptions.
  • Intelligent Performance Management (IPM) features are available exclusively with EPM Enterprise subscriptions.

    Exception: AutoPredict is also available with Planning in EPM Standard subscription.

  • Some features available with both EPM Standard and EPM Enterprise subscriptions are not listed in this table. For a comprehensive overview of features related to each business process, refer to the Administrator guides.
High-level Features Available with Cloud EPM Subscriptions
EPM Standard Subscription EPM Enterprise Subscription
Planning
  • Planning Modules
    • Capital
    • Financials
    • Projects
    • Workforce
    • Strategic Modeling
  • One Reporting (ASO) cube and one Input (BSO) cube
Planning

All EPM Standard subscription features plus:

  • Application Types:
    • Custom Planning (with Strategic Modeling support)
    • FreeForm
    • Predictive Cash Forecasting
    • Sales Planning
    • Strategic Workforce Planning
  • Multiple Reporting (ASO) and Input (BSO) cubes
  • Custom Groovy Scripting support
  • Cloud EPM System Reports within Reports
Account Reconciliation (with Reconciliation Compliance) Account Reconciliation

All EPM Standard subscription features plus Transaction Matching

Financial Consolidation and Close
  • Supplemental Data Management
  • Financial Consolidation
  • Support for Complex Ownership Structures
  • Configurable Consolidation Rules
  • Equity Pickup
  • Custom Configurable Calculations and On-demand Rules
Financial Consolidation and Close

All EPM Standard subscription features plus:

  • Enterprise Journals
  • Custom Groovy Scripting support
  • Cloud EPM System Reports within Reports
Narrative Reporting
  • Report Packages
  • Reports
Narrative Reporting

All EPM Standard subscription features plus:

  • Report Notes
  • Cloud EPM System Reports within Reports
  FreeForm
  Enterprise Data Management (with limits on hosted employee and hosted record metrics)
  Profitability and Cost Management

Application Types:

  • Enterprise Profitability and Cost Management
  • Profitability and Cost Management
  Tax Reporting
  • Tax Provisions
  • Country by Country Reporting (CbCR)
  • Pillar Two (Global and Local Top-up Tax)
  • Supplemental Data Management
  • Custom Configurable Calculations and On-demand Rules, including Groovy (preview)
  • Cloud EPM System Reports within Reports

Planning Modules and Strategic Modeling: Planning provides five complete, planning and budgeting solutions for Financials, Workforce, Capital, Projects, and Strategic Modeling. They include built-in best practice predefined content including forms, calculations, dashboards, drivers, and key performance indicators (KPIs). You can get up and running quickly by enabling only the features you need, and later enable additional features to enhance your application. You can integrate to plan at the detail level you need. Configurable help provides default descriptions for forms and members, which you can customize for your business needs.

  • Financials: The Financials solution provides integrated driver-based planning for income statement, balance sheet, and cash flow. The out-of-box tools, such as KPIs, drivers, and accounts help you prepare reports faster. You can also use Financials to perform expense and revenue planning.
  • Workforce: The Workforce solution enables headcount and compensation planning to link financial plans with the workforce plan. You can budget for future headcount and related personnel expenses such as salary, benefits, and taxes.
  • Projects: The Projects solution bridges the gap between project planning systems and the financial planning process. It helps you assess the impact organizational projects and initiatives have on overall resources to ensure they align with short and long term financial targets.
  • Capital: The Capital solution helps you plan for the long-term impact of capital assets on financial plans to manage, prioritize, and plan for capital expenses.
  • Strategic Modeling: The Strategic Modeling solution combines a set of rich financial forecasting and modeling features with built in on-the-fly scenario analysis and modeling capabilities for long-term strategic planning.

Cloud EPM Service Landing Pages

The landing page is your starting point for creating a business process and for viewing video tours to help you get started. The landing page presents the business processes that you can create.

Cloud EPM Standard Service Landing Page

Cloud EPM Standard Service Landing Page

Cloud EPM Enterprise Service Landing Page

Cloud EPM Enterprise Service Landing Page

Planning Business Process Overview

You develop your operational financial plan with Planning. You set up the Planning business process to include the appropriate structure for your organization's needs. Each Planning business process has a specific framework with the following structure:

  • Application name — Specify the name of the business process.
  • Calendar structure — Specify your organization’s calendar, such as the first month and first year for your fiscal year.
  • Currency — Identify whether multiple currencies are needed and define the default currency.
  • Number and names of cubes — Select and name plan types to hold combinations of metadata, forms, and business rules.

After the framework is created, dimensions and members (metadata) are added and assigned to cubes. Security is assigned so that users and groups can access Planning. Access can be further defined to secure metadata, forms, task lists, and business rules.

Creating the Standard Planning Business Process

Before you create your Planning business process, analyze your current processes and determine your organization’s requirements.

Note:

See the Best Practices for Designing Your Application section in the Oracle Cloud Administering Planning documentation

In this section, you learn how to create the following Planning business processes in Cloud EPM Standard Service:

  • Module-based
  • Migrated Custom

Tip:

After you initiate the creation of a business process, you cannot return to the Cloud EPM Service landing page. If you want to return to the landing page to create a different business process, you must first reset your environment to its original state. See the Recreating Service section of this tutorial.

Logging On

  1. Go to the Planning URL provided by your Service Administrator.
  2. Enter your Username and Password.
    login
  3. Click Go.
  4. On the Cloud EPM Standard Service landing page, for Planning click SELECT.

    The Planning landing page is displayed.

    Planning business process

New Application: Creating a Module-based Application

Note:

If you have a business process created, remove it first by following the steps in the Removing Applications section of this tutorial.
  1. On the Planning landing page, for Create a new application, click START.
    Create a new application
  2. Complete the required general properties:
    • Name your application.
    • Enter a description.
    Standard Create Planning
  3. Click Next.

    The Details page is displayed.

    Standard Create Details page
  4. Select a Time Period.
  5. Select the Start and End year.
  6. Select the First Month of Fiscal Year.
  7. Select a Weekly Distribution option: Even, 445, 454, or 544.
  8. For Task Flow Type, EPM Task Manager is the default option for new applications.

    Task lists are a classic feature which guides users through the planning process by listing tasks, instructions, and end dates.

  9. Select the Main Currency.
  10. Select whether to allow for Multicurrency.
  11. Accept or modify the names of the Input Cube and Reporting Cube.
  12. Select whether to enable Sandboxes.
  13. Select whether to enable Strategic Modeling.
  14. Click Next.
  15. Review your selections. If necessary, return to previous pages to make changes.
    Review selections
  16. When ready to proceed, click Create.

    The Application Creation Status information message box is displayed.

    Application creation status

    Application creation may take several minutes. When completed, an Application created successfully message is displayed.

    Application created successfully
  17. Click Configure or complete that task later.

    If you click OK, the Planning home page is displayed. You can access the Configure page by navigating to Application, then Configure from the home page.

    If you click Configure, the Configure page for modules is displayed.

    Note:

    Refer the Administering Planning Modules documentation for configuration details of the respective Planning Module for your business need.

Migrating a Snapshot to Create an Application

Migration allows you to create a custom Planning business process from a snapshot that you upload to the environment.

Note:

If you have a business process created, remove it first by following the steps in the Removing Applications section of this tutorial. You will need a snapshot compatible with Cloud EPM Standard Service to perform the steps in this tutorial.
  1. On the Planning landing page, click MIGRATE.
    Migrating snapshots

    The Migration page is displayed.

    Migration dialog box
  2. Click Snapshots.

    The Snapshots tab is displayed.

    Snapshots tab
  3. Click Upload.
  4. In the Upload dialog box, click Browse to select the file.

    Note:

    Depending on your browser, the button label may display Choose File or Browse. The snapshot is not provided in this tutorial. You can get a snapshot compatible with Cloud EPM Standard Service to perform the steps in this tutorial.
  5. Navigate to where you saved ModPlnStd.zip, then select and open it.
  6. Click Upload.
  7. When a message stating that the File uploaded and processed successfully is displayed, click OK.
    Upload completed successfully

    The snapshot is now listed on the Snapshots tab.

  8. For the snapshot you uploaded, click the Actions icon (), and select Import.
    Actions menu for the imported snapshot
  9. When prompted to proceed with the import, click OK.

    The Migration Status Report is displayed. The migration import process may take several minutes.

  10. Click Refresh until the status displays Completed.
    Completed migration
  11. Click Close twice to close both dialog boxes.
  12. Sign out and log back in to start working with Planning.

Creating the Enterprise Planning Business Process

Before you create your Planning business process, analyze your current processes and determine your organization’s requirements.

Note:

See the Best Practices for Designing Your Application section in the Oracle Cloud Administering Planning documentation on docs.oracle.com.

In this section, you learn how to create the following Planning business processes in Cloud EPM Enterprise Service:

  • Sample application
  • Module-based
  • Custom
  • FreeForm
  • Migrated Custom

Tip:

After you initiate the creation of a business process, you cannot return to the Cloud EPM Service landing page. If you want to return to the landing page to create a different business process, you must first reset your environment to its original state. See the Recreating Service section of this tutorial.

Logging On

  1. Go to the Planning URL provided by your Service Administrator.
  2. Enter your Username and Password.
  3. Click Go.
  4. On the Cloud EPM Enterprise Service landing page, for Planning click SELECT.

    The Planning landing page is displayed.

    Planning business process

Sample Application

Planning provides a sample business process, called Vision, that lets you quickly deploy a business process with artifacts and data. The sample business process is only available in Planning for Cloud EPM Enterprise Service.

If you have a business process created, remove it first by following the steps in the Removing Applications section of this tutorial.

  1. On the Planning landing page, for Create a sample application, click CREATE.
    Planning landing page

    The Application Creation Status information message box is displayed.

    Application creation status

    Application creation may take several minutes. When completed, an Application created successfully message is displayed.

  2. Click OK.

    The Planning home page is displayed.

    Planning home page

    Note:

    The home page is for the Default Navigation Flow.
    Planning home page

New Application: Creating a Module-based Application

Note:

If you have a business process created, remove it first by following the steps in the Removing Applications section of this tutorial.
  1. On the Planning landing page, for Create a new application, click START.
  2. Create a new application
  3. Complete the required general properties:
    • Name your application.
    • Enter a description.
    • From the Application Type dropdown list, select Modules.
    • Planning module selection screen
  4. Click Next.

    The Details page is displayed. The Planning Frequency is set to Monthly.

    Details page
  5. Select a Time Period.
  6. Select the Start and End year.
  7. Select the First Month of Fiscal Year.
  8. Select a Weekly Distribution option: Even, 445, 454, or 544.
  9. For Task Flow Type, EPM Task Manager is the default option for new applications.

    Task lists are a classic feature which guides users through the planning process by listing tasks, instructions, and end dates.

  10. Select the Main Currency.
  11. Select whether to allow for Multicurrency.
  12. Accept or modify the names of the Input Cube and Reporting Cube.
  13. Select whether to enable Sandboxes.
  14. Select whether to enable Strategic Modeling.
  15. Click Next.
  16. Review your selections. If necessary, return to previous pages to make changes.
    Review selections
  17. When ready to proceed, click Create.

    The Application Creation Status information message box is displayed.

    Application creation may take several minutes. When completed, an Application created successfully message is displayed.

  18. Click Configure or complete that task later.

    If you click OK, the Planning home page is displayed. You can access the Configure page by navigating to Application, then Configure from the home page.

    If you click Configure, the Configure page for modules is displayed.

    Note:

    Refer the Administering Planning Modules documentation for configuration details of the respective Planning Module for your business need.

New Application: Creating a Custom Application

Custom applications support most planning and budgeting requirements through Enterprise complex business logic, such as business rules and allocations. Select this option to create a business process if your requirements would necessitate a high degree of application customization.

Note:

If you have a business process created, remove it first by following the steps in the Removing Applications section of this tutorial.
  1. On the Planning landing page, for Create a new application, click START.
  2. Create a new application
  3. Complete the required general properties:
    • Name your application.
    • Enter a description.
    • From the Application Type dropdown list, select Custom.
    • Planning general properties
  4. Click Next.

    The Details page is displayed.

    details page
  5. Select a Period Frequency: Monthly, Weekly, Quarterly, or Custom.
    • If you selected Monthly:
      • Select the First Month of Fiscal Year.
      • Select a Weekly Distribution option: Even, 445, 454, or 544.
  6. Select the Start and End year.
  7. If you selected Weekly or Quarterly, select the First Fiscal Period Start Date.
  8. If you selected Custom:
    • Enter the Periods per Year.
    • Optional: Specify a prefix.
  9. Select whether to enable Rolling Forecast and specify the Period Duration.
  10. For Task Flow Type, EPM Task Manager is the default option for new applications.
  11. Select the Main Currency.
  12. Select whether to allow for Multicurrency.
  13. Accept or modify the names of the Input Cube and Reporting Cube.
  14. Select whether to enable Sandboxes.
  15. Select whether to enable Strategic Modeling.
  16. Click Next.
  17. Customize the required Planning dimensions, if necessary.
  18. Metadata and Custom Dimensions page
  19. Add members in the Member Names column, separating each name with a comma.
  20. Optional for Account, Scenario, Version, Entity, and Custom Dimensions: Import metadata using a file.
  21. To add a custom dimension, for the dimension type listed as Custom, enter a dimension name.
  22. If you need to add more dimensions, click Add Custom Dimension to add another row.
  23. Click Next.
  24. Review your selections. If necessary, return to previous pages to make changes.
  25. Review selections
  26. Click Create.

    When application is completed, an Application created successfully message is displayed

  27. Click OK.

    The Planning home page is displayed.

New Application: Creating a FreeForm application from an Essbase Outline File

FreeForm business process can be created using an Essbase outline file (OTL) from an on-premises deployment to import dimensions and members. The outline file name can have a maximum of eight characters because the file name is used to name the cube of the FreeForm business process.

  1. On the Planning landing page, for Create a new application, click START.
  2. Create a new application
  3. Complete the required general properties:
    • Name your application.
    • Enter a description.
    • From the Application Type dropdown list, select FreeForm.
    • From the Application Setup dropdown list, accept the default value Import Essbase OTL/LCM.
    • Select a location:
      • Local — if you have the OTL or LCM stored locally.
        • If you selected Local, for Import File, click Browse.

          Note:

          Depending on your browser, the button label may display Choose File or Browse.
        • Navigate to where you saved Sales.otl, then select and open it.
      • Inbox — if you have the OTL or LCM uploaded to your instance.
        • If you selected Inbox, select your OTL or LCM from the Select One dropdown list.
        FreeForm Planning general properties
  4. Click Next.
  5. Review your selections. If necessary, return to previous pages to make changes.
    Review FreeForm Planning selections
  6. Click Create.

    Application creation may take several minutes. When completed, an Application created successfully message is displayed.

  7. Click OK.

    The Planning home page is displayed.

    Planning home page

New Application: Creating a FreeForm application using Create Cubes

You can model and build your own Hybrid BSO or ASO cubes while preserving the ability to leverage Planning functionalities.

Hybrid BSO cubes support some aggregate storage capabilities. Parent members of sparse and dense dimensions can have dynamic aggregations for calculations.

Hybrid cubes provide many benefits including:

  • Smaller database and application size
  • Better cube refresh performance
  • Faster import and export of data
  • Improved performance of business rules
  • Faster daily maintenance of the application
  1. On the Planning landing page, for Create a new application, click START.
  2. Create a new application
  3. Complete the required general properties:
    • Name your application.
    • Enter a description.
    • From the Application Type dropdown list, select FreeForm.
    • From the Application Setup dropdown list, select Create Cubes
    • Select Is ASO for an aggregate storage Cube.
    • Enter a Cube Name.
      Selecting the FreeForm Application type
      Selecting the FreeForm Application type-cube name
  4. Click Next.
  5. Enable the default dimensions.
    Default dimensions

    Note:

    If you select not to enable the default dimensions here, you create them later in Classic Dimension Editor to make sure that you can assign the correct dimension type.
  6. Click Next.

    Review your selections. If necessary, return to previous pages to make changes.

    Review FreeForm Planning selections
  7. Click Create.

    Application creation may take several minutes. When completed, an Application created successfully message is displayed.

  8. Click OK.

    The Planning home page is displayed.

    FreeForm home page

Note:

Steps to creating a new application in Sales Planning or Strategic Modelling are similar to creating a Module-based or a Custom-based Planning application.

Migrating a Snapshot to Create an Enterprise Application

Migration allows you to create a custom Planning business process from a snapshot that you upload to the environment.

Note:

If you have a business process created, remove it first by following the steps in the Removing Applications section of this tutorial.
  1. On the Planning landing page, click MIGRATE.
    Migrating snapshots

    The Migration page is displayed.

    Migration dialog box
  2. Click Snapshots.

    The Snapshots tab is displayed.

    Snapshots tab
  3. Click Upload.
  4. In the Upload dialog box, click Browse to select the file.

    Note:

    Depending on your browser, the button label may display Choose File or Browse.
  5. Navigate to where you saved P_Sample_LCM_v3.zip, then select and open it.
  6. Click Upload.
  7. When a message stating that the File uploaded and processed successfully is displayed, click OK.

    The snapshot is now listed on the Snapshots tab.

    List of snapshots
  8. For the snapshot you uploaded, click the Actions icon (), and select Import.
    Actions menu for the imported snapshot
  9. When prompted to proceed with the import, click OK.

    The Migration Status Report is displayed. The migration import process may take several minutes.

  10. Click Refresh until the status displays Completed.
  11. Click Close twice to close both dialog boxes.
  12. Sign out and log back in to start working with Planning.
    home page

Removing Applications

In this section, you learn how to remove applications from your Planning instance.

  1. From the Planning home page, click Application, and then Overview.
  2. Applications cluster
  3. On the Overview tab, click Actions and select Remove Application.
  4. Remove Application in the Actions menu
  5. When prompted to continue to delete the application, click Yes.
    Confirm application removal

    The process takes a few minutes to complete. When the application is completely removed, you will be signed out of the instance.

Recreating Service

The process of recreating your environment deletes the current business process, including all user-defined (custom) artifacts and data from the environment. If you want to preserve the data and artifacts in the current environment, you must perform a complete backup of the business process before you re-create an environment.

Tip:

The environment is not available for approximately 15 minutes, while the re-create process is in progress.

After re-creating the environment, you can create the same business process or a different one. You can also import a business process from a snapshot using Migration or EPM Automate.

In this section, you learn how to restore the environment into its original state, ready for you to create a new business process.

  1. From the Planning landing page or home page, access Settings and Actions by clicking your username at the top right corner of the screen and select Recreate Service.
    Settings and Actions

    The Recreate Service dialog box is displayed. Carefully read the information. The process deletes the application, including its data and artifacts.

  2. Select the checkboxes to confirm that you are aware of the consequences of recreating the environment.
    Recreate Service dialog box
  3. Click Recreate Service.

    You are signed out of the instance. The instance will be inaccessible for approximately 15 minutes.

More Learning Resources

Explore other labs on docs.oracle.com/learn or access more free learning content on the Oracle Learning YouTube channel. Additionally, visit Oracle University to view training resources available.

For product documentation, visit Oracle Help Center.