Before you Begin

This 60-minute tutorial shows you how to configure and enable features in Capital. The sections build on each other and should be completed sequentially.

Background

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

In this tutorial, you configure and enable features in Capital.

With Capital, you can manage, prioritize, and plan for capital expenses. Capital helps decision-makers and front-line managers communicate throughout the request, justification, review, and approval process.

You can perform the following tasks in Capital:

  • Perform driver-based calculations to assess the impact of changes and additions on profit, cash flow, and funding
  • Request and approve capital expense plans
  • Anticipate the impact to financial statement given transfers, impairments, retirements, and replacement

Before you can start planning capital assets, you must enable Capital features. Enable only the features you want to use. You can incrementally enable components to best meet your capital planning needs; however you must enable all the dimensions you want to include in the application the first time you enable features.

Caution:

After you enable a feature, you can’t later disable it.

What Do You Need?

An EPM Cloud Service instance allows you to deploy and use one of the supported business processes. To deploy another business process, you must request another EPM Enterprise Cloud Service instance or remove the current business process.

  • Have Service Administrator access to an EPM Enterprise Cloud Service instance. The instance should not have a business process created.
  • Upload and import this snapshot into your instance.
  • Download this file (CPX_Entity.csv) to a local folder.

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.

Enabling Capital

In this section, you configure and enable features for Capital.

Navigating to the Configure Page for Capital

  1. On the home page, click Application, and then Configure.
    Application cluster
  2. On the Configure page, select Capital from the dropdown list.
    Selecting Capital

    The Configure page for Capital is displayed.

    Configure page for Capital

Selecting Features and Components

  1. On the Configure page for Capital, click Enable Features.
    Enable Features
  2. In Enable Features, select New Capital Investment.
    New Capital Investment

    Enabling New Capital Investment allows you to plan for tangible assets, lease assets, and intangible assets. You can also add the names of assets to plan at a detailed level.

  3. Under New Capital Investment, select the following components:
    • Lease Assets
    • Intangible Assets
    • Named Assets
  4. Under Lease Assets, select IFRS16 Standard.
    IFRS Standard

    If you are performing lease asset planning, you can incrementally enable IFRS16 support by selecting IFRS16 Standard under Lease Assets.

    Tip:

    To learn more about how IFRS Standard features are implemented in Capital, see the Enabling New Capital Investment section of the Administering Planning Module documentation.
  5. Under Named Assets, set the number of New Assets per Planning Cycle to 100.
    New Capital Investment component
  6. Select Manage Existing Assets.
    Exising Assets

    Enabling Manage Existing Assets allow you to plan for asset-related expenses, retirement, transfers, and improvements. You can also plan for existing intangible assets.

  7. Select the following components:
    • Existing Intangibles
    • Retirements
    • Transfers
    • Improvements/Impairments
    Existing Expenses

Mapping Existing and Custom Dimensions

  1. In Map/Rename Dimensions, review the preselected dimensions for Capital.
    Map/Rename Dimensions
  2. Select Custom 1.

    Once selected, two options are enabled: Rename Target Dimension (Rename Target Dimension) and Clear Target Dimension (Clear Target Dimension).

    Custom 1
  3. For Custom 1, click Rename Target Dimension (Rename Target Dimension).
  4. In the Map/Rename Dimension dialog, select Project from the Map from existing dimensions list.
    Mapping Project
  5. Click OK.

    Custom 1 is mapped to the Project dimension.

    Enable Features
  6. In Enable Features, click Enable.
  7. At the confirmation message, click Yes.
    Confirmation message

    The enable process takes a moment to complete.

    Progress bar
  8. At the information message, click OK.
    Information message
  9. Sign out and sign back into Planning.

Adding Asset Class Members

You can add or import tangible asset class members. You can select from the provided list of asset class members or add your own custom asset class.

In this section, you add tangible asset class members by selecting from a predefined list.

  1. On the home page, click Application, and then Configure.
  2. On the Configure page, select Capital from the dropdown list.

    The Configure page for Capital displays enabled features. You can now start configuring and adding components.

    Configure page for Capital
  3. Click Assets.
  4. In the Assets dialog, click Actions, select Add, and then Provided Members.
    Actions

    Provided Members
  5. From the Provided Members list, select the following and click OK:
    • Buildings
    • Land
    • Machinery and Equipment
    • Vehicles
    • Computers

    Provided Members dialog
  6. In the Asset dialog, review and verify the asset class members you selected and click Save.
    Assets
  7. At the information message, click OK.
    Information message
  8. Click Close.

Setting the Timeframe and Granularity for Plans

In this section, you configure the time frame and granularity for Capital plans.

  1. On the Configure page for Capital, click Planning and Forecast Preparation.
    Planning and Forecast Preparation

    The Planning and Forecast Preparation dialog is displayed.

    Planning and Forecast Preparation
  2. Set the Current Fiscal Year to FY21.
  3. For Plan, set the Years to 9 Years.
    Years

    Note:

    The application you imported includes years from FY20 to FY29. With FY21 selected as the Current Fiscal Year, that leaves nine (9) years left. You can add years to the beginning or end of the calendar, but you can't reduce the number of calendar years without creating a database. See the Adding Years to the Calendar section of the Administering Planning documentation.
  4. Select All, and then click Planning Basis (Planning Basis) and select Monthly.
    Planning basis

    Tip:

    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.
  5. Click Save.
  6. At the validation message, click OK.
    Validation message
  7. Click Close.

Adding Intangible Assets

  1. On the Configure page for Capital, click Intangible Assets.
    Intangible Assets
  2. In the Intangible Assets dialog, click Actions, select Add, and then Provided Members.
    Actions

    Provided Members
  3. From the Provided Members list, select the following and click OK:
    • Brand Valuation
    • Copyrights

    Provided Members dialog
  4. In the Intangible Asset dialog, review and verify the intangible asset class members you selected and click Save.
    Added members
  5. At the information message, click OK.
    Information message
  6. Click Close.

Setting Up the Entity Hierarchy

In this section, you import entities to the OEP_CPX cube using a data file.

  1. From the cards on the top, click Overview.
    Application Overview

    The Application page is opened with the Overview tab displayed.

    Application Overview
  2. Click the Dimensions tab.

    The Dimensions tab displays the dimensions in the Plan1 cube.

    Plan1
  3. From the Cube dropdown list, select OEP_CPX.
    OEP_CPX

    Dimensions in the OEP_CPX cube are now listed on the page.

    OEP_CPX Dimensions
  4. Click Import.
    Import
  5. In Import Metadata, click Create.
    Import Metadata
  6. From the list of dimensions, locate Entity and click Choose File.
    Choose File

    Note:

    Depending on your browser, the button label may display Choose File or Browse.
  7. Navigate to where you saved CPX_Entity.csv, then select or open it.

    Once selected, it displays as:

    Import file attached
  8. At the top of the dialog, click Import.

    Tip:

    Oracle recommends validating your import file before running the import process. The import file included in this tutorial has been tested and validated.
  9. In Options, select Refresh Database if Import Metadata is successful and click OK.
    Refresh database
  10. At the information message, click OK.
    Information message
  11. Click Close, twice to close both Import Metadata dialogs.
  12. From the cards at the top, click Jobs.
    Jobs
  13. In Jobs, locate the following jobs and verify that they completed successfully:
    Jobs

Enabling Capital Projects

In this section, you enable Capital Projects.

  1. From the cards on top, click Configure.
    Configure
  2. On the Configure page, select Projects from the dropdown list.
  3. On the Configure page for Projects, click Enable Features.
    Enable Features for Projects
  4. In Enable Features, under Project Type - Internal Projects, select Capital.
    Capital Projects

    Caution:

    Both Projects and Capital must be enabled before you enable Capital Projects.
  5. In Enable Features, click Enable.
  6. At the confirmation message, click Yes.
    Confirmation message

    The enable process takes a moment to complete.

    Progress bar
  7. At the information message, click OK.
    Information message
  8. Sign out and sign back into Planning.
  9. On the home page, click Application, and then Overview.
    Application Overview
  10. In Application - Overview, click Actions, then select Refresh Database.
    Actions menu
  11. In Refresh Database, click Create.
    Create
  12. Accept all default selections and click Refresh Database.
    Refresh Database
  13. Click Refresh.
    Refresh database
  14. When the cube refresh progress completes, click Finish.
    Completed refresh
  15. Click Close, twice to close both Refresh Database dialogs.
  16. On the upper-right of the page, click Home (Home).

Setting Up Assumptions

Assigning Values to User Variables

User Variables were added when the business process was created. User variables act as filters in forms, enabling planners to focus only on certain members. In this section, you set values for user variables.

  1. On the home page, click Tools, and then User Preferences.
    User Preferences
  2. On the left, click User Variables.
    User variables
  3. For each variable, click its Member Selector (Member Selector) to select a member as the variable's value:
    User Variable Member
    Currency USD
    Entity Operations US
    Reporting Currency USD
    Scenario Plan
    Version Working
    Years FY21
  4. Verify your selections and click Save.
    User variables with selected Members
  5. At the information message, click OK.
    Information message
  6. On the upper-right of the page, click Home (Home).

Setting Up Depreciation Assumptions

In this section, you set global assumptions for an asset's depreciation value.

  1. On the home page, click Capital, and then Investments.
    Capital Investments
  2. From the vertical tabs on the left, click Assumptions (Assumptions).
  3. In Depreciation Assumptions, enter or select the following and click Save:
    Depreciation

    After saving, the "dirty" (yellow) cells turn white.

    Depreciation assumptions

Setting Funding Assumptions

In this section, you set up funding and cash flow assumptions.

  1. From the horizontal tabs, click Funding Assumptions.
  2. Enter or select the following and click Save:
    Save

Setting Assumptions for Other Expenses

In this section, you enter assumptions for other expenses such as the percentage for Repairs, Insurance, Maintenance, and Taxes.

  1. From the horizontal tabs, click Other Expenses Assumptions.
  2. Enter the following values and click Save:
    Other Expenses
  3. At the information message, click OK.

    Assumptions were saved to the application.

    Saved data

Learn More