GUID

Oracle® Cloud
Administering Planning Modules
E94267-15
Oracle Cloud Administering Planning Modules,
E94267-15
Copyright © 2016, 2019, Oracle and/or its affiliates. All rights reserved.
Primary Author: EPM Information Development Team
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 li‐
cense 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 engi‐
neering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibi‐
ted.
The information contained herein is subject to change without notice and is not warranted to be error-free. If
you find any errors, please report them to us in writing.
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 installed on the hardware, and/or documentation, delivered to U.S. Government end users are
"commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-spe‐
cific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the pro‐
grams, including any operating system, integrated software, any programs installed on the hardware, and/or
documentation, shall be subject to license terms and license restrictions applicable to the programs. 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 Xeon 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, Opteron,
the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devi‐
ces. 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 dis‐
claim 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, prod‐
ucts, or services, except as set forth in an applicable agreement between you and Oracle.
Contents
Documentation Accessibility
Follow us on Social Media
1 Welcome
Introduction 1-1
About Financials 1-2
About Workforce 1-2
About Projects 1-3
About Capital 1-4
About Strategic Modeling 1-4
Learning More 1-5
2 Setting Up Your Application

Getting Started Checklist 2-1
Creating an Application 2-2
Converting a Standard or Reporting Application to an Enterprise Application 2-3
Conversion Considerations 2-5
Integration Scenarios and Workflow 2-5
Setting User Variables 2-8
3 Setting up Strategic Modeling

Getting Started Checklist for Strategic Modeling 3-1
4 Familiarizing Yourself With Planning Modules

Navigating 4-1
Reviewing Modified Artifacts 4-2
iii
Getting Descriptions of the Predefined Artifacts 4-3
5 Configuring Financials
Enabling Financials Features 5-1
About the Financials Chart of Accounts 5-2
Enabling Revenue and Gross Margin 5-3
Enabling Expense 5-3
Enabling Income Statement 5-4
Enabling Balance Sheet 5-4
Enabling Cash Flow 5-5
Enabling Rolling Forecast 5-5
Enabling Weekly Planning 5-6
Enabling Map/Rename Dimensions 5-7
Associating Custom Dimensions with Financials Features 5-7
About the Internal Aggregation Rules 5-8
About the Account and Plan Element Dimensions 5-8
Configuring Financials 5-9
Planning and Forecast Preparation 5-10
Weekly Configurations 5-11
Setting Global Assumptions: Exchange Rates 5-12
About Exchange Rates and Weekly Planning 5-13
About Adding and Modifying Accounts and Drivers 5-13
Adding and Managing Accounts and Drivers 5-13
Adding KPIs 5-14
Adding Accounts for Integration with Projects 5-14
Adding Custom Expense Driver Categories 5-14
Post Configuration Tasks 5-15
Specifying Days in Period for Driver-Based Balance Sheet 5-15
Modifying Account Signage for Alternate Reporting Methods 5-15
Financials Rules 5-15
6 Configuring Workforce
Enabling Workforce Features 6-1
Identifying the Level of Workforce Detail to Capture 6-4
Configuring Workforce 6-5
iv
Configuring Benefits, Taxes, and Additional Earnings 6-13
Before You Use the Benefits and Taxes Wizard 6-13
About the Benefits and Taxes Wizard 6-13
Common Properties for the Components 6-14
Component Types in the Wizard 6-14
About One-time Pay Options 6-15
About Maximum Value Type 6-15
About Earning Type 6-16
About Taxable Component 6-16
About Entering Rates 6-17
About Rates and Threshold Scope 6-17
Applying Rates by Hierarchy 6-17
Creating Custom Calculation Logic in a Component 6-18
After Configuring Using the Wizard 6-22
Example - Adding a Fringe Benefit 6-22
Setting Assumptions 6-25
Setting Defaults 6-26
Synchronizing Defaults 6-27
Post Update Tasks 6-27
Workforce Rules 6-28
Performance Considerations with Workforce Rules 6-30
7 Configuring Projects
Enabling Projects Features 7-1
Enabling Project Type 7-3
Enabling Project Revenue 7-3
Enabling Project Benefits 7-3
Enabling Project Expense 7-4
Enabling Rolling Forecast 7-5
Configuring Projects 7-6
Entering Global Project Rates 7-11
Mapping Projects to Programs 7-11
v
Projects Rules 7-12
8 Configuring Capital
Enabling Capital Features 8-1
Enabling New Capital Investment 8-2
Enabling Manage Existing Assets 8-2
Configuring Capital 8-3
Capital Rules 8-8
Creating a Custom Depreciation or Amortization Method 8-10
9 Configuring Strategic Modeling

Enabling Strategic Modeling 9-1
Working with Templates 9-1
Creating and Uploading Custom Templates 9-2
Changing the Owner and Access Permissions for Custom Templates 9-2
Creating a Strategic Modeling Model 9-3
Setting Up Model Access Permissions 9-4
About Model Access Permissions 9-5
Specifying Global Access Permissions for All Models 9-7
Specifying Access Permissions for a Model 9-7
Changing a Model's Owner 9-8
Changing Model Properties 9-8
Pushing Data Between Strategic Modeling and Planning 9-9
Using Groovy Business Rules with Strategic Modeling 9-9
Groovy Business Rule Examples 9-10
Pushing Data Between Strategic Modeling and Planning Using Data Maps 9-10
Defining Advanced Data Maps 9-13
Using Microsoft Excel to Define Advanced Data Maps 9-14
Associating a Data Map with a Model 9-15
Associating a Data Map with a Consolidation 9-15
Running a Data Map 9-16
Integrating Data Between Strategic Modeling and Financials 9-17
Managing Metadata with Model Change Management 9-19
vi
Defining Target Models for Model Change Management 9-20
Defining Metadata to Copy with Model Change Management 9-20
Copying Metadata from Source to Target 9-23
Editing or Deleting a Model Change Management Definition 9-24
10 Followup Administrative Tasks

Pushing Data Using Data Maps 10-1
Mapping Data for Reporting 10-2
Entering Assumptions 10-2
Maintaining Your Application 10-2
Updating Planning Modules 10-3
Customizing Predefined Artifacts 10-3
Reviewing Modified Artifacts 10-4
Reversing Customizations 10-5
Customizing Help for Predefined Artifacts 10-5
Customizing Navigation Flows 10-6
A Business Scenarios
IT Financial Management in EPM Cloud A-1
Configuring Planning Modules for IT Planning A-7
B Importing Data
About Importing Data B-2
Importing Financials Data B-2
Importing Workforce Data B-4
Loading and Calculating Incremental Workforce Data B-6
Preparing the Source Data File B-6
Configuring the Incremental File Adapter in Data Management B-7
Deciding Which Workforce Rules to Add B-12
Executing an Incremental Workforce Data Load B-13
Importing Projects Data B-13
Importing Capital Data B-31
C Updating Artifacts
Updating Workforce Artifacts to Use New Features C-1
Updating Capital Artifacts C-12
vii
For information about Oracle's commitment to accessibility, visit the Oracle Accessibili‐
ty Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Access to Oracle Support

Oracle customers that have purchased support have access to electronic support
through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/look‐
up?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if
you are hearing impaired.
viii
Follow us on Social Media
Follow EPM Information Development on these social media sites:
LinkedIn - http://www.linkedin.com/groups?gid=3127051&goback=.gmp_3127051
Twitter - http://twitter.com/hyperionepminfo
Facebook - http://www.facebook.com/pages/Hyperion-EPM-Info/102682103112642
See all videos on YouTube - https://www.youtube.com/oracleepminthecloud
To provide feedback on this documentation, send email to [email protected].
ix
1
Welcome
Related Topics
• Introduction
• Learning More
Introduction
Planning provides five complete, planning and budgeting solutions for Financials,
Workforce, Capital, Projects, and Strategic Modeling. They include built-in best prac‐
tice predefined content including forms, calculations, dashboards, drivers, and key per‐
formance 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 de‐
fault descriptions for forms and members, which you can customize for your business
needs.
• Financials— Enhance your ability to manage and analyze finances at any busi‐
ness level using driver or trend-based income statement, balance sheet, and cash
flow planning, or simply plan revenue and expenses. With the best practice, out of
box key performance indicators, drivers, and accounts, Financials accelerates
your planning process. See About Financials.
• Projects— Bridge the gap between project planning systems and the financial
planning process. Assess the impact organizational projects and initiatives have
on overall corporate resources and ensure they align with short and long term fi‐
nancial targets. See About Projects.
• Workforce—Headcount and compensation planning to link financial plans with the
workforce plan. Budget for future headcount and related personnel expenses such
as salary, benefits, and taxes. See About Workforce.
• Capital— Planning for the long-term impact of capital assets on financial plans.
Manage, prioritize, and plan for capital expenses. See About Capital.
• Strategic Modeling—For long-term strategic planning, this solution combines a set
of rich financial forecasting and modeling features with built in on-the-fly scenario
analysis and modeling capabilities. See About Strategic Modeling.
Watch this overview video to learn more.
Overview Video
Watch this overview video to learn how to enable, configure, and maintain the applica‐
tion.
Overview Video
After you enable features, predefined artifacts are created including:
1-1
Chapter 1
Introduction
• Dimensions, including Accounts

• Forms
• Rules (calculations)
• Member formulas
• Dashboards
Forms integrate with the dashboards and reports that dynamically reflect data, plans,
and forecasts.
Oracle reserves the right to restrict export or import of the provided content in the fu‐
ture.
About Financials
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
Financials integrates with Capital, Workforce, and Projects so that planners can create
very granular plans, forecasts, and financial reports that include different types of data.
Watch this overview video to learn more about Financials.
Overview Video
About Workforce
Workforce enables planners to align critical corporate resources—people and dollars
—with the strategies that best leverage a competitive advantage. Using Workforce, de‐
partments collaborate to plan headcount and related expenses such as salaries,
health care, bonuses, and taxes. Planners can see up-to-date graphics that show ex‐
penses and trends.
Depending on the features that you enable, planners can manage and track head‐
count expenses by:
• Analyzing, calculating, and reporting on headcount, salary, bonuses, taxes, and
health care expenses
• Planning for hires, transfers, promotions, terminations, and so on
• Defining country-appropriate taxes and benefits
To integrate corporate strategy with execution, enable the Strategic Workforce op‐
tion. Strategic Workforce enables Human Resource departments to plan long-range
1-2
Chapter 1
Introduction
headcount and required skills. Planners can analyze future demands on the workforce
by exploring scenarios that impact those demands.
Tip:
To augment your workforce strategies, see Administering and Working with
Oracle Strategic Workforce Planning Cloud.
You can enable Workforce stand-alone, or integrate it with Financials and Projects.
See Integration Scenarios and Workflow.
You can also align and pull data from Oracle Human Capital Management Cloud, us‐
ing Data Management to load data. Data Management provides an out-of-the-box sol‐
ution that enables you to apply predefined mappings from the Oracle HCM Cloud mod‐
el to target dimensions in Workforce. (See Integrating Oracle HCM Cloud.) You can al‐
so customize and extend these integrations, for example, by applying other mappings
to meet your business needs.
Workforce provides these components that you can enable incrementally to best meet
workforce planning needs:
• Compensation Planning
• Other Expenses
• Demographics
• Analysis
• Strategic Workforce
Watch this overview video to learn more about Workforce.
Overview Video
About Projects
Use Projects to evaluate how assets and resources related to corporate initiatives are
allocated, and analyze their probable return on investment. Projects unifies the deci‐
sion-making process between corporate financial planning and project financial plan‐
ning processes. Because the approval processes for projects are tied to the approvals
for financial plans and forecasts, Projects ensures agreement between project spon‐
sors, key stakeholders, and financial decision makers. This aligns project plans and fi‐
nancial plans with financial targets and corporate long-range financial plans.
Projects supports several 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 for companies such as
engineering companies that make money from contract projects.
• Capital projects—Projects that manage capital investments, for companies that in‐
vest in capital assets. For example, a company building a new facility can manage
costs, labor, equipment, and so on to manage capitalization of assets.
1-3
Chapter 1
Introduction
Projects provides these components that you can enable incrementally to best meet
your project planning needs:
• Project Summary
• Expense
• Revenue
• Analysis
Watch this overview video to learn more about Projects.
Overview Video
About Capital
Use Capital to manage, prioritize, and plan for capital expenses. Capital helps deci‐
sion-makers and front-line managers communicate throughout the request, justifica‐
tion, review, and approval process. Use Capital to perform tasks such as:
• 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, retire‐
ments, and replacement
Capital provides these components that you can enable incrementally to best meet
your capital planning needs:
• Investments
• Existing Assets
• Intangibles
• Analysis
Watch this overview video to learn more about Capital.
Overview Video
About Strategic Modeling

Strategic Modeling is a solution that combines a set of rich financial forecasting and
modeling features with built in on-the-fly scenario analysis and modeling capabilities. It
helps users quickly model and evaluate financial scenarios, and offers out of the box
treasury capabilities for sophisticated debt and capital structure management. It pro‐
vides a compelling solution that can be used to set targets, perform quick financial im‐
pact analysis, and present focused financial information for informed decision making.
Strategic Modeling provides these features:
• A built-in hierarchical chart of accounts to get you up and running quickly.
• Consolidations
• Forecast modeling
1-4
Chapter 1
Learning More
• Target setting
• What-if analysis
• Integration with Financials, Capital, Projects, and Workforce, including the ability to
check the status of consolidations from the Job Console, and the ability to custom‐
ize navigation flows.
Strategic Modeling functionality is provided to a) licensed users of Oracle Financial
Statement Planning option for Oracle Planning and Budgeting Cloud Service, or b)
Oracle Financial Statement Planning provided as part of Oracle Enterprise Planning
and Budgeting Cloud Service.
Watch this overview video to learn more about Strategic Modeling.
Overview Video
Learning More
To get more information or help:
• Review best practices and watch tutorial and overview videos by clicking Acade‐
my on the Home page.
• Access context-sensitive help by clicking Help in Enable and Configure.

• To get Help, use the arrow next to your user icon in the upper right corner of the
screen, and then click Help.
• Use these related guides on the Help Center (Help Center):
– Getting Started with Oracle Enterprise Performance Management Cloud for
Administrators
– Working with Planning Modules
– Administering Planning
– Working with Planning
1-5
2
Setting Up Your Application
Related Topics
• Getting Started Checklist
Perform the tasks in this checklist to set up Capital, Financials, Projects, and
Workforce.
• Creating an Application
Follow these steps to create an application.
• Converting a Standard or Reporting Application to an Enterprise Application
Learn about converting an application in this topic.
• Integration Scenarios and Workflow
Planning uses data maps and Smart Push for out of box integration between Fi‐
nancials, Workforce, Projects, Capital, and Strategic Modeling. This section de‐
scribes the integration scenarios and the overall process for integrating.
• Setting User Variables
Getting Started Checklist

Perform the tasks in this checklist to set up Capital, Financials, Projects, and Work‐
force.
To set up Strategic Modeling, see Getting Started Checklist for Strategic Modeling.
1. Create an application. See Creating an Application.
2. If your application is multicurrency, use the Dimension Editor to add dimension
members for each currency. See Administering Planning.
3. Review the supported scenarios for integration to determine which options to ena‐
ble and any sequence required. See Integration Scenarios and Workflow.
4. Enable features.
You can add up to three custom dimensions to each module.
See:
• Enabling Capital Features
• Enabling Financials Features
• Enabling Projects Features
• Enabling Workforce Features
While you are enabling features, the application is put in maintenance mode and
only administrators can use the application. If any metadata changes are detected,
the database is refreshed before features are enabled. If any validation errors are
detected, they are displayed; you must resolve these errors before features can be
enabled.
5. Configure and run any required rules. See:
2-1
Chapter 2
Creating an Application
• Configuring Capital
• Configuring Financials
• Configuring Projects
• Configuring Workforce
Note:
Because entities are common across all modules, you can simultaneous‐
ly import all Entity members.
6. After you configure, and whenever you make configuration changes or import met‐
adata, refresh the database. Click Application , then Configure
, and then from the Actions menu, select Refresh Database, then Cre‐
ate, and then Refresh Database.
7. Set required user variables. See Setting User Variables.
8. Import data. See Importing Data.
9. Create the required user and group accounts and grant permissions. See Getting
Started with Oracle Enterprise Performance Management Cloud for Administra‐
tors.
10. Make the application available to planners. From the Home page, click Applica‐
tion , and then Settings . In System Settings, change Enable Use

of the Application for to All Users.
11. To define the approval process, define the approval units and promotional paths
for approving plans in your organization. See Managing Approvals.
12. If required, perform the data mapping required for integration. See Pushing Data
Using Data Maps.
Perform follow-up tasks as needed. See Followup Administrative Tasks.
Watch this overview video to learn how to enable, configure, and maintain the applica‐
tion.
Overview Video
Creating an Application
Follow these steps to create an application.
1. If you purchased EPM Cloud before June 4, 2019, log in and click Start under Fi‐
nance, click Planning and Budgeting, and then select Enterprise.
2-2
Chapter 2
Converting a Standard or Reporting Application to an Enterprise Application
If you purchased EPM Standard Cloud Service or EPM Enterprise Cloud Service
after June 4, 2019, log in and click Select under Planning, click Start to create a
Planning business process, and then select Module. For more information, see
New EPM Cloud Services in Getting Started with Oracle Enterprise Performance
Management Cloud for Administrators to get started with the new services.
2. Enter an application name and description and then click Next.
3. Specify this information, noting that only monthly planning is supported.
• Start and End year—Years to include in the application. Make sure to include
the year that contains the historic actuals required for planning and analysis.
For example, for an application beginning in 2018, select 2017 as the start
year so that the latest actuals are available for trending and reporting purpo‐
ses.
• First Month of Fiscal Year—Month in which your fiscal year begins
• Weekly distribution.
• Main Currency—For a multicurrency application, this is the default reporting
currency and the currency against which exchange rates are loaded.
• Multicurrency—Multicurrency support is provided by the Currency dimension,
and enables planning in different currencies.
If you select Multicurrency, a member called No <Member> (for example: No
Entity, No Period, No Version) is added to all dimensions to store currency in‐
formation. You can’t edit or delete this member.
Watch this tutorial video to learn more about multicurrency applications.
Tutorial Video.
For more information, see About Simplified Multicurrency.
• Name of Input Cube—Name for data entry (block storage) cube. You can’t
later change the cube name.
• Name of Reporting Cube—Name for the reporting (aggregate storage) cube.
You can’t later change the cube name.
• Sandboxes—When you create an application, a block storage cube is cre‐
ated, which you can enable for sandboxes by selecting the Sandboxes option.
If you create a custom block storage cube in the application, you can use
sandboxes in that cube. When creating the custom cube, select Enable Sand‐
boxes. (Sandboxes aren't supported in the cubes created by default for the
modules.) To learn more about setting up and using sandboxes, see Adminis‐
tering Planning and Working with Planning.
4. Click Next and then click Create.
For additional details about creating applications, see Administering Planning.
Converting a Standard or Reporting Application to an Enter‐

prise Application
Learn about converting an application in this topic.
2-3
Chapter 2
Converting a Standard or Reporting Application to an Enterprise Application
• If you purchased EPM Cloud after June 4, 2019, see New EPM Cloud Services in
Getting Started with Oracle Enterprise Performance Management Cloud for Ad‐
ministrators to learn about migrating an application to the new services.
• If you purchased EPM Cloud before June 4, 2019, you can convert a Standard or
Reporting application to an Enterprise application.
To convert a Standard or Reporting application:
1. Review the conversion considerations. See Conversion Considerations.
2. Back up the Standard or Reporting application.
3. Open the application, and then click Application , and then Overview
.
4. Click Actions, then Convert to Enterprise, and then Continue to proceed. A
message lets you know if the application is converted to Enterprise. If successful,
log off.
The application type is changed to "Enterprise", which includes options to enable
and configure, and enables Groovy scripting. Metadata and data isn't changed
during the conversion.
5. Log on and enable features that you need.
These validations are performed when you enable features:
• There can't be a member that already exists with the same name as any of the
custom and base dimensions you specify in Map/Rename Dimensions. For
example, if you create a custom dimension called Market in Financials, there
can't be a member called Market in any other dimension.
• There can't be a member with the name NO_<<customDimension>>, To-
tal_<Dimension>>, All_<<Dimension>>, where <<Dimension>> is the
actual dimension name you specified. For example, if you rename Plan El-
ement in Financials to Element for a custom dimension, there can't be No
Element, Total Element. This is specific to modules that depend on any
non-prefixed member.
• The data storage for the Period and Account dimensions must be set to Never
Share.
• The Year dimension name must be Years.
• 18 alias tables are predefined. The maximum supported is 32 (1 used internal‐
ly). The conversion process attempts to merge the predefined alias tables with
the alias tables in the existing application; if the count goes above 30, you get
a validation error.
• The conversion process calculates the number of existing dimensions in the
application and the number of new dimensions that would be created if the
module is initialized. If resulting sum of both is greater than 32 (the maximum
allowed), you'll see a validation error.
• For Projects, the name you specify for Program (a custom dimension option)
shouldn’t already exist as a non-attribute dimension.
2-4
Chapter 2
Integration Scenarios and Workflow
• For Workforce, none of the version members can be Label only.

When you convert an on-premise Oracle Hyperion Planning R11.1.2.1 (supported ver‐
sion) application to Planning using Migration, the same rules above apply.
Conversion Considerations
You can convert a Standard or Reporting application to an Enterprise application if:
• You are commercially authorized to implement an application of type "Enterprise".
• It does not use weekly, quarterly, or custom time periods.
• You rename the Year dimension to Years prior to converting.
• It uses simplified multicurrency (that is, it's not a standard currency application), if
it's a multicurrency application.
• Artifact names don't use these prefixes:
– oep_—Prefix for common artifacts
– ofs_—Prefix for Financials artifacts
– owp_—Prefix for Workforce artifacts
– opf_—Prefix for Projects artifacts
– ocx_—Prefix for Capital artifacts

Planning uses data maps and Smart Push for out of box integration between Finan‐
cials, Workforce, Projects, Capital, and Strategic Modeling. This section describes the
integration scenarios and the overall process for integrating.
Watch this overview video to learn more about integration.
Overview Video.
Watch this tutorial video to learn more about integrating Financials and Workforce.
Tutorial Video.
Integration Scenarios
Integrate s to take advantage of these scenarios:
• In Financials, see a rollup of Workforce employee details and integrate Workforce
expenses (such as salary, benefits, and so on) into Financials reporting.
• In Financials, see a rollup of Projects details and integrate project expenses and
revenue into your Financials reporting.
• In Financials, see a rollup of capital asset details and integrate capital asset values
(such as fixed asset values, depreciation, and other asset-related expenses as
well as cash flows) into financial reporting.
2-5
Chapter 2
• In Workforce, see the utilization of employees across projects or on a per project

basis.
• In Projects, allocate project expenses partially or fully to create one or more capital
assets.
• In Projects, use jobs, employee names, and other assumptions from Workforce for
labor expense planning.
• In Projects, use Equipment Rates from Capital.
• Integrate data between models in Strategic Modeling and income statements in
Financials.
Integration Task Flow

To implement integration, follow this overall process, in this sequence:
Note:
To push data between models in Strategic Modeling and income statements
in Financials, see Integrating Data Between Strategic Modeling and Finan‐
cials.
1. Enable and configure Financials.
Note:
Entities are common across all modules. Ideally, import the entities all at
one time.
If you are integrating Financials with Projects, note that aggregated data
for total projects is pushed to Financials. You do not need to add a
Project dimension in Financials.
2. Enable and configure Workforce.

• For integration with Financials, in the Workforce Benefits and Tax Wizard, map
a component to a Financials account (for example, to Financials Payroll Tax‐
es, Total Salary, and so on).
• For integration with Projects, utilization is computed at the employee level, so
on the Enable page, for Granularity, select either Employee or Employee
and Job.
• In Map/Rename Dimensions, add a custom dimension called Project (the
default dimension name in Projects). If you plan to rename and use a different
name for the Project dimension in Projects, use that dimension name here.
3. Enable Capital.
• For integration with Projects, on the Enable page, in Map/Rename Dimen‐
sions, add a custom dimension called Project (the default dimension name in
Projects). If you plan to rename and use a different name for the Project di‐
mension in Projects, use that dimension name here.
2-6
Chapter 2
• On the Configuration page, select the task Map Capital Accounts to Fin
Statement. For each Capital account, map it to the corresponding account in
Financials. Select the horizontal tabs to map assets for Tangible Assets, Intan‐
gible Assets, and Lease Assets.
• From the Actions menu, select Synchronize. Run this rule in these scenar‐
ios:
– Every time a new asset is added.
– Any time the integration mapping between Capital and Financials is upda‐
ted.
– When planningyearRange is increased, for example from FY14:FY15 to
FY15:FY24.
– After transferring assets (for example from one department to another).
4. Enable Projects.
• For integration with Capital, on the Enable page, enable projects of type Capi‐
tal.
• For Expense, enable Standard Rates from Workforce, and Employee (for
Workforce integration) and for equipment, Standard Rates from Capital (for
Capital integration).
• If you are integrating Projects with Workforce, you don't need to import Re‐
source Class in Projects; instead you'll use the Jobs from Workforce using the
Import Job Configuration task in Workforce.
• In Map/Rename Dimensions, you should see a mapping between Project
and Project.
Tip:
If you inadvertently named the custom dimension Projects instead of
Project when you created it in Workforce or Capital, you can rename
it here.
• On the Configuration page, select the task Projects Financials Mapping.

For each Projects account, map it to the corresponding account in Financials.
5. Optionally, review the data maps that were created. From the Home page, click
Application , then Data Exchange , and then Data Maps.

6. Complete the remaining steps in the Getting Started Checklist. See Getting Star‐
ted Checklist.
7. As users prepare plans and forecasts, when users want to move data between
modules, administrators must push data using the predefined data maps. From the
Home page, click Application , then Data Exchange , and then

Data Maps. Select a data map, and then from the Actions menu, select Push Da‐
ta and then click Yes to confirm the option to clear the data. For more information,
see Pushing Data Using Data Maps.
2-7
Chapter 2
Setting User Variables
Some forms have a menu option to push data. For these forms, users don’t have
to request administrators to push data using data maps.
Detailed Integration Scenarios
Financials and Workforce

• Detailed Workforce data can feed into Financials summary data. From Financials,
you can drill to the details of the account in Workforce.
• You can override the expense lines in Financials with the more detailed values
that Workforce stores.
Financials and Projects

• Move financial information from Projects to Financials for account level data
• Revenue planned in Projects is rolled up into Financials for contract projects
• Ability to drill through from Financials to Projects for project level financial data
• Assign project benefits for indirect projects to financial impacts for increased reve‐
nue or cost impacts
Financials and Capital

• Capital expense planning in detail is rolled into Financials at the summary level
• Asset related expenses such as depreciation, amortization, insurance are moved
• Cash flows from Capital are pushed to Financials cash flows
Workforce and Projects

• Job-level FTE input from Projects to Workforce
• Utilization of employees across projects based on assignments and reassign em‐
ployees to projects as needed
• Review FTE, labor hours, and expenses allocated to a project
Capital and Projects

• Create single or multiple assets from projects
• Detailed cost modeled in Projects and asset cost pushed to Capital
• Assignment of equipment to Projects from Capital assets
• Review Capital Work In Progress values from the project

Each planner must set the variables described below.
1. From the Home page, click Tools , then User Variables .

2. Set up these user variables:
• Entity
2-8
Chapter 2
• Scenario
• Version
• Reporting Currency
• Years
For Financials, set these user variables for the Account dimension:
• For the OFS_Expense Account variable, select OFS_Total Other Expen‐
ses.
• For the OFS_Expense Drivers variable, select OFS_Expense Drivers for
Forms.
Capital, Workforce, and Projects have their own dynamic variables (defined with the
Use Context option), which allow user variables to be used in the Point of View. With
dynamic variables, the value of the user variable changes dynamically based on the
context of the form, and users don’t need to set the default value.
2-9
3
Setting up Strategic Modeling
Related Topics
• Getting Started Checklist for Strategic Modeling
Getting Started Checklist for Strategic Modeling

Perform these tasks to set up Strategic Modeling:
1. Create an Enterprise application, or identify an existing application to use. See
Creating an Application.
2. Enable Strategic Modeling. See Enabling Strategic Modeling.
3. Review the provided templates, and upload any custom templates required for
your organization. See Working with Templates.
4. Create a model from a template. See Creating a Strategic Modeling Model.
5. Set up access permissions. See Setting Up Model Access Permissions.
6. After you enable Strategic Modeling, refresh the database. Click Application
, then Configure , and then from the Actions menu, select Re‐
fresh Database, then Create, and then Refresh Database.
3-1
4
Familiarizing Yourself With Planning Mod‐
ules
Related Topics
• Navigating
• Reviewing Modified Artifacts
You can check which original application artifacts such as forms and menus have
been modified.
• Getting Descriptions of the Predefined Artifacts
Navigating
Useful navigation tips:
• To return to the Home page when you’ve navigated away from it, click the Oracle
logo in the upper left corner (or your custom logo) or the Home icon
.
• To see additional administrator tasks in the Navigator, click the horizontal bars
next to the Oracle logo (or your custom logo) .

• Expand a dashboard to full screen by clicking the Show/Hide bar at the top of the
dashboard; click it again to return to normal view.
• Hover the cursor in the upper right corner of a form or dashboard to see a menu of
options appropriate to the context, such as Actions, Save, Refresh, Settings, Maxi‐
mize .
• In a subcomponent, use the horizontal and vertical tabs to switch tasks and cate‐
gories.
For example, use the vertical tabs to switch between reviewing Overview dash‐
boards and planning Expenses. The vertical tabs differ, depending on the features
that you’ve enabled.
4-1
Chapter 4
Reviewing Modified Artifacts
Use the horizontal tabs to switch categories within a task. For example, in Ex‐
pense planning, choose between entering expense drivers and reviewing trend-
based planning expenses.
In Financials and Capital, the icon indicates a reporting form for reviewing da‐
ta, not for data entry. The icon indicates that a form is a data entry form for
entering planning details.

been modified.
To review the artifacts in your application:
1. Click Application , then Configure , and then select Financials,

Workforce, Projects, or Capital.
2. From the Actions menu, select Review Modified Artifacts.
3. Click Filter to select an artifact type, and then click Apply.
4-2
Chapter 4
Getting Descriptions of the Predefined Artifacts
The artifacts that have been modified are listed.
Getting Descriptions of the Predefined Artifacts

After you’ve enabled features, you can review the descriptions for predefined artifacts
(for example, members, forms, and dashboards) to help you understand how features
and their associated artifacts work.
To see descriptions for predefined content:
1. Click Tools , and then click Artifact Labels .
2. Click Filter .
3. From Artifact, select Member or Form.
4. If you selected Member, select Account from the Dimension list.
5. For Property, select Formula Description for member formulas or Description
for form descriptions and click Apply.
6. Select a language from the Add Language list.
Artifacts for the features you’ve enabled are displayed, prefixed with one of the follow‐
ing:
• OFS — Financials
• OWP — Workforce
• OPF — Projects
• OCX — Capital
Note:
Scroll to the right until you can see the <Language> column.
For information about modifying the description, changing the language, or adding in‐
structions for planners, see Customizing Help for Predefined Artifacts.
4-3
5
Configuring Financials
This chapter includes these topics:
• Enabling Financials Features
• Configuring Financials
• Post Configuration Tasks
• Financials Rules
Enabling Financials Features

Before users can start planning, you must enable Financials features. Based on your
selections, dimensions, drivers, forms, and accounts are created.
Note:
• You must define all custom dimensions the first time you enable fea‐
tures. You can’t define these later.
• While you can enable more features later, Oracle recommends that you
enable only the features that planners currently require.
• You can’t disable features later.
For information about how provided drivers calculate accounts, see About the Internal
Aggregation Rules and About the Account and Plan Element Dimensions.
Watch this tutorial video to learn more about enabling and configuring Financials.
Tutorial Video
1. From the Home page, click Application , and then click Configure
.
2. From the Configure list, select Financials, and then Enable Features.
3. Select the features to enable.
5-1
Chapter 5
Table 5-1 Enabling Financials Features
Enable Description
Revenue / Gross Mar‐ Enable revenue planning. Use your own accounts or select the provi‐
gin ded Accounts and Drivers.
See Enabling Revenue and Gross Margin.
.
Expense Enable expense planning. Use your own accounts or select the provi‐
ded Accounts and Drivers.
See Enabling Expense.
Income Statement Enable income statement planning. Use your own format or a prede‐
fined income statement format.
See Enabling Income Statement.
Balance Sheet Enable balance sheet planning. Use your own accounts or select the
provided Accounts and Drivers.
See Enabling Balance Sheet.
Cash Flow Statement Enable cash flow planning and select a method. Use your own chart
of accounts or select the provided Accounts.
See Enabling Cash Flow.
Rolling Forecast Enables rolling forecast for revenue, expense, balance sheet, and
cash flow (depending on what you've enabled) to allow continuous
forecasting beyond a one year timeframe.
See Enabling Rolling Forecast.
Weekly Planning Enables planners to plan and forecast at the weekly level. You also
specify how to map weeks to months. You can enable weekly plan‐
ning at any time. See Enabling Weekly Planning.
Map/Rename Dimen‐ • Add up to five custom dimensions to your application.
sions • For each custom dimension, specify to which features it applies
—Revenue, Expense, Balance Sheet, or Cash Flow. See Asso‐
ciating Custom Dimensions with Financials Features.
• Map custom dimensions to existing dimensions.
• Rename base dimensions.
You must perform this step the first time you enable Financials. You
can’t do it later.
See Enabling Map/Rename Dimensions.
The Financials artifacts are populated, including dimensions, forms, and accounts.
About the Financials Chart of Accounts

Financials includes a robust, complete chart of accounts 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.
You choose whether to use the provided chart of accounts or your own chart of ac‐
counts when you enable features. In Enable Features:
• To use your own chart of accounts, click the checkbox next to the feature name.
If you choose to create your own chart of accounts, enabling features creates an
account structure with key members for you to add your own chart of accounts.
5-2
Chapter 5
Import your own accounts for each enabled feature. Selecting this option enables
direct entry and trend-based planning.
If you initially create your own chart of accounts, you can incrementally enable the
standard, provided chart of accounts.
• To use the provided chart of accounts, select accounts and drivers under each
feature name.
If you choose to use a standard chart of accounts or to use driver-based planning,
select which accounts and drivers to enable. Selecting this option enables a com‐
plete chart of accounts for the selected feature and enables driver-based planning.
Whether you create your own chart of accounts or use the provided accounts, you
can:
• Use existing forms and dashboards
• Work with existing integrated financial statement
• Use existing calculations, such as trend-based planning
• Integrate Financials with Capital, Projects, and Workforce.
Notes if you are using your own chart of accounts:
• For information about importing the accounts, see Importing Metadata. You can
use the Dimension Editor to see the key accounts provided.
• If you want to use the dashboards that graphically depict total results, you must
add your accounts as shared members under the appropriate parent: OFS_Total
Revenue, OFS_Total Cost of Sales, OFS_Total Operating Expenses,
OFS_Cash. The share can be at the level of detail required for your business.
Other charts and dashboards use the key members that are provided.
Watch these tutorial videos to learn more about enabling and configuring Financials
with your own chart of accounts.
Tutorial Video
Tutorial Video
Enabling Revenue and Gross Margin

Select Revenue/Gross Margin to enable Revenue/Gross Margin planning. Selecting
only Revenue/Gross Margin creates an account structure with key members for you
to add your own chart of accounts for revenue planning. Selecting this option enables
direct entry and trend-based planning.
To enable a standard chart of accounts or driver-based planning, select Accounts or
Drivers and then select the drivers to enable.
Enabling Expense
Select Expense to enable Expense planning. Selecting only Expense creates an ac‐
count structure with key members for you to add your own chart of accounts for ex‐
pense planning. Selecting this option enables direct entry and trend-based planning.
5-3
Chapter 5
To enable a standard chart of accounts or driver-based planning, select Accounts or

Drivers, and then select the expense driver categories. For example if you enable
Compensation, salary expense is derived using headcount and average salary.
Enabling Income Statement

Select Income Statement to enable income statement planning. Selecting only In‐
come Statement creates a basic income statement format.
To use a predefined income statement format, select Gross Profit or Contribution
Margin and associated options. To use the provided Gross Profit or Contribution Mar‐
gin accounts, you must also select the provided Revenue and Expense accounts. The
options you choose when you enable Income Statement affect the income statement
rollup.
Additional Options adds rollups to the income statement hierarchy.
Enabling Balance Sheet

Select Balance Sheet to enable balance sheet planning. Selecting only Balance
Sheet creates an account structure with key members for you to add your own chart of
accounts for balance sheet planning. Selecting this option enables direct entry and
trend-based planning.
To enable a standard chart of accounts or driver-based planning, select Accounts and
Asset and/or Liability and Equity or Drivers and Related Accounts. If you are do‐
ing cash flow planning and driver-based balance sheet planning, you must enable In‐
direct Cash Flow and define the days in period in the application after configuration.
5-4
Chapter 5
Enabling Cash Flow

Select Cash Flow Statement and a cash flow method (Direct or Indirect) to enable
cash flow planning.
• The Direct method calculates cash flow using sources and uses of cash. You can
use this method if you enabled Revenue and/or Expense planning.
• The Indirect method derives cash flow from Operating, Investing, and Financing
activities. To use this method, you must also enable Income Statement and Bal‐
ance Sheet.
Selecting only Cash Flow Statement and a method creates an account structure with
key members for you to add your own chart of accounts for cash flow planning.
Select account categories to add account groups to support cash flow reporting.
Enabling Rolling Forecast

Enabling rolling forecast allows planners to perform continuous planning beyond a
one-year timeframe. After you enable rolling forecast, use the Planning and Forecast
Preparation configuration task to configure rolling forecast to plan continuously at a
weekly level for either 13, 26, or 52 weeks, at a monthly level for either 12, 18, or 24
months, (and for Financials also for 30, 36, 48, or 60 months) or at a quarterly level for
either 4, 6, or 8 quarters.
By using the Planning and Forecast Preparation configuration task to define the rolling
forecast range and using the provided forms, it's easy to implement a rolling forecast.
Rolling forecast is primarily used in Financials for data entry and analysis, but if you
enable rolling forecast for Projects, you can analyze projects over the defined rolling
forecast time period range.
When you enable and configure rolling forecast:
• Rules, forms, and dashboards for rolling forecast planning and analysis are cre‐
ated.
• Forms and dashboards are designed so you can view the entire rolling forecast
range. Valid intersections are used to control what displays.
• When you update the current time period, forms and dashboards are automatically
updated to add or drop new time periods as needed to reflect the updated rolling
forecast range. Trends and drivers are populated to newly added time periods.
Valid intersections are used to make the forms dynamic.
• For Financials, a new member (OEP_Rolling Forecast) is added to the Scenario
dimension. Note that the standard forecasting member (OEP_Forecast) is still
available so you can use the standard forecasting method that allows forecasting
for a one-year timeframe and the rolling forecasting method.
• Projects uses the OEP_Rolling Forecast member to dynamically display data in
the rolling forecast range by referring to the forecast scenario (OEP_Forecast) for
the corresponding period. It does not allow data entry for the OEP_Rolling Fore‐
cast member.
If you purchased EPM Cloud before June 4, 2019, you can convert a Standard or Re‐
porting application to an Enterprise application. If you convert the application, planners
can continue to use existing forms that use the converted application's rolling forecast‐
5-5
Chapter 5
ing method because the form property that creates rolling forecast is still available in
your custom cubes.
Watch this overview video to learn more about planning using a rolling forecast.
Overview Video.
Watch this tutorial video to learn more about planning using a rolling forecast.
Tutorial Video.
Enabling Weekly Planning

In Financials, select Weekly Planning to enable planners to plan and forecast at the
weekly level. Forms are designed so planners can view weekly level plan and forecast
data. Planners can also leverage the rolling forecast range at a weekly granularity and
plan continuously at a weekly level for 13, 26, or 52 weeks.
You also specify how to map weeks to months, based on the number of fiscal weeks in
a month: 4-4-5, 4-5-4, or 5-4-4. The application treats quarterly values as if they were
divided into 13 weeks and distributes weeks according to the selected pattern. For ex‐
ample, if you select 5-4-4, the first month in a quarter has five weeks, and the last two
months in the quarter have four weeks. You can't later change the distribution method.
After you enable weekly forecast, use the Planning and Forecast Preparation con‐
figuration task to configure your Plan, Forecast, or Rolling Forecast for weekly, month‐
ly, or yearly planning.
By default, when you enable weekly planning, all entity and account combinations are
set up for weekly planning. You can specify that some entity/account combinations use
monthly planning. This is useful when most entities use weekly planning, but certain
entities use monthly planning; or when an entity plans at the monthly level except for
certain accounts. To configure weekly planning for these scenarios, see Weekly Con‐
figurations.
When you enable and configure weekly planning:
• Rules for weekly planning and analysis are created, to convert months to weeks,
and to convert weeks to months.
• Forms are designed so you can view the appropriate granularity for each time peri‐
od. For example, some years can show weekly data while other years show
monthly or yearly data. Valid intersections are used to control what displays.
• When you update the current time period, forms are automatically updated to add
or drop new time periods as needed to reflect the updated period. Trends and driv‐
ers are populated to newly added time periods. Valid intersections are used to
make the forms dynamic.
• A new member (OEP_Weekly Plan) is added to the Period dimension.
• When you enter exchange rates at the monthly level in the Global Assumptions
configuration task, when you save the form, the monthly exchange rates are cop‐
ied to the weekly level, based on how you mapped weeks to months (4-4-5, 4-5-4,
or 5-4-4), for the Financials cube (OEP_FS) only. The weekly time periods are not
automatically enabled for other cubes when they are enabled for Financials. If you
5-6
Chapter 5
enable weekly periods for other cubes and want currency conversion to work for
weekly time periods, you must enter exchange rates for weekly periods for that
cube.
Weekly currency conversion is supported for BSO cubes only. (It is not supported
for ASO cubes even if weekly periods are enabled for ASO cubes.)
• If you are integrating with Capital, Projects, or Workforce, the granularity of the da‐
ta in each must match in order to view the integration-related reports.
These batch rules must be run after planning at the weekly level, to convert weeks to
months or months to weeks, and before performing trend calculations if the actuals da‐
ta is at a monthly granularity. Give planners access to these rules and instruct them to
run the rules after performing weekly planning:
• Convert Weekly Data to Monthly. You must run this rule before planners can view
monthly data in dashboards.
• Convert Monthly Data to Weekly.
Before you run the rules Prepare Plan, Prepare Forecast, or Prepare Rolling Fore‐
cast, make sure to perform any required conversions from months to weeks or weeks
to months.
Watch this tutorial video to learn more about weekly planning.
Tutorial Video.
Enabling Map/Rename Dimensions

You must perform this configuration task the first time you enable features. Use Map/
Rename Dimensions as follows:
• To add custom dimensions. For example, you might want to plan by channel and
market. In this case, add these two dimensions and import channel and market
members. Calculations, forms, and other artifacts include the additional dimen‐
sions you specify.
• To rename a dimension if an existing dimension has the same name as a dimen‐
sion in a module you are enabling, and you want to keep both dimensions.
• To use existing dimensions in multiple modules. For example, if you set up Finan‐
cials and later enable Projects, you can take advantage of any existing dimensions
that are common between the two. Use this feature so you don't have to rebuild a
common dimension when you enable a new module.
• To reuse dimensions in a converted Planning application.
Associating Custom Dimensions with Financials Features

When you first enable features for Financials, you can add custom dimensions—Prod‐
uct, Services, and up to three additional custom dimensions. When you add a custom
dimension, you also specify to which features the dimension applies—Revenue, Ex‐
pense, Balance Sheet, or Cash Flow. For example, a custom dimension might apply
only to Expense, or only to Balance Sheet.
Custom dimensions are added to the Page in forms for features to which the custom
dimension applies. For example, if a custom dimension is applicable to Expense only,
5-7
Chapter 5
it appears on the Page for Expense forms. In forms for other features, such as Reve‐
nue, NoMember for the dimension is on the POV.
You can incrementally associate custom dimensions with additional features after you
first enable Financials.
Watch this tutorial video to learn more about associating custom dimensions with Fi‐
nancials features.
Tutorial Video.
About the Internal Aggregation Rules

Financials uses these rules:
For Actuals—The Calculate Actuals rules calculates drivers and aggregates data.
For Plans and forecasts—The Rollup rule aggregates plan or forecasts and is re‐
quired to run report or analyze data at various levels of the business hierarchy. If you
enabled revenue dimensions, this rule must be run to see Total Revenue data.
Total expense is determined by rolling up and aggregating all parent account groups.
For example, with Expense, Operating Expenses and Depreciation and Amortization
are aggregated in Total Expense.
About the Account and Plan Element Dimensions

The Account dimension is populated based on the features that you enable. If you en‐
able accounts and drivers, a complete chart of accounts with account group members,
driver members for calculations, KPIs, and forms are generated to support your type of
planning. All provided members prefixed with OFS are locked. Although you can’t de‐
lete or modify provided members, you can add members for your business accounts,
as well as define custom drivers and KPIs. If you choose to use your own chart of ac‐
counts, enabling features creates a simplified account structure with key members for
you to add your own chart of accounts, along with associated forms.
The Plan Element dimension delineates the different types and sources of data used
in the application. For example:
• Total: Calculated—Aggregates the value of all driver-derived calculations.
• Total Adjust—Enables planners to override and adjust account values that were
calculated by trends or driver-based calculations.
• Load—Contains actuals for imported accounts.
• Cash Flow Impact—Contains cash derived from financing and investing details.
• Cash Flow Calculated—Enables planners to define payment terms that specify
when customers remit payment, such as 50% within 30 days, 40% in 60 days, and
the remaining 10% in 90 days.
• Direct Entry—Enter plans or forecasts.
• Cash Flow Reporting—Members are only are seeded if Cash Flow Direct Method
is enabled. Cash Flow Direct Input aligns to the definition for Cash Flow Impact.
Cash Flow Calculated is the result of Cash Flow Direct planning in which planners
define the payment terms used in cash calculations.
5-8
Chapter 5
Perform these steps after enabling Financials features.
.
2. From the Configure list, select Financials. Use the Filter to check the status of
configuration actions. Use Actions to update task status.

3. Perform all mandatory tasks. Perform the optional tasks required for your busi‐
ness.
4. Import your business data to populate the application. See Importing Data. After
importing data, run Calculate Actuals and Rollup, and then refresh the applica‐
tion.
5. If you enabled Driver-Based Balance Sheet, see Specifying Days in Period for
Driver-Based Balance Sheet.
6. After configuring, and any time you make changes in configuration or import meta‐
data, refresh the database. From the Configure page, select Refresh Database
from the Actions menu. Click Create, and then click Refresh Database.
Table 5-2 Configuring Financials
Configure Description
Planning and Forecast Set the timeframe and granularity for plans.
Preparation Configures the timeframe, the starting period, and the level of granu‐
larity for planning and forecasting. Gives you the ability to plan and
forecast on a different basis for different years.
If you enabled Rolling Forecast, configures the rolling forecast time
periods.
See Planning and Forecast Preparation.
Weekly Configurations You can use this configuration task after you enable weekly planning
to customize the planning granularity for entity and account combina‐
tions.
See Weekly Configurations.
Revenue Accounts, Ex‐ Set up accounts, drivers, and KPIs based on the features you ena‐
pense Accounts, Bal‐ bled. You can add, modify, import, and export these artifacts. If re‐
ance Sheet Accounts, quired, you might need to add logic or calculations related to custom
Cash Flow Accounts accounts and drivers. You can also add custom expense driver cate‐
gories.
See Adding and Managing Accounts and Drivers, Adding KPIs, and
Adding Custom Expense Driver Categories.
5-9
Chapter 5
Table 5-2 (Cont.) Configuring Financials
Entities Import Entities.
Import the Entity dimension members that reflect your business hier‐
archy, such as departments, cost centers, and business units.
Select the location of the file containing the members (Local or Plan‐
ning inbox), click Browse to find the file, specify the file type, and then
click Import.
Tip:
Entities are common across modules,
so import all entities together.
Global Assumptions Enter foreign exchange rates in a multicurrency application. See Set‐
ting Global Assumptions: Exchange Rates.
Product Import product dimension members that represent your business’s
product offerings. See Importing Data.
Services Import the Services dimension members that represent your busi‐
ness's service offerings. See Importing Data.
<Custom Dimension> If you enabled any custom dimensions, import members to populate
the dimension.
See Importing Data.
Planning and Forecast Preparation

You can configure the time frame and granularity for plans for each module. You can
have a different time frame and granularity for each module and for each year.
To configure the time frame and granularity for plans:
1. In Current Fiscal Year, select the current fiscal year.
2. From Period, select the current actual month. You need to update this value on a
monthly basis.
3. From Plan Start Year, indicate if planners will plan in the current or next fiscal
year
4. Click Plan, and then the Years column to select the number of years to configure.
For example, to configure the first five years of a ten year application, select 5
Years.
5. 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.
6. Click Forecast and repeat these steps to specify the forecasting basis.
5-10
Chapter 5
7. For Financials or Projects: If you enabled Rolling Forecast, click Rolling Forecast
to select the basis for continuous planning. Select the planning frequency (monthly
or quarterly), the number of periods, and the number of actual periods.
For Financials, you can also select a weekly planning frequency and choose
whether to plan at a weekly level for 13, 26, or 52 weeks.
The number of actual periods defines how many time periods of actual data to
show in forms and dashboards in conjunction with the rolling forecast time periods.
The Rolling Forecast Range is updated based on your selections.
When you configure rolling forecast, forms and dashboards are set up based on
the planning frequency and number of periods. When you change the current plan‐
ning period, the rolling forecast forms and dashboards are updated—time periods
are added or dropped and actuals time periods are updated to reflect the new roll‐
ing forecast range.
You can plan using a combination of standard forecasting and rolling forecasting.
8. If you enabled weekly planning for Financials, specify the current week. You need
to update this value on a weekly basis.
This configuration task sets all required substitution variables.
Weekly Configurations
You can use this configuration task after you enable weekly planning to customize the
planning granularity for entity and account combinations.
When you enable weekly planning, by default all entity and account combinations are
set up for weekly planning. You can specify that some entity/account combinations use
monthly planning. This is useful when most entities use weekly planning, but certain
entities use monthly planning; or when an entity plans at the monthly level except for
certain accounts. For example, Operations might plan at a weekly level, whereas IT
plans at a monthly level. Or, for Sales US, revenue planning is at the weekly level but
expense planning is at the monthly level.
Before you set up weekly configurations, perform Planning and Forecast Prepara‐
tion to set the timeframe and granularity for plans. See Planning and Forecast Prepa‐
ration.
To set up custom configuration for planning granularity for entities and accounts:
1. From Configure, click Weekly Configurations.
2. In the Entity column, expand the Entities list until you see the entity you want to
modify.
You see entities and accounts only for the features you've enabled.
3. Change the planning granularity for an entity or for entity/account combinations:
• To switch to monthly planning for an entity and all of the accounts for the enti‐
ty, clear the Weekly Planning check box for the entity. To return to weekly
planning for all entities, or all accounts for the selected entity, from the Ac‐
tions menu, select Set All Entities as Weekly or Set All Accounts as Week‐
ly.
• To switch to monthly planning for only some accounts for an entity, in the Ac‐
counts column for the entity you want to change, click the link, expand to see
the accounts you want to change, and clear the Weekly Planning check box
5-11
Chapter 5
for the account. To return to weekly planning for all accounts for the entity,
from the Actions menu, select Set All Accounts as Weekly.
4. Click Save.
Weekly configuration considerations:
• Forms are updated to display in the granularity you specified for the entity/account
combination.
• Weekly configuration for entities and accounts is supported only for the Plan and
Forecast scenario; it is not supported for the Rolling Forecast scenario.
• All drivers involved in a calculation must be at the same granularity.
• Oracle recommends that all related driver accounts be at the same granularity. For
example, for a particular entity, all Revenue drivers could be weekly and all Ex‐
pense drivers could be monthly. But all revenue drivers should be the same granu‐
larity, and all expense drivers should be the same granularity.
• If a parent entity has a combination of weekly and monthly child entities, then you
must launch the Convert Weekly Data to Monthly or Convert Monthly Data to
Weekly rule for each entity before reviewing consolidated data on forms and dash‐
boards.
• When a form includes both monthly and weekly data, non-valid intersection cells
are not editable.
Setting Global Assumptions: Exchange Rates

If you created a multicurrency application, set up exchange rates. You can enter ex‐
change rates manually as described below, or import them. For information about im‐
porting exchange rates, see Administering Planning.
To set up exchange rates manually:
1. Add members for each of your currencies in the Currency dimension.
2. Click Global Assumptions to open the Exchange Rates to <Base Currency>
task. Here you'll enter the exchange rates for the currencies that planners will use.
3. Select the members from the Point of View.
4. Enter average and ending exchange rates for each period and each currency, and
then save the form.
The form is renamed to Exchange Rates to <Base Currency>, where <Base Cur‐
rency> is the reporting currency you selected when you created the application. For
example, if the application base currency is Yen, the form is Exchange Rates to Yen.
This indicates to planners the currency against which exchange rates are used to con‐
vert their data, and enables them to enter rates specific to scenario, year, and version.
Note:
If you add a new version, you must enter exchange rates in that version.
5-12
Chapter 5
About Exchange Rates and Weekly Planning

If you're planning at the weekly level in Financials, when you enter exchange rates at
the monthly level in the Global Assumptions configuration task, when you save the
form, the monthly exchange rates are copied to the weekly level, based on how you
mapped weeks to months (4-4-5, 4-5-4, or 5-4-4), for the Financials cube (OEP_FS)
only. For other cubes, the monthly exchange rates are not automatically copied to the
weekly level. You can create a custom form to enter exchange rates at the weekly lev‐
el.
About Adding and Modifying Accounts and Drivers

Depending on the number of custom drivers members, account members, and other
artifacts you need to add or modify, perform one of these tasks:
• A small quantity—Add or edit them directly from the configuration page
• A large quantity—Import them by:
– Exporting the existing set.
– Modifying the exported spreadsheet to add rows and data for the custom arti‐
facts.
– Importing the spreadsheet.
This export and import process speeds up the design and maintenance of the applica‐
tion. When requirements change, you can repeat this process as many times as nee‐
ded. For example, you might see a predefined marketing driver that is similar to a driv‐
er for a new social media campaign you plan to run. You can easily export the drivers,
make a copy of the marketing driver, modify it as needed for your social media cam‐
paign, and then re-import it.
Watch this tutorial video to learn more about importing custom accounts and drivers.
Tutorial Video
See Adding and Managing Accounts and Drivers for more details.
Adding and Managing Accounts and Drivers

To add or modify accounts and drivers:
1. Select the configuration task to set up accounts or drivers.
2. Select a component or category from the list (if available).
3. Perform a task:
• To add an artifact, select Add from the Actions menu, and then enter details
in the new row.
• To modify a group of artifacts, or to add many new ones, export the set of pre‐
defined artifacts (select Export from the Actions menu), and then modify the
export file in Excel. You can edit predefined artifacts, make a copy of an arti‐
fact and modify it to create a new one, or add new artifacts. Then, import the
modified file (select Import from the Actions menu). If available, use catego‐
ries and subcategories to group functionally related artifacts.
5-13
Chapter 5
• To export or import all drivers, regardless of their category or grouping, use

Batch Export or Batch Import.
• To export or import only certain kinds of drivers, specify a Category or a Com‐
ponent, and then use Import or Export.
Notes:
• Specify unique member names and aliases for custom members so they don’t
conflict with any provided members.
• If you must delete a driver, check the formulas of the other account drivers in its
group to see if they reference the driver that you want to remove. If they do, up‐
date their logic accordingly.
Adding KPIs
You add and edit KPIs in the same way you add or edit accounts and drivers.
To add or edit KPIs:
1. Check that your KPI member aliases and names don’t conflict with those of the
provided KPIs.
2. From the Configure page, select <Subcomponent> Accounts, and then select
KPIs from the Category list.
3. Perform a task:
• To add a small number of KPIs, select Add from the Actions menu and then
enter details in the new row. Click Edit Formula to enter the formula for
the metric.
• To add a group of KPIs, export the set of predefined KPIs (select Export from
the Actions menu), and then modify the export file in Excel. You can edit pre‐
defined KPIs, make a copy of a KPI and modify it to create a new one, or add
new KPIs. Then, import the modified file (select Import from the Actions
menu).
4. Refresh the database.
Adding Accounts for Integration with Projects

If you are integrating Financials and Projects and want to add additional accounts to
Financials, add a shared member under OFS_Financials Integration. This ensures
that the account appears in the Financial Statement Accounts Smart List used for
integration.
Adding Custom Expense Driver Categories

In Financials, if you enabled driver-based planning, if you need additional expense
driver categories other than the ones provided, you can add custom categories and
drivers from the Configure page. Members are automatically added under the appro‐
priate hierarchy and to the expense driver forms.
To add a custom Expense driver category:
1. From the Financials Configure page, click Expense Accounts.
5-14
Chapter 5
Post Configuration Tasks
2. From the Actions menu, select Add Category.

3. Enter a category name, and then click OK.
The CategoryName you entered is added to the Category List. The CategoryName
and Total <CategoryName> are added to the Components list.
4. To add drivers to the new category, select the category, and then select the com‐
ponent to add to: CategoryName or Total <CategoryName>.
You must add drivers under a new category to ensure that the cube refreshes suc‐
cessfully. Adding drivers under a new category is required for a successful cube
refresh.
5. From the Actions menu, select Add, enter details for the new expense driver, and
then click Save.
You can also use Export and Import to add a large number of expense drivers for
the new category.

Related Topics
• Specifying Days in Period for Driver-Based Balance Sheet
• Modifying Account Signage for Alternate Reporting Methods
Specifying Days in Period for Driver-Based Balance Sheet
Click Balance Sheet , then Driver-Based , then Days in Period, and

then enter the number of days in each collection period.
Modifying Account Signage for Alternate Reporting Methods

If you want to report Revenue / Assets as positive data values and Expenses / Liabili‐
ties as negative values, use the Dimension Editor to modify members as follows:
• Edit the Account Type and Variance Reporting options for members in the Account
dimension.
• Edit the Consolidation Operator for members in any dimension in the Financials
cube (OEP_FS).
Financials Rules
Run rules to calculate values in the application. From the Home page, click Rules.
Tip:
To see only Financials rules, click All Cubes next to the Filter, and from the
Cube list select OEP_FS.
Financials rules:
5-15
Chapter 5
Financials Rules
• OFS_Calculate Actuals—Calculates drivers and aggregates data. Run this rule

to ensure that you're working with the latest figures and calculations.
• OFS_Calculate Cash Flow—Used for Cash Flow Direct only. Calculates Cash
based on the sources and uses of cash.
• OFS_Prepare Forecast—Copies selected months of Actual results to the Fore‐
cast scenario and recalculates drivers and trends based on the new periods of ac‐
tual results. You can also use this rule when rolling over to a new year as the start‐
ing point for a forecast.
• OFS_Prepare Plan—Calculates Plan based on the trends and drivers set up in
the application. Use this to either create or update a plan or use this as a starting
point for rolling over to a new year.
• OFS_Prepare Rolling Forecast—Similar to OFS_Prepare Forecast; use when
the Rolling Forecast feature is enabled.
• OFS_Trend Based Calculation / OFS_Rolling Trend Based Calc—Rules are
run on save for driver and trend forms to calculate accounts based on the selected
trend. OFS_Rolling Trend Based Calc is available only if Rolling Forecast is ena‐
bled.
• OFS_Rollup—Roll up values for any scenario (actual, plan, forecast or rolling
forecast). Run this rule when you want to see values at the top of the dimension
hierarchy.
• OFS_Rollup Project Integration Data / OFS_Clear Project Integration Data—
Use when integrating Financials with Projects.
5-16
6
Configuring Workforce
• Enabling Workforce Features
• Configuring Workforce
Enabling Workforce Features

Before users can start workforce planning, enable the Workforce features you want to
use. Based on your selections, dimensions, drivers, forms, and accounts are popula‐
ted. In most cases, you can come back later and incrementally enable additional fea‐
tures. However, note these exceptions:
• If you want to use Employee Demographics, you must select it the first time you
enable features.
• You must enable all the dimensions you want to include in the application and re‐
name dimensions the first time you enable using Map/Rename Dimensions.
Tip:
If your company doesn’t use Union Code, you can rename the Union
Code dimension to a dimension that's more meaningful for your busi‐
ness. You must do so when you first enable features.
After you enable a feature, you can't later disable it.

Watch this tutorial video to learn more about enabling and configuring Workforce.
Tutorial Video
.
2. From the Configure list, select Workforce, and then click Enable Features.
Select the features you want to enable. Except as noted, you can come back later
and enable additional features, so enable only the features you need to use now.
6-1
Chapter 6
Table 6-1 Workforce Enable Features
Feature Description
Granularity Select the level of workforce detail to manage:
• Employee—Manage workforce expenses
at the employee-only level.
• Job—Manage job workforce expenses at
the job-only level.
• Employee and Job—Manage workforce
expenses by both employees and jobs.
Note:
You must select
a level of granu‐
larity.
Note:
For integration
with Projects, for
tracking employ‐
ee utilization, the
granularity must
be either Em‐
ployee or Em‐
ployee and Job.
To learn more, see Identifying the Level of

Workforce Detail to Capture.
Expense Planning Select which workforce-related expenses to
manage:
If you select Expense Planning, then Com‐
pensation Planning, which includes salary
planning, is also selected by default. You can
also enable Additional Earnings, Benefits,
Taxes, and Non Compensation Expenses
by the level of granularity you selected. You
can select Merit Based Planning only if you
enable granularity for either Employee or Em‐
ployee and Job.
6-2
Chapter 6
Table 6-1 (Cont.) Workforce Enable Features
Feature Description
Headcount Planning Select which headcount-related details to
manage. Headcount Planning options:
• Employee Demographics—Select to an‐
alyze such employee attributes as veteran
status, gender, and age band. If you want
to use Employee Demographics, you
must select it the first time you enable fea‐
tures.
• Strategic Workforce—Select to align
corporate strategy with execution by plan‐
ning long-range headcount and required
skills.
Note:
To enable Strategic Work‐
force requires either Employ‐
ee and Job or Job granularity.
If you enable Strategic Workforce, then

Demand Planning and Supply Planning
are automatically enabled.
Workforce Management Select to plan expenses based on employee
or job hiring, terminating, and transferring to
another department. Workforce Management
options:
• New Hires—Enables planning for new
hires and their impact on expenses.
• Terminations—Enables planning for em‐
ployee departures and their impact on ex‐
penses.
• Transfers—Enables you to transfer em‐
ployees from one department (or entity) to
another. Transferring employees changes
the department against which their com‐
pensation expenses are calculated.
6-3
Chapter 6
Table 6-1 (Cont.) Workforce Enable Features
Feature Description
Map/Rename Dimensions • Enable up to three additional custom di‐
mensions in your application.
• Map custom dimensions to existing di‐
mensions.
You must perform this step the first time you
enable Workforce.
For example, on the first pass, you select the
top-level Headcount Planning checkbox with‐
out selecting options under it (such as Em‐
ployee Demographics). Then you later ena‐
ble Employee Demographics. You can’t re‐
name its associated dimensions Age Band,
Gender, and Highest Degree of Education.
If you are integrating Workforce with Projects,
add a custom dimension called Project, the
default dimension name in Projects. If you
name it anything else, make sure the dimen‐
sion name is the same in all modules.
Identifying the Level of Workforce Detail to Capture

You can enrich Workforce to reflect your organization's planning needs.
To help you decide the granularity you want:
Table 6-2 Overview of Granularity Level
Option Description
Employee If you select Employee, the Employee dimen‐
sion is added, which stores the organization's
employees. Calculations for salary and related
compensation can be performed for existing
employees or in planning for new hires. Oracle
anticipates that you import existing employees
from a Human Resources system, such as
PeopleSoft.
If you select this option, you must set defaults
for Pay Type (for example, Exempt or Non-ex‐
empt) and Employee Type (Regular, Contrac‐
tor, and Temporary). Or, if you don't use this
information, set them to null (the No <member
name>). See Setting Defaults.
Job If you select Job, the Job dimension is added,
which stores the roles assigned to employees.
Examples of jobs: Engineer, Software Devel‐
oper, and Mechanic.
If you select this option, you must set defaults
for Pay Type and Skill Set. Or, if you don't use
this information, set them to null (the No
<member name>). See Setting Defaults.
6-4
Chapter 6
Table 6-2 (Cont.) Overview of Granularity Level
Option Description
Employee and Job With this option, the Job dimension is used
with the Employee dimension to facilitate anal‐
ysis of roles across the organization, to track
new hire requests, and to identify employees
by role.
If you select this option, you must assign de‐
faults for Job and Union Code. See Setting
Defaults.
If you don't track Union Codes, when you ena‐
ble Workforce, you can use Map/Rename Di‐
mension to rename Union Code to something
that's meaningful to your business. If you re‐
name Union Code when enabling Workforce,
you must still assign a default for the renamed
dimension.
You can rename Employee, Job, or Employee and Job in Map/Rename Dimen‐
sions.

sions you specify.
Perform these configuration tasks after you’ve enabled Workforce features.
.
2. From the Configure list, select Workforce.
6-5
Chapter 6
ness. Use the Filter to check the status of configuration actions. Use Actions
to update task status.

Table 6-3 Configuring Workforce
Component Optional
Import selected Grades, Taxes, Benefits, and
Additional Earnings, which are considered
Workforce components. After importing a com‐
ponent, configure it with the appropriate Con‐
figure option.
Tip:
You can import
metadata and
data into compo‐
nents in a batch
file. You can also
use a template to
import data. See
Importing Data.
Entities Mandatory
Import the Entity dimension members that re‐
flect your business hierarchy, such as depart‐
ments, cost centers, and business units.
Salary Grades Mandatory
Define the salary basis (for example, Annual
or Hourly) and the pay rates for the Salary
Grades that you imported.
Options and Tiers Optional
Set options for Additional Earnings such as
overtime or bonus and for Benefits such as
medical benefit rates. Set tiers for Taxes, such
as employer-paid taxes. After setting options
and tiers, use the Benefits and Taxes wizard
to configure Additional Earnings, Benefits, and
Taxes.
See Adding and Managing Accounts and Driv‐
ers and Configuring Benefits, Taxes, and Addi‐
tional Earnings.
6-6
Chapter 6
Table 6-3 (Cont.) Configuring Workforce
Planning and Forecast Preparation Optional
Set the timeframe, the starting period, and the
level of granularity for planning and forecast‐
ing. You can plan and forecast on a different
basis for different years.
Benefits and Taxes Mandatory
Set up Benefits, Taxes, and Additional Earn‐
ings. A component is a tax, a benefit, or an ad‐
ditional earning. A wizard guides you through
setting up a component with business-based
questions. See Configuring Benefits, Taxes,
and Additional Earnings.
Workforce Assumptions Mandatory
Set default assumptions such as hours worked
per day, week, and year. Also, set the partial
payment factor, which sets the pay percentage
to apply to Maternity status. You can set these
assumptions by Scenario, Version, Entity, and
Currency. For more information, see Setting
Assumptions.
Employee Type Optional
Import more employee types in your organiza‐
tion as members into the Employee Type di‐
mension. The provided employee type mem‐
bers are Regular, Contractor, and Temporary.
This option is available for the Employee-only
level of granularity.
Pay Type Optional
Import pay types in your organization as mem‐
bers into the Pay Type dimension. The provi‐
ded pay types are Exempt and Non-Exempt.
This option is available for the Employee-only
level of granularity.
6-7
Chapter 6
Employee Demographics Optional
Set up employee demographics such as High‐
est Education Level. Demographics enable
you to analyze data based on individual em‐
ployee characteristics. You can select, add,
import, or export a demographic, such as eth‐
nic group.
If you enable Employee Demographics, Work‐
force provides the Gender, Age Band, and
Highest Education Degree attributes, and you
can add employee demographics such as vet‐
eran status. You typically import demographic
attributes for existing employees, and planners
assign demographics after new employees are
hired.
Workforce provides data maps for reporting on
such information as demographics.
ers.
Employee Properties Optional
Set up employee properties such as Employee
Type. Add, import, or export properties such
as Skill Set, FT/PT, Start Month, Merit Month,
and Hiring Status. Then to view and edit em‐
ployee properties, use Compensation Plan‐
ning, then the Manage Employee Details
tab.
ers.
Non Compensation Expenses Optional
Set up non compensation expenses such as
training or travel expenses. Add, import, or ex‐
port a non compensation expense. After non
compensation expenses are added, enter the
data in the form (Other Expenses, and then
Non Compensation Expenses).
ers.
Performance Metrics Optional
Add, import, export, or delete a performance
metric for a component. For example, add per‐
formance ratings such as Meets Expectations
and Exceeds Expectations.
ers.
Merit Rates Mandatory
Define merit rates by year. Select the scenar‐
io, version, and currency to which to apply the
merit rates.
6-8
Chapter 6
Employees Optional
Import employee names or employee numbers
in your organization as members into the Em‐
ployee dimension.
Jobs Optional
Import jobs in your organization as members
into the Job dimension.
Skill Sets Mandatory for Job Granularity
Import skill sets used in your organization by
importing members into the Skill Set dimen‐
sion.
Union Codes Mandatory for Employee and Job Granularity
Import union codes used in your organization
by importing members into the Union Code di‐
mension. If you don't track Union Codes, you
can rename the dimension to something that's
meaningful to your business. However, you
must still assign a default to the renamed di‐
mension.
Gender Optional
Import members into the Gender dimension
Highest Education Degree Optional
Import highest education degrees used in your
organization by importing members into the
Highest Education Degree dimension.
6-9
Chapter 6
Age Band Optional
Import members into the Age Band dimension.
Employees’ ages are calculated and assigned
to an age band as it changes over time.
Note:
Oracle recom‐
mends that you
use the default
age bands in‐
stead of loading
your own.
Note:
If you are an ex‐
isting customer,
continue to use
your existing age
bands and mem‐
bers.
<Custom Dimension Name, such as Projects> Optional

Populate the application with a dimension you
added, such as projects, by importing mem‐
bers into the dimension.
Global Assumptions Mandatory
Set foreign exchange rates in a multicurrency
application.
See Importing Data. You can also add members using the dimension editor.
Tip:
After importing dimensions and members, you can view the hierarchical
structure in the dimension editor.

6-10
Chapter 6

monthly basis.
year
Years.
the row for FY21.

facts.
Tutorial Video

6-11
Chapter 6
3. Perform a task:
in the new row.
Notes:
About Setting Up Employee Demographics

Watch this tutorial video to learn about setting up and using employee demographics
to analyze workforce data.
Tutorial Video

then save the form.
6-12
Chapter 6
Note:
Configuring Benefits, Taxes, and Additional Earnings

The following sections describe how to use the Benefits and Taxes wizard to configure
benefits, taxes, and additional earnings. Workforce provides 10 generic accounts for
benefits, taxes, and additional earnings that can be assigned (using Default Assign‐
ments) to an employee or job, depending on the granularity.
Tip:
You can set up valid intersections for Options and Tiers to their respective
parents in the Components dimension. For information on setting up valid in‐
tersections, see Defining Valid Intersections in Administering Planning.
Before You Use the Benefits and Taxes Wizard

Ensure that you have performed these tasks before you launch the wizard:
• Imported Benefits, Taxes, and Additional Earnings using Components on the
Workforce Configure page. Importing the component makes it available in the
wizard.
• Configured Options and Tiers on the Configure page to set up Benefits and Ad‐
ditional Earnings (Options) and Taxes (Tiers), which creates the options and tiers.
Then you're ready to launch the Benefits and Taxes wizard to define each option for
Benefits, Taxes, and Additional Earnings.
About the Benefits and Taxes Wizard

Using business-based questions, a wizard guides you through the steps to defining
options for Benefits and Additional Earnings and defining tiers for (employer-paid) Tax‐
es.
Examples:
• Additional Earnings: Overtime Pay, Merit Increase
• Benefits: Health Insurance, House Loan, Car Allowance
• Employer-paid Taxes: US FICA, Canada Pension Plan (CPP)
In the wizard, you specify the logic, such as whether a tax rate is a flat amount, a per‐
centage of salary, incurred monthly, quarterly, or annually, and so on. You can also
use the wizard to maintain taxes, benefits, and additional earnings. Each component
can vary by scenario and version.
To launch the wizard, from Configure, click the Benefits and Taxes link. Use Filter to
select the component to configure. You are guided through three steps: Details, Rates,
and Review.
6-13
Chapter 6
Note:
• Ensure that all entities have a rate and threshold (if the component uses a thresh‐
old). If the same rates and thresholds apply globally, run the rule Copy Rates
Across Entities from a source entity. See Applying Rates by Hierarchy.
• Whenever you update an entity default for a benefit, tax, or additional earning, you
must run the Synchronize Defaults rule to apply the entity default at the employ‐
ee-job level. When you update an existing component (a benefit, tax, or additional
benefit) in the wizard, you must run the Synchronize Component Definition rule
to push the updated definition to employees and jobs.
Common Properties for the Components

Additional Earnings, Benefits, and Taxes share certain properties.
The components share these properties:
• Payment Terms, such as Monthly, Quarterly, or Annually.
• Payment Frequency, such as One-time Pay or Pay During Last Period. Payment
Frequency is tied to Payment Terms.
• Component Types: Simple, Rate Table, Rate Table with Threshold, and Custom.
Component Types in the Wizard

On the Details screen, you select a component type (a calculation rate type) for a ben‐
efit, tax, or additional earning.
The component types:
• Simple—A single rate option per year with a threshold value. Then you assign the
desired option to the appropriate drivers as defaults. Because the Simple compo‐
nent type is a single rate option or tier with a threshold value for all defaults,
there’s only one row: No Option for Additional Earnings and Benefits and No Tier
for Taxes.
• Rate Table—Provides different rate options with no threshold values. With this
component type, you assign the desired option or tier to the appropriate drivers as
defaults. The rate table provides rows of options and tiers (you defined these rows
of options and tiers with the Options and Tiers on the Configure page), with no
threshold values that are assigned.
• Rate Table and Threshold—Provides different rate options with thresholds. With
this component type, you assign the desired option or tier to the appropriate driv‐
ers as defaults. The rate table with threshold provides rows of options or tiers with
thresholds as previously configured. Additional Earnings and Taxes support the
Maximum Value Type of Threshold Amount, which crosses all tiers regardless of
the option or tier assigned as a default.
• Custom—Enables you to create custom calculation logic for a component’s addi‐
tional earnings, benefits, or taxes. See Creating Custom Calculation Logic in a
Component.
6-14
Chapter 6
Tip:
A threshold is a cap or maximum value on the resulting expense value. For
example, Car Allowance is a percent of salary up to a threshold of $4,000,
when the Car Allowance benefit would stop. The rate changes when a cap is
reached. For example, the tax rate in the first tier is 4.5% up to a threshold
of $50,000, and the second tier is 12.6% up to $100,000. Not only does a
threshold apply only to the tiered structure, but you can also set a maximum
value with the Additional Earning, Benefit, or Tax calculations.
About One-time Pay Options

Using One-time Pay Options enables you to specify which month an additional earn‐
ing, benefit, or tax is paid. Your options depend on which Payment Terms you’ve se‐
lected for the component.
For example, if a benefit needs to be paid once every six months in February and Au‐
gust, then select Payment Terms as Semiannually (Calendar), One-time Pay as the
Payment Frequency, and Second Month in the One-time Pay Options.
Another example: if your Payment Terms is Annually (Fiscal Year), and you select
One-time Pay as the Payment Frequency, then the one-time payment occurs once in
the fiscal year. For One-time Pay Options, you can then select which month in the
fiscal year (first through twelfth) the expense is calculated. If your fiscal year starts in
July, and you select the eleventh month, the expense is added in May.
You access these new options in the Benefits and Taxes wizard on the Details page
for the component.
About Maximum Value Type

The available options for Maximum Value Type are based on whether the component
is an Additional Earning, Benefit, or a Tax.
Setting the Maximum Value Type to Threshold Amount is available only for Taxes
(not Additional Earnings or Benefits). If the Maximum Value Type is set to Threshold
Amount, then the threshold of each tier drives the tiered calculations. The application
applies all tiers to the default assignment, as appropriate, regardless of the tier as‐
signed as a default. If you need to apply a tiered tax with multiple tier rates, then select
Component Type as Rate Table and Threshold with Maximum Value Type as
Threshold Amount.
If you select the Component type as Simple, then you provide rates in No Tier. In this
case, tiered calculation logic isn't applied even if Maximum Value Type is Threshold
Amount.
You set the Maximum Value Type on the Details page of the wizard.
6-15
Chapter 6
If the Maximum Value Type is not set to Threshold Amount, then the assignment of
each option or tier row is relevant and needs to be assigned appropriately.
Let’s use US FICA tax as an example of setting the Maximum Value Type to Thresh‐
old Amount. No one row will be assigned as a default because all rows apply. So the
tax rate is 7.65% of salary for the first $118,500, then 1.45% of salary over $118,500
up to $200,000. Then 2.35% tax is applied to salaries over $200,00. (You still have to
select an option or tier when assigning the default; it is just ignored in the calculation.)
Example:
About Earning Type

Earning Type is valid only for Additional Earnings.
The earning types Add to Gross Pay and Do Not Add to Gross Pay drive the Bene‐
fits and Taxes Value Type and Maximum Value Type of Overall Earnings. So if the
Earning Type is set to Add to Gross Pay, then those Additional Earnings will be in‐
cluded in any Benefit or Tax based on % Overall Earnings.
If the Earning Type is set to Do Not Add to Gross Pay, then any Benefit or Tax using
% Overall Earnings for the Value Type and Maximum Value Type will exclude those
Additional Earnings from any Benefit or Tax calculations based on % Overall Earnings
About Taxable Component

Taxable Component works like Earning Type in that any Additional Earning or Bene‐
fit set to Yes for Taxable Component will be included in any Tax calculation where
the Value Type or Maximum Value Type is set to % Taxable Earnings.
6-16
Chapter 6
About Entering Rates

You can input component rates and logic by period and by entity in the Benefits and
Taxes wizard. You can account for rates that change during the year and assess their
impact on compensation expenses. For example, you can account for a tax rate that
changes in July.
The Rates page in the Benefits and Taxes wizard opens with the YearTotal member
collapsed with the Time Balance property of Account set to Balance. You can enter a
value in YearTotal, and the value automatically spreads to the last of its child time peri‐
ods. If no distribution exists (that is, the values for all children are zeros or are miss‐
ing), the value is spread across its children. Or, you can expand YearTotal and man‐
ually enter or change rates in the level 0 members.
About Rates and Threshold Scope

The Threshold Scope option (YTD or Monthly) for a component enables you to set
rate tiers for an additional earning, benefit, or tax that are calculated independently
each month or year. For example, an insurance program may apply rate tiers that start
from zero each month.
In this example, assume employees in Finance earn $4,000, where tax is defined as
Percent of Salary, with a Threshold Scope of Monthly and three rate tiers:
Their tax rate is 12% for the first 1,000 monthly compensation, 20% between 1,000
and 3,000 earned, and 30% between 3,000 and 5,000.
Applying Rates by Hierarchy

You can apply the same rates and thresholds to members within a section of the Entity
hierarchy by using the Copy Rates Across Entities rule. Using this rule saves you
from having to manually enter or import rate data.
The Copy Rates Across Entities rule is especially useful when a number of entities
use the same rates and thresholds for additional earnings, benefits, or taxes. On the
Rates page, you can copy component rates and thresholds from one entity to another
section of the hierarchy by running this rule from the Actions menu. In the Member
Selector, select the source level 0 Entity member whose rate you want to copy and
the target parent or level 0 member to copy the rate to.
For example you can enter rate data for a benefit for France and then use Copy Rates
Across Entities to copy the benefit rate using relationship functions to all level 0 de‐
scendants of Total Europe and level 0 descendants of Total Nordic.
6-17
Chapter 6
Creating Custom Calculation Logic in a Component

Defining your own Workforce calculations in a custom component gives you great flex‐
ibility in applying conditional logic and specifying value drivers to calculations for addi‐
tional earnings, benefits, or taxes.
For example, you could create a bonus calculation that applies to new hires who start
in the first 6 months of a calendar year, but not for those who start in the last 6 months
of the calendar year in their first year of hire. You can also select a value driver other
than the predefined ones (for example, Flat Amount, Percentage of Salary, and so on).
So, for example, you could base an additional earning such as commissions on a cus‐
tom member that you create, for example, Revenue. To specify a member as the Val‐
ue Type driver, you include it in the member formula for the custom component.
To customize logic in a custom component:
1. In the Benefits and Taxes wizard, on the Details page, edit an existing compo‐
nent, and for Component Type, select Custom.
2. Continue setting up the component, including optionally entering rates to be used
in your custom logic.
Include any thresholds in the member formula.
3. Create a member formula for the OWP_Custom Expense member in the Property
dimension:
a. On the Home page, select Application, then Overview, and then Dimen‐
sions.
b. Click the down arrow to the right of Cube, and then select OEP_WFP.
c. Click Property, right-click in the Member Name column header, and then
clear Default mode.
d. Select the member OWP_Custom Expense, scroll right to the OEP_WFP
Formula column, and then click in the intersection cell.
e. In the upper left of the grid, click the Member Formula icon
.
f. Enter the member formula.
Notes:
• Before creating your own custom calculation logic, Oracle encourages you to first
do due diligence in using the predefined calculations.
• Evaluate the performance of your custom formula before taking the application into
production.
• To create and use multiple custom components, modify the OWP_Custom Ex‐
pense member formula to accommodate each component’s custom logic. For ex‐
ample, use nested IF conditions for each custom component type.
6-18
Chapter 6
Tip:
See the following topics for advice on customizing calculation logic and for
several sample formulas.
Creating Custom Formulas for OWP_Custom Expense

Use these tips and the formula examples that follow to help you create custom formu‐
las for OWP_Custom Expense. These tips assume that the application granularity is
Employee and Job.
• Data for properties such as Payment Terms, Payment Frequency, and Value Type
are stored at the corresponding Property member > No Currency > Begbalance >
Account (Benefit1:10/Earning1:10/Tax1:Tax10) at the Employee and Job combina‐
tion.
• Rates are stored at OWP_Value > Currency > Account (Benefit1:10/Earning1:10/
Tax1:Tax10) at the Employee and Job combination.
• Thresholds are stored at OWP_Maximum Value > Currency > Account (Bene‐
fit1:10/Earning1:10/Tax1:Tax10) at the Employee and Job combination.
• You can refer to the provided formulas for evaluating the periods to calculate the
expenses based on Cal Tp-Index of the month, corresponding to different Pay‐
ment Terms options.
• To add multiple custom formulas, nest them in the OWP_Custom Expense mem‐
ber formula.
Customizing Benefit and Tax Calculations

Review these examples to help you customize your benefit and tax calculations.
Use Case
You want to calculate commission as a percentage of the Commission Basis account,
which is a custom account not provided with Workforce. Commission is calculated by
multiplying the rate entered in the Benefits and Taxes wizard times the custom Com‐
mission Basis account.
Sample Formula
IF("No Property"->"BegBalance"==[OWP_EarningList.Commission])
IF(@ISMBR(@RELATIVE("OWP_Existing Employees",0)))
"Commission Basis"->"No Property" * ("OWP_Value"/100);
ELSE
#Missing;
ENDIF
ENDIF
Use Case
Building on the previous example, you want to add a benefit called Insurance, which is
calculated as a percentage of the Merit account, with the following values selected in
the Benefits and Taxes wizard:
6-19
Chapter 6
• Component Type—Custom
• Payment Terms—Quarterly (Calendar Year)
• Payment Frequency—Pay During First Period
• Maximum Value Type—Flat Amount
• Threshold Scope—YTD
• Taxable Component—Yes
• Rate for all months—10
• Threshold—400
• Value Type—You can select any value for Value Type as we are calculating the
benefit as a percentage of Merit in the custom logic.
Sample Formula
ELSE
#Missing;
ENDIF
ELSEIF("No Property"->"BegBalance"==[OWP_BenefitList.Insurance])
IF("Cal TP-Index"==1 OR "Cal TP-Index"==4 OR "Cal TP-Index"==7 OR "Cal
TP-Index"==10)
"OWP_Expense amount"="OWP_Merit"->"OWP_Expense amount"*("OWP_Val-
ue"/100);
ENDIF;
IF("OWP_Expense amount"!=#MISSING)
IF("OWP_Calculated Max Value"!=#MISSING)
IF("OWP_CYTD(Prior)"+"OWP_Expense amount">"OWP_Calculated Max
Value")
IF("OWP_CYTD(Prior)"<="OWP_Calculated Max Value")
"OWP_Expense amount"="OWP_Calculated Max Val-
ue"-"OWP_CYTD(Prior)";
ELSE
"OWP_Expense amount"=#MISSING;
ENDIF;
ENDIF;
ENDIF;
ENDIF;
ENDIF;
Use Case
Building on the previous examples, you want to add a Tax (Tiered Tax) named SUTA,
which is calculated as a percentage of Benefit1, Benefit2, Benefit3, Benefit4, with the
following values selected in the Benefits and Taxes wizard:
• Component Type—Custom
• Payment Terms—Monthly
• Maximum Value Type—Threshold
• Threshold Scope—Monthly
6-20
Chapter 6
• No rates are provided in the Rates page.

• For the custom tiered tax, rates need to be provided as part of the custom formula.
Sample Formula
ELSE
#Missing;
ENDIF
ELSEIF("No Property"->"BegBalance"==[OWP_BenefitList.Insurance])
IF("Cal TP-Index"==1 OR "Cal TP-Index"==4 OR "Cal TP-Index"==7 OR "Cal
TP-Index"==10)
"OWP_Expense amount"="OWP_Merit"->"OWP_Expense amount"*("OWP_Val-
ue"/100);
ENDIF;
IF("OWP_Expense amount"!=#MISSING)
IF("OWP_Calculated Max Value"!=#MISSING)
IF("OWP_CYTD(Prior)"+"OWP_Expense amount">"OWP_Calculated Max
Value")
IF("OWP_CYTD(Prior)"<="OWP_Calculated Max Value")
"OWP_Expense amount"="OWP_Calculated Max Val-
ue"-"OWP_CYTD(Prior)";
ELSE
"OWP_Expense amount"=#MISSING;
ENDIF;
ENDIF;
ENDIF
ENDIF
ELSEIF("No Property"->"BegBalance"==[OWP_TaxList.SUTA])
IF("OWP_Benefit1"->"OWP_Expense amount"+"OWP_Benefit2"->"OWP_Expense
amount"+"OWP_Benefit3"->"OWP_Expense amount"+"OWP_Benefit4"->"OWP_Expense
amount"<=1000)
"OWP_Expense amount"=("OWP_Benefit1"->"OWP_Expense
amount"+"OWP_Benefit4"->"OWP_Expense amount")*(10/100);
ELSEIF("OWP_Benefit1"->"OWP_Expense amount"+"OWP_Benefit2"->"OWP_Ex-
pense amount"+"OWP_Benefit3"->"OWP_Expense amount"+"OWP_Benefit4"->"OWP_Ex-
pense amount"<=1200)
"OWP_Expense amount"=(("OWP_Benefit1"->"OWP_Expense
amount"+"OWP_Benefit4"->"OWP_Expense amount")-1000)*(20/100) +
1000*(10/100);
ELSEIF("OWP_Benefit1"->"OWP_Expense amount"+"OWP_Benefit2"->"OWP_Ex-
pense amount"+"OWP_Benefit3"->"OWP_Expense amount"+"OWP_Benefit4"->"OWP_Ex-
pense amount"<=1300)
"OWP_Expense amount"=(("OWP_Benefit1"->"OWP_Expense
amount"+"OWP_Benefit4"->"OWP_Expense amount")-1200)*(30/100) +
(1200-1000)*(20/100) + 1000*(10/100);
ELSE
"OWP_Expense amount"=(1300-1200)*(30/100) + (1200-1000)*(20/100) +
1000*(10/100);
6-21
Chapter 6
ENDIF
ENDIF
After Configuring Using the Wizard

After configuring Additional Earnings, Benefits, and Taxes using the wizard, perform
these tasks:
• Assign defaults for Salary, Additional Earnings, Benefits, and Taxes. See Setting
Defaults.
• Assign defaults for Salary Grades for New Hires.
• To assign the defaults to employees (in Employee only or Employee and Job gran‐
ularity) and jobs (in Job only granularity), run the Synchronize Defaults rule. This
rule is applied to both new hires and existing employees or jobs.
To run the rule for a single employee or job or an employee-job combination, in the
form, select that row and then click Actions, and then Synchronize Defaults.
Click Compensation Planning, then Manage Employees, and then Existing
Employees. To run the rule for a parent level employee/job, click Actions, then
Business Rules, and then Synchronize Defaults.
Example - Adding a Fringe Benefit

This example walks you through the steps to creating a new fringe benefit. Let’s say
that you want the benefit to be a percentage of employees' salary. You want to specify
a different percentage for employees in North America, EMEA, and APAC, ranging
from 33% to 35%.
Before you start, we assume that:
• You've enabled Workforce for, at a minimum, Expense Planning, Compensation
Expenses, and Benefits. (All three granularity levels support benefits.)
• You've imported the application metadata to include the Fringe Benefit Rate com‐
ponent member.
• You’ve set the user variables.
Add the Fringe Benefit as a Component

First, we'll use the Benefits and Taxes wizard to create a new benefit.
1. From the Home page, click Application, and then Configure.
2. From the Configure list, click , and then Workforce.
3. From Configure: Workforce, click Options and Tiers.
6-22
Chapter 6
4. On Options and Tiers, from Component, select Options.

5. From Actions, select Add, then in the text box, enter "Fringe Rate – North Ameri‐
ca". Repeat to add an option for EMEA and APAC:
6. Click Save, then Next, and then Close.
Define the Fringe Benefit

Next, we use the Benefits and Taxes wizard to set the rate for the fringe benefit op‐
tions.
1. From Configure: Workforce, click Benefits and Taxes.
2. Click Filter .
3. Select the Scenario and Version for the fringe benefit and from Components, click
Benefits, and then Apply:
4. Under Details, set the fringe benefit parameters:
6-23
Chapter 6
5. Click Save and Next.

6. On Rates, enter the fringe benefit rates for each fringe rate option for each year:
7. Click Save and Next.

8. Review the new benefits options:
9. Click Save, and then Close.
Set the Benefit Defaults

Next we’ll set the benefit defaults for the children members of each parent entity: North
America, EMEA, and APAC.
1. Click Workforce on the Home page.
2. Click Compensation Planning, then Defaults, and then Benefits.
3. From the POV, select the Entity member.
In this example, we'll set the benefit default for "Sales Italy".
6-24
Chapter 6
4. Click Actions, and then Add Benefit Default.

5. On Add Benefit Defaults, for Benefit, select Fringe Benefit Rate, and for Op‐
tion, select Fringe Rate – EMEA:
6. Click Launch.
Now, whenever you add a hiring requisition (using the Add TBH business rule) to
Sales Italy, the new fringe benefit rate that we set up for EMEA (for example, 34% for
2017) is applied. Compensation is automatically calculated, including the fringe bene‐
fit. (The fringe benefit rate is also applied when you run the Synchronize Default busi‐
ness rule.) If you update the fringe benefit rate using the Benefits and Taxes wizard, to
apply the updated rate, run the Synchronize Component Definition business rule.

Related Topics
• Setting Assumptions
• Setting Defaults
Defaults (and assumptions) drive the calculations for workforce-related expenses.
• Synchronizing Defaults
• Post Update Tasks
After updating Workforce content from a monthly update, note the following infor‐
mation.
Setting Assumptions
Assumptions (and defaults) drive the calculations for workforce-related expenses. As‐
sumptions include:
• Hours worked per day, week, and month, which drive salary expenses for hourly
employees.
• The partial payment factor (that is, the pay percentage to apply to Maternity Sta‐
tus).
• The salary basis (for example, annual) and rate for Salary Grades.
• Set merit rates, which are added to salary calculations.
You can set assumptions by entity or at the No Entity level (for default assumptions). If
you set assumptions for the entity, then they are used for calculations; otherwise, the
assumptions set for No Entity (at the organization level) are used. The exception to
this is Merit Rate, which must be set at the entity level.
Administrators set workforce assumptions during configuration. If they're granted per‐
missions, planners can then update them as needed by clicking or tapping Compen‐
sation Planning, then the Assumptions tab .
6-25
Chapter 6
After setting assumptions, run the Synchronize Defaults rule (see Synchronizing De‐
faults.) To set defaults for Salary, Additional Earnings, Benefits, and Taxes, see Set‐
ting Defaults.
Setting Defaults
Defaults (and assumptions) drive the calculations for workforce-related expenses.
If you want a default for salary, additional earnings, benefits, or taxes to be used for all
employees in a specific job, select that job when adding the default. For example, if
you select Accountant when adding the default for Job, then all employees who are
Accountants are assigned that default.
If Employee and Job granularity is enabled, you must set defaults based on Job and
Union Code. This setting defaults compensation elements for new hires for a specific
job. For example, you might set the default Salary Grade to Grade 3 for a Warehouse
Worker with the Union Code of Teamster.
To apply a compensation element default to all employees in all jobs, select the
OWP_All <member> when setting defaults for salary, additional earnings, benefits,
and taxes. For example, select the OWP_All Union Code member and the OWP_All
Jobs member if you want the default compensation element to be used for all employ‐
ees in any job and in any union. So for example, if you select the OWP_All Union
Code member and the OWP_All Job member, then Sue Doe in Accounting (whose
Union Code is Default No Union Code) would get the same compensation element de‐
fault as Tom Blue in the Warehouse (whose Union Code is Teamsters).
Note:
Workforce seeds a level-zero member named No Union Code as a sibling to
Total Union Code. However, when you add defaults for salary, additional
earnings, benefits, and taxes, No Union Code isn't available for selecting in
the runtime prompt. To meet this need, Workforce expects you to add at
least one sibling null metadata member (such as OWP_Unspecified Union
Code) to OWP_All Union Code.
If your company doesn't use Union Code, you can rename that dimension to
something that’s meaningful to your business when you enable Workforce. If
you didn’t rename Union Code when you enabled Workforce, you can create
whatever members you want in the Union Code dimension and change the
alias of the dimension to your preferred name.
Set Workforce defaults by clicking or tapping Compensation Planning, then the De‐
faults tab. Then:

• To set Salary defaults, click Salary. These defaults are used for new hires or job
salary defaults. Using Assumptions, and then Salary Grades , planners

can then set the salary basis (for example, Annual or Hourly) and the salary rate
for the Salary Grades that you imported.
6-26
Chapter 6
If you import the salary basis and salary rates to the OEP_No Entity member, they
are used across all entities. Alternately, select OEP_No Entity (in Compensation
Planning, then Assumptions, and then Salary Grades).
• To set Additional Earnings defaults, click Additional Earnings.
• To set Benefits defaults, click Benefits.
• To set Taxes defaults, click Taxes.
Synchronizing Defaults
Whenever you update the entity defaults for benefits, taxes, or additional earnings us‐
ing the Benefit and Taxes wizard on the Configure page, you must push the updated
data to the input forms by running the Synchronize Defaults business rule.
1. Click Compensation Planning, then Manage Employees, and then Existing
Employees.
2. Highlight a row with an individual or a blank row.
If you intend to execute the business rule for:
• Only one person, highlight the row containing that person's name, and then
run the rule
• Multiple people or to select the dimensionality with a runtime prompt, highlight
a blank row and then run the rule
3. Click Actions, then Business Rules, and then Synchronize Defaults.
The business rule recalculates and updates data in the forms.
Note:
When you update the metadata for a component (for example, salary grades,
benefits, taxes, and additional earnings), run the Synchronize Component
Definition business rule to push the updated definition to already-assigned
employees and jobs. This rule doesn't update the entity defaults.
Post Update Tasks

After updating Workforce content from a monthly update, note the following informa‐
tion.
• Immediately after updating the Workforce May 2019 content, you must run the
new rule 1X Copy Compensation Details from BegBalance to Periods, which
copies compensation details from the BegBalance member to all months. Run this
rule only once for each active Scenario and Version combination with data, imme‐
diately after updating content. To run this rule, on the Home page, click Rules,
then All Cubes, and then select OEP_WFSC from the Cube drop-down list. Then
click Launch for the rule Copy Compensation Details from BegBalance to Pe‐
riods.
• Immediately after updating the Workforce July 2018 content, you must run the new
rule One Time - Copy Rates to Months, which copies rates from the BegBalance
member to all months. Run this rule only once for each active Scenario and Ver‐
6-27
Chapter 6
Workforce Rules
sion combination with data, immediately after updating content. To run this rule, on
the Home page, click Rules, then All Cubes, and then select OEP_WFSC from
the Cube drop-down list. Then click Launch for the rule One Time - Copy Rates
to Months.
• Enhancements available in certain releases include updates to some provided arti‐
facts. If you haven’t modified these artifacts, then the artifacts and features are
available to you automatically with the release. Because customized artifacts are
not updated during releases, if you have customized these artifacts and want to
take advantage of the new features, review the information in the appendix Updat‐
ing Workforce Artifacts to Use New Features.
Also, check this appendix to see the list of new rules. To make new rules available
to users, you must give users access to the rules. To do so, on the Home page,
select Rules, the OEP_WFP cube, the new rule, and then the Permission icon.
• For components configured with the Payment Frequency set to One-time Pay:
Unless you select a One-time Pay Option, your component expenses continue to
occur in the first month of your selected payment frequency.
• Workforce provides four forms for quickly updating and processing data on exist‐
ing employees. Each form is associated with a Groovy rule that processes only the
changed data. The forms are designed for optimal processing efficiency, depend‐
ing on the kind of data being updated. You access these forms from the Mass Up‐
date tab. See Updating Employees and Jobs Details in the Working with Planning
Modules.
On these forms, all the Flex dimensions and the Entity dimension are initially on
the Page. Oracle recommends that you analyze the form load performance and
then modify the layout of these forms, moving certain dimensions from the Page to
the rows based on your requirements. Year and Period are also on the Page; Ora‐
cle assumes you'll use the selected Year and Period for loading and processing
the changed data. Your Year and Period selection is equivalent to the runtime
prompt values for the Process Loaded Data rule.
To provide processing efficiency for multiple simultaneous users, the default paral‐
lelism for the Groovy rule is set to 2. However, if you don't provide access to these
forms for planners or if you expect a low level of concurrency, then you can adjust
a design-time prompt (DTP) value to increase the parallelism to 4. Doing so will
increase processing speed for large-scale changes in data.
Workforce Rules
Run the Workforce business rules in the situations described here.
Tip:
For suggestions on enhancing the execution performance of rules, see Per‐
formance Considerations with Workforce Rules.
To launch a business rule, click Actions, then Business Rules, and then the rule.
• Synchronize Defaults—Run this rule after you update the entity defaults for a
benefit, tax, or additional earning. For example, you set up a new benefit or re‐
moved an existing benefit from entity defaults. Running this rule from the New
Hires or Manage Existing Employees form pushes the updated entity default at the
6-28
Chapter 6
Workforce Rules
employee-job level. If you launch Synchronize Defaults using the right-click

menu, you use it for a selected employee-job combination.
If you intend to execute the Synchronize Defaults rule for:
– Only one person, highlight the row containing that person's name, and then
run the rule.
– Multiple people, or to select the dimensionality with a runtime prompt, right-
click in the white space, and then run the rule.
• Synchronize Component Definition—Run this rule after you update an existing
benefit, tax, or additional earning. For example, you updated a rate table, payment
frequency, salary grade, or maximum value. Running Synchronize Component
Definition pushes the updated component definition to employees and jobs. This
rule doesn't update the entity defaults.
• Calculate Compensation—When you update data on a form, to recalculate ex‐
penses, run the Calculate Compensation rule. For example, if you change an
employee's status, review that employee's FTE, and then run Calculation Com‐
pensation.
• Process Loaded Data—After you import new compensation data, run the rule
Process Loaded Data to copy the data to the necessary periods in the planning
year range. Running this rule sets the Headcount to 1 and the Partial Payment
Factor to 100% for every employee unless you've loaded different values at the
processing month.
Tip:
You can quickly make changes to the source data for existing employees,
entities, and jobs in four Workforce Mass Update forms. Each form is asso‐
ciated with a Groovy rule that processes only the changed data. See Updat‐
ing Multiple Employees and Jobs Details in Working with Planning Modules.
Note:
You can run the rules Synchronize Defaults, Synchronize Component
Definition, and Process Loaded Data for multiple entities at a time by se‐
lecting the parent entity under Total Entity. Oracle recommends that for per‐
formance reasons, you run multiple instances of rules by selecting different
children under Total Entity instead of running rules for all entities in one pass.
Note:
If you get an error message about invalid data when running a business rule,
see Troubleshooting a Rule’s Error Message.
6-29
Chapter 6
Performance Considerations with Workforce Rules

Consider these tips to potentially improve the execution performance of Workforce
rules.
• Workforce rules assume that the FIXPARALLEL statement runs on the Entity dimen‐
sion, which is ideal if you're loading the bulk of your data into the Entity dimension.
However, if you load the bulk of your data into another dimension, for example, a
Flex dimension such as Project, you can improve performance by modifying the
FIXPARALLEL statement to apply to the Project dimension instead. Workforce pro‐
vides a template named OWP_Fix Parallel_T that is used in the rules Synchron‐
ize Defaults, Synchronize Component Definition, and Process Loaded Data. If
you modify the FIXPARALLEL statement to reflect your optimal dimension, all three
rules take advantage of the performance enhancement.
Tip:
To determine the best dimension to include in the FIXPARALLEL state‐
ment, Oracle recommends that you do some testing using realistic and
representative data.
To modify the template OWP_Fix Parallel_T:

1. Replace {Department} (which is the default Entity dimension in this template)
with your optimal dimension and include the appropriate Entity selection in the
subsequent FIX statement. See this BEFORE and AFTER example.
BEFORE:
SET UPDATECALC OFF;
FIXPARALLEL(4,@RELATIVE({Department},0))
FIX({Scenario}, {Version} [FlexDim1Fix] [FlexDim2Fix] [FlexDim3Fix]

[CurrencyDTP])
FIX([EmpDimFix] [JobDimFix])
AFTER, modified assuming that Project is FlexDim1 and using sample mem‐
ber names (“All Project” and “OEP_Total Entity”). Also note the comma
inserted before the reference to Entity in the second FIX statement:
SET UPDATECALC OFF;
FIXPARALLEL(4,@RELATIVE(“All Project”,0))
FIX({Scenario}, {Version} ,@RELATIVE(“OEP_Total Entity”,0) [Flex-

Dim2Fix] [FlexDim3Fix][CurrencyDTP])
FIX([EmpDimFix] [JobDimFix])
6-30
Chapter 6
Note:
When you modify the template, ensure that the syntax (for example,
the commas) is valid and balanced by reviewing the Design-time
Prompts (DTP).
2. Redeploy the three rules.
Note:
Test your changes in your Test instance before applying the
changes in Production.
• If your organization’s usual practice is to run Synchronize Defaults immediately

after running Process Loaded Data, you can reduce execution time by modifying
the Process Loaded Data rule to substitute the Synchronize Defaults template
in place of the Synchronize Definition template in the same relative position. By
doing this, you eliminate the execution time of the Synchronize Definition tem‐
plate, which is unnecessary if you include the Synchronize Defaults template in
the Process Loaded Data rule because Synchronize Defaults includes the logic
in Synchronize Definition.
• If you load the additional earning, benefit, and tax assignments directly from a
source Human Resources or Payroll system, such as Oracle Fusion Human Capi‐
tal Management, then you do not need to run Synchronize Defaults nor Calcu‐
late Compensation. Running Process Loaded Data is sufficient in this use case
to calculate compensation for all the loaded data, because it includes Synchron‐
ize Component Definition.
6-31
7
Configuring Projects
• Enabling Projects Features
• Configuring Projects
Enabling Projects Features

Before users can start planning projects, you must enable Projects features. Enable
only the features you want to use. Based on your selections, dimensions, drivers,
forms, and accounts are populated. You can come back later and incrementally enable
additional features; however you must enable all the dimensions you want to include in
the application the first time you enable features.
Note:
After you enable a feature, you can’t later disable it.
Watch this tutorial video to learn more about enabling and configuring Projects.
Tutorial Video
.
2. From the Configure list, select Projects, and then click Enable Features.
3. Select the features you want to enable and then click Enable. Except as noted,
you can come back later and enable additional features, so enable only the fea‐
tures you need to use now.
7-1
Chapter 7
Table 7-1 Enabling Projects Features
Enable Description
Project Type Select the project types for planning.
Enable only the project types you need. You
can later enable additional project types if nee‐
ded.
You must enable Capital before you can ena‐
ble Capital projects, and add a custom dimen‐
sion in Capital called Project (the default di‐
mension name in Projects). If you plan to re‐
name and use a different name for the Project
dimension in Projects, use that same dimen‐
sion name in Capital.
See Enabling Project Type.
Revenue Provides the ability to manage revenue.
Available only for Contract projects. You can
track revenue by directly entering it (Direct In‐
put) or by setting up revenue drivers (Driver
Based). Adds artifacts (forms, calculations,
and reporting) to support revenue planning.
See Enabling Project Revenue.
Project Benefits Tracks qualitative and quantitative project ben‐
efits.
See Enabling Project Benefits.
Expense Select project related expenses to plan.
Track expenses by entering them (Direct In‐
put) or by setting up expense drivers (Driver
Based). Adds forms, calculations, and report‐
ing to support expense planning. To use Job
Rates from Workforce, you must first enable
Workforce. To track utilization of Employees,
you must enable Workforce before Projects,
and for Granularity, select either Employee
or Employee and Job. To use Equipment
Rates from Capital, you must first enable Capi‐
tal.
See Enabling Project Expense.
Rolling Forecast Enables rolling forecast for projects to allow
project reporting and analysis over a rolling
forecasting time period range.
See Enabling Rolling Forecast.
mensions in your application. For
Projects, suggested dimensions are provi‐
ded: Vendor, Phase, and Program.
mensions.
enable Projects.
See Enabling Map/Rename Dimensions.
7-2
Chapter 7
The Projects artifacts are populated, including dimensions, forms, and accounts.
Enabling Project Type

Select Project Type, and then select the type of project to enable:
• Contract—A Contract project is work performed for a customer and the customer
reimburses the company. A contract project generates revenue based on an un‐
derlying 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.
• Capital—A Capital project is a long-term or short-term investment project under‐
taken for construction of a capital asset (such as buildings, dikes, and roads). If a
project has a classification of Capital, you can do only expense budgeting for the
project. You can, however, capture financial and non financial benefits of the
project. The expenses for a Capital project are tracked as Construction in Pro‐
gress (CIP) on the Balance Sheet while the assets are being developed. After a
Capital project is placed in service and the assets are ready, you must reconcile
the CIP assets with existing assets. You must enable Capital before you can ena‐
ble Capital projects, and add a custom dimension in Capital called Project (the de‐
fault dimension name in Projects). If you plan to rename and use a different name
for the Project dimension in Projects, use that same dimension name in Capital.
• Indirect—Also called internal projects, indirect projects have a cost impact but
don’t generate revenue. For example, an IT project that creates a portal for the
Human Resources team to track personal details of employees is an Indirect
project. 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.
Enabling Project Revenue

You can plan project revenue for Contract projects only.
Select Revenue if you want to plan revenue associated with Contract projects, and
then select options for revenue planning. Select a revenue planning method:
• Direct Input—Allows users to enter values directly in planning forms.
When you use direct entry, no predefined calculations are used.
• Driver Based—Allows users to enter rates and drivers for revenue calculations.
When you do driver-based revenue planning, revenue is calculated using the pre‐
defined formulas, using standard rates and the revenue drivers you enter. For ex‐
ample, you can set up set up a revenue driver for a construction project using billa‐
ble resources that are onsite and offshore. You provide the billable rate for onsite
and offshore resources. Labor revenue is calculated based on the number of re‐
sources, the billable hours, and the billable rates.
Enabling Project Benefits

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
7-3
Chapter 7
benefits of a project, which can be used to justify a project and help measure a proj‐
ect's success.
Select Project Benefits and then specify the type of project benefits to enable:
• Financial—You can define financial benefits associated with projects; users can
track project performance. For example, if you are setting up a new web site, you
can track financial benefits that might come out of the project. For example, you
might get incremental revenue from leads from the web site, or, if you handle quer‐
ies on the web site, you might see call center savings. Or a new video conferenc‐
ing facility can lead to savings on travel expenses.
• Non-Financial—You also can define non-financial benefits. For example, a new
web site might improve the customer satisfaction index, or you might see an incre‐
mental increase in your user base by investing in the project. You can quantify the
benefits and map them to various project accounts.
Once you define the benefits, users can track the performance.
Users can also capture additional qualitative project benefits that aren't trackable with
numbers that can help justify projects. For example, you could note that customers will
have a better user experience with the improved web site design.
Enabling Project Expense

You can plan expenses for all project types.
Select Expense if you want to plan expense associated with projects, and then select
an expense planning method:
• Driver Based—Users enter drivers for expense calculations.
When you do driver-based planning, expense is calculated using the predefined
formulas, using standard rates and the expense drivers you enter.
You can enable several expense driver types:
– Labor—Allows planners to calculate a variety of labor related costs, set start
and end dates, plan the FTEs, and so on. You can also select additional op‐
tions:
* Standard Rates from Workforce—Brings in the labor codes from Work‐
force and rates for the codes.
* Employee—Allows for planning at the named employee level rather at the
job level. Used for tracking employee utilization.
– Equipment—Allows planners to plan the equipment expenses for a project,
including the start and end date, number of units, and so on. You can also se‐
lect Standard Rates from Capital to bring in capital assets and allocate them
to projects.
– Material—Allows planners to plan the material expenses for a project. For ex‐
ample, a construction project would require lumber, concrete, and rebar.
• Direct Input—Allows users to enter values directly in planning forms.
When you use direct entry, no predefined calculations are used.
7-4
Chapter 7
Enabling Rolling Forecast

Enabling rolling forecast allows planners to perform continuous planning beyond a
one-year timeframe. After you enable rolling forecast, use the Planning and Forecast
Preparation configuration task to configure rolling forecast to plan continuously at a
weekly level for either 13, 26, or 52 weeks, at a monthly level for either 12, 18, or 24
months, (and for Financials also for 30, 36, 48, or 60 months) or at a quarterly level for
either 4, 6, or 8 quarters.
By using the Planning and Forecast Preparation configuration task to define the rolling
forecast range and using the provided forms, it's easy to implement a rolling forecast.
Rolling forecast is primarily used in Financials for data entry and analysis, but if you
enable rolling forecast for Projects, you can analyze projects over the defined rolling
forecast time period range.
When you enable and configure rolling forecast:
• Rules, forms, and dashboards for rolling forecast planning and analysis are cre‐
ated.
• Forms and dashboards are designed so you can view the entire rolling forecast
range. Valid intersections are used to control what displays.
• When you update the current time period, forms and dashboards are automatically
updated to add or drop new time periods as needed to reflect the updated rolling
forecast range. Trends and drivers are populated to newly added time periods.
Valid intersections are used to make the forms dynamic.
• For Financials, a new member (OEP_Rolling Forecast) is added to the Scenario
dimension. Note that the standard forecasting member (OEP_Forecast) is still
available so you can use the standard forecasting method that allows forecasting
for a one-year timeframe and the rolling forecasting method.
• Projects uses the OEP_Rolling Forecast member to dynamically display data in
the rolling forecast range by referring to the forecast scenario (OEP_Forecast) for
the corresponding period. It does not allow data entry for the OEP_Rolling Fore‐
cast member.
If you purchased EPM Cloud before June 4, 2019, you can convert a Standard or Re‐
porting application to an Enterprise application. If you convert the application, planners
can continue to use existing forms that use the converted application's rolling forecast‐
ing method because the form property that creates rolling forecast is still available in
your custom cubes.
Watch this overview video to learn more about planning using a rolling forecast.
Overview Video.
Watch this tutorial video to learn more about planning using a rolling forecast.
Tutorial Video.
7-5
Chapter 7

sions you specify.
Perform this task after you’ve enabled Projects features.
.
2. From the Configure list, select Projects.

For information on importing files and the file formats, see Importing Data.
Table 7-2 Configuring Projects
Project Import projects.
Populate the application with projects by im‐
porting members to the Projects dimension.
7-6
Chapter 7
Table 7-2 (Cont.) Configuring Projects
Resource Class Import resource class. The Resource Class
consists of labor, material, and equipment co‐
des.
Import detailed jobs to use for planning project
expenses. You can import members, or, if
Workforce is enabled, you can use jobs from
Workforce.
Note:
If you are inte‐
grating Work‐
force and
Projects, you
don't need to im‐
port jobs. The
Jobs are auto‐
matically impor‐
ted from Work‐
force.

Select the location of the file containing the
members (Local or Planning inbox), click
Browse to find the file, specify the file type,
and then click Import.
Note:
Entities are com‐
mon across
modules, so im‐
port all entities
together.
Expense Accounts Configure expense accounts.

Select the defined artifacts to use. Add or im‐
port custom drivers or accounts to manage
project expenses for your business needs. If
required, you might need to add logic or calcu‐
lations related to any custom accounts.
ers.
7-7
Chapter 7
Table 7-2 (Cont.) Configuring Projects
Revenue Accounts Configure revenue accounts.
port custom drivers or accounts to manage
project revenue for your business needs. If re‐
quired, you might need to add logic or calcula‐
tions related to any custom accounts.
ers.
Planning and Forecast Preparation Set the timeframe and granularity for plans.
Configures the timeframe, the starting period,
and the level of granularity for planning and
forecasting. Gives you the ability to plan and
Project Properties Configure project properties.
port custom project properties using the same
process used for adding and importing ac‐
counts and drivers.
ers.
Global Assumptions Set exchange rates.
Enter foreign exchange rates in a multicurren‐
cy application.
Additionally, enter global assumptions for
projects including standard labor rates, over‐
head, working days and hours, discount rate,
See Setting Global Assumptions: Exchange
Rates and Entering Global Project Rates.
Projects Financials Mapping If you are integrating Projects and Financials,
for each Projects account, select the corre‐
sponding Financials account from the Smart
List.
You can do the mapping at No Entity level, the
default, which is used if an entity level map‐
ping isn’t set up.
Available only if Financials is enabled.
<customName> Dimension Import members for the <customName> di‐
mension.
Use if you enabled the <customName> dimen‐
sion, for example to associate projects with a
vendor.

7-8
Chapter 7

monthly basis.
year
Years.
the row for FY21.
7. For Financials or Projects: If you enabled Rolling Forecast, click Rolling Forecast
to select the basis for continuous planning. Select the planning frequency (monthly
or quarterly), the number of periods, and the number of actual periods.
For Financials, you can also select a weekly planning frequency and choose
whether to plan at a weekly level for 13, 26, or 52 weeks.
The number of actual periods defines how many time periods of actual data to
show in forms and dashboards in conjunction with the rolling forecast time periods.
The Rolling Forecast Range is updated based on your selections.
When you configure rolling forecast, forms and dashboards are set up based on
the planning frequency and number of periods. When you change the current plan‐
ning period, the rolling forecast forms and dashboards are updated—time periods
are added or dropped and actuals time periods are updated to reflect the new roll‐
ing forecast range.
You can plan using a combination of standard forecasting and rolling forecasting.
8. If you enabled weekly planning for Financials, specify the current week. You need
to update this value on a weekly basis.

facts.
7-9
Chapter 7
Tutorial Video

3. Perform a task:
in the new row.
Notes:

7-10
Chapter 7
then save the form.
Note:
Entering Global Project Rates

Enter global project assumptions for standard rates that drive revenue and expense
calculations, such as overhead, working days and hours, and labor and equipment
rates. Planners can override these values for a project if the project is set up with
Override Standard Labor Rates, Override Standard Equipment Rates, or Override
Standard Materials Rates set to Yes.
To enter global project assumptions:
1. Click Global Assumptions.
2. Select the horizontal tab for the global assumptions you want to enter and then en‐
ter assumption details.
• Standard Rates—Specify rates for equipment, labor, and materials.
• Overhead—Specify overhead for different accounts. For example, you can
plan the overhead rate for Engineering or Manufacturing, or allocate a Facili‐
ties overhead.
• Discount rate—Specify the discount rate per year; used in NPV calculations.
• Standard Rates for Labor—Specify rates for different jobs.
• Working Days and Hours—Specify the working days and hours in a month; it
can vary by entity. For example, you can set different working days and hours
for different regions or for different departments.
The forms that are loaded are based on the features and integration you’ve enabled.

Related Topics
• Mapping Projects to Programs
Mapping Projects to Programs

If you enabled the Program dimension, you can group projects together into a program
for analysis purposes. You must have already added projects to perform this task.
When you enable the Program dimension, it is added as an attribute dimension. Map
projects to programs in the Dimension Editor.
7-11
Chapter 7
Projects Rules
To map projects to programs:
1. From the Home page, click Navigator and then select Dimensions from the
Create and Manage category.
2. Select Project from the Dimension drop-down list.
3. From the Actions menu, select Custom Attributes.
4. Click Programs to move it to the Attribute Values pane.
5. Click + to add the program members.
6. Select a program, and then in Attribute Values, select the project you want to as‐
sociate with the program.
Projects Rules
Run rules to calculate values in the application. From the Home page, click Rules.
Tip:
To see only Projects rules, click All Cubes next to the Filter, and from the
Cube list select OEP_PFP.
Projects rules:
• OPF_Add Project—Adds a new project on the fly.
• OPF_Add Expense Line Item—Adds a new expense line item in a project.
• OPF_Add Revenue Line Item—Adds a new revenue line item in a project.
• OPF_Approve Project—Sets the status of the project to Approved; copies the
plan data to the forecast scenario, since this project is likely to move forward.
• OPF_Calculate Capitalized Expense—Calculates capitalization expenses for
capital projects.
• OPF_Calculate Direct Expense—Calculates direct expenses for all projects.
• OPF_Calculate EVM—Calculates Earned Value Measure for Project – Schedule
and Cost variance based on set targets.
• OPF_Calculate Expense CashFlow—Calculates cash flows associated with ex‐
penses, based on the assumptions set for the project.
• OPF_Calculate Expense—Calculates driver-based expenses for labor, material,
and equipment based on set driver-based assumptions.
• OPF_Calculate Financial Benefits—Calculates aggregated financial benefits.
• OPF_Calculate Non Financial Benefits—Calculates non-financial benefits, sum‐
ming the year totals.
• OPF_Calculate Overhead Expenses—Calculates overhead expenses based on
the specified drivers.
7-12
Chapter 7
Projects Rules
• OPF_Calculate Payback period—Calculates the payback period based on the

expenses and benefits planned for a project.
• OPF_Calculate Payback period Revenue—Calculates the payback period based
on the expenses and revenue for a project.
• OPF_Calculate Project Benefits—Calculates the project benefits for indirect and
capital projects.
• OPF_Calculate Revenue—Calculates revenue for contract projects based on the
project type: time and material, cost plus, or direct.
• OPF_Calculate Revenue cash flows—Calculates the cash flows for revenue re‐
alization.
• OPF_Calculate Revenues
• OPF_Copy Data to Finstmt—Moves data from Projects to Financials after aggre‐
gating data for all projects, based on the defined mapping.
• OPF_Delete Project—Deletes the project.
• OPF_Execute Project to Capital Map Reporting—Creates capital assets from
project expenses.
• OPF_Execute Project to Capital Map Reporting - Capitalized—Creates capital
assets from project expenses based on resource class.
• OPF_Execute Project to WFP Map Reporting—Moves assigned job codes and
employees FTE, labor hours, and expenses to Workforce.
• OPF_Prepare Detailed Forecast Data—Organizes data for forecast for months
and years.
• OPF_Prepare High Level Forecast Data—Organizes data for high level fore‐
casts for months and years.
• OPF_Push data to capex from Projects—Moves data into planned capital work
in progress assets based on allocated expenses from Projects to Capital.
• OPF_Recognize Revenue—Calculates revenue recognition based on the as‐
signed revenue recognition drivers.
• OPF_Refresh Project Dates—Run this rule before directly entering expenses or
revenue for projects that have been imported, or when project dates are changed.
• OPF_Remove Line items—Removes line items from the project.
• OPF_Rollup Project Cube—Calculates the aggregation of projects through the
hierarchy.
• Roll up Project—Aggregates the projects and pushes the data to Financials
based on the account mapping.
7-13
8
Configuring Capital
• Enabling Capital Features
• Configuring Capital
Enabling Capital Features

Before users can start planning capital assets, you must enable Capital features. Ena‐
ble only the features you want to use. Based on your selections, dimensions, drivers,
forms, and accounts are populated. You can come back later and incrementally enable
additional features; however you must enable all the dimensions you want to include in
the application the first time you enable features. You must also specify Named Assets
the first time you enable Capital features.
Note:
After you enable a feature, you can’t later disable it.
Watch this tutorial video to learn more about enabling and configuring Capital.
Tutorial Video
.
2. From the Configure list, select Capital, and then click Enable Features.
3. Select the features you want to enable. Except as noted, you can come back later
and enable additional features, so enable only the features you need to use now.
Table 8-1 Enabling Capital
Enable Description
New Capital Investment Select new capital investments.
See Enabling New Capital Investment.
8-1
Chapter 8
Enabling Capital Features
Table 8-1 (Cont.) Enabling Capital
Enable Description
Manage Existing Assets Select existing capital assets.
See Enabling Manage Existing Assets.
mensions in your application.
mensions.
enable Capital.
If you are integrating Capital with Projects, add
a custom dimension called Project, the default
dimension name in Projects. If you name it
anything else, make sure the dimension name
is the same in all modules.
See Enabling Map/Rename Dimensions
The Capital artifacts are populated, including dimensions, forms, and accounts.
Enabling New Capital Investment

Enables new capital investments for fixed assets and optionally allows you to plan for
lease assets (for example, vehicles) or intangibles (for example, copyrights). Select
Named Assets to add the names of assets to plan at the detail level, and specify the
likely number of named assets that you would add in a planning cycle.
If you are going to use Named Assets, you must select it the first time you enable
Capital. You can’t come back later to enable it. You can, however, come back later to
increment the number of named assets.
Enabling Manage Existing Assets

Enables planning for asset-related expenses, and retirement, transfer, and improve‐
ments on existing assets. Optionally you can also plan for existing intangible assets.
Use this option if you want to plan for expenses at the asset level, for high mainte‐
nance, high value assets that can be planned by setting standard percent assump‐
tions.

sions you specify.
8-2
Chapter 8
Configuring Capital
Configuring Capital
Perform this task after you’ve enabled Capital features.
.
2. From the Configure list, select Capital.

You must add asset classes (and intangible assets if intangible assets are ena‐
bled) from provided members or by importing them from a file. This is required to
load dashbaords and forms.
For information on formatting import files, see Importing Data.
8-3
Chapter 8
Configuring Capital
Table 8-2 Configuring Capital
Select the location of the file containing the
members (Local or Planning inbox), click
Browse to find the file, specify the file type,
and then click Import.
Note:
Entities are com‐
mon across
modules, so im‐
port all entities
together.
Assets Set up asset classes.

Add or import tangible asset class members.
You can select from the defined lists of asset
class or add your own custom asset class. The
Asset Class dimension details the categories
of assets that a company owns.
ers.
Intangible Assets Set up intangible assets.
Add or import intangible asset class members.
You can select from the defined lists of asset
class, add from a Smart List, or add your own
custom asset class. The Asset Class dimen‐
sion details the categories of assets that a
company owns.
ers.
Expense Configure expense accounts by selecting the
defined artifacts to manage.
You can remove expense accounts for Capital,
but you can’t add or import them.
ers.
Asset Details Import asset details.
Import asset details into the Asset Detail di‐
mension, which is used to track the details of
an asset as an individual asset or a group of
assets, depending on the requirement. An as‐
set can be New Owned, Existing Owned, New
Leased, or Existing Leased.
For more information, see Importing Data.
8-4
Chapter 8
Configuring Capital
Table 8-2 (Cont.) Configuring Capital
Planning and Forecast Preparation Set the timeframe and granularity for plans.
Configures the timeframe, the starting period,
and the level of granularity for planning and
forecasting. Gives you the ability to plan and
Expense and Cash Flow Assumptions Set up assumptions for tangible asset expen‐
ses, depreciation and amortization, and fund‐
ing assumptions. Used as drivers for expense
calculations for Tangible Assets.
You can only remove predefined expense as‐
sumptions; you can’t add or import new ones.
ers.
Assumptions for Intangibles Set up assumptions for depreciation method
and convention, useful life, and cash flow and
funding assumptions. Used as drivers for ex‐
pense calculations for Intangible Assets.
You can only remove predefined expense as‐
sumptions; you can’t add or import new ones.
ers.
Global Assumptions Set exchange rates.
Enter foreign exchange rates in a multicurren‐
cy application. See Setting Global Assump‐
tions: Exchange Rates.
Map Capital Accounts to Financials Map asset accounts from Capital to Financials
accounts to allow for integration and move‐
ment of data from detail assets in Capital to
account level in Financials. For each asset ac‐
count, select the corresponding Financials ac‐
count from the Smart List.
Select the horizontal tabs to map assets for
Tangible Assets, Intangible Assets, and Lease
Assets.
Available only if Financials is enabled.
Import <customName Dimension> Import <customName Dimension>.
Import members to populate the <custom‐
Name Dimension> dimension. Use if you ena‐
bled a custom dimension.

8-5
Chapter 8
Configuring Capital
monthly basis.
year
Years.
the row for FY21.
In Capital, forms and rules allow different planning years for the Plan and Forecast
scenarios.
During Capital Planning and Forecast Preparation configuration, instead of setting
the &OEP_YearRange substitution variable for both Plan and Forecast scenario, Cap‐
ital configures business rules to use methods that read the start year and end year
from the Planning and Forecast Preparation configuration separately for each sce‐
nario. Forms are created to display data based on the start and end periods for the
scenario.
To create custom rules for Capital, use these functions rather than the &OEP_Year‐
Range substitution variable:
• [[PlanningFunctions.getModuleStartYear("CAPITAL",{Scenario})]]—Returns
start year of given scenario
• [[PlanningFunctions.getModuleENDYear("CAPITAL",{Scenario})]]—Returns
end year of given scenario
To create custom forms for Capital, use ILvl0Descendants of "All Years" instead of
&OEP_YearRange.

facts.
8-6
Chapter 8
Configuring Capital
Tutorial Video

3. Perform a task:
in the new row.
Notes:

8-7
Chapter 8
then save the form.
Note:

After completing the configuration tasks, perform these tasks:
• Refresh the cube after configuring and any time you import metadata.
• Review the assumptions forms under Investments and Intangibles and for Existing
Assets at No Entity level and at members of Total Entity level. If desired, set up
assumptions at No Entity level so planners have a starting point for planning. You
can make the No Entity assumption values non-editable for planners by setting up
security so that No Entity is Read Only. When you do this, planners can see global
assumptions but can’t not modify them.
• Don’t change the Enable for Dynamic Children and Number of Possible Dy‐
namic Children properties for OCX_Total New and OCX_New Lease members
in the Asset Detail dimension. These properties must be Read Only.
• If needed for your business, you can create custom depreciation and amortization
methods. See Creating a Custom Depreciation or Amortization Method.
Capital Rules
To run rules, from the Home page, click Rules.
Tip:
To see only Capital rules, click All Cubes next to the Filter, and from the
Cube list select OEP_CPX.
Capital rules:
• Add Asset—Adds new assets for asset class; for tangible assets.
• Add Asset Dynamic—Adds new assets with member names given in the runtime
prompt.
• Add Intangibles—Adds intangible assets for asset class.
• Add Intangible—Adds new assets when Named Asset is not selected in Enable
Features
8-8
Chapter 8
Capital Rules
• OCX_Add Intangibles Dynamic—Adds new assets with member names given in

the runtime prompt.
• Add LeasedAsset—Adds leased assets at the entity level including determining
whether it's operating or capital lease.
• Add LeasedAssets—Adds a named leased asset at the entity level including de‐
termining whether it's operating or capital lease.
• Assign Driver for a plan year—Sets percentage driver for a target year either
based on source year or simply based on value provided.
• OCX_Add LeasedAsset Dynamic—Adds leased asset with member names giv‐
en in the runtime prompt.
• Calculate All Existing Intangible Assets—This rule is now obsolete. Use this
rule instead: Calculate Intangible Asset.
• Calculate All Existing Tangible Assets—This rule is now obsolete. Use this rule
instead: Calculate Tangible Asset.
• Calculate Existing Intangible Assets—Calculates the amortization and all other
expenses and cash flow for the specified existing intangible asset.
• Calculate Intangible Asset—Calculates the amortization and all other expenses
and cash flow for the specified intangible asset.
• Calculate Tangible Asset—Calculates the depreciation and all other expenses
and cash flow for the specified asset.
• Calculate All Leased Assets—Calculates PV value of lease, depreciation, inter‐
est, and cash flows for all leased assets for an entity.
• Calculate Leased Assets—Calculates PV value of lease, depreciation, interest,
cash flows for a specified leased asset.
• Impair Intangible—Calculates impairment (reduction of asset value) for intangi‐
bles.
• Improve Asset—Allows for adding improvements to existing assets by splitting
the asset and creating the value of the improvement.
• Reconcile Asset—Reconciles the new asset request against an existing asset. All
values are pushed to the assigned asset.
• Reconcile Leased Asset—Reconciles the new leased asset request against an
existing leased asset. All values are pushed to the assigned asset.
• Remove Named Asset—Removes a named asset that's no longer relevant.
• OCX_Remove Asset Dynamic—Removes a planned named asset investment
that's no longer relevant.
• Remove Leased Asset—Removes a planned lease asset investment that's no
longer relevant.
• OCX_Remove Leased Asset Dynamic—Removes a planned named leased as‐
set investment that's no longer relevant.
• Retire Asset—Retires the existing asset, where the asset can be sold or written
off, with corresponding accounting implications.
• Retire Intangible—Retires the existing intangible, where the asset can be sold or
written off, with corresponding accounting implications.
• Roll up Capital—Rolls up Accounts, Asset Details, Asset Class, Entity.
8-9
Chapter 8
Creating a Custom Depreciation or Amortization Method
• Sync FS Account Mapping—Synchronizes the mapping of financial statement

accounts between Capital and Financials.
• Synchronize drivers—Synchronizes asset assumptions to level 0 assets.
• Transfer Asset—Transfers existing tangible assets from one entity to another; all
costs/expenses are pushed to the new entity.
• Transfer Intangibles—Transfers existing intangibles from one entity to another;
all costs/expenses are pushed into the new entity.
• Push Data To Financials—Runs the data map Financial Statement Integration
to push data from Capital to Financials.
Creating a Custom Depreciation or Amortization Method

If needed for your business, you can define custom depreciation and amortization
methods. Capital provides a Smart List entry called Custom. You can define a busi‐
ness rule to calculate depreciation or amortization as needed for your business, and
then associate the new business rule with the Custom Smart List entry. The Custom
Smart List entry is available in Depreciation and Amortization Assumptions.
To create a custom depreciation or amortization method:
1. Using Calculation Manager, define a new depreciation or amortization rule.
When defining the business rule, set the deprMethod = 5 or set amortMethod =
3. These are the Smart List entry numbers for the Custom entry.
See Designing Business Rules.
2. Create an Action Menu menu object, for example named Custom Depreciation or
Custom Amortization and associate the business rule you just created to the
menu. From the Home page, click Navigator and then click Action Menus.
See Administering Action Menus.
3. Edit the form with which you want to associate the new menu option, for example,
New Tangibles, and add the menu option to the form. See Administering Forms.
4. In the Depreciation and Amortization Assumptions form, for the Asset Class
that requires the custom method, select Custom.
Now, when users are creating a new asset, when a new asset requires the custom
method, they can select the custom rule you defined from the Actions menu.
Note:
You must use the custom rules with the Custom depreciation or amortization
Smart List entry, and use provided rules for the provided methods.
Tip:
To change the name of the Custom method, change the artifact label: From
the Home page, click Tools, then click Artifact Labels, and then apply the
filter to see Smart List Entry. Select your language, and then change the la‐
bel for the custom OCX_AmortizationMethod or OCX_DeprMethod entry.
8-10
9
Configuring Strategic Modeling
Related Topics
• Enabling Strategic Modeling
• Working with Templates
• Creating a Strategic Modeling Model
• Setting Up Model Access Permissions
• Changing Model Properties
• Pushing Data Between Strategic Modeling and Planning
• Managing Metadata with Model Change Management
Use Model Change Management to copy metadata from a source model to one or
more target models.
Enabling Strategic Modeling

Before users can start strategic planning, you must enable Strategic Modeling.
To enable Strategic Modeling:
.
2. From the Configure list, select Strategic Modeling, and then click Enable Fea‐
tures.
3. Log out and log in again to see the newly enabled feature.
There are no configuration tasks required for Strategic Modeling.
The Strategic Modeling provided templates are populated.
Working with Templates

Use templates to quickly create a model. Templates include a hierarchical set of ac‐
counts without time periods or data.
Strategic Modeling includes templates for commonly used account structures. You can
use one of the provided templates, or create and upload custom templates.
Oracle provides these templates:
• Standard
9-1
Chapter 9
Working with Templates
• Utility
• Healthcare
• Retail
• Higher Education
These templates are available when you enable Strategic Modeling so you can get up
and running quickly. You can't modify the templates provided by Oracle, but you can
save a copy of a template and modify it for your business use case.
To review the account structure of the provided templates and any custom templates
you've uploaded:
1. From the Home page, click Strategic Modeling , and then click Tem‐
plates .
2. From the Actions menu for the template you want to review, click Open.
3. Change the Scenario, Dataview, or Account Groups to show different sets of
accounts.
You can also review and edit the account structure in the templates provided by Ora‐
cle using Strategic Modeling in Oracle Smart View for Office.
Creating and Uploading Custom Templates

You can create a custom template by saving a copy of one of the templates Oracle
provides and customizing it. Review the account structure in the provided templates to
determine which most closely suits your business needs, and then use Oracle Smart
View for Office to customize and upload the template for use on the Web.
You can also use Smart View to upload templates you created from the on premise
version of Oracle Hyperion Strategic Finance for use on the Web.
Changing the Owner and Access Permissions for Custom Templates

All users (except those with No Access) can view the out-of-box templates provided
with Strategic Modeling. Administrators can change the owner and the access permis‐
sions for custom templates.
To change the owner or access permissions for custom templates:
1. From the Home page, click Strategic Modeling , and then click Tem‐
plates .
2. From the Actions menu next to the template you want to modify, click Properties.
9-2
Chapter 9
Creating a Strategic Modeling Model
3. Change the owner of the template if required.

4. Click Permissions.
5. Click to add users or groups and assign them access to the template.
For information about user and group permissions, see Setting Up Model Access
Permissions.
6. To replace the current permissions with default permissions, click Inherit Default
Access.
7. Click Apply to save the changes.
Creating a Strategic Modeling Model

Administrators and Modelers can create Strategic Modeling models using templates—
financial model frameworks that contain predefined reporting and modeling standards.
Oracle includes several pre-defined templates to get you up and running quickly. You
can also create a model that is based on an existing model.
Users check out models to work with them, or they can work with a copy of the model.
When users work with a copy of a model, they can't save changes to the data or to the
model.
When you create a model, the model is populated with a hierarchical chart of ac‐
counts, a time structure, reports, dataviews, account groups, and all the metadata from
the template or the model it was created from.
You must have already created an application and enabled Strategic Modeling. If you
want to use a custom template (customized using Oracle Smart View for Office) to cre‐
ate the model, it must already be uploaded.
Watch this tutorial video to learn more about creating a Strategic Modeling model.
Tutorial Video
To create a Strategic Modeling model:
1. From the Home page, click Strategic Modeling , and then click Model
View .
2. Click Create.
3. On the General page, specify the following options and then click Next.
• Specify a model name and description.
• Select whether to create the model from a template, from an existing model in
the current application, or from a local .alc file, and then select the template,
model, or file.
If you are creating a model from a local .alc file, the file must have already
been converted in Smart View for use on the Cloud.
9-3
Chapter 9
Setting Up Model Access Permissions
To integrate Strategic Modeling data with Financials, select the Financial tem‐
plate.
• Select Place at Root to create a standalone model or a model that will be the
parent of another model, or to create a hierarchical structure, clear Place at
Root and select a parent model.
Creating a hierarchical model structure can be useful for consolidations and
managing access control, or for visually organizing models.
• Select a base currency and units.
Each model can have its own currency and units, independent of the applica‐
tion.
If you create a model from a local .alc file or from an existing file if you keep
source data, these options are not available; the model is created using the
units and currency of the original model.
Note:
You set up currency conversions in Smart View. See "Translating
Currencies" in Working with Strategic Modeling in Smart View.
• If you created the model from an existing model, select Keep Time Structure
if you want the new model to use the same time period structure as the exist‐
ing model.
If you selected Keep Time Structure, you can select Keep Source Model
Data to include the source model's data values in the accounts.
If you select Keep Time Structure, skip to step 5.
• If you created a model using the Financial template for integration with Finan‐
cials, in Select Entity, select a Financials Entity dimension member. The mod‐
el will be mapped to the selected Entity dimension member.
This option is available only when creating a model from the Financial tem‐
plate. For more information, see Integrating Data Between Strategic Modeling
and Financials.
4. On the Calendar, Time Period, and Configure Years pages, specify the options
for building the calendar for this model.
5. Review the model creation options, and then click Create Model.
The model is created with a chart of accounts and a calendar structure based on the
options you selected.
You can convert an Oracle Hyperion Strategic Finance model to a Strategic Modeling
model in Smart View. See Working with Strategic Modeling in Smart View.

Planning administrators are set up as Strategic Modeling administrators and can set
up access permissions that define the type of access users and groups have to mod‐
els and Strategic Modeling features—global permissions that apply to all models in the
application, and permissions for individual models. When you assign access permis‐
sions to an individual model, any models nested under that model in the model hierar‐
chy inherit the access permissions from the parent.
9-4
Chapter 9
If a model is inheriting access permissions (either from the global level or from a pa‐
rent), as long as you have not made any changes to the individual model's access per‐
missions, it will continue to inherit any changes to access permissions. However, once
you modify an individual model's access permissions, it no longer inherits any permis‐
sion changes from either the global level or the parent (depending on where it inheri‐
ted permissions from).
Available roles include Modeler, Analyst, Viewer, and No Access. See About Model
Access Permissions for more information about these roles. These permissions also
apply to models when you work with Strategic Modeling in Oracle Smart View for Of‐
fice.
Model access details:
• Planning users (except Administrators) are available in the Users list to assign
model access. Note that access permissions in Strategic Modeling are unrelated
to those in Planning. You must give users access to Strategic Modeling models
even if they have access to the Planning application.
• When a model is first created, it is set up with Default permissions and Owner per‐
missions. You can't delete these. Any newly added user or group gets the default
permissions.
By default, the Default permissions and new users and groups have the No Ac‐
cess role. If you assign global access, all new models inherit that access.
• When a user has no access to a model, no model actions or options are available.
When a user has no access to a menu item, it doesn't appear on the Actions
menu.
Watch this tutorial video to learn more about setting up model access permissions.
Tutorial Video
About Model Access Permissions

Administrators can perform these tasks:
• Enable Strategic Modeling
• Assign access permissions
• Create, delete, and modify models and consolidations
• Upload templates, assign access to custom templates, and delete templates
Users' access to consolidations comes from the Global Access.
9-5
Chapter 9
Table 9-1 Model Access Permissions
Role Access
Modeler • Models:
– Create
– Open - Check out and check in
– Open As Copy
– Delete
• Account View: All options are available
– Find Account
– Account Forecast
– Subaccounts
– Goal Seek
– Scenario Manager
– Audit Trail
– Simulations
– Enter data, Calculate, and Save
– Change the Point of View to display
different account groups, scenarios,
and dataviews
• Consolidations: All options are available
• Templates: View templates, delete cus‐
tom templates, import templates
• Reports: All options are available
• In Oracle Smart View for Office:
– Models: Copy Local File to Server,
Delete Model, Input Status, Account
Groups, Funding Options, Required
Elements, Template Name
– Time management: Time tab. All op‐
tions are available
– Scenarios: All options are available
– Dimensions: All options are available
Analyst • Models:
– Open - Check out and check in
– Open As Copy
• Account View
– Find Account
– Account Forecast
– Goal Seek
– Audit Trail
– Enter Data, Calculate, and Save
and data views
• Templates: View templates
• Reports: View reports
9-6
Chapter 9
Table 9-1 (Cont.) Model Access Permissions
Role Access
Viewer • Models: Open As Copy
• Account View
– Find Account
– Goal Seek
– Audit Trail; however, viewers can't
make changes to inputs
– View the grid in read only mode (can't
Enter Data or Save)
and data views
• Templates: View templates
• Reports: View reports
No Access No access
Specifying Global Access Permissions for All Models

To specify global access permissions that apply to all models:
1. From the Home page, click Strategic Modeling , then Model View
, and then Global Access.

2. Specify a role for each user or group.
3. Click to add users or groups and assign them global access.
Specifying Access Permissions for a Model

If you set up global access permissions, each individual model inherits access permis‐
sions from the global access list. You can modify the permissions for each model. Chil‐
dren models inherit permissions from the parent model, unless the parent has no spe‐
cific permission, in which case they inherit the global access permissions. Once you
modify an individual model's access permissions, it no longer inherits any permission
changes from either the global level or the parent (depending on where it inherited per‐
missions from).
To specify access permissions for a specific model:
9-7
Chapter 9
Changing Model Properties
1. From the Home page, click Strategic Modeling , and then Model View
.
2. From the Actions menu next to the model you want to modify, click Properties.
3. Click Permissions and then specify the user and group permissions for the mod‐
el.
4. Click to add users or groups and assign them access to the model.
5. To replace the current permissions with default permissions, click Inherit Default
Access.
6. Click Apply to save the changes.
Changing a Model's Owner

You can change the owner of a model.
To change a model's owner:
.
3. Change the owner, and then click Apply.
Changing Model Properties

Administrators and model owners can change the properties of a model.
To change a model's properties:
.
3. Change the properties, and then click Apply:
• Owner—Specify the account owner.
9-8
Chapter 9
Pushing Data Between Strategic Modeling and Planning
• Default Units—Specify the default units for the model.

• Default Currency—Specify the default currency for the model.
• Input Decimal Places—Specify the number of decimals to display for input ac‐
counts.
• Output Decimal Places—Specify the number of decimals to display for output
accounts.

You can push data between Strategic Modeling and Planning in two ways:
• Data Maps and Smart Push—Provides an easy-to use interface that automatically
maps same-named dimensions and members and allows you to define the map‐
ping between other dimensions and members. You can define complex mappings
to or from a single dimension to or from multiple dimensions. The feature also pro‐
vides a Microsoft Excel template to further simplify setting up detailed mappings
and import them using a familiar interface. Using Data maps and Smart Push
works for most use cases. See Pushing Data Between Strategic Modeling and
Planning Using Data Maps.
• Groovy Rules—Provides a powerful rule-based method for creating complex data
maps using Groovy scripting language. Use Groovy rules to define complex map‐
pings. For example, you can define a Groovy rule that pulls data from Planning for
targeted regions based on the current form, such as only from edited cells. You
can also perform calculations on data before pushing it, such as applying a scaling
factor. See Using Groovy Business Rules with Strategic Modeling.
Using Groovy Business Rules with Strategic Modeling

You can create Groovy business rules to push data between Planning cubes and Stra‐
tegic Modeling models. For information about designing Groovy rules, see Creating a
Groovy Business Rule in Designing with Calculation Manager for Oracle Enterprise
Performance Management Cloud and Using Groovy Rules Administering Planning.
Note:
• If you purchased EPM Cloud before June 4, 2019, you can use Groovy
rules only for applications of type "Enterprise" (available with Enterprise
PBCS or PBCS Plus One licenses), Oracle Strategic Workforce Planning
Cloud, or Oracle Sales Planning Cloud.
• If you purchased EPM Cloud Standard Edition after June 4, 2019, you
can use the Groovy rules included with the modules.
• If you purchased EPM Cloud Enterprise Edition after June 4, 2019, you
can use the Groovy rules included with the modules. Additionally, you
can edit and create Groovy rules in Custom, Module, and Free Form
business processes.
Watch this tutorial video to learn more about using Groovy rules with Strategic Model‐
ing.
9-9
Chapter 9
Tutorial Video
Groovy Business Rule Examples

To see example Groovy scripts:
1. See the Java API Reference for Oracle Enterprise Performance Management
Cloud Groovy Rules, http://docs.oracle.com/cloud/latest/epm-common/GROOV/.
2. Do one of the following:
• Under Example Groovy Scripts on the main page, click the word "here" to
view sample scripts:
• Under All Classes in the left pane, click a class to see the examples for that
class.
For example, to see Strategic Modeling examples, click the StrategicModel
class in the left pane.
Pushing Data Between Strategic Modeling and Planning Using Data

Maps
You can push data between Strategic Modeling and Planning using data maps. You
can define data maps that push data:
• From a Strategic Modeling model or consolidation to a Planning cube.
• From a Planning cube to a Strategic Modeling model.
Advanced options let you define complex mappings to or from multiple dimensions to
or from a single dimension and between members with different names. These ad‐
vanced data map options are available only if Strategic Modeling is enabled and is a
source or target in the data map.
Administrators have privileges to create, edit, and run data maps.
To create a data map:
1. From the Home page, click Application , then Data Exchange ,

and then click Data Maps.
2. Click Create.
3. Enter a name and description for the data map.
4. Under Source, select the source for the data. You can select:
• A Planning input cube (Block Storage) from the available cubes for the current
application.
9-10
Chapter 9
• A Strategic Modeling model. You can select from any models in the selected
application.
• A Strategic Modeling consolidation. You can select from any consolidations in
the current application. When the source is a consolidation, metadata is pulled
from the root model of the consolidation.
5. Under Target, select:
• A Planning input cube (Block Storage) or reporting cube (Aggregate Storage)
from the available applications, if the source is a model or a consolidation.
• A Strategic Modeling model if the source is a Planning input cube (Block Stor‐
age).
6. Define how to map dimensions between source and target:.
Under each mapped dimension, click Select, and then select the artifact or arti‐
facts to use.
These dimensions are automatically mapped:
• Model in Strategic Modeling and Entity in Planning.
You can select multiple models (from a list of all the models in the application)
as a target. For example, you might have multiple entities in Planning that map
to multiple models in Strategic Modeling. Multiple selections must have a one
to one mapping between model and entity.
• Scenario (or Business Case if the source is a consolidation) in Strategic
Modeling to Scenario in Planning. Multiple selections must have a one to one
mapping between Scenario in Strategic Modeling and Scenario in Planning.
• Account in Strategic Modeling to Account in Planning. You can select multi‐
ple accounts.
Tip:
Account members with the same name are automatically mapped
(based on the Description in Strategic Modeling and the Name in
Planning.) Click Map in the Account row to see the mappings.
Tip:
If you know all of the member names, you can skip this step and en‐
ter the member names directly in Advanced Data Maps. See Defin‐
ing Advanced Data Maps.
• Dimensions with the same name.

Other dimensions are in the Unmapped Dimensions list.
7. Map any remaining dimensions from the Unmapped Dimensions list if required.
Click the arrow next to a dimension in the Unmapped Dimension list to move it to
the Mapping area. Select the dimension to map it to, and then click Select to se‐
lect the members to map. For any unmapped dimensions, select a member.
8. Map any custom dimensions.
9-11
Chapter 9
Map custom dimensions in the same way you map base dimensions. Members as‐
sociated with a custom dimension are shown under the custom dimension rather
than under the Account dimension.
If the data map includes accounts that aren't part of the custom dimension, map
the root of the custom dimension in Strategic Modeling to a specific member in
Planning. Data for accounts that aren't part of the custom dimension are pushed to
this member.
9. If required, you can map to or from multiple dimensions to or from a single dimen‐
sion:
a. Click Actions next to a mapping row and then select Add Source Map‐
ping or Add Target Mapping.
b. Select the additional dimension to map, and then select the members to map.
For example, you might want to map the Time dimension in Strategic Model‐
ing to the Years and Period dimensions in Planning.
Or, you might want to map the Business Case in Strategic Modeling to Sce‐
nario and Version in Planning. Including the Version dimension allows run-
time input when you run the consolidation.
10. If the member names don't match in the source and target, or when mapping to or
from multiple dimensions to or from a single dimension, you must define an ad‐
vanced data map. See Defining Advanced Data Maps. You can also use ad‐
vanced data maps to define mappings when you know all the member names.
11. Click Save and Close at any time. If the data map definition is not yet complete,
you will receive an error, but you can save the data map as a draft so you can con‐
tinue to work on it at another time.
12. Associate the data map with a model or consolidation:
• If the source is a model, you can optionally associate the data map with a
model. See Associating a Data Map with a Model.
• If the source is a consolidation, you must associate the data map with a con‐
solidation. See Associating a Data Map with a Consolidation.
You can associate up to three data maps with a model or consolidation.
13. Optionally, specify options that define how to execute the data map. See Defining
Data Map Options.
For information about running data maps, see Running a Data Map.
Watch these tutorial videos to learn more about creating data maps to move data be‐
tween Strategic Modeling and Planning.
Overview Video
Overview Video
9-12
Chapter 9
Defining Advanced Data Maps

When member names don't match in the source and target, or when mapping to or
from multiple dimensions to or from a single dimension, you must define an advanced
data map.
1. Click Map in a mapping row to define the advanced mapping.
For example, you might want to map multiple accounts from Planning into a single
account in Strategic Modeling.
The Edit Data Map page lets you define mapping on each tab. Tabs include Ba‐
sic Info, Source Selection, Target Selection, a tab for each mapped dimension,
and if they exist, Unmapped Source and Unmapped Target dimensions.
The Source Selection and Target Selection tabs contain a superset of the de‐
tails to be mapped on the other tabs.
2. Click a tab to define the mapping details. For each dimension, the Source mem‐
bers are listed.
• For each Source member where the member names between source and tar‐
get are different, add the Target member. (Target members must be level zero
members in the hierarchy).
• Specify an operator if required. The default operator is +.
The operator for a row defines the operation to use for the current row.
For example, to have multiple accounts from the source aggregate and map to
a single account in the target, add a row for each member in the source, each
mapped to the same target member. By default, the + operator for each row
defines the aggregation.
Or, you might want to map multiple periods in a cube (Jan through Dec) to a
single time period in a Model (2018).
• You can Copy Rows or Paste Rows or copy and paste data from
one tab to another.
• Add as many rows as needed to define all the members to map. Click Insert
Row to add a mapping definition between a source and target member.
• If needed, click Delete Invalid Entries to clear any mapping rows where
the source is invalid and clear any invalid target members.
3. When mapping from multiple dimensions to a single dimension, for example from
Years and Period in Planning to Time in Strategic Modeling, the Edit Data Map
page is populated the all the possible source combinations. Select the correspond‐
ing target members for each source combination you need.
If there are some source combinations you don't need to map to, select the row
and then click Delete Row . This source combination will not be automatically
populated again if you return to the Edit Data Map page.
If you later want to see the deleted source combinations, click Populate Detailed
Mappings . The Edit Data Map page is updated to show all possible source
combinations.
4. Click Done.
9-13
Chapter 9
Note the following about mapping members:

• When member names in source and target match and are automatically mapped,
they are not listed on the Mapping Details page.
• You can only select target members that are listed on the Target Selection tab. If
you need a different member, return to the Data Maps page and select it from the
Target member list. (If you didn't enter members on the Data Maps page, you're
not restricted in this way.)
To simplify defining an advanced data map, you can export the data map definition to
Excel, edit the data map template in Excel, and then import it. See Using Microsoft Ex‐
cel to Define Advanced Data Maps.
About Data Maps and Custom Dimensions

Note the following when defining data maps when some of the Strategic Modeling ac‐
counts in the data map are associated with custom dimensions and some are not.
When creating a data map from Planning to Strategic Modeling, the data moves based
on the following rules.
• When the root of the dimension in Strategic Modeling is part of the detailed map‐
ping:
– For accounts where this dimension is applicable, the root dimension mapping
is ignored. (Data can’t be written to the root for valid accounts.)
– For accounts where this dimension is not applicable, only the root dimension
mapping is considered. (Data can’t be written to the nonexistent leaf mem‐
bers.)
– For dimensions that have no members in Strategic Modeling, the data is al‐
ways written to the root. (The root member is the only available member.)
• When the root of the dimension in Strategic Modeling is not part of the detailed
mapping:
– For accounts where this dimension is applicable, data movement occurs as
defined in the data map definition. (Data can be written to all the members in
the mappings.)
– For accounts where this dimension is not applicable, each member in the tar‐
get is replaced with the root dimension. The aggregated data for all the mem‐
bers is moved to the root of the Strategic Modeling dimension.
If this is not the behavior you want, make sure you map the appropriate mem‐
ber in Planning to the root dimension in Strategic Modeling.
• When the dimension is part of the Unmapped Dimensions (for the Target):
– For the accounts where this dimension is applicable, the data is pushed to the
member defined in the target.
– For the accounts where this dimension is not applicable, the data is pushed to
the root.
Using Microsoft Excel to Define Advanced Data Maps

To simplify defining an advanced data map, use Microsoft Excel to define the data
map.
9-14
Chapter 9
1. Define the basic dimension mappings in the Data Maps page.

2. From the Actions menu, select Export Data Map.
3. Update the Source and Target tabs if needed, and the detailed mappings in each
tab of the Excel worksheet, and then save it.
4. In the Data Maps page, from the Actions menu, select Import Data Map, and
then save the data map.
Watch these tutorial videos to learn more about importing data maps.
Overview Video
Overview Video
Associating a Data Map with a Model

When the source of a data map is a model, you can associate the data map with the
model and specify that the data map should run when you check in the model.
You can associate up to three data maps with a model, or change the data map prop‐
erties associated with a model. You can also delete a data map's association with a
model.
1. From the Home page, click Strategic Modeling and then click Model
View .
2. From the Actions menu next to the model you want to associate, click Properties,
and then click Data Maps.
3. Click Add .
Any data maps that have this model as a source are listed.
4. Click the data map, and then click Associate.
You can associate multiple data maps with a model.
5. To run the data map when the model is checked in, select Run on Check-In.
6. Click Apply.
You can also delete a data map association with a model.
Associating a Data Map with a Consolidation

When the source of a data map is a consolidation, you must associate the data map
with the models in the consolidation and specify that the data map should run when
you run the consolidation. You can associate up to three data maps with a consolida‐
tion.
9-15
Chapter 9
1. From the Home page, click Strategic Modeling and then click Consolida‐
tion View .
2. Open the consolidation you want to associate with a data map.
3. From the Actions menu, select Set Data Maps.
4. In the Data Maps column, click None if no data maps are already associated with
this consolidation. Or click the data map name if a data map is already associated
with the consolidation.
5. Click Add .
Any data maps that have this consolidation as a source are listed.
6. Click the data map, and then click Associate.
7. For a child model in the consolidation, select an option for Use Default Data Map:
• By default, Use Default Data Map is selected for child models. If the child
model is specified in the data map selected for the parent, selecting Use De‐
fault Data Map runs the data map for the child model to push to the target
scenario defined in the data map, using the child's contributing scenario as de‐
fined in the consolidation view.
Use Default Data Map has no effect if the child model is not specified in the
data map for the parent.
• If you clear the selection for Use Default Data Map, you can:
– Have no data map run for the child model.
– Associate a different data map with the child model. Click Add , click
the data map to associate (any data maps that have this child consolida‐
tion as a source are listed), and then click Associate.
8. Make sure Run on Consolidation is selected so the data map runs when you run
the consolidation by selecting Run and Push Data.
9. Click Close.
Running a Data Map

Data maps are run automatically in the following situations:
• If the source is a model and you associated the data map with the model and se‐
lected Run on Check-In, when you make a change to the model and check it in,
the data map runs and Smart Push pushes the data to Planning.
• If the source is a consolidation and you associated the data map with the consoli‐
dation and selected Run on Consolidation, in the Consolidation View, from the
Run menu, click Run and Push Data. The data map runs and Smart Push pushes
the data to Planning.
If you mapped the Business Case in Strategic Modeling to Scenario and Version
in Planning, when you run the consolidation, you have the option to select Over‐
write Target Version, which overwrites the Version defined in the data map.
9-16
Chapter 9
If Version is in the Unmapped section, the selected Overwrite Target Version is

ignored
• If the source is a Planning cube, associate the data map with a form and specify it
to Run on Save. See Configuring Smart Push for a Form. You can associate mul‐
tiple data maps with a single form.
If the source is a model or a Planning cube, you can also run data maps from the Data
Maps page: From the Home page, click Application , then Data Exchange
, and then click Data Maps. From the Actions menu for the data map you
want to run, select Clear and Push Data.
To check the status of the data map and Smart Push job, from the Home page, click
Application , and then click Jobs . Click the job name to see informa‐
tion and status about the Smart Push job. If there is an error, click Error to see details
to help you resolve the error.
Integrating Data Between Strategic Modeling and Financials

You can push data between models in Strategic Modeling and income statements in
Financials using the provided template and data maps.
To complete this task, both Strategic Modeling and Financials must be enabled, in any
order. Income Statement must be enabled in Financials.
1. EnableFinancials with Income Statement enabled, and then create a Financials
application.
See Configuring Financials.
2. Enable Strategic Modeling, and then create a new model.
• On the General page of the Create New Model wizard, select Create Model
From Template, and then select Financial from the Select Template list.
• In Select Entity, select a Financials Entity dimension member. The model will
be mapped to the selected Entity dimension member.
• If the Planning application is multi-currency, select a currency from the Cur‐
rency list. If the Planning application is single currency, this option is not avail‐
able, and it defaults to the application's currency.
• The Calendar, Time Period, and Configure Years pages of the Create New
Model wizard are not available when you create a model from the Financial
template. The Start and End Period dates are set based on the Planning ap‐
plication. Year Configuration is monthly.
When you create the model, two data maps are created. The data maps' detailed
mappings are automatically populated between the dimension members in Strate‐
gic Modeling and in Financials. You can optionally view the detailed data maps:
From the Home page, click Application, then click Data Exchange, and then click
Data Maps.
9-17
Chapter 9
• <Model_Name>_SMtoPLDatamap pushes data from Strategic Modeling to

the Target version in Financials. By default, the data map is associated with
the model you just created and is set to run when you check in the model.
• <Model_Name>_PLtoSMDatamap pushes data from the Working version in
Financials to Strategic Modeling.
For more details about enabling Strategic Modeling, see Enabling Strategic Model‐
ing.
For more details about creating a Strategic Modeling model, see Creating a Strate‐
gic Modeling Model.
3. To push data from Strategic Modeling to Financials:
a. Check out the Strategic Modeling model, enter data, and then calculate the
scenario or all scenarios.
b. Check in the model.
If the data map is set to run on check-in (the default), when you check in the
model, the data map runs and the Smart Push job is submitted.
Tip:
To check the status of the job, from the Home page, click Applica‐
tion and then click Jobs.
In Financials, open the income statement to review the data that was pushed.
From the Home page, click Financials, then click Revenue, and then click In‐
come Statement.
4. To push data from Financials to Strategic Modeling use one of these methods:
• Run the data map from the Data Maps page: From the Home page, click Ap‐
plication , then Data Exchange , and then click Data Maps.
From the Actions menu for <Model_Name>_PLtoSMDatamap, select

Clear and Push Data.
• Associate the <Model_Name>_PLtoSMDatamap data map with a form and
set it up for Smart Push. See Configuring Smart Push for a Form.
If you later enable additional accounts in Financials, edit the data maps to add the de‐
tailed mapping between the accounts in Financials and the accounts in Strategic Mod‐
eling. For more information about editing data maps and detailed mappings, see Defin‐
ing Advanced Data Maps.
Note:
You can make a copy of the data maps before editing them so you can keep
the original data map definition.
9-18
Chapter 9
Managing Metadata with Model Change Management
Note:
Custom dimensions in Strategic Modeling and a custom chart of accounts in
Financials are not supported when pushing data between Strategic Modeling
and Financials.

Use Model Change Management to copy metadata from a source model to one or
more target models.
Organizations work with different models to perform their strategic planning. Some
models might be more granular, and others might focus on a specific territory or re‐
gion. Typically, many of the models have a similar structure. For example, custom di‐
mensions, accounts, scenarios, and time periods might differ only slightly. You can
create a master source model in which you build the master structure of accounts, ac‐
count groups, custom dimensions, time structure, and scenarios. You manage meta‐
data by copying all or part of the metadata from this source model to one or more tar‐
get models. You can also copy incremental changes from the source model to the tar‐
get models.
To use model change management, first create a base model to use as the source.
The source model should include the accounts, account groups, custom dimensions,
time structure, and scenarios that you want to copy to any target models. After a
source model is created, you can use Model Change Management to copy any of the
metadata to one or more target models.
Overview of steps in Model Change Management:
1. Create the Model Change Management definition by selecting one or more target
models.
See Defining Target Models for Model Change Management.
2. Define the metadata to copy:
• Accounts and account attributes
• Account groups
• Custom dimensions
• Time
• Scenarios
See Defining Metadata to Copy with Model Change Management.
3. Run Model Change Management to copy the metadata from the source model to
target model or models.
See Copying Metadata from Source to Target.
4. If needed, you can edit or delete a Model Change Management definition.
See Editing or Deleting a Model Change Management Definition.
Watch this tutorial video to learn more about copying subaccounts and account attrib‐
utes with Model Change Management.
Tutorial Video.
9-19
Chapter 9
Watch this tutorial video to learn more about copying account groups with Model
Change Management.
Tutorial Video.
Watch this tutorial video to learn more about copying scenarios with Model Change
Management.
Tutorial Video.
Watch this tutorial video to learn more about copying time periods with Model Change
Management.
Tutorial Video.
Defining Target Models for Model Change Management

To manage metadata with Model Change Management, first define the target models
to copy metadata to.
1. From the Home page, click Strategic Modeling, and then click Model View.
2. From the Actions menu for the model you want to use as a source, click Model
Change Management, then click Open, and then click Edit.
3. On the Map Target Model tab , click Add Target , select the target
model or models you want to copy metadata to, and then click OK.
The list includes all the models in the application.
Click Exclude to prevent a target model from being included when Model Change
Management runs; metadata is not copied to this model.
4. Define the metadata to copy, and then click Save.
See Defining Metadata to Copy with Model Change Management.
To delete a target model, select it and then click Remove Target .
Defining Metadata to Copy with Model Change Management

To manage metadata with Model Change Management, after defining the target mod‐
els, define the metadata to copy.
1. On the Model Change Management page, click Configure Model to specify

the metadata to copy.
2. Define the subaccounts to copy: On the Accounts tab, click Add and then
click Add Subaccount Change. The list displays all the accounts that have sub‐
accounts. Select the accounts that have the subaccounts that you want to copy to
the target models, and then select from additional options for copying subac‐
counts:
9-20
Chapter 9
• Keep account details in the target—Keeps account hierarchy details in the tar‐
get even if they do not exist in the source.
• Copy account attributes—Copies the attributes of the selected account to the
target.
For all accounts, copies:
– Account Name
– Forecast Method
– Subtotal Method
– Account Note
– Exchange Rate
For Memo accounts, copies:
– Account Name
– Calculation Method
– Aggregation Method
– Output Type
– Output Unit
• Delete accounts not in the source—Deletes any accounts in the target that are
not in the source. Oracle recommends that you select this option. Clearing this
selection can cause errors during consolidation.
All of the subaccounts from the selected accounts are copied to the target.
3. Define the account attributes to copy: On the Accounts tab, click Add and
then click Add Account Attribute Change. Select the accounts that have the at‐
tributes that you want to copy to the target models, select the scenarios to copy for
the selected accounts, and then select from additional options for copying account
attributes:
• Rename Accounts—Renames accounts in the target to match those in the
source.
• Copy Other Account Attributes—When you select this option, these account
attributes are copied from the source to the target:
– For all accounts, copies:
* Forecast Method
* Subtotal Method
* Account Note
* Exchange Rate
– For Memo accounts, copies:
* Calculation Method
* Aggregation Method
* Output Type
* Output Unit
9-21
Chapter 9
Tip:
To edit the selections for accounts, click the link in the Change Details
column on the Accounts tab.
4. Define the account groups to copy: On the Account Groups tab, click Add Ac‐
count Group . Select the account groups you want to copy to the target mod‐
els, and then select from the following options:
• Do not overwrite account group in the target—Does not overwrite the account
group if it already exists in the target.
• Overwrite account group in the target—Overwrites the account group if it al‐
ready exists in the target.
• Delete account group in the target—Deletes any account groups in the target
that are not in the source.
Tip:
Use Search Account Groups to easily find the account groups to copy.
5. Define how to handle custom dimensions when copying to the target: On the Cus‐
tom Dimensions tab, click Copy Custom Dimensions to copy the custom di‐
mensions to the target, and then select from the following options:
• Assign accounts to custom dimensions in the target—Copies the account as‐
signments along with the custom dimension structure to the target. For exam‐
ple, if the Sales account in the source is associated with a custom dimension,
when the custom dimension structure is copied to the target, selecting this op‐
tion assigns the custom dimension to the Sales account in the target.
• Keep subhierarchies in custom dimensions in the target—When a custom di‐
mension is in the target and in the source, allows you to keep child dimension
members that are in the custom dimension in the target that are not in the
source.
• Delete custom dimensions not in the source—Deletes custom dimensions in
the target that are not in the source. Oracle recommends that you select this
option. Clearing this selection can cause errors during consolidation.
Tip:
Click Preview Source Custom Dimensions to review the custom di‐
mensions in the source model before making your selections.
6. Define how to handle time periods when copying to the target: On the Time tab,
click Copy Time Structure to copy the time structure to the target, and then select
one or more of the following options for retaining time structure details in the tar‐
get:
• Allow the target to keep time period details—Allows the target to retain time
detail that is not in the source. For example if the source contains only years
but the target also contains quarters, selecting this option retains the quarters
in the target when you copy the time structure.
9-22
Chapter 9
• Allow the target to keep years earlier than years defined in the source—For
example if the source model's time structure includes 2018 - 2022, and the tar‐
get model includes 2015 - 2020, selecting this option results in the target mod‐
el time structure to include 2015 - 2022.
• Allow the target to keep years later than years defined in the source—For ex‐
ample if the source model's time structure includes 2017 - 2022, and the target
model includes 2018 - 2025, selecting this option results in the target model
time structure to include 2017 - 2025.
If you leave these options cleared, the time structure of the source completely re‐
places the time structure of the target.
Tip:
Click Preview Source Time Periods to review the time periods in the
source model before making your selections.
7. Define how to handle scenarios when copying to the target: On the Scenarios tab,
click Add Scenario Change , select the scenarios to copy to the target, select
from the following options, and then click Add:
• Do not overwrite scenario in the target—Keeps any scenarios already in the
target, even if they are not in the source.
• Overwrite scenario in the target—Overwrites scenarios in the target.
• Delete scenario in the target—Deletes scenarios in the target that aren't in the
source.
If needed, after you've defined the scenarios to copy, you can change the options
on the Scenarios tab: Click Change Details next to the scenario, and select a
new option.
8. Click Save and Close.
Copying Metadata from Source to Target

To manage metadata with Model Change Management, after defining the target mod‐
els and the metadata to copy, copy the metadata from source to target.
2. From the Actions menu for the source model, click Model Change Manage‐
ment, then click Open, and then click Run.
Model Change Management locks the targets briefly to write the new metadata. If
a target is locked by another user, the target is skipped and noted in the log.
3. Check the status of the model change management job: From the Home page,
click Application, and then click Jobs. Click the job name to see information and
status about the job. If there is an error, click Error to see details to help you re‐
solve the error.
You can also check the job status on the Model Change Management page: From
the Actions menu for the source model, click Model Change Management
and then click Status. You see the status for each target model and the overall
status for the source model.
4. Review your changes in the target model or models.
9-23
Chapter 9
Editing or Deleting a Model Change Management Definition

If needed, you can edit or delete a Model Change Management definition.
2. • To edit a model change management definition: From the Actions menu
for the source model, click Model Change Management, then click Open,
and then click Edit.
• To delete a model change management definition: From the Actions menu
for the source model, click Model Change Management and then click De‐
lete.
If the model is locked by another user, you can view the Model Change Management
definition but you can't make changes to it.
9-24
10
Followup Administrative Tasks
• Pushing Data Using Data Maps
• Mapping Data for Reporting
• Entering Assumptions
• Maintaining Your Application
• Updating Planning Modules
• Customizing Predefined Artifacts
Pushing Data Using Data Maps

Perform this task if you enabled and configured integration between Financials, Work‐
force, Projects, and Capital as described in Integration Scenarios and Workflow. As
users prepare plans and forecasts, when they are ready to move data, administrators
must push data using the predefined data maps.
To push data for integration between modules:
1. From the Home page, click Application , then Data Exchange ,

and then Data Maps.
2. Select a data map, and run a rule if required:
Table 10-1 Data Maps for Integration
Integration Scenario Description/Planner Action Administrator Rule/Data

Map to Run
Projects to Financials When a planner rolls up the Not required.
Projects cube (using the rules
OPF_Rollup Projects and
Rollup Project Cube), the da‐
ta is moved to Financials.
Projects to Capital When a planner saves the Not required.
form Project Capitalization,
the data is moved to Capital.
Projects to Workforce When a planner runs the rule Not required.
Calculate Expenses for a
project with driver-based la‐
bor, the data is moved to
Workforce for use in the uti‐
lization calculation.
In Workforce, the planner
must run the Aggregate rule.
10-1
Chapter 10
Mapping Data for Reporting
Table 10-1 (Cont.) Data Maps for Integration
Integration Scenario Description/Planner Action Administrator Rule/Data

Map to Run
Workforce to Financials Data is moved when compen‐ In Data Maps, select Com‐
sation is calculated and the pensation Data, then Push
planner runs the Synchronize Data, and then click Yes to
rule. confirm the option to clear the
data.
Capital to Financials Data is moved when a planner • In the Configure page for
adds an asset and runs Cal‐ Capital, select Map Capi‐
culate Assets. Data is also tal Accounts to Finan‐
moved when a planner trans‐ cials, and then from the
fers assets. Actions menu, select
Synchronize.
• In Data Maps, select Fi‐
nancial Statement Inte‐
gration, then Push Data
and then click Yes to con‐
firm the option to clear the
data.
You can configure the system to push data in batches.
Mapping Data for Reporting

Planning Modules provides reporting data maps to map between the modules and a
reporting application.
You can modify existing data maps if needed, or create new ones for any customiza‐
tions you make to the application. Synchronize or push data as needed. For more in‐
formation about data maps, see Administering Planning Using the Simplified Interface.
Workforce provides data maps for reporting. See Reporting on Data.
Entering Assumptions
Financials, Workforce, Projects, and Capital let planners define assumptions such as
revenue drivers, expense drivers, rates, and so on that drive calculations. As an ad‐
ministrator, you can define these assumptions as a starting point for your planners.
Planners can modify them as needed.
For information about setting up assumptions, see Working with Planning Modules.
Maintaining Your Application

For Financials, Workforce, Projects, and Capital: As your business changes, continue
to update drivers, accounts, users, and so on to keep your application up to date.
You can easily perform these tasks by returning to the Configuration tasks.
On a monthly basis, you must update the current planning period:
10-2
Chapter 10
Updating Planning Modules
1. From the Home page, click Application , then Configure , and

then select a module.
2. From the Configure page, select Planning and Forecast Preparation.
3. Select the current planning month from the Period list and then click Save.
Updating Planning Modules

When you update Planning Modules, any custom modifications that you have made
are maintained. For example, any modifications you've made to unlocked predefined
artifacts (such as forms) are tracked internally. No changes are made to these modi‐
fied artifacts during the update.
• If you are using Workforce, product enhancements in some updates require you to
update certain artifacts, if you've modified them. If you've customized Workforce
artifacts, see Updating Workforce Artifacts to Use New Features for important de‐
tails about how to take advantage of new features.
• If you are using Capital, product enhancements in some updates require you to
update certain artifacts, if you've modified them. If you've customized Capital arti‐
facts, see Updating Capital Artifacts.
• If you are using Strategic Modeling, custom templates and custom reports aren't
impacted during application update. For any templates provided by Oracle,
changes might be applied during content update.
Note:
If you plan to modify the navigation flows, Oracle recommends that you make
a copy of the predefined navigation flows and work in the copy, not the origi‐
nal. When you update, Oracle applies the update to the original navigation
flows and leaves your modified navigation flows unchanged.
Before updating, the application is put in maintenance mode and only administrators
can use the application.
If any metadata changes are detected, the database is refreshed before content up‐
date. If any validation errors are detected, you must resolve the errors before you can
update content.
Use the Job Console to review the errors.
Customizing Predefined Artifacts

For Financials, Workforce, Projects, and Capital: You can add additional custom di‐
mensions the first time you enable and configure using the Map/Rename Dimensions
task.
After you enable and configure, predefined artifacts are added to an application. You
can customize these artifacts:
10-3
Chapter 10
• Accounts—You can add more accounts. For predefined accounts, you can
change the alias and member formula, and enable the members for other plan
types. You can't delete or rename predefined members.
• Forms —You can add new forms and change the layout of predefined forms. You
can't rename or delete the predefined forms.
• Calculations—You can add member formula/rules or change predefined member
formula/rules.
• Dashboards—You can change dashboard layout, and add more dashboards. You
can't rename or delete predefined dashboards.
• Navigation flows—Change navigation flows by renaming or adding new tasks.
For additional information about requirements for preserving modified navigation
flows during content update, see Customizing Navigation Flows.
• Aliases for predefined drivers—You can only modify, not delete or rename.
• Map reporting definitions for integrations—You can only modify, not delete or re‐
name.
• Driver and KPI formulas—You can only modify, not delete or rename.
• Labels—You can change the label for all predefined artifacts.
• Variables—You can add new variables.
When you customize artifacts, you might need to adjust calculations and related con‐
tent to ensure the application’s integrity.
Note:
When you modify artifacts, they are tracked internally. Oracle maintains
these customizations during content updates.
Some artifacts are locked to ensure that internal calculations work properly and you
can’t modify them.
See Administering Planning for details about customizing artifacts.

been modified.
To review the artifacts in your application:
1. Click Application , then Configure , and then select Financials,

Workforce, Projects, or Capital.
2. From the Actions menu, select Review Modified Artifacts.
3. Click Filter to select an artifact type, and then click Apply.

The artifacts that have been modified are listed.
10-4
Chapter 10
Reversing Customizations
To undo customizations to predefined artifacts:
1. From the Home page, click Application , then Configure , and

then select a module.
2. From the Actions menu, select Review Modified Artifacts. Click Filter to
select different artifact types.
3. Select the artifacts, and then click Restore.
Watch this tutorial video to learn more about restoring artifacts to their predefined
state.
Tutorial Video
Customizing Help for Predefined Artifacts

You can customize the help that is provided for predefined artifacts (members, forms,
dashboards) to make it applicable for your business needs. You can also change the
language of the help that's displayed.
To edit descriptions for predefined content or change the language:
1. Click Tools and then click Artifact Labels .
2. Click Filter .
3. From Artifact, select Member or Form.
4. If you selected Member, select Account from the Dimension list.
5. For Property, select Formula Description for member formulas or Description
for form descriptions and click Apply.
6. Select a language from the Add Language list.
7. To customize the help, click Actions, then Export, modify the content as required,
and then click Import to integrate the help in the application.
8. To change the help language, click Add Language and select a language.
You can also add descriptions for other artifacts or instructions to planners. See Ad‐
ministering Planning.
10-5
Chapter 10
Customizing Navigation Flows
Customizing Navigation Flows

Planning Modules is designed with customized navigation flows that implement a plan‐
ning process that's easy for planners to use. You can customize the navigation flows
or add your own as needed for your organization. For more information, see Adminis‐
tering Planning.
Note:
If you plan to modify the navigation flows, Oracle recommends that you make
a copy of the predefined navigation flows and work in the copy, not the origi‐
nal. During content updates, Oracle applies the update to the original naviga‐
tion flows and leaves your modified navigation flows unchanged.
If you incrementally enable additional features, any new forms or other artifacts are
added to the original and the copy of the navigation flows.
10-6
A
Business Scenarios
Related Topics
• IT Financial Management in EPM Cloud
• Configuring Planning Modules for IT Planning
IT Financial Management in EPM Cloud

Oracle Enterprise Performance Management Cloud supports the dual role of a CIO in
today's organizations—both on the spending side to run the business, and on the in‐
vesting side to grow and transform the business. By implementing customized solu‐
tions for Oracle Profitability and Cost Management Cloud and Projects and Financials
in Planning Modules, and integrating data from the General Ledger, IT Financial Man‐
agement planning using EPM Cloud enables IT Finance Departments to be strategic
partners with the business.
Using Oracle Profitability and Cost Management Cloud and the IT Costing and Char‐
geback Template, you can model financial data and analyze IT as a business services
provider. After defining the services your organization provides (using the IT Service
Catalog), the IT assets and resources in your organization (such as hardware, soft‐
ware, and people), and importing data from the General Ledger, you define rules for
service costing and chargeback. This allows you to determine the cost of IT operations
by linking assets to services. Modelling in this way helps you analyze current costs
and plan for future costs. If required for your business, you can allocate service or
overhead costs to projects or departments and determine the chargeback for IT serv‐
ices or resources for each project or department.
You model the flow of data in Oracle Profitability and Cost Management Cloud using
Manage Rules, where you define the rules for modifying and mapping the data. Using
dimensions that include Account, Entity, Projects, Resources, Service, and Consumer,
modeling data allows you to:
• Allocate overheads to projects.
• Take General Ledger data and projects data and push it to resources or services.
• Take resource costs and push them to services (for example, how many servers
does a service use?).
• Optionally, charge back the service costs to a consumer. (The model can either
perform chargeback or showback.)
A-1
Appendix A
Business users can use Rule Balancing to review the rules and their impact on the
data. Click the Smart View links to see the details. The ability to perform step by step
validation of rules with access to details provides transparency and auditability. It gives
you access to the operational data outside of the General Ledger where you can mod‐
el the data using pre-built analytics, without impacting the General Ledger.
After defining the rules, you can review more than ten reports provided with the IT
Costing and Chargeback Template. Reports include:
• Bill of IT Services—Shows chargeback and charge rate and drivers. You can
choose whether to charge back to consuming organizations. If you chose to per‐
form chargebacks, you can push the charges back to the General Ledger.
A-2
Appendix A
• Service Costing—Shows the cost per supported user and project and resource
consumption.
• Project Costing—Lets you analyze the costs for run versus build, and capital ex‐
penditures versus operating expenditures.
After modeling the IT costs and allocating costs in Oracle Profitability and Cost Man‐
agement Cloud, push the data to Planning Modules using Oracle Enterprise Data
Management Cloud and perform further planning and analysis in Financials and
Projects.
In Financials, you can perform high level IT spend planning, by Services and Applica‐
tions.
In Projects, you can perform more detailed project planning to plan by resource, and
understand project costs and benefits before submitting plans for approval. You can
then compare the plan against what is actually spent and review variations and devia‐
tions using IT Costing.
A-3
Appendix A
Customize Projects for IT with custom forms, dashboards, drivers, and navigation flow.
Add a custom dimension for Service, and share the members from the IT Service Cat‐
alog in Oracle Profitability and Cost Management Cloud.
Customize the navigation flow to suit your organization's requirements:
For example, this custom navigation flow in Projects provides a workflow for:
• Entering IT spends for services applications.
• Allocating IT spends to projects.
• Analyzing IT project costs and benefits.
• Performing chargeback planning.
• Reviewing IT Spends overview in a dashboard.
Enter IT spends for services applications in the data entry form:
A-4
Appendix A
Allocate IT spends to projects:
You can also define project benefits.

Design custom dashboards for an overall view of IT spends and variance analysis:
A-5
Appendix A
By importing data from the General Ledger, modeling and allocating costs in Oracle
Profitability and Cost Management Cloud, and then pushing the data to Planning Mod‐
ules using Oracle Enterprise Data Management Cloud, you create an IT Financial
Management system with pre-built analytics that is easy to use, gives you transparen‐
cy of results and auditability, helps you optimize IT investment decisions, and pro‐
motes partnership with the business.
Watch this overview video to learn more about IT Financial Management in EPM
Cloud.
Overview Video
A-6
Appendix A
Configuring Planning Modules for IT Planning

Implementing a comprehensive, robust IT financial management process provides in‐
sight into how your company's IT service portfolio, vendor relations, and resource allo‐
cations influence your company's cost structure as a whole. You can customize
Projects to optimize planning for IT-type projects by modifying pre-defined forms,
dashboards, accounts, and drivers to manage your IT projects.
Additionally, by designing a customized navigation flow, you can create a turn-key sys‐
tem for users to plan and analyze IT projects, measure performance, and monitor
spending. You can create cards in a custom navigation flow to meet these needs:
• Collaborate and plan, allowing you to coordinate between IT, Operations, and Fi‐
nance departments to build project plans
• Evaluate and optimize resources within your budget constraints expecting the
maximum gain
• Manage measurable targets, project justifications, and other financial benefits that
help determine if a project is worth investing in
• Monitor progress and performance once a project is approved
Watch this tutorial video to see an example of configuring Planning Modules for IT
Planning.
Tutorial Video.
Here's an example of a customized navigation flow:
Let's take a look at each card and its custom dashboards and forms.
A-7
Appendix A
IT Spending
The IT Spending tab helps you monitor expenses across new and existing IT projects.
The IT Spending dashboard lets you monitor expenses at a high level, such as IT
spending by category and trend. You can review top down IT spending targets and de‐
sign reliable IT spending forecasts.
Monitor additional detail that relates to expenses and income statement on the Ex‐
pense and Income Statement tabs.
A-8
Appendix A
On the Driver and Trend based tab , expenses are calculated using driver-
based or trend-based assumptions.
For example, the acquisition of server machines requires drivers for the number of IT
Server Machines and the maintenance cost per machine.
Managing driver trends allow you to identify cost reduction opportunities.
You can plan other spending on the Direct Entry tab .
You can review financial performance on the Income Statement tab.
A-9
Appendix A
Analysis
In Analysis, you can monitor progress and performance, and review financial and non-
financial benefits, which allows you to determine if it's worth investing in a specific IT
Project
The Analysis dashboard contains a summary of charts used to monitor the project.
IT Project Summary
In IT Project Summary, you can monitor IT projects and related labor costs.
A-10
Appendix A
This section allows you to manage and plan for resource assignments.
Project Costs and Benefits

Project Costs and Benefits helps you monitor assumptions, direct expenses, total
project expenses, and billing rates and costs.
A-11
Appendix A
This section allows you to identify other costs related to the project, and determine fi‐
nancial and non-financial benefits that help justify investing in IT projects.
A-12
Appendix A
For information about creating custom navigation flows, see Designing Custom Navi‐
gation Flows in Administering Planning.
A-13
B
Importing Data
You can download data import templates from within the application. The templates
are generated based on the features you’ve enabled and the custom dimensions that
were added.
To download the data import templates:
1. From the Home page, click Application and then click Configure
.
2. From the Configure list, select the module for which you want to download tem‐
plates, and then from the Actions menu, select Download Data Load Tem‐
plates.
3. Save the zip file locally, and then extract the csv files.
Perform these tasks to import data:
1. Before importing data, configure the application as described in this help system
and use Configure to import the dimensional metadata.
Note:
Oracle recommends that you use Configure to import metadata, which
ensures that metadata is loaded correctly to work with the provided rules
and forms. If you choose to use the Dimension Editor to load metadata,
the primary hierarchy for a dimension should go under the All member
for the dimension. You can add alternative hierarchies under the Root
member as well, but the member should be a Parent or rollup type mem‐
ber. No parent or member should be set to rollup/aggregate to the root
member of a dimension, because the root member can't be displayed on
any form, dashboard, or report.
2. Specify the appropriate data import settings. See Administering Data Load Set‐
tings.
3. Optional: Make a backup copy of the data import templates to which you can re‐
vert if necessary.
4. Optional: Back up the application.
5. If you created custom Smart Lists, import them before the associated data (availa‐
ble only for some modules.)
To identify the Smart List to import and their entry names:
B-1
Appendix B
About Importing Data
a. Click Navigator , and then Smart Lists from Create and Manage.
b. Select the Smart List, click Edit, and then Entries.
c. Note the associated names.
6. Open the templates in Microsoft Excel, and customize them to specify your busi‐
ness data.
7. Optional: To ensure that your data will import and calculate correctly, import it into
a test application first.
8. Import the data into your production application.
9. For the first data import, run the rules required to process and calculate the data.
When customizing the templates:
• Don’t enter zeros.
• To import data, you must have one member at least from all dimensions in the file
to import.
• Remove columns for which you have no data. For example, if your periodocity is
monthly, you can delete columns for Qtrly 1 - 4.
• If member names start with zeros (0), change numeric columns to text.
About Importing Data

You can download data import templates from within the application. The templates
are generated based on the features you've enabled and the custom dimensions that
were added.
Watch this tutorial video to learn more about importing data.
Tutorial Video
Importing Financials Data

The Financials templates are created based on the dimensionality of your application,
and include any custom dimensions you added when you enabled features.
Depending on the features you've enabled, the following templates are available in the
zip file:
• FinStmt Expense Data Load Template.csv
• FinStmt Expense Weekly Load Template.csv—use this template if you
are planning at the weekly level
• FinStmt Revenue Data Load Template.csv
• FinStmt Revenue Load Weekly Template.csv—use this template if you
are planning at the weekly level
• FinStmt Balance Sheet Load Template.csv
• FinStmt Cash Flow Direct Assumptions.csv
B-2
Appendix B
Importing Financials Data
• FinStmt Cash Flow Indirect Load Template.csv

The templates have a placeholder for every enabled dimension; each dimension is de‐
faulted to the NoMember member. Specify the appropriate dimension members for
each record of data that you're loading. Use NoMember if the dimension is not applica‐
ble for a record of data.
For all templates other than FinStmt Cash Flow Direct Assumptions.csv, im‐
port data using these guidelines:
• Specify accounts in the rows in Column A and time periods vertically.
• Modify account dimension members in Column A to reflect renamed accounts.
• Time periods are in columns D-S (rows B - BA if you are planning expenses at the
weekly level, rows C - BB if you are planning revenue at the weekly level). Delete
columns for periods that you don't use.
• Modify the data in the Point of View column to identify where to import data:
– OFS_Load—Data value to import
– <Custom Dimension>—Any custom dimensions that you added when you en‐
abled features.
– OEP_No Entity—Member in the Entity dimension that identifies the depart‐
ments in the business hierarchy to import data to
– No Year—Year member
– OEP_Actual—Scenario member
– OEP_Working—Version member
– USD—The exchange rate (for a multicurrency application)
• The Data Load Cube Name must be OEP_FS.
• For FinStmt Balance Sheet Load Template.csv, you can use BegBa‐
lance to accommodate the opening amount for balance sheet accounts.
For FinStmt Cash Flow Direct Assumptions.csv, import data using these
guidelines:
• Rows
– Identify Cash Flow Sources and/or Cash Flow Uses accounts in rows under
Column A.
– The first column is for the Account dimension. If the Account is renamed,
make the corresponding update.
• Columns
– Cash Flow Direct Assumption members are in columns B - F.
– Column B sets the cash collection or cash disbursement terms you would like
to set for the particular account.
– Columns C-F set the cash collection or cash disbursements timing for the par‐
ticular account. The values entered must equal 100% for the four columns.
• Point of View—identify where to load BegBalance, No Product, No Services, No
Channel, No Customer, No Segment, OEP_No Entity, No Year, OEP_Plan,
OEP_Working, USD
– BegBalance—Cash flow Direct assumptions are loaded to BegBalance.
B-3
Appendix B
Importing Workforce Data
– No Product, No Services, No Channel, No Customer, No Segment—Indicate

the applicable custom dimensions that you set up when you enabled features.
If you don't use custom dimensions, these members will not be seeded.
– OEP_NoEntity—Member in the Entity dimension that identifies the depart‐
ments in the business hierarchy to which to load data.
– NO Year— Indicate the Year dimension member.
– OEP_Plan—Scenario dimension member.
– OEP_Working—Version dimension member.
– USD—The exchange rate (for a multicurrency application).
• The Data Load Cube Name must be OEP_FS.
• For the first data import, run the rules required to process and calculate the da‐
ta:Financials: Calculate Actuals, and Rollup.

You can download Workforce data import templates from within the application. The
templates are generated based on the features you’ve enabled and the custom dimen‐
sions that you added when you enabled features. See Importing Data.
Note:
If you want to load only changed and new Workforce data since the last load,
you can improve load performance using Data Management. See Loading
and Calculating Incremental Workforce Data.
The templates reflect the CurYr that you set in the Planning and Forecast Prepara‐
tion configuration task. After importing your data and refreshing the cube, run the rule
Process Loaded Data to copy the data to the necessary periods in the planning year
range.
The prefix of each template name depends on the application's granularity:
• EJ_ precedes template names for Employee and Job applications. For example:
EJ_EmployeePropertiesDataLoad_Plan.csv.
• EO_ precedes template names for Employee-only applications. For example:
EO_EmployeePropertiesDataLoad_Plan.csv.
• JO_ precedes template names for Job-only applications. For example: JO_JobO-
therCompensationDataLoad_Plan.csv.
Importing Employee Properties

Use these templates to import properties for existing employees:
• EmployeePropertiesDataLoad_Plan.csv—Import plan properties for em‐
ployees. (You don't need to load Headcount and Partial Payment Factor unless
you want to explicitly set these values. If you don't load Headcount and Partial
Payment values, they're set to 1 and 100% respectively for every employee.)
B-4
Appendix B
Note:
For the EJ_EmployeePropertiesDataLoad_Plan.csv template:
Don't load to "No Union Code" or to "OWP_All Union Code". Instead add
and use new child metadata member of "Total Union Code". Otherwise,
the synchronize rules may not work properly.
• EmployeePropertiesDataLoad_Actuals.csv—Import actual properties for

employees.
Importing Employee Compensation

Use EmployeeSalaryDataLoad_Plan.csv to import data used to calculate salary.
Importing Actual Employee Compensation

Use EmployeeCompensationDataLoad_Actuals.csv to import actual compensa‐
tion data for employees.
To use this template, set these Data Load Settings:
1. From the Home page, click Navigator , and then under Integration, click Da‐
ta Load Settings.
2. Set these parameters for importing data:
• Data Load Dimension: Account
• Driver Dimension: Period. Member: BegBalance,ILvl0Descendants(YearTo‐
tal)
• Data Load Dimension Parent:
– OWP_Total Earnings. Driver Dimension Unique Identifier: BegBalance
– OWP_Total Benefits. Driver Dimension Unique Identifier: BegBalance
– OWP_Total Taxes. Driver Dimension Unique Identifier: BegBalance
Importing Employee Other Compensation Data

Use EmployeeOtherCompensationDataLoad_Plan.csv to import other compen‐
sation data—benefits, taxes, and additional earnings—for employees.
OWP_Value is an optional field. If you include the rate value in the template, that rate
is copied to the planning year range for the specified employee.
Importing Salary Grades

Use Salary Grade-Basis.csv and Salary Grade-Value.csv to import salary
grades into Assumptions.
Importing Properties and Rates for Additional Earnings, Benefits, and Taxes
Use these templates as examples when importing properties and rates for additional
earnings, benefits, and taxes into the Benefits and Taxes wizard.
• Earnings,Benefits and Taxes-Properties.csv—Import properties for
additional earnings, benefits, and taxes.
B-5
Appendix B
• Earnings,Benefits and Taxes-Rates.csv—Import rates for additional

earnings, benefits, and taxes.
Importing Job Properties

Use JobPropertiesDataLoad_Plan.csv to import job properties.
Importing Job Salaries

Use JobSalaryDataLoad_Plan.csv to import salaries for jobs.
Importing Job Other Compensation Data

Use JobOtherCompensationDataLoad_Plan.csv to import other compensation
data for jobs: benefits, taxes, and additional earnings.
Loading and Calculating Incremental Workforce Data

At the beginning of a planning cycle, you might load the entire data for a given scenar‐
io and version. However, to stay up to date with Human Resources changes, you can
import new and updated information frequently. Processing and calculation perform‐
ance is greatly improved when you load updated data into Workforce using Data Man‐
agement.
Data Management functionality enables you to compare a source data file with a previ‐
ous version of the source data file and load only records that are new or have changed
since the last load. The Incremental File Adapter in Data Management identifies the
data that needs loading. Additionally, Workforce provides rules that dynamically gener‐
ate the appropriate calculation script, depending on the changed and new data in the
data load file and calculates only the data for the modified intersections.
After the Data Management load process, the changed and new data displays in the
appropriate Workforce forms. The data reflects calculations applied in the load proc‐
ess.
To learn how to load and calculate incremental Workforce data in Data Management,
watch this tutorial video.
Loading and Calculating Incremental Workforce Data using Data Management.
Note:
Whenever you load data from Data Management, to copy data to future peri‐
ods, you must select one of these Workforce rules: OWP_Incremental Proc‐
ess Data and Synchronize Defaults or OWP_Incremental Process Data
and Synchronize Definition. See Deciding Which Workforce Rules to Add.
Preparing the Source Data File

You first generate a source data file and register it as an Incremental File Adapter in
Data Management. You then set up a data rule that designates the source data file.
B-6
Appendix B
Data loads are run from the file designated in the data rule. The initial source data file
is compared with a subsequent file; the last run file becomes the basis against which
the subsequent load is compared. The Incremental File Adapter loads only the differ‐
ences, which results in faster data loads.
Tip:
You'll experience better performance if you provide a pre-sorted source file.
About a source data file:

• The source data file must be a delimited data file. The data field is the last column
in the file.
• Supported delimiters: Comma, Pipe, Exclamation, Semi-Colon, Colon, Tab, and
Tilde.
• Data files used must contain a one-line header, which lists the dimensions you're
loading. For example: Entity,Employee,Job,Project,Version,Account,Proper-
ty,Data.
• Both numeric and non-numeric data can be loaded.
• Any deleted records between the two files is ignored. You must manually handle
deleted records.
• If the file is missing (or you change the last ID to a non-existent run), the load com‐
pletes with an error.
• Pre-sorting the file decreases the processing time.
• Only single Period data loads are supported for an incremental load. Multi-period
loads are not supported.
• Drill down is not supported for incremental loads because incremental files are loa‐
ded in Replace mode and only the last version of the file comparison is present in
the staging table. As a workaround, you can load the same data file to another lo‐
cation using the full data load method. In this case, you should import data only
and not export it to the target application.
• Copies of the source data file are archived for future comparison. Only the last 5
versions are retained. Files are retained for a maximum of 60 days. If no incre‐
mental load is performed for more than 60 days, then set the Last Process ID to 0
and perform the load.
You can load data using the Incremental File Adapter multiple times.
Configuring the Incremental File Adapter in Data Management
Note:
Options when defining the Data Load Rule in Data Management enable you
to decide if you're loading only incremental data into Workforce or loading all
data every time.
B-7
Appendix B
To set up an incremental data source file:

1. Add an incremental data source:
a. From the Home page, click the Navigator, and then under Integration, click
Data Management.
b. Click the Setup tab, and then under Register, click Target Application.
c. Under Target Application Summary, click Add, and then Data Source.
d. Under Source System, select Incremental File.
e. In Prefix, you can specify a prefix to make the source system name unique.
Use a prefix when the source system name you want to add is based on an
existing source system name. The prefix is joined to the existing name. For ex‐
ample, if you want to name an incremental file source system the same name
as the existing one, you might assign your initials as the prefix.
f. Click OK.
g. From the Select dialog, select the source data load file from the Inbox. If the
file is missing, click Upload to add it to the Inbox (server /u03/inbox/inbox).
You may need to expand the Home folder, and then select Inbox to see the
source file listing. The file must be a delimited file using one of the supported
delimiters, and must contain a header record for each dimension in the first
row. The data field is the last column in the file. See Preparing the Source Da‐
ta File.
h. Click OK and then Save.
The system automatically creates the dimension details.
2. Set up the Import Format, which describes the source file structure and is execu‐
ted when the source file is imported:
a. On the Setup tab, under Integration Setup, click Import Format.
b. Under Import Format Summary, click Add.
c. Under Details, enter a name for the Import Format.
d. In Source, browse to select your source.
e. From File Type, select the delimited file type.
Oracle recommends selecting Delimited - All Data Type, which is common
for loading text as well as numeric data.
f. From the File Delimiter drop-down list, select the delimiter type in the source
data file: Comma, Pipe, Exclamation, Semi-Colon, Colon, Tab, and Tilde.
g. In Target, browse to select your Planning application, and then click Save.
h. Under Mappings, map dimensions between the Source Column and the tar‐
get application, and then click Save.
The Source Column is populated with the dimensions from the header row in
your source data file.
Note:
Only single-period loads are supported.
B-8
Appendix B
For more information on Import Formats, see Working with Import Formats in
Administering Data Management for Oracle Enterprise Performance Manage‐
ment Cloud.
3. Define the Location, which is the level at which a data load is executed in Data
Management. The Location specifies where to load the data and is associated with
the Import Format.
a. On the Setup tab, under Integration Setup, select Location.
b. Under Location, click Add.
c. Under Details, on the Location Details tab, enter a name for the Location.
d. Browse to select your Import Format.
e. Enter the Functional Currency, and then click Save.
For more information, see Defining Locations in Administering Data Management
for Oracle Enterprise Performance Management Cloud.
4. Create member mappings:
a. On the Workflow tab, under Data Load, select Data Load Mapping.
b. At the bottom of the page, verify the POV for the Location.
i. Click the link for Location, which displays the Select Point of View dia‐
log.
ii. Select your Location, Period, and Category (Scenario).
iii. Optional: Select Set as Default to retain this POV.
iv. Click OK.
c. Map the members from the source that you are loading to the target applica‐
tion:
i. At the top of the page, from Dimension, select a dimension in your source
file.
ii. Click one of the five member mapping tabs (for example, the Like tab),
and then click Add.
iii. Enter * in the Source Value column and also in the Target Value column
to represent all values.
iv. Click Save after mapping members for each dimension.
You must create a member mapping for each dimension in the source da‐
ta file.
For more information, see Creating Member Mappings in Administering
Data Management for Oracle Enterprise Performance Management
Cloud.
5. Select the data load rule: On the Workflow tab, under Data Load, select Data
Load Rule.
a. At the bottom of the page, verify the POV for the Location, just like you did in
Step 4b.
b. In the Data Rule Summary area, click Add.
c. Under Details, enter the data load rule name.
d. In Category, select the category to map source system data to target Scenar‐
io members.
B-9
Appendix B
e. In Period Mapping Type, select Default.

f. You don't need to specify an Import Format, because the Import Format from
the Location is used. Specify an Import Format only when you want to override
the Import Format for the Location.
g. From the Target Plan Type drop-down list, select OEP_WFP.
h. On the Source Filters tab, in Source File, browse to select the data file that
contains the data you're loading. It may be the same one from which you cre‐
ated the data source application, or another file that has data as well as the
appropriate header.
It may have the same name as the original file, or it may have a new name.
The differences in the incremental load file is created automatically between
the two loaded files. So if file A.txt has 100 rows and file B.txt has 300 rows
where the first 100 are identical, your first load should select file A.txt when the
Last Process ID is 0. The second load will be against file B.txt, and the ID au‐
tomatically points to the Last Process ID that was assigned to A.
i. In Incremental Processing Option, select whether to sort data in the source
file:
• Do not sort source file—The source file is compared as provided. This
option assumes that the source file is generated in the same sort order
each time. Data Management compares the files, and then extracts the
new and changed records. This option makes the incremental file load
perform faster.
• Sort source file—Data Management sorts the source file before perform‐
ing the file comparison for changes. The sorted file is then compared to
the previous sorted version of this file. Sorting a large file consumes many
system resources. If the source system provides a sorted file, avoid using
this option because it consumes computer resources and slows perform‐
ance.
Note:
If you have a rule that uses the Do not sort source file option
and then switch to a Sort option, then the first load will have in‐
valid results because the files are in different order. Subsequent
runs load data correctly.
• Review the Last Process ID value.

When the load is first run for the original data file, the Last Process ID
shows the value of 0. When the load is run again, the Last Process ID
shows the run number of the last load for the original source data file. If
the newly created file comparison version and the original data file show
no differences, or if the file is not found, the value of the Last Process ID
is assigned to the last load ID that ran successfully.
To reload all data, set the Last Process ID back to 0, and select a new
source file to reset the baseline.
B-10
Appendix B
Note:
Copies of the source data file are archived for only the last 5 ver‐
sions and retained for a maximum of 60 days. After 60 days, set
the Last Process ID to 0 and then perform the load.
j. Click Save.
6. Select the Load Method for the target application and add the Workforce business
rules that execute the logic for the incremental load when the data load rule is run:
a. Click the Setup tab, and under Register, click Target Application.
b. Under Target Application Summary, from the Type column, select Plan‐
ning.
c. Under Application Details, click the Application Options tab.
d. For Load Method, select All data types with security, and then click OK.
e. Click the Business Rules tab, and then click Add.
f. Under Business Rule, enter or paste the Workforce business rule name.
For information on Workforce rules, see Deciding Which Workforce Rules to
Add. For more information on adding business rules in Data Management see
Adding Business Rules in Administering Data Management for Oracle Enter‐
prise Performance Management Cloud.
g. Under Scope, select Data Rule.
h. Under Data Load Rule, select the data load rule you created, and then click
Save.
7. Preview the data before exporting it.
a. Click the Workflow tab, and then Data Load Rule.
b. Click Execute.
c. On the Execute Rule dialog, select Import from Source and verify the Start
Period and End Period.
To actually send the incremental data to the target application, you could also
select Export to Target.
d. Click Run.
See Using the Data Load Workbench in Administering Data Management for Ora‐
cle Enterprise Performance Management Cloud.
8. You're now ready to execute the incremental data load. See Executing an Incre‐
mental Workforce Data Load.
B-11
Appendix B
Tip:
After loading data, to quickly update and process data on multiple existing
employees, jobs, or entity defaults in Workforce, you can use the Mass Up‐
date forms. These forms enable you to quickly review and edit employees,
jobs, and entity defaults after data is loaded. Designed for optimal processing
efficiency, each form is associated with a Groovy rule that processes only the
changed data. See Updating Multiple Employees and Jobs Details in Work‐
ing with Planning Modules.
Deciding Which Workforce Rules to Add

You can decrease processing time by associating the optimal Workforce rules with a
Data Management data rule:
• OWP_Incremental Process Data with Synchronize Defaults
• OWP_Incremental Process Data with Synchronize Definition
You add the rules when defining the integration file (see Configuring the Incremental
File Adapter in Data Management).
Table B-1 Deciding Which Workforce Rule to Add to the Integration File
Your Objective Add This Workforce Rule

• Apply entity defaults for additional earn‐ OWP_Incremental Process Data with Syn‐
ings, benefits and taxes and calculate chronize Defaults
compensation based on the component
definition and rates that are set in the
Benefits and Taxes wizard.
• Copy changed data (employee/job proper‐
ties or any change in salary) to future peri‐
ods in the Year Range.
• Load compensation assignments for addi‐ OWP_Incremental Process Data with Syn‐
tional earnings, benefits, and taxes and chronize Definition
calculate compensation based on the
rates in the data load file.
• Copy changed data (employee/job proper‐
ties or any change in salary or compensa‐ Note:
tion assignments) to future periods in the
If you want to ap‐
Year Range.
ply the rates
from the Benefits
and Taxes wiz‐
ard, then load
only component
assignments.
Don't provide
rates in the data
load file.
For more information, see Adding Business Rules in Administering Data Management
for Oracle Enterprise Performance Management Cloud.
B-12
Appendix B
Importing Projects Data
Executing an Incremental Workforce Data Load

After you've prepared the source data file and configured the Incremental File Adapter
in Data Management, you're ready to import incremental Workforce data.
See:
• Loading and Calculating Incremental Workforce Data
• Preparing the Source Data File
• Configuring the Incremental File Adapter in Data Management
To execute the data load:
1. From the Home page, click the Navigator, and then under Integration, click Data
Management.
2. On the Workflow tab, click Data Load Rule.
3. Select the data load rule you created, and then click Execute.
4. On the Execute Rule dialog, select Import from Source and Export to Target.
5. For the Start and End Period, select the Period (it may already default from the
POV).
6. Click Run.
For more information, see Step 1: Importing Source Data in Administering Data Man‐
agement for Oracle Enterprise Performance Management Cloud.

The Projects templates are based on the dimensionality of your application, and in‐
clude any custom dimensions you added when you enabled features.
For analysis and reporting, you must import this data:
• Project Details—Information about existing projects for forecasting.
• Labor—Two templates are available: with or without integration with Workforce.
– Labor assumptions for projects to be used in forecasting and analysis.
– Labor expense and labor hours actuals for reporting and analysis.
• Equipment—Two templates are available: with or without integration with Capital.
– Equipment assumptions for projects to be used in forecasting and analysis.
– Equipment expense actuals for reporting and analysis.
• Materials
– Material assumptions for projects to be used in forecasting and analysis.
– Material expense and material units actuals for reporting and analysis.
• Other—Additional expense plan, forecast, or actuals for reporting and analysis.
• Direct Expense—Direct expense plan, forecast, or actuals for reporting and analy‐
sis.
• Revenue
B-13
Appendix B
– Assumptions for projects to be used in forecasting and analysis.

– Actuals for analysis and reporting purposes.
• Global Rate Assumptions.
– Standard rates for projects including labor standard rates, material standard
rates, and equipment standard rates.
– Overhead rates.
• Project Benefits.
• Allocate Expenses to Assets—Import allocations to various assets when Capital is
enabled.
Importing Project Details

Use Project Details Load Template.csv or Capital Project Details
Load Template.csv to import project details and related information. For custom
project details, add accounts to the column of the file to import. All details go to the
same intersections.
• Column 1 is the Project dimension.
• The other columns represent account dimension members. The members listed
should align to the member under the OPF_Properties on the Forms member in
the account dimension. Project details are imported to No Year, BegBalance mem‐
bers.
• Project details are imported to the No Project Element and No Resource class
members.
• If the application uses simplified multiple currency, Project Details goes to the No
Currency member.
• OEP_No Entity is from the Entity dimension.
• OEP_Plan is from Scenario dimension.
• OEP_Working is from the Entity dimension.
• No Vendor is from the Vendor dimension, if it was added when you enabled fea‐
tures.
• No Phases is from the Phases dimension, if it was added when you enabled fea‐
tures.
Importing Project Labor Assumptions

Use Labor Assumption Load Template.csv to import labor assumptions if you
don’t use Workforce. Use OEP_PFP Labor Assumption Template -WFP Inte-
gration.csv if you use Workforce. Labor Assumptions import to Beg Balance and
No Year.
• Line 1 represents the Project Element dimension.
• The columns contain the required account members. These members are in
OPF_Labor Assumptions.
– OPF_Vendor—Sets the Vendor Smart List member for the line item.
– OPF_Phase—Sets the Phase Smart List member for the line item.
B-14
Appendix B
– OPF_Job—Sets the Job Smart List member for the line item. The Job list is in
the Resource Element dimension under Detailed Jobs.
– WFP/PFP Job—In an application that has Workforce integration, the Job
comes from the Workforce dimension and not the Resource Element dimen‐
sion. This does not impact the format of the file; the only difference is that the
Account associated with the Smart List is OPF_Job_WF.
– Unspecified Employee—Set the Employee Resource Smart List member for
the line item. The member can be an employee name that is a member from
the Plan Element dimension found under “Existing Employees” hierarchy.
WFP/PFP Employee—In an application that has Workforce integration, the
Employee comes from the Workforce dimension and not from the Plan ele‐
ment dimension. This however does not impact the format of the file. The only
difference is that the Account associated with the Smart List is OPF_Employee
Resource_WF.
• No Project is a member from the Project dimension.
• OPF_Labor is the appropriate member from the Resource Element dimension.
• OEP_No Entity is from the Entity Dimension.
• Labor Expense assumptions are imported to No Year member from the Year di‐
mension and BegBalance from the Period dimension.
• OEP_Plan is from the Scenario dimension.
• OEP_Working is from the Version dimension.
tures.
tures.
• USD is a member from the Currency dimension.
Importing Labor Expense (Without Workforce)

Use Actual Labor Expense Load Template.csv to import Actual Expenses or
Approved Plans for existing projects if you aren’t using Workforce. Planning data for
labor expense at the detailed resource level requires you to import Hours, Rate, and
Labor expense values.
Row
Rows represent the account dimension.
Labor Hours and Labor Expense should be imported for Analysis and comparison pur‐
poses. Importing actual Labor Rate isn't required.
The accounts that actual data is imported to is dependent on the type of project.
• Onsite/Offsite Labor Hours and Labor Expense accounts are specific to Contract
Project Time and Material projects.
• Labor Hours and Labor Expense accounts are used for Contract Projects – Fixed
Price or Cost Plus, Indirect Projects as well as Capital projects.
Column
Months. You can import one month at a time or multiple months simultaneously.
B-15
Appendix B
Point of View
• Use a specific employee member from the Project Element dimension or Unspeci‐
fied Employee for detailed hours and detailed labor expense.
• No Project is from the Project dimension.
• OPF_Detailed Jobs is from the Resource Element dimension; members from the
Detailed Jobs hierarchy specifically.
tures.
• No Phases is from the Phase dimension, if it was added when you enabled fea‐
tures.
• FY16 is from the Year dimension. You can import multiple years simultaneously.
• OEP_Actual is from the Scenario dimension. To import historical Plan or forecast
information, set this field to the corresponding member.
• USD is from the Currency dimension if the application uses simplified multiple cur‐
rency.
Importing Labor Expense (With Workforce)

Use Actual Labor Expense WFP Load Template.csv to import Actual Expen‐
ses or Approved Plans for existing projects if you also use Workforce.
Row
Labor Expense should be imported for analysis and comparison purposes. Importing
actual Labor Rate isn’t required. Detailed Labor Hour analysis per Employee or Job is
in Workforce. Only summary level comes into Projects.
• Onsite/Offsite Labor Hours and Labor Expense accounts are specific to Contract
Project Time and Material projects.
• Labor Hours and Labor Expense accounts should be used for Contract Projects –
Fixed Price or Cost Plus, Indirect Projects as well as Capital projects.
Column
Point of View
• Line 1 is a member from the Project Element dimension. Each Labor Expense
should go to a unique Line Item per project.
• OPF_Base Resource is from the Resource Element dimension.
B-16
Appendix B
• OEP_Actual is from the Scenario dimension. If you want to import historical Plan
or forecast information set this field to the corresponding member.
• USD is from the currency dimension if the application uses simplified multiple cur‐
rency.
tures.
tures.
Importing Equipment Assumptions

Use Equipment Assumption Load Template.csv to import equipment assump‐
tions.
• The columns contain the required account members. These members are in
OPF_Equipment Assumptions.
– OPF_Equipment—Sets the Job Smart List member for the line item. The Job
list found in the Resource Element dimension under Detailed Jobs.
– OPF_Equipment Description is textual.
– OPF_Equipment Units—Number of units.
• OPF_Equipments is the appropriate member from the Resource Element dimen‐
sion.
• Equipment Expense assumptions are imported to the No Year member from the
Year dimension and BegBalance from the Period dimension.
tures.
tures.
Importing Equipment Actual Expenses

Use Actual Equipment Expense Load Template.csv or Actual Equipment
Expense CPX Load Template.csv to import actual equipment expenses. Use
Actual Equipment Expense CPX Load Template.csv when you are integrat‐
ing Projects with Capital.
Row
B-17
Appendix B

Equipment Expense should be imported for Analysis and comparison purposes. The
accounts that actual data is imported to is dependent on the type of project.
• Equipment Expense accounts are should be used for Contract Projects—Fixed
Price or Cost Plus, Indirect Projects as well as Capital projects.
• Equipment Expense—Billable should be used for Contract Time Material Projects
only.
Column
Point of View
• Line 1 is a member from the Project Element dimension. Each Equipment Ex‐
pense should go to a unique Line Item per project.
• OPF_Detailed Equipment is from the Resource Class dimension. Used for Ac-
tual Equipment Expense Load Template.csv only.
• OPF_Base Resource is from the Resource Element dimension. Used for Actual
Equipment Expense CPX Load Template.csv only.
tures.
tures.
• OEP_Actual is from the Scenario dimension. To import historical Plan or forecast
information, set this field to the corresponding member.
rency.
Importing Materials Assumptions

Use Material Assumption Load Template.csv to import materials assump‐
tions.
• The columns contain the required account dimension members. These members
are in OPF_Material Assumptions.
– OPF_Material—Sets the Material Smart List member for the line item. The Ma‐
terial Smart List found in the Resource Class dimension under Detailed Materi‐
als.
– OPF_Expense Cash Flow Incidence—Set the value for cash flow calculation.
B-18
Appendix B
– OPF_Billable—Applicable to Time Material Projects only – indicates if expense

should be set to billable.
– OPF_Units—Units assumptions need to be imported by Month. You can either
create a separate line for each month or you can use a template similar to Ma‐
terials actual to import the monthly values more easily.
Point of View
• OPF_Materials is the appropriate member from the Resource Class dimension.
• Material assumptions are imported to the No Year member from the Year dimen‐
sion and BegBalance from the Period dimension.
• OEP_Plan is from the Scenario dimension. Or you can use the Forecast member.
tures.
tures.
Importing Materials Expenses

Use Actual Material Expense Load Template.csv to import materials ex‐
penses.
Row
In the rows is the Material Expense related Account dimension.
Material Units and Material Expense should be imported for Analysis and comparison
purposes. Importing actual Material Cost/Unit isn't required.
Material Expense—Billable should be used for Contract Project Time and Material type
only, all other project types should use Material Expense account.
Therefore for each material used on a project, you will have two lines for actual data to
be imported.
Column
Point of View
• OPF_Detailed Material is from the Resource Class dimension—Members from the
Detailed Materials hierarchy specifically.
• Line 1 represents the Project Element dimension. Each different Material used on
a project should go to a different Line member.
B-19
Appendix B
• OEP_Actual is from the Scenario dimension. If you want to import Plan or forecast
information set this field to the corresponding member.
rency.
tures.
tures.
Importing Other Expense Actuals

Use Actual Other Expense Load Template.csv to import actuals for other ex‐
penses.
Row
In the rows is the Other Expense related Account dimension.
The accounts that actual data is imported to is dependent on the type of project. Other
Expenses – Billable should be used for Contract Project Time Material type only, all
other project types should use Other Expenses account.
Column
Point of View
• Line 1 represents the Project Element dimension. If multiple lines of Other ex‐
pense you must use a different Line member.
• OPF_Base Resource is from the Resource Class dimension.
• FY16 is from the Year dimension. You can import multiple years simultaneously .
• No Vendor is for dimensions of Vendor dimension, if it is added during enable
time.
• No Phases is for dimensions of Phase dimension, if it is added during enable time.
• OEP_Actual is from the Scenario dimension. If you want to import Plan or forecast
information set this field to the corresponding member.
rency.
Importing Other Expense Assumptions

Use Other Assumption Load Template.csv to import other expense assump‐
tions.
Row
B-20
Appendix B
Line 1 represents the Project Element dimension – use one line for each of the as‐
sumptions to be imported.
Column
Account members required to import assumptions. These members are in OPF_Other
Assumptions.
• OPF_Resource Name
• OPF_Vendor—Sets the Vendor Smart List member for the line item.
• OPF_Phase—Sets the Phase Smart List member for the line item.
• OPF_Expense Cash Flow Incidence—Set the value for cash flow calculation.
• OPF_Billable—Applicable to Time Material Projects only – indicates if expense
should be set to billable.
• OPF_Other Expenses—Expense amount assumption need to be imported by
Month. You can either create a separate line for each month or you can use a tem‐
plate similar to Other Expense actual to import the monthly values more easily.
Point of View
• OPF_Other is from the Resource Class dimension.
• No Year is for appropriate member for the Smart List and Billable indicator, where‐
as FY16 is from the Year dimension for the Expense amount. You can import mul‐
tiple years simultaneously.
• OEP_Plan is from the Scenario dimension. If you want to import forecast informa‐
tion set this field to the corresponding member.
rency.
• BegBalance is applicable for the Smart List assignments where the actual month
is to be imported.
• Vendor 1 is for dimensions of the Vendor dimension, if it is added during enable
time.
• Phase 1 is for dimensions of the Phase dimension, if it is added during enable
time.
Importing Direct Expense Actuals and Direct Revenue Actuals

Use Actual Direct Expense Load Template.csv or Actual Direct Reve-
nue Load Template.csv to import actuals for direct expenses or direct revenue.
Row
In the rows is the Direct Expense/Direct Revenue related Account dimension.
The accounts to be imported using this file format can be found under OPF_Other Di‐
rect Costs in the account dimension. The accounts that actual data is imported to is
dependent on the type of project. Any expense accounts that have “ Billable” in the
name should be used for Contract Project Time Material type only.
B-21
Appendix B
Column
Point of View
• Line 1 represents the Project Element dimension. If there are multiple lines, you
must use a different Line member.
• Project 1 represents a member from the Project dimension.
• OPF_Direct Resource is from the Resource Class dimension.
• Entity 1 is from the Entity Dimension.
rency.
• No Vendor is for the Vendor dimension, if it was added during enablement.
• No Phases is the Phase dimension, if it was added during enablement.
• <Custom Dimension>—Any custom dimensions that you added when you enabled
features.
Importing Direct Expense Assumptions and Direct Revenue Assumptions

Use Direct Expense Assumption Load Template.csv to import direct ex‐
pense assumptions and Direct Revenue Assumption Load Template.csv to
import direct revenue assumptions.
Row
Line 1 represents the Project Element dimension. Use one line for each assumption to
import.
Column
The columns contain the account members you need to import assumptions. These
members are in OPF_Direct Input Expense Assumptions:
• OPF_Expense Type or OPF_Revenue Type—Smart List for the account associ‐
ated with the assumption
• OPF_Vendor—Vendor Smart List member for the line item.
• OPF_Phase—Phase Smart List member for the line item.
• OPF_Direct Expense Amount or OPF_Revenue Amount—Amount to import on a
monthly basis. You can create a line for each month, or use a template similar to
OEP_PFP Actual Other Expense.csv to import monthly values.
Point of View
• OPF_Direct Entry is from the Resource Class dimension.
B-22
Appendix B
• No Year is for appropriate member for the Smart List and Billable indicator, where‐
as FY16 is from the Year dimension for the Expense or Revenue amount. You can
import multiple years simultaneously.
tures.
tures.
rency.
• BegBalance is applicable for the Smart List assignments where the actual month
is to be imported.
Importing Revenue Actuals for Contract Time and Material Projects

Use Actual Revenue Time and Material Load Template.csv or Actual
Revenue Time and Material No Emp Load Template.csv to import actuals
for time and materials projects.
Project Revenue is based on the labor hours, equipment units, material units, and their
associated billing rates. See Importing Standard Billing Rates (Contract Projects Only).
Row
Field 1 represents the Resource Class Dimension.
Detailed Resources should be placed on the rows, the resources themselves can be
found in the Resource Class dimension under Detailed Resources.
• Detailed Jobs
• Detailed Materials
• Detailed Equipment
• OPF_Base Resource is used for all other Revenue for TM Projects
Column
Periods. You can import one month at a time or multiple periods simultaneously.
Point of View
• Unspecified Employee is from the Plan Element dimension. You can import to
named employee if employees have been imported.
• OPF_Contract Revenue—Labor, OPF_Contract Revenue – Material, OPF_Con‐
tract Revenue – Equipment are all from the account dimension. Align the Re‐
source class member to the account member.
– OPF_Contract Revenue—Labor is applicable for Detailed Jobs.
– OPF_Contract Revenue—Material is applicable for Detailed Material.
– OPF_Contract Revenue—Equipment is applicable for Detailed Equipment.
B-23
Appendix B
– OPF_Contract Revenue—Others is applicable for Base Resource.

tures.
tures.
rency.
Importing Revenue Assumptions for Cost Plus Projects

Use Cost Plus Assumptions Load Template.csv to import assumptions to in‐
dicate what is the driver or drivers of Cost Plus Project.
Row
Line 1 is from the Project Element dimension. Each layer of Cost Plus contract should
be entered on a line. If Cost Plus Margin % is simply on total you will only have one
line.
Column
OPF_Cost Plus Driver sets the Smart List for the contract terms.
OPF_Cost Plus Margin % is the overall Margin % for the contract. If the Margin % var‐
ies by year or by month, the data should be imported in a similar manner to Cost Plus
Revenue Actuals.
Point of View
• OPF_Cost Plus is from Resource Element dimension.
• Cost Plus Contract terms are entered to BegBalance No Year.
rency.
tures.
tures.
Importing Revenue Actuals for Cost Plus Projects

Use Actual Revenue Cost Plus Load Template.csv to import revenue ac‐
tuals.
B-24
Appendix B
Row
OPF_Contract Revenue – Cost Plus is the Account to import revenue to for a Cost
Plus Project
Column
Periods. You can import one month at a time or multiple periods simultaneously.
Point of View
• Line 1 represents the Project Element dimension. If there are multiple lines, you
must use a different Line member.
• OPF_Base Resource is from the Resource Element dimension.
rency.
tures.
tures.
Importing Global Assumptions for Overhead

Use Overhead Assumptions Load Template.csv to import global assumptions.
Global assumptions can either be manually entered via forms or can be imported into
Projects.
Row
Field 1 represents the Account dimension.
Column
OPF_Overhead Method—Sets the Smart List for the Overhead method for each type
of overhead. The accounts to be imported using this file format can be found under
OPF_Indirect Expense in the account dimension.
Point of View
• No Resource Class Resource is from the Resource Class dimension.
• BegBalance is from the Period dimension.
• OEP_Plan is from the Scenario dimension. If you want to import historical Actuals
B-25
Appendix B

• No Currency is from the currency dimension if the application uses simplified multi‐
ple currency.
tures.
tures.
Importing Overhead Rates

Use Overhead Rates Load Template.csv to import overhead rates.
Row
Line 1 represents the Account dimension. The account members that you import are
loaded to OPF_Indirect Expense.
Column
Years for the overhead rates.
Point of View
• OPF_Overhead Rate—Account to which to import rates.
• No Resource Class Resource is from the Resource Class dimension.
tures.
tures.
ple currency.
Importing Standard Rates

Use Standard Equipment Rates Load Template.csv, Standard Labor
Rates Load Template.csv, and Standard Material Rates Load Tem-
plate.csv to import Standard Rates for expense calculations. Members are loaded
into the Resource Class dimension.
Import a standard rate for all applicable detailed resources members such as Labor,
Equipment, and Materials. Each has their own account into which rates are imported.
Column contains account members
• OPF_Detailed Equipment Standard Cost is used for Detailed Equipment Resour‐
ces.
B-26
Appendix B
• OPF_Detailed Jobs Standard Hourly Cost is used for Detailed Labor Resources.
• OPF_Detailed Materiall Standard Cost is used for the Detailed Material Resour‐
ces.
Point of View
• OPF_Standard Labor is from the Plan element Dimension and should be used for
all Labor Assumptions.
OPF_Standard Equipment and OPF_Standard Material members should align with
the members from the Account dimension.
• OPF_Material Standard Cost, OPF_Equipment Standard Cost, OPF_Labor Stand‐
ard Hourly Cost.
rency.
tures.
If rates vary by vendor, the file should contain multiple rows for the same Re‐
source Class.
tures.
Importing Standard Billing Rates (Contract Projects Only)

Use Standard Equipment Billing Rates Load Template.csv, Standard
Labor Billing Rates Load Template.csv, and Standard Material
Billing Rates Load Template.csv to import Standard Billing Rates in a reve‐
nue-enabled application.
Row
Import Standard Billing Rates to the members in the Resource Class dimension. A
Standard Billing Rate should be imported for all applicable detailed resources mem‐
bers. Detailed Resource planning can be for Labor, Equipment and Materials. Each
has their own account into which rates are imported.
Column
The columns contain these accounts:
• OPF_Detailed Equipment Standard Billing Rate—For Detailed Equipment Resour‐
ces
• OPF_Detailed Material Standard Billing Rate—For Detailed Material Resources
• OPF_Detailed Jobs for Detailed Labor Resources.
Point of View
B-27
Appendix B
• No Project—From the Project dimension

• OPF_Standard Labor—From the Plan Element dimension. Use this for all Labor
Assumptions.
• OPF_Equipment Standard Billing Rate and OPF_Material Standard Billing Rate
members—Align with Account members.
• OPF_Onsite and Offsite Standard Billing Rate—For Detailed Labor Resources
• BegBalance—From the Period dimension.
• OEP_Plan—From the Scenario dimension. To import historical Actuals or forecast,
specify the corresponding member.
• OEP_Working—Fom the Version dimension.
rency.
tures.
tures.
Importing Working Days and Hours

Use Working Days and Hours Load Template.csv to import standard working
days and hours, when Standard Rates from Workforce is not selected. Column
Contains account members.
• OPF_Working Hours per Day
• OPF_Working Days per Month
Point of View
• Working days and hours are imported to the No Project Element and No Resource
class members.
tures.
tures.
ple currency.
Importing Financial Project Benefits Assumptions

Use Financial Benefit Assumption Load Template.csv to import financial
project benefit assumptions.
B-28
Appendix B
Row
OPF_PB Line 1 is from the Project Element dimension. Each Benefit should go to a
different benefit line.
Column
• OPF_Impacted Account sets the Smart List to link the benefit to a natural Account.
• OPF_Financial Benefits is a text field.
• OPF_Financial Benefit Amount is the value of the benefit. This assumption needs
to be entered in the applicable month or months.
Point of View
• OPF_Base Resource is a member from the Project Resource dimension.
• Impacted Account and Financial Benefit textural value are entered to BegBalance
No Year.
tion, set this field to the corresponding member.
rency.
tures.
tures.
Importing Financial Project Benefits Actuals

Use Actual Financial Benefit Load Template.csv to import financial
project benefit actuals.
Row
Field 1 represents the Account dimension that the benefit is applicable to.
Column
Point of View
• OPF_PB Line 1 represents a member from the Project Element dimension.
• OPF_Base Resource is from the Resource Class dimension.
• OEP_Actual is from the Scenario dimension. If you want to import multiple periods
of Plan or forecast information, set this field to the corresponding member.
B-29
Appendix B
rency.
tures.
tures.
Importing Non Financial Project Benefits Assumptions

Use Non Financial Benefit Assumption Load Template.csv to import non
financial project benefit assumptions.
Row
OPF_PB Line 1 is from the Project Element dimension. Each Benefit should go to a
different benefit line.
Column
• OPF_Non Financial Benefits sets the Smart List to your non financial benefit
items. Non Financial Benefit Smart List needs to be populated with the customized
list of perceived benefits.
• OPF_Benefit Description is a text field.
• OPF_ OPF_Quantative Measure is the value of the benefit. This assumption
needs to be entered in the applicable month or months.
Point of View
• OPF_Base Resource is a member from the Project Resource dimension.
• Impacted Account and Financial Benefit textual value are entered to BegBalance
No Year. OPF_Quantative Measure should be entered per month.
tion, set this field to the corresponding member.
tures.
tures.
rency.
Importing Expense Allocations

Use Allocate Expense To Assets Load Template.csv to import expense al‐
locations for capital project assets, if you are integrating Projects with Capital.
Row
Line 1 is from the Project Element dimension. Each row allocates a % of a category of
expense to a CIP Asset in Capital (Construction in Progress Asset).
B-30
Appendix B
Importing Capital Data
Column
• OPF_Project Expenses—Sets the Smart List value for the project expense ac‐
count which needs to be allocated.
• OPF_Capital Expenses—Sets the Smart List value for the Capital Expense ac‐
count. Expenses allocated to the asset goes to this account in Capital.
• OPF_Capitalization—Specify the % of expense to be allocated to the asset.
• OPF_Asset Class—Sets the Smart List value for the Asset Class account. This
corresponds to the asset class members in Capital which CIP asset is associated
to.
• OPF_Asset Details—Sets the Smart List value for the CIP asset to which alloca‐
tion is being done. The assets correspond to the Asset Detail members in Capital.
Point of View
• No Resource Class is from the Resource Class dimension.
• No Year is from the Years dimension.
rency.
tures.
tures.
Note:
For the first data import, run the rules required to process and calculate the
data: OPF_Rollup Projects and Rollup Project Cube. If you imported ac‐
tuals, run Prepare Detailed Forecast Data and Prepare High Level Fore‐
cast Data.

Depending on the features you've enabled, the following templates are available in the
Capital zip file:
• ExistingIntangibleload.csv
• ExistingLeaseLoad.csv
• ExistingTangibleLoad.csv
• PeriodIntangibles.csv
• PeriodLease.csv
B-31
Appendix B
• PeriodTangibles.csv
The templates are created based on the dimensionality of your application, and in‐
clude any custom dimensions you added when you enabled features.
Import Capital data using the following templates and guidelines.
Importing Asset Detail Properties

Use these templates to import asset detail properties, such as laptop names, price,
and depreciation type:
• ExistingTangibleLoad.csv
• ExistingLeaseLoad.csv
• ExistingIntangibleload.csv
Use these guidelines:
• Columns—Column1 refers to the Asset Class dimension.
• Rows—Each asset detail must have data for three rows.
– Row 1 imports data at NoYear, USD, BegBalance. Modify these values to
specify the correct year, currency, and so on.
– Row 2 imports data to FY16, No currency, Begbalance. Modify these values
as required.
– Row 3 imports data to No year, No currency, Begbalance. Modify these values
as required.
• Point of View
Replace OEP_No Entity in the Point of View with the actual Entity.
Importing Actuals
Use these templates to import actuals for assets:
• PeriodTangibles.csv
• PeriodIntangibles.csv
• PeriodLease.csv
Use these guidelines:
• Columns— refers to Account members.
• Rows
– Rows 5 - 16 (Jan, Dec) refer to one year's calculated actual expense to be im‐
ported for FY16. If data for FY15 has to be imported, then you must add a new
set of rows for FY.
– Row 17: NoYear-> Begbalance-USD combination has computed basic cost.
For each asset detail there needs to be only one row.
– Row 18: Data at NoYear->BegBalance->NoCurrency. Import asset detail infor‐
mation such as purchase date, inservice date, description, and justification.
• Point of View
– Use actual children of OCX_Total Major Assets for OCX_Total Major Assets.
B-32
Appendix B
– Use actual members of OCX_Tangible Assets for OCX_Tangible Assets.

– Use actual members of Entity in place of OEP_No Entity.
B-33
C
Updating Artifacts
Related Topics
• Updating Workforce Artifacts to Use New Features
• Updating Capital Artifacts
Updating Workforce Artifacts to Use New Features

Overview
Enhancements available in certain releases, described here, require updates to some
provided artifacts.
• If you haven't modified these artifacts (described below), the artifacts and features
are available to you automatically with the release.
• Because customized artifacts aren't updated during a new release, if you've cus‐
tomized these artifacts and want to take advantage of the new features, perform
these steps:
1. Perform a full backup after the update and download it locally.
2. Review the list of modified artifacts and consider whether the enhancements in the
monthly update address the modifications you've made to artifacts. Evaluate
whether you want to restore the modified artifacts to take advantage of the new
features, and whether you will need to re-apply some or all of your modifications.
Tip:
For any artifacts listed below that you have modified, consider creating a
copy of your modified artifact and using that as a reference for the
changes you made to it.
Note:
Obsolete artifacts remain available for your use but will no longer be en‐
hanced and could be removed from active forms, menus, dashboards,
and so on.
3. After the update, reverse the customizations to the artifacts you've identified to re‐
store the artifacts to the provided format. See Reversing Customizations.
4. Re-implement your customizations to the artifacts, if necessary.
5. For any restored Calculation Manager rules or templates, after they are final, be
sure to deploy the updated rules or templates to the application for any impacted
artifacts. See Showing the Usages of a Custom Template and Deploying Business
Rules and Business Rulesets.
C-1
Appendix C
June 2019 Update

The following information describes modified artifacts resulting from a fixed defect in
the 19.06 update.
Artifact Type Modified Artifacts New Artifacts Obsolete Artifacts

Templates OWP_Assign Com‐ NA NA
pensation Defaults
Groovy Templates • OWP_Add Requi‐ NA NA
sition_GT
• OWP_Change
Requisition_GT
• OWP_Change
Existing De‐
tails_GT
May 2019 Update

The following information describes new and modified artifacts related to the enhance‐
ments in the May 2019 update.
C-2
Appendix C
Table C-1 May 2019 Update - Workforce Enhancements

Calculation Manager • Synchronize De‐ Copy Compensation • Change Employ‐
Rules faults Details from BegBa‐ ee Status
• Synchronize Defi‐ lance to Periods • Add Job
nition
• Process Loaded
Data
N
• Change Job
• Transfer In o
• Transfer Out
• Transfer t
• Associate Em‐ e
ployee
• Calculate Existing :
Employee Com‐
pensation U
• Calculate New p
Hire Compensa‐ d
tion a
t
i
n
g
c
u
s
t
o
m
e
r
s
:
R
u
n
t
h
e
r
u
l
e
1
X
C
o
p
y
C
o
m
p
e
C-3
Appendix C
Table C-1 (Cont.) May 2019 Update - Workforce Enhancements
n
s
a
t
i
o
n
D
e
t
a
i
l
s
f
r
o
m
B
e
g
B
a
l
a
n
c
e
t
o
P
e
r
i
o
d
s
o
n
e
t
i
m
e
i
m
m
e
d
i
a
t
e
C-4
Appendix C
l
y
a
f
t
e
r
u
p
d
a
t
i
n
g
t
h
e
M
a
y
2
0
1
9
c
o
n
t
e
n
t
t
o
c
o
p
y
c
o
m
p
e
n
s
a
t
i
o
n
d
e
t
C-5
Appendix C
a
i
l
s
f
r
o
m
B
e
g
B
a
l
a
n
c
e
t
o
a
l
l
p
e
r
i
o
d
s
.
Calculation Manager • Synchronize De‐ • Enable Job_T • Change Requisi‐

Templates faults • Change Existing tion_T
• Synchronize Defi‐ Details_T • Add Job_T
nition • Change Employ‐
• Process Loaded ee Status_T
Data_T • Assign Compen‐
• Change Job sation Defaults
• Assign Compen‐
sation_T
• Assign Target De‐
faults
• Calculate Em‐
ployee Compen‐
sation_Te
• Transfer Out_T
• Associate Em‐
ployee
C-6
Appendix C

Groovy Rules • Incremental Syn‐ NA NA
chronize Defaults
• Incremental Syn‐
chronize Defini‐
tion
• Incremental Proc‐
ess Data and
Synchronize Defi‐
nition
ess Data and
Synchronize De‐
faults
Groovy Templates • Add Requisi‐ • Enable Job_GT NA
tion_GT • Change Sal‐
• Change Requisi‐ ary_GT
tion_GT • Change Existing
• Incremental Syn‐ Details_GT
chronize De‐
faults_GT
• Incremental Syn‐
chronize Defini‐
tion_GT
ess Data and
Synchronize Defi‐
nition_GT
ess Data and
Synchronize De‐
faults_GT
Forms • Employee Proper‐ NA NA
ties
• Job Properties
• Identify Invalid
Data
• Process Data and
Synchronize Defi‐
nition
Menus Existing Actions • Employee Actions NA
• Job Actions
Member Formulas OWP_Basic Salary NA NA
Smart Lists NA Employee Options NA
February 2019 Update

The following information describes new and modified artifacts related to the incre‐
mental data load functionality in the February 2019 update.
C-7
Appendix C
Table C-2 February 2019 Update - Enhancements Related to Incremental Data

Load

Calculation Manager NA NA NA
Rules
Calculation Manager • OWP_Process NA NA
Templates Loaded Data_T
• OWP_Synchron‐
ize Definition
• OWP_Synchron‐
ize Defaults
• OWP_Fix Paral‐
lel_T
Groovy Rules NA • OWP_Incremen‐ NA
tal Process Data
with Synchronize
Defaults
• OWP_Incremen‐
tal Process Data
with Synchronize
Definition
• OWP_Incremen‐
tal Synchronize
Defaults
• OWP_Incremen‐
tal Synchronize
Definition
Groovy Templates NA • OWP_Incremen‐ NA
tal Process Data
with Synchronize
Defaults_GT
• OWP_Incremen‐
tal Process Data
with Synchronize
Definition_GT
• OWP_Incremen‐
tal Synchronize
Defaults_GT
• OWP_Incremen‐
tal Synchronize
Definition_GT
Forms NA • Process Data and NA
Synchronize De‐
faults
• Process Data and
Synchronize Defi‐
nition
• Synchronize De‐
faults
• Synchronize Defi‐
nition
Vertical Tab NA Mass Update NA
C-8
Appendix C
Table C-2 (Cont.) February 2019 Update - Enhancements Related to Incremen‐

tal Data Load

Horizontal Tabs NA • Process Data and NA
Synchronize De‐
faults
• Process Updated
Data
• Synchronize De‐
faults
• Synchronize Defi‐
nitions
Data Import Tem‐ • EJ_EmployeePro‐ NA NA
plates pertiesData‐
Load_Plan
• EO_Employee‐
PropertiesData‐
Load_Plan
November 2018 Update

The following information describes new and modified artifacts related to the perform‐
ance enhancements in the Add Hiring Requisition rule in the November 2018 update.
Table C-3 November 2018 Update - Enhancements Related to Add Hiring

Requisition Rule Performance

Calculation Manager Add Requisition_GT NA NA
Rules
Calculation Manager • OWP_Add Requi‐ NA NA
Templates sition_T
• OWP_Assign
Compensation_T
September 2018 Update

The following information describes new and modified artifacts related to the perform‐
ance enhancements in the September 2018 update.
C-9
Appendix C
Table C-4 September 2018 Update - Enhancements Related to Performance Im‐

provements

Calculation Manager • OWP_Process NA NA
Rules Loaded Data
• OWP_Synchron‐
ize Defaults
• OWP_Synchron‐
ize Definition
• OWP_Plan De‐
parture
Calculation Manager • OWP_Process OWP_Fix Parallel_T NA
Templates Loaded Data_T
• OWP_Synchron‐
ize Definition
• OWP_Synchron‐
ize Defaults
• OWP_Add Requi‐
sition_T
• OWP_Assign
Compensation_T
• OWP_Plan De‐
parture_T
Members OWP_Utilization NA NA
July 2018 Update

The following information describes new and modified artifacts in the July 2018 up‐
date.
Table C-5 July 2018 - Enhancements Related to Add Requisition

Calculation Manager NA • OWP_Add Requi‐ • OWP_Add TBH
Rules sition_GT • OWP_ChangeHir‐
• OWP_Change ingRequisitionSta‐
Requisition_GT tus
Calculation Manager NA • OWP_Add Requi‐ • OWP_Add
Templates sition_T TBH_T
• OWP_Assign • OWP_ChangeHir‐
Compensation_T ingRequisitionSta‐
• OWP_Change tus_T
Requisition_T
Smart Lists OWP_Status • OWP_Salary Op‐ NA
tions
• OWP_Requisition
Options
Menus • New Hire Actions NA NA
Menu Item-Add
Hiring Requisition
• Change Requisi‐
tion Status
C-10
Appendix C
July 2018 Update - Enhancements Related to Benefits and Tax Wizard Calcula‐
tions

Calculation Manager • OWP_Synchron‐ • OWP_Copy NA
Rules ize Defaults Rates Across En‐
• OWP_Synchron‐ tities
ize Definition • OWP_Copy
• OWP_ Process Rates to Months
Loaded Data • OWP_Copy
• OWP_Transfer Rates from Perio‐
• OWP_Transfer In dicities
• OWP_Change • OWP_Copy
Job Rates Across
Years
• OWP_Associate
Employee
Calculation Manager • OWP_Synchron‐ • OWP_Copy NA
Templates ize Defaults Rates Across En‐
• OWP_Synchron‐ tities
ize Definition • OWP_Copy
• OWP_ Assign Rates to Months
Compensation • OWP_Copy
Defaults Rates from Perio‐
• OWP_ Assign dicities
Target Defaults • OWP_Copy
Rates Across
Years
• OWP_Check
Rates Availability
at Months_T
Members • All ten base ac‐ In the Property dimen‐ NA
counts under sion:
each parent: • OWP_Custom
OWP_Total Earn‐ Expense
ings, OWP_Total • OWP_One Time
Benefits, and Pay
OWP_Total Tax‐
es
• Provided children
of OWP_Tiers
and OWP_Op‐
tions in the
OEP_WFSC cube
are now set to a
Time Balance
Property of Bal‐
ance. The Time
Balance property
of custom mem‐
bers added under
parent members
OWP_Options
and OWP_tiers
should also be
changed to Bal‐
ance.
C-11
Appendix C
Updating Capital Artifacts

Smart Lists OWP_Payment Fre‐ • OWP_Compo‐ NA
quency nent Type
• OWP_One Time
Pay
Forms • OWP_Rate Table NA NA
• OWP_Rate Table
- Simple
• OWP_Rate Table
- Threshold
Menus NA OWP_Copy Rates NA
Data Load Templates • EJ_Earnings,Ben‐ NA NA
efits and Taxes-
Properties
• EO_Earn‐
ings,Benefits and
Taxes-Properties
• JO_Earn‐
ings,Benefits and
Taxes-Properties
• EJ_Earnings,Ben‐
efits and Taxes -
Rates
• EO_Earn‐
ings,Benefits and
Taxes -Rates
• JO_Earn‐
ings,Benefits and
Taxes -Rates

If you are using Capital, product enhancements in some updates require you to update
certain artifacts, if you've modified them. If you've customized Capital artifacts, review
this section.
Beginning with the April 2019 release, Capital forms and rules have been updated to
allow different planning years for the Plan and Forecast scenarios. Previously, the
Planning and Forecast Preparation configuration task for Capital set the
&OEP_YearRange substitution variable for both Plan and Forecast scenario. Referen‐
ces to this substitution variable are being discontinued.
With the April 2019 update, Capital has updated all business rules to use methods that
read the start year and end year from the Planning and Forecast configuration sepa‐
rately for each scenario. Forms are modified to display data based on the start and
end periods for the scenario. When the update is applied, if you haven't modified these
forms and business rules:
• Predefined forms are updated.
• Predefined business rules are updated.
Because customized artifacts aren't updated during a new release, if you've custom‐
ized forms or business rules, note the following.
C-12
Appendix C
• If you’ve modified rules that rely on the &OEP_YearRange substitution variable,

update the rules to use these functions (either in Business Rules or Groovy rules):
– [[PlanningFunctions.getModuleStartYear("CAPITAL",{Scenario})]]—Re‐
turns start year of given scenario
– [[PlanningFunctions.getModuleENDYear("CAPITAL",{Scenario})]]—Re‐
turns end year of given scenario
• Update custom forms for Capital to use ILvl0Descendants of "All Years" instead
of &OEP_YearRange.
C-13

GUID

Uploaded by

Copyright:

Available Formats

GUID

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

GUID

Uploaded by

Copyright:

Available Formats

Oracle® Cloud

Administering Planning Modules

Primary Author: EPM Information Development Team

Follow us on Social Media

2 Setting Up Your Application

3 Setting up Strategic Modeling

4 Familiarizing Yourself With Planning Modules

9 Configuring Strategic Modeling

10 Followup Administrative Tasks

Access to Oracle Support

• Dimensions, including Accounts

About Strategic Modeling

my on the Home page.

• Access context-sensitive help by clicking Help in Enable and Configure.

Getting Started Checklist

adata, refresh the database. Click Application , then Configure

tion , and then Settings . In System Settings, change Enable Use

Converting a Standard or Reporting Application to an Enter‐

• For Workforce, none of the version members can be Label only.

Integration Scenarios and Workflow

• In Workforce, see the utilization of employees across projects or on a per project

Integration Task Flow

1. Enable and configure Financials.

2. Enable and configure Workforce.

• On the Configuration page, select the task Projects Financials Mapping.

Application , then Data Exchange , and then Data Maps.

Home page, click Application , then Data Exchange , and then

Detailed Integration Scenarios

Financials and Workforce

Financials and Projects

Financials and Capital

Workforce and Projects

Capital and Projects

Setting User Variables

1. From the Home page, click Tools , then User Variables .

Getting Started Checklist for Strategic Modeling

next to the Oracle logo (or your custom logo) .

Reviewing Modified Artifacts

1. Click Application , then Configure , and then select Financials,

3. Click Filter to select an artifact type, and then click Apply.

The artifacts that have been modified are listed.

Getting Descriptions of the Predefined Artifacts

1. Click Tools , and then click Artifact Labels .

Enabling Financials Features

Table 5-1 Enabling Financials Features

About the Financials Chart of Accounts

Enabling Revenue and Gross Margin

To enable a standard chart of accounts or driver-based planning, select Accounts or

Enabling Income Statement

Enabling Balance Sheet

Enabling Cash Flow

Enabling Rolling Forecast

Enabling Weekly Planning

Enabling Map/Rename Dimensions

Associating Custom Dimensions with Financials Features

About the Internal Aggregation Rules

About the Account and Plan Element Dimensions

configuration actions. Use Actions to update task status.

Table 5-2 Configuring Financials