July 2022 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
28 JUN 2002	EPM Common	Changes to Planning Admin Extension Installation and Update Process	Updated document. Revised feature information.
28 JUN 2022	IMPORTANT Actions and Considerations		Updated document. Added item to EPM Common section.
23 JUN 2022			Created initial document.

Overview

HAVE AN IDEA?

We’re here and we’re listening. If you have a suggestion on how to make our cloud services even better then go ahead and tell us. There are several ways to submit your ideas, for example, through the Ideas Lab on Oracle Customer Connect. Wherever you see this icon after the feature name it means we delivered one of your ideas.

GIVE US FEEDBACK

We welcome your comments and suggestions to improve the content. Please send us your feedback at oracle_fusion_applications_help_ww_grp@oracle.com.

DISCLAIMER

The information contained in this document may include statements about Oracle’s product development plans. Many factors can materially affect Oracle’s product development plans and the nature and timing of future product releases. Accordingly, this Information is provided to you solely for information only, is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle.

This information may not be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates. Oracle specifically disclaims any liability with respect to this information. Refer to the Legal Notices and Terms of Use for further information.

Feature Summary

Enterprise Performance Management

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, July 1, 2022.

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

NOTE: The monthly update will not be applied to any environment for which this monthly update is requested to be skipped using the EPM Automate skipUpdate command or service request to Oracle.

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, July 1, 2022.

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.

Documentation Updates Available One Week After Readiness Documents

Updated documentation is published on the Oracle Help Center on the first Friday of each month, coinciding with the monthly updates to Test environments. Because there is a one week lag between the publishing of the readiness documents (What's New and New Feature Summary) and Oracle Help Center updates, some links included in the readiness documents will not work until the Oracle Help Center update is complete.

https://docs.oracle.com/en/cloud/saas/epm-cloud/index.html

Fixed Issues and Considerations

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

NOTE: Fixed issues for EPM Cloud Common components (Smart View for Office, EPM Automate, REST API, Migration, Access Control, Data Management/Data Integration, Reports, Financial Reporting, and Calculation Manager) are available in a separate document on the My Oracle Support “Release Highlights” page.

This provides visibility into EPM Cloud release contents.

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.

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.

Follow Us on Social Media

Follow EPM Cloud on YouTube, Twitter, Facebook, and LinkedIn.

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

EPM Common

New Videos

New videos are available:

Overview: Task Manager in Cloud EPM

This overview highlights the features of Task Manager, common terms used, and a typical Task Manager process flow. The Task Manager helps you define, execute, and report on the interdependent activities of a business process. It provides centralized monitoring of all tasks, as well as a visible, automated, and repeatable system of record for running a business process.

Overview: Navigating Tasks in EPM Task Manager

This overview highlights Task Manager features by navigating through the different sections of a task. Task Manager helps you to define, execute, and report the interdependent activities of a business process.

Applies To: Financial Consolidation and Close, Planning, Planning Modules, Tax Reporting

Business Benefit: Videos provide 3-5 minute overviews and step-by step instructions to perform tasks and achieve an outcome.

EPM Cloud Platform Page

The EPM Cloud Platform page has been added to each EPM library. The page highlights EPM platform components and tasks used consistently across all EPM Cloud business processes.

Applies to: Account Reconciliation, Enterprise Data Management, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Narrative Reporting, Planning, Planning Modules, Profitability and Cost Management, Tax Reporting

Business Benefit: Customers can use the page to see the platform components and tasks used consistently across all EPM Cloud business processes.

Key Resources

• Account Reconciliation - https://docs.oracle.com/en/cloud/saas/account-reconcile-cloud/platform.html
• Enterprise Data Management - https://docs.oracle.com/en/cloud/saas/enterprise-data-management-cloud/platform.html
• Enterprise Profitability and Cost Management - https://docs.oracle.com/en/cloud/saas/enterprise-profitability-cost-management-cloud/platform.html
• Financial Consolidation and Close - https://docs.oracle.com/en/cloud/saas/financial-consolidation-cloud/platform.html
• FreeForm - https://docs.oracle.com/en/cloud/saas/freeform/platform.html
• Narrative Reporting - https://docs.oracle.com/en/cloud/saas/enterprise-performance-reporting-cloud/platform.html
• Profitability and Cost Management - https://docs.oracle.com/en/cloud/saas/profit-cost-cloud/platform.html
• Planning - https://docs.oracle.com/en/cloud/saas/planning-budgeting-cloud/platform.html
• Tax Reporting - https://docs.oracle.com/en/cloud/saas/tax-reporting-cloud/platform.html

REST API for Group Assignment Audit Report

You can now use a REST API to generate a group assignment audit report. The report contains details on the users and groups that were added to or removed from Access Control groups in a given date range.

This report is in CSV format. Each row of the report provides the user or group that was added or removed, the group to which the user or group was added or removed from, the Service Administrator who performed the action, and the date and time when the action was completed.

Applies to: Account Reconciliation, Enterprise Data Management, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Narrative Reporting, Planning, Planning Modules, Profitability and Cost Management, Tax Reporting

Business Benefit: This lets you use a REST API to automate this process and satisfy audit requirements.

Key Resources

• Managing Users in REST API for Oracle Enterprise Performance Management Cloud

Role Information

• Service Administrators

REST APIs to View or Update the IP Allowlist - Only for OCI (Gen 2) Environments

In OCI (Gen 2) environments, you can now use a REST API to update or view the IP allowlist.

Use the POST method with the action parameter set to add to add the IP addresses and Classless Inter-Domain Routings (CIDRs) to the allowlist of your environment. Use the POST method with the action parameter set to delete to remove the IP addresses and CIDRs from the allowlist of your environment.

Use the GET method to view IP addresses and CIDRs in the allowlist of your environment.

Applies to: Account Reconciliation, Enterprise Data Management, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Narrative Reporting, Planning, Planning Modules, Profitability and Cost Management, Tax Reporting

Business Benefit: This provides a self-service method to use a REST API to set the IP allowlist without a need to create a service request to Oracle.

Key Resources

• Migration REST APIs in REST API for Oracle Enterprise Performance Management Cloud

Role Information

• Service Administrators

Changes to Planning Admin Extension Installation and Update Process

The installation process and file format for the Planning Admin Extension for Oracle Smart View for Office has changed to take advantage of the Smart View extension installation and update process.

Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Tax Reporting

The Planning Admin Extension allows Service Administrators to quickly import and edit dimension and member metadata directly in Smart View.

NOTE: The Planning Admin Extension is also referred to as the Smart View Add-on for Administrator or Admin Extension.

Previously, to install the Planning Admin Extension, an MSI file was downloaded from the Downloads page of the supported business process, and then installed using an installation wizard. Now the Planning Admin Extension is in SVEXT format, which allows it take part in the extension installation and update process available in Smart View.

To use the new SVEXT file format, you are required to first uninstall the MSI version of the Planning Admin Extension using Windows Programs and Features.

After uninstalling the MSI version, then you can install the new Planning Admin Extension in SVEXT format in either of these ways:

• From the business process Downloads page, download the SVEXT, and then double-click the SVEXT file.

• From the Smart View Options dialog, Extensions tab, click "Check for Updates, New Installs, and Uninstalls," then follow the prompts to download and install the Planning Admin Extension.

Once the SVEXT is installed, you can always click the "Check for Updates, New Installs, and Uninstalls" to check for any updates, following the extension update process outlined in Working with Oracle Smart View for Office. You can also continue to use the Admin Extension download from the Downloads page of your business process. Note, however, that the only way to remove the Admin Extension, or to know whether an updated version of the Admin Extension is available, is by using the extension update process in Smart View.

Business Benefit: Moving the Planning Admin Extension to the SVEXT format allows users to regularly check for and install updated versions of the extension directly in Smart View.

Steps to Enable

To install the SVEXT version of the Planning Admin Extension:

1. Close any open Office applications.
2. From the Windows Control Panel, Programs and Features, uninstall the MSI version of the Planning Admin Extension. Look for the extension listed under "Planning.'
3. To install from the Downloads page:
   1. Using a Microsoft Edge or Google Chrome browser, on your business process Home page, access Settings and Actions by clicking your user name at the top right corner of the screen.
   2. Select Downloads.
   3. Click the Download Admin Extension button and save the SVEXT file to a temporary directory.
   4. Double-click the SVEXT to install it.
   5. Restart Excel and go to the Smart View Options dialog, Extensions tab, to view the Admin Extension in the list.
4. To install from Smart View:
   1. Launch Excel and in the Smart View ribbon, click Options, and then click Extensions.
   2. Click Check for Updates, New Installs, and Uninstalls.
   3. In Select Location for Extension Updates, select the data source connections to check for extension updates, and then click Get Updates.
   4. Review the list of extensions and where you see an Install link, click the link to launch the installer.
   5. Follow the prompts to close and restart Excel, and then go to the Smart View Options dialog, Extensions tab, to view the Admin Extension in the list.

Tips And Considerations

• You must uninstall the MSI version of the Planning Admin Extension before installing the SVEXT version. If you keep the MSI version on your machine, the Smart View extension update process will not recognize updates to the SVEXT version of the Planning Admin Extension.

• You may continue to use the MSI version of the Planning Admin Extension that you previously installed. However, this version of the extension will not be updated in the future so will not contain any future bug fixes or enhancements. For this reason, Oracle recommends moving to the Planning Admin Extension in SVEXT format.

• Enterprise Profitability and Cost Management: The Admin Extension is supported starting with Smart View 22.100.

Key Resources

• Using Smart View to Import and Edit Application Metadata in Administering Planning
• Installing Extensions in Working with Oracle Smart View for Office

New Version of Oracle Smart View for Office

Oracle Smart View for Office version 22.100 will be available soon.

Applies to: Account Reconciliation, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Narrative Reporting, Planning, Planning Modules, Profitability and Cost Management, Tax Reporting

The following new features are included:

• Show or hide the Documents folder in the EPM Cloud Library

• Set and export default Smart View options in the Options dialog box

• New cell styles for Parent and Child members

• Support for a new EPM Cloud business process, Enterprise Profitability and Cost Management

• Enhanced Reports functionality, including:
  • Create an ad hoc grid based on an imported report
  • View properties for a report

• For Narrative Reporting users, Reports functionality no longer requires the Narrative Reporting extension (starting with the 22.06 Narrative Reporting extension update)

• Microsoft WebView2 and Edge support for importing Financial Reporting documents

• Microsoft .NET Framework Version now displayed in the Health Check dialog

Business Benefit: This Smart View release includes new features and fixed defects.

Steps to Enable

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

Key Resources

• Documentation updates will be available when 22.100 is generally available.
  • Working with Oracle Smart View for Office
  • Developing Applications for Oracle Smart View for Office
  • Oracle Smart View for Office Readme

Use of Hardware Security Module (HSM) to Store Transparent Database Encryption (TDE) Master Key in OCI (Gen 2) Environments

To provide an additional level of security, on OCI (Gen 2) environments, EPM Cloud now stores Transparent Database Encryption (TDE) master key in a Hardware Security Module (HSM), a trusted network computer dedicated to performing cryptographic operations for key management, encryption, and so on.

Applies to: Account Reconciliation, Enterprise Data Management, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Narrative Reporting, Planning, Planning Modules, Profitability and Cost Management, Tax Reporting

Business Benefit: The use of HSM to store the master encryption key enhances EPM Cloud security.

Copying Direct URLs for Individual EPM Artifacts in Connected Environments

We now offer support for copying the direct URL for any EPM Cloud artifact that is accessible using Navigation Flows.

Applies to:  Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Tax Reporting

Use the Copy URL option on the artifact listing page to copy the unique URL for the following artifacts in your EPM Cloud business process:

• Dashboards
• Forms
• Infolets
• Reports

To copy the unique URL for an EPM Cloud artifact, open the listing page for the artifact, click the Actions icon next to the artifact, and then select Copy URL.

Copy URL on the Actions Menu

Business Benefit: By adding a Copy URL option for individual artifacts, we've made it easier to integrate with ERP and other Oracle vertical solutions.

Key Resources

• Copying Individual URLs in Administering Financial Consolidation and Close Cloud
• Copying Individual URLs in Administering and Working with FreeForm
• Copying Individual URLs in Administering Planning
• Copying Individual URLs in Administering and Working with Enterprise Profitability and Cost Management

Validating Navigation Flows to Identify and Resolve Missing Artifacts

We now provide the ability to help you more easily find missing artifacts in navigation flows using the Validate feature.

Applies to:  Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Tax Reporting

While viewing the Navigation Flow listing page, you might see navigation flow nodes or artifacts displaying an error icon . This error occurs because artifacts that were associated with the navigation flows were either renamed or were deleted so the artifacts are considered missing. You'll need to edit the navigation flow to associate it with either a renamed artifact or with a different artifact before you can activate the navigation flow. You might not realize that artifacts are considered missing, so it's recommended that you validate your navigation flows before setting them to Active status.

To validate navigation flows, open the Navigation Flow listing page, highlight one or more navigation flows, click Actions, and then click Validate. If artifacts are missing, you'll see an error message indicating which navigation flows are referencing the artifacts that cannot be found.

Business Benefit: By adding a Validate feature for navigation flows, we've made it easier to identify which navigation flow elements contain artifacts that are missing.

Key Resources

• Using Validate to Find Missing Artifacts in Navigation Flows in Administering Financial Consolidation and Close Cloud
• Using Validate to Find Missing Artifacts in Navigation Flows in Administering and Working with FreeForm
• Using Validate to Find Missing Artifacts in Navigation Flows in Administering Planning
• Using Validate to Find Missing Artifacts in Navigation Flows in Administering and Working with Enterprise Profitability and Cost Management

Create Custom Email Notification Policies Within Task Manager

Service Administrators can now define the default email notification settings for all of their Task Manager users.

Applies to: Financial Consolidation and Close, Planning, Planning Modules, Tax Reporting

The Service Administrator can:

• Define the default settings for all Task Manager notifications for all users
• Allow users to customize their personal email notification settings by selecting User Specified option
• Modify the default settings which are inherited by all users who have not set a value for these updated preferences
• Prevent any user customizations to the email notification settings

Business Benefit: This feature provides Service Administrators better control of their users' Task Manager notification settings.

Key Resources

• Enabling Email Notifications in Task Manager in Administering Financial Consolidation and Close
• Setting Up Email for Notifications in Working with Financial Consolidation and Close
• Enabling Email Notifications in Task Manager in Administering Planning
• Setting Up Email for Notifications in Working with Planning
• Enabling Email Notifications in Task Manager in Administering Tax Reporting

Enhanced Late Notifications in Task Manager

The Task Owner now has the option to choose not to receive any email notifications.

Applies To: Financial Consolidation and Close, Planning, Planning Modules, Tax Reporting

Within the Late Notification list, the Task Owner can now set notification as "Never" for the following Notification Types:

• You are the task owner and task assignee is late
• You are the task owner and task approver is late

Business Benefit: This new capability enables the user to opt out of the email notifications.

Key Resources

• Enabling Email Notifications in Task Manager in Administering Financial Consolidation and Close
• Enabling Email Notifications in Task Manager in Administering Tax Reporting
• Setting Up Email for Notifications in Working with Financial Consolidation and Close
• Enabling Email Notifications in Task Manager in Administering Planning

Enhanced Audit History for Rules

Additional information is now added to the audit log when changes are made to a rule’s definition.

Applies to: Account Reconciliation, Financial Consolidation and Close, Planning, Planning Modules, Tax Reporting

The changes are displayed both in the History tab as well as the Audit Report.

Business Benefit: This feature helps in tracking the changes made to Rules.

Key Resources

• Working With Task Rules, Working With Template Rules, Working With Task Type Rules, and Working With Schedule Rules in Administering Financial Consolidation and Close

• Working With Task Rules , Working With Template Rules, Working With Task Type Rules, and Working With Schedule Rules in Administering Tax Reporting

• Working With Task Rules, Working With Template Rules, Working With Task Type Rules, and Working With Schedule Rules in Administering Planning

• Working With Format Rules in Setting Up and Configuring Account Reconciliation

Loading Oracle General Ledger Metadata from the Oracle ERP Cloud

Oracle General Ledger metadata from the Oracle ERP Cloud can now be loaded to your Oracle Enterprise Performance Management Cloud applications using Data Integration. The feature enables you to load the General Ledger hierarchy top node, segment value, description, parent, child, account type, etc.

Applies to: Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Tax Reporting 

To load the metadata, you simply pick the desired source ledger from the Oracle ERP Cloud using a new Oracle ERP Cloud (Chart of Accounts) source adapter, set up a few simple mappings, and then push a button to pull the data into the EPM Cloud applications.

Business Benefit: This feature allows customers to build an integration definition from an Oracle General Ledger  source, and then load the metadata to an Oracle Enterprise Performance Management Cloud environment.

Key Resources

• Loading Oracle General Ledger Metadata from the Oracle ERP Cloud in Administering Data Integration for Oracle Enterprise Performance Management Cloud

EPM Integration Agent No Longer Requires Certificate

Starting in this update, when you install the EPM Integration Agent, you are no longer required to download and install the Oracle Cloud certificates in the cert folder.

Applies to: Account Reconciliation, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Tax Reporting

If you plan to use an older version of the agent (prior to the 22.07 update), then retain any existing certificates in the cert folder. This also applies if you use any custom certificates.

Business Benefit: Oracle Cloud certificates are now included automatically and do not need to be configured manually.

Key Resources

• Installing and Configuring the EPM Integration Agent in Administering Data Integration for Oracle Enterprise Performance Management Cloud

Suppress Reports with No Data in Bursting Output

Previously, if a report with suppression enabled and the POV selection defined in a bursting had #missing data, the report’s results would be included in the bursting definition output. Now, any Reports with suppressed grids are not included in the Bursting output. There is no special setting required, this is the behavior going forward.

NOTE: The report needs to have suppression enabled for the entire grid with no other report objects such as text boxes or images in the body of the report.

Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Narrative Reporting, Planning, Planning Modules, Tax Reporting

Business Benefit: Provides users an easy way to execute the Bursting Definitions.

Key Resources

• Working with Bursting in Designing with Reports for Oracle Enterprise Performance Management Cloud

Account Reconciliation

Create Custom Email Notification Policies

Service Administrators can now define default email notification settings. The Service Administrator can:

• Define the default settings for all notifications and for all users
• Allow users to customize their personal email notification settings by selecting the User Specified option
• Prevent any user customizations to the email notification settings
• Modify the default settings, which will then be inherited by all users who have not set a value for these updated settings

Business Benefit: This feature provides Service Administrators better control on their users’ notification settings.

Key Resources

• Enabling Email Notifications in Setting Up and Configuring Account Reconciliation
• Managing Preferences in Administering Account Reconciliation

Enhancements to Adjustment Time for Transaction Matching

Service Administrators can define the cutoff time for Transaction Matching adjustments by using the new Transaction Matching Adjustment Cutoff Time setting. For adjustments created before the cutoff time on a particular day, the Adjustment Accounting Date is set to the current date. Adjustments created after the set cutoff time will be created with an Accounting Date of the next day. This setting applies to both manually and automatically created adjustments.

The Service Time Zone setting determines the time zone that is considered for the adjustment cutoff time.

Related to this update, the following user interface changes have been made:

• The Due Dates tab in System Settings is now called Date and Time tab.

• The Number of days before due date to send reminder is renamed as Reconciliation Due Reminder. The End of day late time is renamed as Reconciliation Due Time.

• The Open Reconciliations Start Service Start Time is renamed as Reconciliation Open Time and it has been moved from the Services tab to the Date and Time tab.

Business Benefit: This feature provides the flexibility to set a cutoff time, for Transaction Matching adjustments, that is based on the business requirements and the time zone.

Key Resources

• Setting Up Service Time Zone and Due Dates in Setting Up and Configuring Account Reconciliation

Data Management Option Enabled in the Clone Environment Screen

In the 22.06 update. the Data Management option in the Clone Environment screen of the Account Reconciliation business process was disabled because it did not work. This option is now enabled, and you can use this option while cloning an Account Reconciliation environment.

Business Benefit: Using the Data Management option allows you to clone the complete set of setup and staging table data from Data Management.

Enterprise Data Management

There are no new features in this update except for the applicable features listed in the EPM Common section.

Financial Consolidation and Close

Updated Academy Page

The Academy page has been updated with new categories and videos for Enterprise Journals.

Additional videos are now available in the Financial Consolidation and Close Cloud Academy.  To view the updated content, access a service instance and then click or tap Academy.

Enterprise Journal videos on the Academy page include:

• Tour of Enterprise Journals
• Working with Enterprise Journals
• Working with Enterprise Journals in Smart View
• Managing Enterprise Journals

Business Benefit:  The Academy has been updated to reflect recent changes in the software user interface.

Intercompany Matching Report Enhancements

In Intercompany Matching Reports, if you select entities that have a common Parent entity, you can now select the Parent Currency member for the report. You can also specify the same Account and Matching Account, but you can select only one set of the same member in Accounts and Matching Accounts.

Business Benefit: These enhancements allow more flexibility in specifying members for Intercompany Matching Reports.

Key Resources

• Creating Intercompany Matching Reports in Working with Financial Consolidation and Close Cloud

Impact Status Validation Substitution Variable

The DisableImpactStatusConsolValidation substitution variable is now enabled by default. The Impact Status rule semantic validator now ignores validation errors and continues with Consolidation rule execution.

Business Benefit: Setting this substitution variable to True by default prevents the Impact Status validator from detecting errors and failing the consolidation process during script generation.

Key Resources

• FCCSImpact Status Function in Administering Financial Consolidation and Close Cloud

Performance Substitution Variables

The OptimizeConcurrency, OptimizePelimCalculation, EnableYearlyConsol, ParallelCustomDimDSO, and ParallelCustomDimTranslation substitution variables can be enabled to improve performance.

OptimizeConcurrency = True

This substitution variable improves concurrency of the consolidation process by executing some of the calculations at the very beginning or at the end. The degree of improvement depends on the entity structure of a given customer. Customers with deeper entity hierarchies will benefit the most.

OptimizePelimCalculation= True

This substitution variable improves Partner Eliminations (PElim) performance. If there is a consolidation performance degradation when deploying a user-created “Partner Eliminations Configurable Consolidation Rule” that has an account re-direction, adding this variable can provide significant performance improvement.

EnableYearlyConsol = True

The EnableYearlyConsol substitution variable can be enabled to improve performance for multi-period consolidations in applications that use the Dense/Sparse Optimization option (where Period and Movement are the Dense dimensions).

This substitution variable is applicable if the application meets all of these conditions:

• The application uses the Dense/Sparse Optimization option (Period and Movement are Dense dimensions)
• You have two or more dirty periods, and two or more hierarchy levels
• The dirty entities are identical across periods
• Equity Pickup sequence is not enabled

ParallelCustomDimDSO = True

This substitution variable improves the performance of the consolidation process in applications with Dense/Sparse Optimization, where the Period and Movement dimensions are Dense dimensions. To see performance improvements, you should set this substitution variable to True.

ParallelCustomDimTranslation = True

This substitution variable can improve the performance of the consolidation process in applications with Dense/Sparse Optimization, where the Period and Movement dimensions are Dense dimensions. To see performance improvements, you should set this substitution variable to True. If any degradation is noticed, you should delete this variable.

Business Benefit: These substitution variables help in improving consolidation performance.

NOTE: The degree of performance improvement varies widely across different applications as it is purely driven by the application design and data distribution.

FreeForm

Introduction of Quick Start Checklists for Oracle EPM FreeForm

Wondering how to start using FreeForm? Use these checklists on your first day. Follow the steps to do initial tasks like set up your environment, log in, enter data, analyze forms, and use reports. The checklists are organized by predefined roles for Service Administrators, Power Users, Users, and Viewers.

FreeForm Quick Start Checklists

Business Benefit: These quick start checklists help you learn how to speed up your first day using FreeForm.

Narrative Reporting

There are no new features in this update except for the applicable features listed in the EPM Common section.

Planning

There are no new features in this update except for the applicable features listed in the EPM Common section.

Profitability and Cost Management

Enterprise Profitability and Cost Management

Same As Source Different Dimension Option for Allocation Rules

When creating an allocation rule destination, you now have the option to define that the destination members match the source members you selected for a different dimension.

Business Benefit: This allows you to create source and destination references with dimensions that use members names that occur in multiple dimensions. For example, you could use both the Origin Entity and Target Entity dimensions in order to track sending and receiving entities in the allocation results.

Key Resources

• Setting the Destination to Same as Source in Administering and Working with Enterprise Profitability and Cost Management

Improved Data Form Selection for Rule Balancing, Trace Allocations, and Profit Curves

A new Data Form dialog box organizes the available data forms to apply for rule balancing, trace allocations, or profit curves.

Business Benefit: Organizing data forms in folders in a library makes it easier to find a data form and avoids scrolling through large number of forms.

Key Resources

• The following topics in Administering and Working with Enterprise Profitability and Cost Management:
  • Viewing Rule Balancing Reports
  • Viewing Trace Allocation Results
  • Creating a Profit Curve

Data Maps Support for ASO Source Cubes

Enterprise Profitability and Cost Management customers now have access to Data Maps and Smart Push. Data Maps supports an Aggregate storage (ASO) cube as a source cube.

In this implementation, Data Maps and Smart Push ignore rows when the entire record consists of zeros, missing values, or a combination of missing and zero values.

Business Benefit: Enterprise Profitability and Cost Management customers can create data mappings between a source application and a target reporting application when an Aggregate storage (ASO) cube is the source cube.

Key Resources

• Understanding Data Maps in Administering Data Integration for Oracle Enterprise Performance Management Cloud

REST API to Calculate a Model

In an Enterprise Profitability and Cost Management application, you can now use a REST API to run calculation on a given point of view in a selected cube. This supports Batch calculation with multiple POVs.

Business Benefit: This lets you use a REST API to automate this process.

Key Resources

• Calculate Model in REST API for Oracle Enterprise Performance Management Cloud

Role Information

• Service Administrators

REST API to Clear Data by Point of View

In an Enterprise Profitability and Cost Management application, you can now use a REST API to clear data for a given point of view in a selected cube.

Business Benefit: This lets you use a REST API to automate this process.

Key Resources

• Clear Data by Point of View in REST API for Oracle Enterprise Performance Management Cloud

Role Information

• Service Administrators

REST API to Copy Data by Point of View

In an Enterprise Profitability and Cost Management application, you can now use a REST API to copy data from a source to a destination point of view in a selected cube.

Business Benefit: This lets you use a REST API to automate this process.

Key Resources

• Copy Data by Point of View in REST API for Oracle Enterprise Performance Management Cloud

Role Information

• Service Administrators

REST API to Delete Point of View

In an Enterprise Profitability and Cost Management application, you can now use a REST API to delete the point of view group. The data associated with the POV is  deleted from the calculation cube.

Business Benefit: This lets you use a REST API to automate this process.

Key Resources

• Delete Point of View in REST API for Oracle Enterprise Performance Management Cloud

Role Information

• Service Administrators

REST API to Validate a Model

In an Enterprise Profitability and Cost Management application, you can now use a REST API to automate the calculation process for validating a model.

If there are any validation failures, they are written to a file with the file name provided as a parameter. The file can then be downloaded.

Business Benefit: This lets you use a REST API to automate this process.

Key Resources

• Validate Model in REST API for Oracle Enterprise Performance Management Cloud

Role Information

• Service Administrators

Profitability and Cost Management

There are no new features in this update except for the applicable features listed in the EPM Common section.

Tax Reporting

There are no new features in this update except for the applicable features listed in the EPM Common section. Please be sure to review the Important Actions and Considerations section for Audit Purge related information.

IMPORTANT Actions and Considerations

One-Week Lag Between Readiness Documents Live and Help Center Live

Because Oracle readiness documents (What's New and New Feature Summary) are live one week before the monthly update is applied to Test environments, some links to documentation included in the readiness documents will not work until after the Oracle Help Center update is complete when the monthly update is applied to Test environments.

EPM COMMON

Default Time Zone for New Users

Starting in 22.10, the default time zone for new users will be (UTC) Reykjavik - Greenwich Mean Time. To reset the time zone, click Tools, then User Preferences, and then click General.

Applies to:  Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Profitability and Cost Management, Tax Reporting

Rolling Back Changes Made to Page Title Display for Horizontal tabs

We are rolling back changes that were made in the April 22.04 update to the page title for horizontal tabs. The change was to not display the page title in horizontal tabs while using the Redwood Theme. From the feedback received on this change, we've decided to roll it back. The change will be available in the July (22.07) update.

Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Profitability and Cost Management, Tax Reporting

Loaner Program for Cloud Infrastructure Generation 2 Testing and OCI Migration Assistance Early Adopter Program

Oracle EPM Cloud is now live on Oracle Cloud Infrastructure (OCI) Gen 2 environments. If you are interested in testing your application performance on an OCI environment, open a service request following the process at https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/tsepm/op_procs_loaner_envs.html and request for a loaner environment in an OCI data center for a duration of 30 days with the business justification as “Want to test application performance in an OCI Gen 2 data center”.

After you have performed the testing, submit Provide Feedback from the loaner environment. Create a service request using the normal support process, if you have any issues or feedback for the OCI environment. For more information, see What is a Gen 2 Cloud?

Additionally, Oracle has instituted a program to assist customers on Oracle Cloud Classic to migrate to OCI. For more information, see Oracle Cloud Classic to Oracle Cloud Infrastructure (OCI) Migration Assistance Program for Early Adopters.

Applies to: Account Reconciliation, Enterprise Data Management, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Narrative Reporting, Planning, Planning Modules, Profitability and Cost Management, Tax Reporting

Alerts Cannot be Migrated to Prior Version

Due to a major upgrade in Alert functionality, any service that has defined Alert Types will not be able to migrate them or the Alerts that are based on them from the 22.04 update to an earlier update. This normally happens if artifacts are moved from Test to Production during the two week period when Test is upgraded to the 22.04 update while Production is still on the 22.03 update. All other objects in the migration are not affected.

Applies to: Financial Consolidation and Close, Planning, Planning Modules, Tax Reporting

Task Manager Email Notification Settings

Starting in the 22.04 update, the service changed the handling of Task Manager’s Email Notification settings during a migration. The target service’s Task Manager Email Notification settings were updated with the settings from the source service. If a customer wants to retain the target service’s Task Manager Notification settings, they can generate an LCM export with the notification settings from the target service, perform the source migration, then import the LCM file with the notification settings.

Applies to: Financial Consolidation and Close, Planning, Planning Modules, Tax Reporting

See LCM Export and LCM Import in REST API for Oracle Performance Management Cloud.

Date Format when Using the EPM Digital Assistant

When using the EPM Digital Assistant, note that the Date format is not taken from User Preferences, and the assistant does not ask which format to use for the date. The assistant attempts to detect the date format based on the user locale set in the browser and other common formats.

Applies to: Account Reconciliation, Financial Consolidation and Close, Planning, Planning Modules,Tax Reporting

Removing Dimensions Before Rebasing a Financial Consolidation and Close or Tax Reporting EPM Digital Assistant Skill

If you want to rebase your Financial Consolidation and Close or Tax Reporting skill to use the 21.11 update of EPM Digital Assistant, note that you must first remove some dimensions before rebasing.

• Financial Consolidation and Close dimensions to be removed before rebasing: Scenario, Years, Period, Entity, Account, Currency, View, Consolidation, Data Source, Multi-GAAP, Intercompany and Movement

• Tax Reporting skill dimensions to be removed before rebasing: Cube, Scenario, Years, Period, Entity, Account, Currency, View, Consolidation, Data Source, Multi-GAAP, Intercompany, Movement and Jurisdiction

Applies to: Financial Consolidation and Close, Tax Reporting

See Removing a Consolidation and Close or Tax Reporting Custom Dimension from an Extended Skill in Getting Started with the Digital Assistant for Oracle Cloud Enterprise Performance Management.

Performing Calculations Without Having to Submit Your Changes (Calc on the Fly)

In a future update, Financial Consolidation and Close and Tax Reporting will support calc on the fly. While the Application Settings option Enable User Formulas in Ad Hoc is available in this update, the feature is not yet supported for these products.

Applies to: Financial Consolidation and Close, Tax Reporting

Drill Landing Page in Data Integration / Data Management

The Enhanced Drill Landing page is the default starting in this update. Starting with the 22.09 update, the option to switch the Drill Type user interface will no longer be available, and the Enhanced version will be the only version.

Applies to: Account Reconciliation, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Profitability and Cost Management, Tax Reporting

Downloading Smart View Extensions from Firefox

When a Smart View extension, such as the Planning Admin Extension or Task Manager extension, is downloaded using Downloads in the Firefox browser, it does not allow opening or saving the extension. Instead, it opens a new tab showing binary data. This issue is planned to be fixed in a future update. In the meantime, download extensions using an alternate supported browser (Microsoft Edge or Google Chrome), or install using the procedure in Installing Extensions in Working with Oracle Smart View for Office.

Applies to: Account Reconciliation, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Narrative Reporting, Planning, Planning Modules, Tax Reporting

Internet Explorer 11 End of Support and Smart View

Microsoft has announced end of support of Internet Explorer 11 by June 15, 2022.

Applies to: Account Reconciliation, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Narrative Reporting, Planning, Planning Modules, Profitability and Cost Management, Tax Reporting

Do not uninstall Microsoft Internet Explorer, even after the end-of support date of June 15, 2022. Instead, you may securely disable Internet Explorer following Microsoft’s guidelines. In situations where the Internet Explorer browser would be called, the Edge browser will be launched instead.

Oracle Smart View for Office does not require the Internet Explorer browser specifically. However, Smart View depends on Windows components (for example, WinInet APIs) that may have dependencies on Internet Explorer. Microsoft recommends keeping Internet Explorer installed on the machine since uninstalling may cause other applications that are dependent on it to work incorrectly. Microsoft also recommends updating to the latest security patches as they become available.

For more information, Oracle Support Document 2877741.1 (Impact on Smart view with Microsoft decommissioning Internet Explorer 11 on June 15, 2022) can be found at: https://mosemp.us.oracle.com/epmos/faces/DocumentDisplay?id=2877741.1.

In Reports, Minor Change to Text Box Text Wrapping

Due to a bug fix in the upcoming 22.08 update, please note that the following change in behavior for Text Wrapping in a Text Box:

When HTML text has multiple blocks of text with different font sizes and types (For example: Bold, Underline, and so on), the text wrapping will be improved to utilize the surrounding space more, previously there were more empty spaces in a text box. This change may reduce the height of the text/note boxes depending on the length of the text.

Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Narrative Reporting, Planning, Planning Modules, Tax Reporting

Change in Reports Behavior with Suppress Missing Blocks Enabled with Zoom on the Column

Please note that beginning in the 22.08 update, Suppress Missing Blocks will no longer be supported with Zoom enabled on column segments. This combination of properties results in unpredictable members returned when doing the query for a Zoom on the column axis.

Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Narrative Reporting, Planning, Planning Modules, Tax Reporting

Data Maps with Mapping or Cross Applications

Data Maps with mapping or cross applications are not supported in this update. If the Data Map has mapping or is a cross application, it needs to be attached to a form or included in the Groovy rule and run as a Smart Push.

Applies to: Enterprise Profitability and Cost Management, Planning, Planning Modules

ENTERPRISE DATA MANAGEMENT

Top Node Filters for Subscriptions No Longer Apply to Delete Actions

Starting in the 22.05 update, top node filters for subscriptions are no longer applied to Delete request actions in the source viewpoint. If a node matching a deleted source node is found in a target viewpoint, the node will be deleted from the target viewpoint regardless of where the node is located as part of a subscription request to ensure synchronization of existing nodes in both viewpoints.

FINANCIAL CONSOLIDATION AND CLOSE

Posting Data Against Global Assumptions

It is recommended that you do not post data against the Global Assumptions member in the Entity dimension. This member is used to store information such as currency rates. Starting with the 22.07 update, if you post data against Global Assumptions, an error will occur.

Phased Approvals

If you decide to enable Phased Approvals in your application, take note of the following considerations:

• You will need to manually modify your Data Status forms to replace the dimension member "FCCS_Status_ApprovalStatus" with the new member "FCCS_Status_ConsolidatedApprovalStatus".

• If you try to export the application from the 22.03 update and import it to the 22.02 update, you must update your Data Status form by changing the dimension member FCCS_Status_ConsolidatedApprovalStatus back to FCCS_Status_ApprovalStatus.

• Additionally, you will encounter errors during the import because new artifacts related to Phased Approvals are not supported in 22.02.

Resetting Customized Changes After an Update

If you have made changes to the seeded Account hierarchy, those changes will be reset. If you have moved seeded members, the move action is retained, but any re-ordering you have done will be reset, and a restructuring will happen when the ordering is reset. The restructuring could take time, so plan accordingly. You may have to manually re-order seeded members again after the update.

PLANNING MODULES

Removal of Strategic Workforce Planning from EPM Cloud Workforce Planning

In a future update, the Strategic Workforce Planning (SWP) enablement option will be removed for all EPM Cloud Planning Modules (Standard and Enterprise) and Enterprise Planning applications that have not already enabled this feature in the Workforce Module. Customers who have already enabled this feature will see no change in their existing applications with this feature already enabled. No new applications will support this feature after this change.

Strategic Workforce Planning functionality is provided in the Strategic Workforce Planning Cloud Service (SWPCS) product, which contains robust SWP functionality that is not available in the existing EPM Cloud Planning Workforce module feature. SWPCS is an Oracle Human Capital Management (HCM) product built on EPM technology. For more information about SWPCS, please refer to the Strategic Workforce Planning information on www.oracle.com.

If you have any concerns about this change, please contact Oracle Support.

Planning Modules That Use a 13-Period Calendar

For Planning Modules applications that use a 13-period calendar, application snapshot files older than 22.07 will no longer work after 22.07 due to changes Oracle plans to make to the application properties for 13-period applications. The change is required to correct the Fiscal Year Start Date option in existing 13-period applications. After the 22.07 update, customers are advised to take a new snapshot of both test and production environments for backup and restore purposes.

TAX REPORTING

Support for Amount and Rate Override for Tax Accounts

Starting with the 22.08 update, three existing override FX rate/amount forms will be deprecated. The forms will no longer allow data entry. The deprecated forms are:

• NIBT FX Rates Override: FX Rates - NIBT Override
• NIBT FX Rates Override - WAR: FX Rates - NIBT Override – WAR
• Weighted Average Rates Override: FX Rates - Expense Override – WAR

In addition, the data intersections underlying the deprecated forms will no longer accept data including through data import, Smart View, or Data Management.

If you are using any of the above forms or the underlying data intersections to view or modify override FX rates/amount you will need to transition to the new override FX rate/amount forms and underlying data intersections.

The replacement forms are available under the Tax Administration\FX Rates folder and will allow entry and review of the respective FX rate or amount override values.

• FX Rates - NIBT Override: NIBT Foreign Exchange Override Rates (This form replaces NIBT FX Rates Override: FX Rates - NIBT Override)

• FX Rates - NIBT Override – WAR: NIBT Foreign Exchange Override Rates - Calculated Weighted Average (This form replaces NIBT FX Rates Override - WAR: FX Rates - NIBT Override – WAR)

• FX Rates - Expense Override – WAR: Foreign Exchange Rates Calculated Weighted Average (This form replaces Weighted Average Rates Override: FX Rates - Expense Override – WAR)

NOTE: The transition from the old override FX rate capability to the new override FX rate capability requires a migration. All applications created prior to 21.07 must manually run the migration no later than the upgrade to 22.08 on your test and production instances. As part of the migration, all the FX override rates (that is, NIBT override, WAR, and others) that are contained within the Tax Reporting application will be migrated to new intersections. You can tell if a migration is necessary by following the steps in Migrating Override FX Rate and Amount Data and verifying that the Migrate NIBT FX override rate, NIBT WAR and Expense WAR Data checkbox is unchecked. The migration is safe to run multiple times.

IMPORTANT: If you fail to run the migration before upgrading to 22.08, Consolidation will fail with the following error message: A method called by the script failed on line: 8, with error: No migration upgrade smartlist detected. Performing the migration will resolve this error.

IMPORTANT: Data integrations involving the deprecated override FX rate intersections, such as data import/export profiles, Data Management integrations, or Smart View sheets may require a manual update to point to the new override FX rate intersections. See the Migrating Override FX Rate and Amount Data for details on the intersections to migrate.

See

• Migrating Override FX Rate and Amount Data in Working with Tax Reporting
• Working with Amount and Rate Override for Tax Accounts in Working with Tax Reporting

Purging of Audit Information

Starting in the 22.10 update, audit records older than 365 days will be automatically purged at service start-up such as after the daily maintenance window, service reset, or outage (planned or unplanned). Purged audit records will not be stored or accessible. To prepare for this change, you may want to take a backup of the historical audit data. To do this, select one of the following options:

1. Export: Select the Export option on the Actions menu from the Audit card by selecting the appropriate filters.
2. EPM Automate command: Use the exportAppAudit command. See exportAppAudit in Working with EPM Automate for Oracle Enterprise Performance Management Cloud.