Cloud Readiness / Oracle Enterprise Performance Management Cloud
What's New
Expand All


  1. January 2021 Update
  1. Revision History
  2. Overview
  3. Feature Summary
  4. Enterprise Performance Management Cloud
        1. Monthly Update Schedule
        2. Please Join Oracle Cloud Customer Connect
        3. Give Us Documentation Feedback
        4. Follow Us on Social Media
        5. Defects Fixed and Considerations
    1. EPM Cloud Common
        1. New Video
        2. New Version of Oracle Smart View for Office
        3. Additional Data Formatting Options in Smart View (Mac and Browser)
    2. Account Reconciliation
    3. Enterprise Data Management
        1. New Videos
    4. Financial Consolidation and Close
    5. Narrative Reporting
    6. Planning
        1. New Videos
    7. Profitability and Cost Management
    8. Tax Reporting
  5. IMPORTANT Actions and Considerations

January 2021 Update

Revision History

This document will continue to evolve as existing sections change and new information is added. All updates appear in the following table:

Date Product Feature Notes
04 JAN 2021 IMPORTANT Actions and Considerations   Updated document. Added a Tax Reporting consideration.
22 DEC 2020     Created initial document.

Overview

This document outlines the upcoming Enterprise Performance Management Cloud update.

Feature Summary

Column Definitions:

Report = New or modified, Oracle-delivered, ready to run reports.

UI or Process-Based: Small Scale = These UI or process-based features are typically comprised of minor field, validation, or program changes. Therefore, the potential impact to users is minimal.

UI or Process-Based: Larger Scale* = These UI or process-based features have more complex designs. Therefore, the potential impact to users is higher.

Features Delivered Disabled = Action is needed BEFORE these features can be used by END USERS. These features are delivered disabled and you choose if and when to enable them. For example, a) new or expanded BI subject areas need to first be incorporated into reports, b) Integration is required to utilize new web services, or c) features must be assigned to user roles before they can be accessed.

Ready for Use by End Users
(Feature Delivered Enabled)

Reports plus Small Scale UI or Process-Based new features will have minimal user impact after an update. Therefore, customer acceptance testing should focus on the Larger Scale UI or Process-Based* new features.

Customer Must Take Action before Use by End Users
(Feature Delivered Disabled)

Not disruptive as action is required to make these features ready to use. As you selectively choose to leverage, you set your test and roll out timing.

Feature

Report

UI or
Process-Based:
Small Scale

UI or
Process-Based:
Larger Scale*

Enterprise Performance Management Cloud

EPM Cloud Common

New Video

New Version of Oracle Smart View for Office

Additional Data Formatting Options in Smart View (Mac and Browser)

Enterprise Data Management

New Videos

Planning

New Videos

>>Click for IMPORTANT Actions and Considerations

Enterprise Performance Management Cloud

Monthly Update Schedule

Test Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, January 1, 2021.

Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, January 15, 2021.

NOTE: Backing up the daily maintenance snapshot and restoring the environment as needed are self-service operations. Oracle strongly recommends that you download the maintenance snapshot every day to a local server.

The Oracle Help Center provides access to updated documentation. The updates will be available in the Help Center on Friday, January 1, 2021.

NOTE: Some of the links to new feature documentation included in this readiness document will not work until after the Oracle Help Center update is complete.

Please Join Oracle Cloud Customer Connect

Please take a moment to join the Cloud Customer Connect forums for EPM Cloud services. Oracle Cloud Customer Connect is a community gathering place for members to interact and collaborate on common goals and objectives. This is where you will find the latest release information, upcoming events, or answers to use-case questions. Joining takes just a few minutes. Join now!

https://cloud.oracle.com/community

NOTE: The Settings and Actions menu now contains a link to Cloud Customer Connect. To access this link, from the Home page, click the down arrow next to the user name (in the upper right-hand corner of the screen), and select Cloud Customer Connect.

Give Us Documentation Feedback

We welcome your comments and suggestions to improve the content of the What's New document and the product documentation.

Please send us your feedback at EPMdoc_ww@oracle.com. In the body or title of the email, state that you are inquiring or providing feedback, and indicate for which EPM Cloud service and the monthly update cycle.

Follow Us on Social Media

Follow EPM Cloud on YouTubeTwitterFacebook, and LinkedIn.

These are great resources for the latest updates and information about EPM Cloud.

Defects Fixed and Considerations

Software issues addressed each month and considerations will be posted to My Oracle Support.

This provides visibility into EPM Cloud release contents.

EPM Cloud Common

This section contains announcements related to the common EPM Cloud components such as EPM Automate, Migration, Access Control, Data Integration, Calc Manager, and Smart View for Office.

New Video

Daunted by your source system integration requirements? Want a more streamlined data integration process? With the EPM Integration Agent, you can reduce unnecessary complexity and directly connect to any data source, anywhere. Watch this video, updated to reflect the latest user interface and capabilities, to learn more.

Overview: Leveraging Source System Data With the EPM Integration Agent

Business Benefit: This video provides an overview to help you perform your related business activities.

New Version of Oracle Smart View for Office

Oracle Smart View for Office version 20.200 is planned to be available in December 2020.

NOTE: Account Reconciliation and Enterprise Data Management do not use Oracle Smart View for Office.

Business Benefit: This version includes new features and fixed defects. See the Readme for the list of new features.

Steps to Enable

Download and install Smart View. See Downloading and Installing Clients in Getting Started with Oracle Enterprise Performance Management Cloud.

Additional Data Formatting Options in Smart View (Mac and Browser)

Oracle Smart View for Office (Mac and Browser) provides two new data formatting options for forms and ad hoc grids: Use Thousands Separator and the Number of Decimal Points.

  • Select the Use Thousands Separator to use a comma or other thousands separator in numerical data. Note that # or $ should not be used as the thousands separator in Excel International Options.
  • In Number of Decimal Points, specify a decimal scale for data values. For example, in Smart View, assume the decimal option selected is "1". All values will change one decimal place to the right. If the original value is 50.56, then after refresh the value will be displayed as 50.6. Similarly, if the option selected is "3", then the displayed value will be 50.560. Note that decimal settings in the form definition are lost when you open the form in Smart View. This is because Excel formatting only accepts a single value fixed decimal length value for precision and does not support the minimum, maximum value defined in the web application. This is the default behavior of Excel formatting and this is the behavior in Smart View as well. In Smart View, users must set the Number of Decimal Points option (precision length) to be able to view the decimal value in cell.

These settings are found on the Formatting tab in the Options panel and they settings override the settings in the form definition and in user preferences set either in the web or in Smart View.

Business Benefit: The new Use Thousands Separator and Number of Decimal Points options provide you greater formatting capabilities on your forms and ad hoc grids.

Steps to Enable

To use the formatting options in Smart View (Mac and Browser), Service Administrators must create and deploy a new manifest file.

  1. Create a new manifest file and customize it per your requirements.
  2. Deploy the manifest file to Smart View (Mac and Browser) users.

Key Resources

Account Reconciliation

There are no new features in this update.

Enterprise Data Management

New Videos

The following videos are now available:

Overview: Extracting Data in Enterprise Data Management Cloud

Learn how extracts differ from exports, and where the flexibility of an extract helps you. You learn how to create extracts for a viewpoint, including how to add extract columns for properties and constants, and how to set extract options. Finally, you learn how to run extracts.

Creating Cross-Dimensional Intersections

Learn how to create multi-dimensional intersections to build validation rules across multiple dimensions and to extract the intersections to various downstream system. You begin with creating a multi-segment maintenance viewpoint, including how to configure a multidimensional node type and its derived properties to store segments of the intersection. Finally, you export the intersections using an extract.

Business Benefit: Videos provide overviews and step-by-step instructions to help you perform your related business activities.

Financial Consolidation and Close

There are no new features in this update.

Narrative Reporting

There are no new features in this update.

Planning

New Videos

Several new videos are available for Planning.

Overview: Planning With a Rolling Forecast

Updated to reflect the latest user interface and forecasting granularity and calendar options, this video orients you with how to use a rolling forecast in Planning to stay agile in today's volatile and ever-changing market.

Creating Models from Strategic Model Templates

Learn how to create models from Strategic Modeling templates in Smart View. Templates include financial model frameworks with predefined reporting and modeling standards. After you select a template, you define the total years, historical periods, granularity, and fiscal year information. You also determine which historical periods can be shared between scenarios.

Migrating from On Premise Hyperion Strategic Finance to Cloud EPM Strategic Modeling

Learn how to migrate from on premise Strategic Finance to Strategic Modeling in Cloud EPM in Smart View. You convert offline Strategic Finance models and templates to Strategic Modeling. You then upload offline models to the Cloud, and import Strategic Finance templates to Strategic Modeling.

Business Benefit: These videos provide an overview to help you perform your related business activities.

Profitability and Cost Management

There are no new features in this update.

Tax Reporting

There are no new features in this update. There is one new consideration under Important Actions and Considerations in this document. Be sure to review this consideration regarding using Financial Reports with the new Special Deductions Hierarchy introduced in Release 20.12.

IMPORTANT Actions and Considerations

REDWOOD USER EXPERIENCE

As part of the new Redwood experience, we are introducing the Dynamic Tabs feature only within the Redwood theme in the 21.02 update. Dynamic Tabs will allow you to open tabs on the fly, both from a list view or from an existing navigation flow tab to perform related actions. Some use case examples: view drill through from a form in a new temporary tab; view a form in design mode; open Web ad hoc from a form or dashboard; open forms from right-click menus; open dimensions on the fly to view how members are calculated.

With the new Redwood experience in 21.02, navigation flows within the Redwood theme will move to the bottom of the page instead of the top of the page where they are currently located. With tabs at the bottom of the page, you will benefit from a clear separation of the EPM Cloud horizontal tabs from their browser tabs at the top of the window. Another benefit of this change will be to keep the navigation flow tab names distinct from the names of the artifacts (such as forms and dashboards) rendered within the horizontal tabs. The vertical tabs will stay where they are.

Also within this new Redwood experience, starting in 21.02, action menus in forms will also be cleaned up to not show items that are already included within the right-click menus in forms.

In 21.03, to reflect these new and future Redwood-only experiences, the Redwood theme will be shown as a 'Redwood Experience' toggle switch that application administrators can turn on in the 'Appearance' page. Existing Redwood theme applications will default into the Redwood experience while other theme experiences will stay as is.

NEW WEB AD HOC EXPERIENCE

With the 21.03 release, we will introduce the new Web ad hoc experience for all users across all themes. This replaces the existing Web ad hoc with a new user experience when using ad hoc over the Web. This will provide the benefit of fast snappy grids with several Smart View ad hoc capabilities over the Web, all within a newly defined interface for Web ad hoc. Users can start with a cube slice from scratch or traverse from their Web forms or dashboards into these new ad hoc sheets for a whole new ad hoc experience. Users within the Redwood theme can leverage the benefit of the dynamic tabs to work in tandem with form or dashboards or reports alongside these new ad hoc grids. This solves many multi-tasking use cases within Cloud EPM. Ad hoc on the Web will be available for Planning, Financial Close and Consolidation, and Tax Reporting business processes. Within Smart View ad hoc, with 21.03, we will also support multi-parent zoom in capabilities in ad hoc when used within the 'Standard’ ad hoc mode.

RUNBUSINESSRULE EPM AUTOMATE COMMAND - CHANGE OF BEHAVIOR

Starting with the 21.05 update, the runBusinessRule EPM Automate command will no longer let you run a ruleset against Planning, Planning Modules, Financial Consolidation and Close, and Tax Reporting applications. Instead, you should use the runRuleSet command to launch business rulesets using EPM Automate.

If you currently use scripts that use the runBusinessRule command to launch rulesets, you must modify them to use the runRuleSet command.

SUPPORT FOR COMPOSITE FORMS

Starting in May 2021, Oracle Cloud EPM plans to stop official support for composite forms. Customers are advised to convert existing composite forms to EPM Cloud dashboards and log any issues with Support.

NEW “SUPPRESS MISSING NATIVE” OPTION IN FINANCIAL REPORTING WEB STUDIO GRID EDITOR

The new “Suppress Missing Native” option in the “Suppression” panel in the Financial Reporting Web Studio Grid Editor properties is non-functional for 21.01. The desired output of the selection will not be available when the report is executed even if the option is enabled. This will be addressed in an upcoming release.

STRATEGIC MODELING TERMINOLOGY CHANGE

Starting with the March 2021 (21.03) update, the Consolidation feature in Strategic Modeling will be renamed Scenario Rollup.

CONFIGURING A SOURCE CONNECTION TO ORACLE NETSUITE

The integration between NetSuite and Cloud EPM with Data Management supports both basic authorization as well as token based authorization (TBA). The NetSuite policy for accessing integrations has changed and requires token based authorization, and NetSuite is in the process of phasing out basic authorization for integrations which uses a user name and password. This requirement does not go into effect until early 2021, but customers that use the integration with NetSuite should start switching over to token base authentication as soon as possible. Starting a few months prior to this required change, basic authorization credentials will be made read only, and customers will need to implement TBA. Please contact NetSuite support to get help generating the required tokens to use when setting up the connection to NetSuite from Cloud EPM.

NEW WARNING MESSAGE ADDED FOR PROFITABILITY AND COST MANAGEMENT DEPLOY CUBE

A new warning message has been introduced for the Deploy Cube job starting with the October update.

"Warning: Data Storage = Store Data is not allowed with Hierarchy Type = Enabled. If Data Storage = Store Data is used with Hierarchy Type = Enabled, it automatically changes to Label Only in the deployed cube for dimension: <dimension name>."

Purpose: To inform application designers of a mismatch between dimension properties metadata and the underlying Essbase cube definition.

Impact: None -- calculations will proceed as before. Please note that data retrieval in this case is consistent with Data Storage = Label Only, not Store Data.

Recommendation: To eliminate this warning message, go to Dimension Management and change the Data Storage value to "Label Only" for the dimension referenced in the message.

NEW VALIDATION FOR MEMBER SOLVE ORDER IN PROFITABILITY AND COST MANAGEMENT COMING SOON

A new validation for the Member Solver Order member property will be implemented in an upcoming update. The valid range for this property will be from 1 to 120. If you currently have any member that has a value for Member Solve Order that is greater than 120, when you edit that member in Dimension Management, you will be required to change it to a valid value in order to save your other changes for that member.

AVOID NAMING ALIASES THE SAME AS OTHER DIMENSION MEMBER NAMES IN PROFITABILITY AND COST MANAGEMENT

Avoid naming aliases for dimension members with the same name as member names of other members. This can cause circular logic in Smart View that leads to problems executing queries that reference these members.

"MEMBERALIAS" AND "MEMBERNAME" TEXT FUNCTIONS IN FINANCIAL REPORTING WEB STUDIO

Using the MemberAlias or MemberName text functions in cells that are not part of a row or column will not update when referenced with a Page dimension.

For example: The MemberAlias text function is in the column header, above the row dimensions <<MemberAlias("Grid1", cur, "Entity")>>

NEW EXTENDACCOUNTSCOPE SUBSTITUTION VARIABLE

In the 20.11 update, a new feature was introduced in Financial Consolidation and Close to extend the Account scope of Translation and Consolidation Logic. Previously not all system rules were applied consistently to all accounts outside of the “FCCS_Balance Sheet” hierarchy. This has now been updated to apply the same system rules to all relevant accounts regardless of their position in the Account dimension hierarchy.

The most notable change is the calculation of Opening Balance and Foreign Exchange Variance on Revenue and Expense accounts with the exception of Income Statement accounts and Revenue and Expense accounts within Total Other Comprehensive Income. The opening balance and foreign exchange variance calculations for these accounts has not changed and are still redirected to FCCS_REC_OBFXCTA and FCCS_OR_OBFXCICTA respectively.

Prior to the change, the movement of Revenue and Expense accounts with a time-balance attribute of Flow could be reported from FCCS_Movements, FCCS_ClosingBalance, FCCS_Mvmts_Total or FCCS_Mvmts_Subtotal. With the new behavior, the same movement data for the account can be reported from FCCS_Mvmts_Subtotal, with Opening Balance and Foreign Exchange Variance included in the other subtotals.

Note that this feature may have an impact on your application due to certain customizations/configurations, and you may need to update reports and forms, etc. If you need to revert to the old system behavior that was in place before this feature was implemented, you can create a Substitution Variable named “ExtendAccountScope” and set it to “False”. This will revert to the system behavior from prior to the implementation of the enhancement. If this substitution variable does not exist, or exists but is not set to “False”, then the new behavior will apply.

SMART VIEW ADD-ON INSTALLATION FOR TASK MANAGER AND SUPPLEMENTAL DATA MANAGER

In an upcoming release, the installation of Smart View add-ons for Task Manager and Supplemental Data Manager will change. At that time, users of the Smart View add-ons will need to uninstall and re-install their add-ons to take advantage of the latest features and fixes.

TAX REPORTING TOTAL SPECIAL DEDUCTIONS HIERARCHY FINANCIAL REPORTS CONSIDERATION

If you are planning to use the new Special Deductions hierarchy introduced in Release 20.12, or if you have Financial Reports that reference the old Special Deductions parent / child hierarchy, please review the information in this Cloud Customer Connect post.