Introduction

This 30-minute hands-on tutorial reviews best practice planning in Financials using your own chart of accounts. After loading your own chart of accounts, you can leverage out-of-the-box features and incrementally add more features to your application. The sections build on each other and should be completed sequentially.

Background

While a complete chart of accounts is included to get you up and running quickly, Financials also gives you the flexibility to use your own chart of accounts and still retain the benefits of the integrated Financials framework.

Financials delivers tools to help you quickly develop plans and forecasts, and generate core financial statements such as balance sheets, cash flow statements, and income statements for internal analysis. Financials provides these components that you can enable incrementally to best meet your business needs:

  • Revenue / Gross Margin
  • Expense
  • Balance Sheet
  • Cash Flow
  • Income Statement
  • Analysis

Here are a few considerations when incrementally enabling features in Financials:

  • If you are planning at the weekly level with a 12-month calendar, you can incrementally enable an option to support a 53-week calendar. Options you specify when enabling 53 weeks determine in which month and year the 53rd week falls. Usually the 53rd week occurs every fourth or fifth calendar year. You can’t disable this feature once it’s enabled.
  • You can enable custom dimensions only on the first time you enable Financials.
  • You can incrementally associate custom dimensions with additional features after you first enable Financials.
  • If you incrementally enable additional features, any new forms or other artifacts are added to the original and the copy of the navigation flows.

Prerequisites

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.
  • Upload and import this snapshot into your Planning instance. Alternatively, you can complete the steps in the Configuring Financials to Bring In Your Chart of Accounts hands-on tutorial, and use that as your starting point for this tutorial.
  • Save this data file locally and extract the ExportedData_Account.csv load file. You will be importing data using this load file.

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.

Reviewing the business process configuration

Reviewing the previously added chart of accounts

Review the previously added members for the chart of accounts. These accounts were not included during Financials configuration.

Note:

To learn more about loading your own chart of accounts, step-through the Configuring Financials to bring in your own Chart of Accounts hands-on tutorial.
  1. On the Planning home page, click Application, then Overview.
  2. Click Dimensions.
  3. From the Cube dropdown list, select OEP_FS.
    4. Selecting the Financials cube
  4. Click Account.
  5. Expand OFS_Financials Accounts.

    6. Here are the parent key members enabled in Financials:

    Account key members
  6. Expand OFS_Revenue Planning, and then OFS_Gross Profit.
  7. Expand the members under OFS_Revenue Planning to display the custom chart of account members.
    8. Revenue accounts
  8. When finished, collapse the hierarchy until only the parent key members are visible under OFS_Financial Accounts.
  9. Expand OFS_Expense Planning, and then OFS_Total Expenses.
  10. Expand the members under OFS_Total Expenses to display the custom chart of account members.
    11. Expense accounts
  11. When finished, collapse the metadata hierarchy.
  12. Switch dimensions. In Edit Member Properties, click the arrow next to the dimension name and select a dimension: Entity, Product, Market.
    • Entity: Expand OEP_Total Entity, and member levels below it to view entities.
    • Product: Expand Total Product, and member levels below it to view products.
      • Products
    • Market: Expand Total Market and member levels below it to view markets.
      • markets

Adding shared members

Some of the included charts and dashboards depict results from key members. Include accounts by adding them as shared members under the appropriate parent. The share can be at the level of detail required for your business.

  1. In Edit Member Properties, click the arrow next to the dimension name and select Account.
  2. Expand OFS_Financials Accounts, then OFS_Income Statement.
  3. Under OFS_Income Statement, select OFS_Net Income.
  4. Click (Add Child).
  5. In the Add Child dialog box, enter 2 and click Apply.
    6. Add Child

    Yellow colored rows were added under OFS_Net Income.

    Added rows
  6. Edit the Member Name for the cells added under OFS_Net Income to:
    • OFS_Gross Profit
    • OFS_Total Expenses
  7. For both members, set the Default Data Storage to Shared.
    8. Shared members
  8. Click Save.

    9. The members are temporarily added to the hierarchy. To commit changes, you must refresh the database.

  9. Click Refresh Database (Refresh Database).
  10. In the Refresh Database dialog box, accept the default selections, and click Refresh Database.

    11. Tip:

    It is recommended that Enable Use of the Application is set to Administrators, before and after refreshing the database, until Financials is completely configured and ready for production.
  11. In the Refresh Database prompt, click Refresh.

    12. The Cube Refresh/Create in Progress status is displayed.

    Cube refresh status
  12. When the status displays as Succeeded and the percent complete is 100%, click Finish.
    13. Cube Refresh Status completed
  13. Click Close.
  14. Click Cancel.

Reviewing the enabled Financials features

Navigating to the Planning home page

From the upper right portion of the page, click (Home).

Navigating to the Configure page

From the Planning home page, click Application, then Configure.

Navigating to the Configure page

If you have another card open in the Application cluster, click Configure from the cards on the top of the page.

Configure card
  1. From the Configure dropdown list, select Financials.
    2. Select Financials
  2. Click Enable Features.

    3. The Financials - Enable Features dialog box is displayed.

    Enable Features dialog box
  3. Verify that the following key account members are enabled:
    • Revenue/Gross Margin
    • Expense
    • Income Statement
    • Balance Sheet
    • Cash Flow Statement

    Tip:

    You may need to scroll down the page to display more options.
  4. Scroll down to the Map/Rename Dimensions section.
  5. Verify that the following custom dimensions are listed and mapped:
    6. Mapped custom dimensions

Incrementally enabling Financials features

Financials allows you to incrementally enable features, depending on your company’s needs.

Enabling additional Financials features

  1. In Enable Features, beginning at the top of the page, select the following features:
    • Revenue/Gross Margin
      • Accounts
      • Drivers and Related Accounts
        • Product
      Revenue selections
    • Expense
      • Accounts
      • Drivers and Related Accounts
        • Marketing
        • Travel & Entertainment
        • Facilities
      Expense selections
    • Income Statement
      • Gross Profit

        • Additional Options:

      • Simple
      Income Statement selections
    • Balance Sheet

        • Accounts

        • Asset
        • Liability & Equity
      Balance Sheet selections
    • Cash Flow Statement
      • Direct Accounts
        • Sources of Cash
        • Uses of Cash
        • Non-Operating Cash
    Cash Flow selections
  2. Aside from accounts and drivers, enable Rolling Forecast.
    3. Rolling Forecast
  3. Review your selections, then click Enable.
  4. When prompted to confirm that you want to continue, click Yes.
    5. Confirm enable features

    A status box is displayed.

  5. When the enable process completes, a message box to confirm is displayed. Click OK.
    6. Enable process completed message box
  6. Sign out and log back in to Planning.

Reviewing enabled account drivers

Predefined drivers and the chart of accounts you bring in can co-exist within the Account dimension member hierarchy.

  1. On the Planning home page, click Application, then Overview.
  2. Click Dimensions.
  3. From the Cube dropdown list, select OEP_FS.
  4. Click Account.
  5. Expand OFS_Financials Accounts.

    6. For each parent key member, expand the member hierarchy to view the added drivers and KPIs.

  6. Display Revenue accounts, drivers, and KPIs. Expand OFS_Revenue Planning, and its descendants.
    7. Revenue accounts
  7. When finished, collapse the hierarchy until only the parent key members are visible under OFS_Financial Accounts.
  8. Display Expense accounts, drivers, and KPIs. Expand OFS_Expense Planning, and its descendants.
    9. Expense accounts
  9. When finished, collapse the metadata hierarchy.
  10. Expand OFS_Income Statement, OFS_Balance Sheet Planning, OFS_Cash Planning and their descendants to review account members and KPIs.
  11. When finished, click Cancel to close Edit Member Properties.

Performing post-configuration tasks

Setting Period and Scenario combinations

  1. Navigate to the Configure page for Financials.
  2. Click Planning and Forecast Preparation.
    3. Planning and Forecast Preparation
  3. In the Planning and Forecast Preparation dialog box, for Plan, make the following selections:
    • Current Fiscal Year: FY23
    • Period: Jun
    • Plan Start Year: Next Fiscal Year
  4. Review the selections and accept the defaults for Forecast and Rolling Forecast.
  5. Click Save.
  6. If prompted that changing the current year will reflect in all business processes, click OK.
    7. Confirm period changes
  7. Click Close.
  8. Go to the Planning home page.

Setting User Variables

Before you can open dashboards and forms, you must set values for user variables.

  1. On the Planning home page, click Tools, then Variables.

    2. 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. This is where you create additional User Variables for your business process.

    User variables
  2. Change the value for Expense Account to iDescendants(OFS_Financials Accounts).
  3. Click Save.
  4. When prompted that the record(s) saved successfully, click OK.
  5. From the cards on the top of the page, click User Preferences.

    6. Planners must first select values in preferences for the variable before opening forms and dashboards.

    Click User Preferences
  6. In the left pane, click User Variables and enter the following members for the user variables:
    • Currency: USD
    • Entity: Sales US
    • Reporting Currency: USD
    • Scenario: OEP_Plan
    • Version: OEP_Working
    • Years: FY24
    • Expense Account: OFS_Total Expenses
    • Expense Drivers: OFS_Expense Drivers for Forms

    Tip:

    You can use Member Selector to select members.
    Selecting user variable members
  7. Click Save.
  8. When prompted, click OK.
  9. Go to the Planning home page.

Importing data into Financials

  1. From the Planning home page, click Application, then Overview.
  2. On the Application page, click Actions and select Import Data.
    3. Import data option
  3. On the Import Data dialog box, click Create.
  4. Accept the default selection, Local, as the Location.
  5. Accept the default selection, Default, as the Source Type.
  6. Accept the default selection, Comma delimited, as the File Type.
  7. For Source File, click Browse File.
  8. Navigate to the location of the ExportedData_Account.csv import file, select it, and click Open.
  9. Select Include Metadata.
  10. For Date Format, accept the default selection: MM-DD-YYYY.
  11. Review your selections.
    12. Import data file selections
  12. Click Import.
  13. On the Information dialog box that confirms that the import data job was submitted successfully, click OK.
  14. Click Close twice to close the Import Data dialog boxes.
  15. From the cards displayed on top of the page, click Jobs and then locate the Import Data job.
  16. Click Refresh until the status displays as Completed.
  17. Go to the Planning home page.

Building revenue and expense plans

You can plan using several different methods:

  • Driver-based—Enter global rate assumptions and other assumptions (for example revenue drivers or expense drivers) to take advantage of built-in accounts and calculations to drive the planning process.
  • Trend-based—For Financials only, enter trend-based assumptions that let you plan and forecast based on trends. For example, you can plan by using current, projected, or past values (such as Forecast Average or Year Over Year Increase) and estimate the percent by which each value is likely to change.
  • Direct Entry—Directly enter data, for example if your planning and forecasting does not have historic trends or specific business drivers. When you use this planning method, no built-in logic is used.

On the Planning home page, click Financials.

Keep in mind that by default, the cards in the Financials cluster depend on what features you enabled. You can customize the display of clusters and cards using navigation flows.

Financials card

In this section of the tutorial, we will quickly go through the Revenue and Expense components.

Note:

Learn more about Financial Planning by stepping-through the EPM hands-on tutorials.
  1. From the Financials cluster, click Revenue or Expense.

    2. The Revenue Overview dashboard or Expense Overview dashboard is displayed.

    Revenue Overview dashboard

  2. Navigate between options using horizontal and vertical tabs.

    Revenue dashboard vertical tabs

    Expense dashboard vertical tabs

    Horizontal tabs vary depending on the vertical tab displayed.

    The vertical tabs, found on the left side of the page, take you to the following options:

    Vertical Tab Name Description 
    Overview vertical tab Overview Review an overview of your financials in a dashboard format.
    Driver and Trend Based vertical tab Driver and Trend Based Enter values for the drivers, view actual account values calculated by drivers, override values if needed, evaluate planned or forecast values and historic actuals using driver trends, plan, without any internal driver-based based logic, at the individual account level by manually entering and adjusting expenses.
    Rolling Forecast vertical tab Rolling Forecast Plan revenue and expenses using a rolling forecast. Use these forms instead of, or in addition to, the forms on the Driver and Trend Based tab.
    Direct Entry vertical tab Direct Entry Enter and adjust account values that are not driver-derived, and manually enter rolling forecast values.
    Income Statement vertical tab Income Statement View Income Statement data.
  3. Verify that the data point-of-view (POV) is set to the following:
    • Entity: Sales US
    • Version: Working (OEP_Working)
    • Reporting Currency: USD
    • Years: FY24
  1. For standard forecasting, click the Driver and Trend Based vertical tab and then:
    • For Revenue, click the Driver Based Revenue Planning horizontal tab.
      Driver Based Revenue Planning
    • For Expenses, click the Driver Based Expense Planning horizontal tab.
      • Driver Based Expense Planning

    Tip:

    If there is no data displayed, set POV members to match the examples.

    Enter assumptions and adjustments on these tabs.

  2. View values for driver calculated accounts and enter adjustments on Driver Based Revenue and Driver Based Expenses horizontal tabs.

    3. Driver Based Revenue

    Driver Based Expenses

    Tip:

    Scroll down to view all members, including the chart of accounts members that were added.
  3. The Revenue Trends, Expense Trends, and Trend Based Expense Planning horizontal tabs let you set values by adjusting using the current, projected, or past values, selecting a trend, and estimating the percent by which each value is likely to change in % Increase/Decrease.

    4. For example, to plan for a 3% overtime pay increase, you would set Overtime to Prior Year Actual Average, and enter .03 in % Increase/Decrease.

    Revenue Trends

    Expense Trends

    Trend Based Expense Planning

Manually entering revenue and expenses

  1. For either Revenue or Expenses, click the Direct Entry vertical tab.

    2. Expense Direct Entry

    Revenue Direct Entry

  2. For each revenue or expense item, enter a monthly or quarterly value.

    3. If you are using a rolling forecast, you can plan revenue and expense on the Enter Revenue Rolling Forecast and Enter Expenses Rolling Forecast horizontal tabs, respectively.