Before you Begin

This 35-minute tutorial shows you how to incrementally enable contract projects and revenue planning, plan for expenses, plan for revenue, and analyze plans. The sections build on each other and should be completed sequentially.

Background

With Projects, you can bridge the gap between project planning systems and the financial planning process. You can assess the impact organizational projects and initiatives have on overall corporate resources and ensure they align with short and long term financial targets.

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

Projects supports these types of projects:

  • Indirect, or internal projects—Projects that are run internally by your company, such as IT, RD, and marketing projects.
  • Contract projects—Projects that generate revenue; used by companies such as those that make money from contract projects.
  • Capital projects—Projects that manage capital investments; used by companies that invest in capital assets. For example, a company building a new facility can manage costs, labor, equipment, and so on to manage capitalization of assets.

Projects provides these components that you can enable incrementally to best meet your project planning needs:

  • Project Summary
  • Expense
  • Revenue
  • Analysis

You can plan for projects using these 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.
  • 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.

In the application used in this tutorial, Projects was enabled with these features:

Enabled Features

Enabled custom dimensions

In this tutorial, you incrementally enable Contract project types and Revenue planning.

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.

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 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 review the values set for user variables.

  1. Click Navigator (Navigator), then under Tools, click User Preferences.
    User Preferences
  2. On the left, click User Variables.
    User variables
  3. Review the selected members for each dimension:
    User variables with selected Members
  4. Return to the home page. On the upper right, click Home icon (Home).

Enabling Contract Projects and Revenue

In this section, you enable contract project types and revenue planning.

  1. On the home page, click Application, and then Configure.
    Navigate to the COnfigure page
  2. On the Configure page, select Projects from the dropdown list.
    Configure page

    The Configure page for Projects is displayed.

    Configure page for Projects
  3. On the Configure page for Projects, click Enable Features.
  4. In Enable Features, under Project Type, select Contract.
    Selecting project types

    A Contract project is work performed for a customer and the customer reimburses the company. A contract project generates revenue based on an underlying contract; costs are incurred and planned against it. The Contract project expenses, revenue, and billing can be for services performed and reimbursed by a client. Contract projects can be Time and Materials, Fixed Price, Cost Plus, and Other.

  5. Select Revenue, then Direct Input.
    Revenue features
  6. On the upper-right, click Enable.
  7. At the confirmation message, click Yes.
    Confirmation message

    The enable process takes a moment to complete.

    Enable process
  8. At the information message, click OK.
    Information message
  9. Sign out and sign back into Planning.
  10. On the home page, click Projects and verify that Revenue is now available within that cluster.
    Projects cluster

Adding a Contract Project

In this section, you add a contract project.

  1. In the Projects cluster, click Project Summary.
    Project Summary

    Project Summary opens with the Contract vertical tab selected and the Contract Projects Overview dashboard displayed.

    Contract Projects Overview
  2. From the horizontal tabs, click Project Details.
  3. In the grid's whitespace, right-click and select Add Project.
    Adding projects
  4. In Add Project, enter or select the following:
    Property Value
    Enter Project Name Eureka
    Enter Project Start Date 7/1/22
    Enter Project End Date 3/1/24
  5. Verify your selections and click Next.
    Adding Project
  6. For Contract project options, enter or select the following:
    Property Value
    Enter Project Type Time and Material
    Enter Revenue Recognition Monthly
    Enter Revenue Cash Flow Same Month
  7. Verify your selections and click Launch.
    Contract project options
  8. At the information message, click OK.
    Information message

    The project was added and displays on the form.

    Project as added

Planning for Expenses

In this section, you enter expense assumptions and calculate expenses.

  1. From the cards on top, click Expense.
    Expense card

    The Expense Overview dashboard is displayed.

    Expense Overview
  2. In the POV, for Project, select Eureka and click Go (Go).
    Selecting the Eureka project

    There is no data on the dashboard. You will be planning for expenses for the Eureka contract project.

    Eureka Overview
  3. From the vertical tabs on the left, click Driver based (Driver Based).
  4. In Expense Assumptions for the Labor horizontal tab, verify that Eureka is selected in the Project POV.
    Project POV
  5. In the grid, enter or select the following labor assignments:
    Expense driver values
  6. Click Save.
  7. At the information message, click OK.
    Information message

    The background color of the "dirty" (yellow) cells turn white after data is saved.

    Data is saved
  8. In the grid's empty corner cell above Line 1, right-click and select Calculate Expenses.
    Calculate Expenses

    The calculation process takes a moment to complete.

    Calculation status
  9. At the information message, click OK.
    Information message

    The form is updated with calculated data.

    Updated form

Planning for Revenue

In this section, you enter revenue directly to a project.

  1. From the cards on the top, click Revenue.
    Revenue
  2. In the Revenue Overview dashboard, verify that Eureka is selected in the Project POV.
    Revenue Overview
  3. From the vertical tabs on the left, click Direct Input Direct Input.
  4. In Project Revenue, verify the POV selections.
    POV
  5. In the grid, enter or select the following values:
    Revenue values
  6. Click Save.
  7. At the information message, click OK.
    Information message

    The background color of the "dirty" (yellow) cells turn white after data is saved.

    Data is saved
  8. In the grid's empty corner cell above Line 1, right-click and select Calculate Revenues.
    Calculate Revenues

    The calculation process takes a moment to complete.

    Calculation status
  9. At the information message, click OK.
    Information message

    Data is saved, calculated, and aggregated.

Analyzing Contract Projects

In this section, you explore forms and dashboards used to review projects.

  1. From the cards on top, click Analysis.
    Analysis
  2. From the vertical tabs on the left, click Profitability (Profitability)
  3. Review the Project Detailed Analysis.
    Profitability
  4. From the horizontal tabs, click Project Profitability.
  5. Review Revenue and Expenses.
    Revenue and Expenses
  6. Expand all levels under Total Revenue and Total Expenses and review the data on the form.
    Project Profitability
  7. Optional: Expand levels under YearTotal to review period distribution.
  8. From the cards on top, click Project Summary.
    Project Summary
  9. From the vertical tabs on the left, verify that you are on Contract (Contract).
  10. From the horizontal tabs, click Contract Projects Overview.
    Horizontal tabs
  11. In Contract Projects Overview, verify the POV and review the dashboard.
    Contract Projects Overview

Learn More