Before you Begin
This 90-minute tutorial shows you how to configure and enable features in Projects. 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 Projects.
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.
You use Projects to evaluate how assets and resources related to corporate initiatives are allocated, and analyze their probable return on investment.
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.
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.
- Download the following import files:
Creating the Application
In this section, you create a Module-based Planning application.
- On the Enterprise landing page, for Planning, click SELECT.
- On the Planning landing page, for Create a new application, click
START.
- In the Application Wizard, for General properties, enter or select the following:
Detail Value Name EPMPLAN Description EPM Projects Application Type Modules - Verify your selections and click Next.
- In Details, for Time Period, accept the default: 12 Months.
- Set the Start and End year to: 2020 to 2029.
- Accept the following default time period selections:
Detail Value First Month of Fiscal Year January Weekly Distribution Even Distribution - Verify your selections.
- For multicurrency, accept all default selections and click Next.
- Review application details and click Create.
The application creation process takes a moment to complete.
When the application creation process completes, an information message displays.
You can click OK to proceed to the home page, or click Configure to proceed to the Configure page for modules.
- Click Configure.
Enabling Features
In this section, you select which features in Projects to enable and set the application to display the Redwood Experience.
Selecting Features and Components
- On the Configure page, select Projects from the dropdown list.
The Configure page for Projects is displayed.
- On the Configure page for Projects, click Enable Features.
- In Enable Features, select Project Type, and then under Internal Projects, select Indirect.
You can enable Contract, Capital, and Indirect project types. In this tutorial, you enable Indirect projects.
Indirect projects have a cost impact but don’t generate revenue. If a project is classified as Indirect, you can do only expense budgeting for the project. You can, however, plan financial and non-financial benefits of the project.
- Select Project Benefits, then select Financial and Non-Financial.
For indirect and capital projects, an additional way to analyze project finances is by tracking project benefits. By planning project benefits, you can quantify the financial benefits to help justify the need for the project. You can also plan the non-financial benefits of a project, which can be used to justify a project and help measure a project's success.
-
Select Expense, then:
- Under Driver Based, select Labor and Equipment
- Direct Input
You can plan expenses for all project types.
- Scroll down to Map/Rename Dimensions.
- In Map/Rename Dimensions, review the preselected dimensions for Projects.
- For Program, select Enable.
- In the upper-right, click Enable.
- At the confirmation message, click Yes.
The enable process takes a moment to complete.
- At the information message, click OK.
- Sign out and sign back into Planning.
Enabling the Redwood Experience
- On the home page, click Tools, then Appearance.
- In Appearance, select Enable Redwood Appearance.
- For Display Business Process Name, select No.
- Click Save.
After saving, the application displays in the Redwood theme.
Specifying Application Settings
- Click
(Navigator), and under Application, click Settings.
- In Application Settings, under Number Formatting, set the Thousands Separator to Comma.
- Under System Settings, select
Display Users' Full Names.
- Click Save.
- At the information message, click OK.
Importing Entities
In this section, you import entities as part of the configuration process.
- Click
(Navigator), then under Application, click Configure.
- On the Configure page, select Projects from the dropdown list.
The Configure page for Projects displays enabled features. You can now start configuring components.
- Click Entities.
- In Import Metadata for Entity, click Choose File.
Note:
Depending on your browser, the button label may display Choose File or Browse. - Navigate to where you saved Entity.csv, then select or open it.
Once selected, it displays as:
- 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. - In Options, select Refresh Database if Import Metadata is successful and click OK.
- At the information message, click OK.
- In Import Metadata, click Close.
- On the Configure page for Projects, verify that the status for Entities shows as In Progress.
- From the cards on top, click Jobs.
- In Jobs, locate the following jobs and verify that they completed successfully:
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.
- Click
(Navigator), then under Tools, click User Preferences.
- On the left, click User Variables.
- For each variable, click its
(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 - Verify your selections and click Save.
- At the information message, click OK.
Setting the Timeframe and Granularity for Plans
In this section, you set up the timeframe and period granularity for Project plans.
- Click
(Navigator), then under Application, click Configure.
- On the Configure page, select Projects from the dropdown list.
- On the Configure page for Projects, click Planning and Forecast Preparation.
The Planning and Forecast Preparation dialog is displayed.
- For Period, select Mar.
- For Plan Start Year, select Current Fiscal Year.
- Verify your selections:
- For Plan, set all years to Monthly.
Typically, projects are planned and calculated in detail monthly. If your organization plans using a different time period, make sure to select the appropriate time period in your application.
- Click Forecast.
- For Forecast, set all years to Monthly.
- Click Save.
- At the validation message, click OK.
- Click Close.
Importing Job Codes
In this section, you import resource class members. The Resource Class consists of labor, material, and equipment codes. You import detailed jobs to use for planning project expenses.
Reviewing the Job Smart List
- Click
(Navigator), then under Create and Manage, click Smart Lists.
- From the available Smart Lists, select Job and click
(Edit).
- Click the Entries tab.
- Note that there are no Job entries other than the OPF_Detailed_Jobs placeholder:
- Click Cancel.
Adding Resource Class Members
- On the Configure page for Projects, click Resource Class.
- In Import Metadata for Resource Class, click Choose File.
Note:
Depending on your browser, the button label may display Choose File or Browse. - Navigate to where you saved Resource_Class.csv, then select or open it.
Once selected, it displays as:
- 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. - In Options, select Refresh Database if Import Metadata is successful and click OK.
- At the information message, click OK.
- In Import Metadata, click Close.
- On the Configure page for Projects, verify that the status for Resource Class shows as In Progress.
- Optional: Navigate to Jobs to verify that the import process completed successfully.
Verifying the Imported Resource Class Members in the Job Smart List
- Click
(Navigator), then under Create and Manage, click Smart Lists.
- From the available Smart Lists, select Job and click
(Edit).
- Click the Entries tab.
- Review the added Smart List entries:
- Click Cancel.
Adding Expense Accounts
In this section, you import custom expense accounts to include in planning projects.
- Click
(Navigator), then under Application, click Configure.
- On the Configure page, select Projects from the dropdown list.
- On the Configure page for Projects, click Expense Accounts.
- Review the predefined expense accounts by changing the Category and Component dropdown list selections.
- For Category, select Other.
- For Component, select Total Other Expenses.
- Review the expense accounts in this category and component.
- Click Actions and select Import.
- In the Import dialog, click Choose File.
Note:
Depending on your browser, the button label may display Choose File or Browse. - Navigate to where you saved Expenses.xlsx, then select or open it.
After the import completes, members are added to the Expense Accounts dialog for the selected category and component.
- Click Save.
- At the information message, click OK.
- Click Close.
Adding a Custom Project Category Property
In this section, you create a Smart List and associate it with a project property.
Creating a Project Category Smart List
- Click
(Navigator), then under Create and Manage, click Smart Lists.
- Click
(Create).
- Enter the following properties:
Property Value Smart List Project_Category Label Project Category - Verify that entered the Smart List name and label correctly, and click the Entries tab.
- In Entries, click Actions and select Add.
- Accept the default ID and enter the following properties:
Name Label IT Information Technology - Repeat steps 5 through 6 to add the following entries:
Name Label NPD New Product Development MKT Marketing BT Business Transformation DT Digital Transformation - Verify your entries and click Save.
Adding the Project Category Smart List to Project Properties
- Click
(Navigator), then under Application, click Configure.
- On the Configure page, select Projects from the dropdown list.
- On the Configure page for Projects, click Project Properties.
- In Project Properties, click Actions and select Add.
A new row is added to the Project Properties dialog.
- Enter the following member properties:
Property Value Name Project Category Alias Project Category Time Balance Flow Data Type SmartList Smart Lists Project_Category - Verify your entry and click Save.
- At the information message, click OK.
- Click Close.
- On the Configure page for Projects, click Actions and select Refresh Database.
- In Refresh Database, click Create.
- In the next Refresh Database, accept all default selections and click Refresh Database.
- When prompted, click Refresh.
Refreshing the database takes a moment to complete.
- Click Finish.
- Click Close, twice to close both Refresh Database dialogs.
Adding Members to the Program Attribute
In this section, you add members to the Program attribute.
- From the cards on top, click Overview.
- In Application, click Dimensions.
- For Cube, select All.
- Click Program.
Edit Member Properties for Program is displayed.
- Click
(Add Child).
- In Add Child,for Number of members to add, enter 3 and click Apply.
Three (3) rows were added to the grid.
- Replaced the untitled member names with:
- Transformation
- New Tech
- Management
- Verify your entries and click Save.
Grid cells change in color to confirm that the entries were saved.
- Click Cancel.
- In Application - Dimensions, click Actions and select Refresh Database.
- In Refresh Database, click Create.
- In the next Refresh Database, accept all default selections and click Refresh Database.
- When prompted, click Refresh.
Refreshing the database takes a moment to complete.
- Click Finish.
- Click Close, twice to close both Refresh Database dialogs.
Learn More
Configuring Projects
F46263-01
August 2021
Copyright © 2021, Oracle and/or its affiliates.
This 90-minute tutorial shows you how to configure and enable features in Projects.
This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.
If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:
U.S. GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software, any programs embedded, installed or activated on delivered hardware, and modifications of such programs) and Oracle computer documentation or other Oracle data delivered to or accessed by U.S. Government end users are "commercial computer software" or "commercial computer software documentation" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, reproduction, duplication, release, display, disclosure, modification, preparation of derivative works, and/or adaptation of i) Oracle programs (including any operating system, integrated software, any programs embedded, installed or activated on delivered hardware, and modifications of such programs), ii) Oracle computer documentation and/or iii) other Oracle data, is subject to the rights and limitations specified in the license contained in the applicable contract. The terms governing the U.S. Government's use of Oracle cloud services are defined by the applicable contract for such services. No other rights are granted to the U.S. Government.
This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
Intel and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Epyc, and the AMD logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.
This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.