May 2023 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	Module	Feature	Notes
30 MAY 2023	Account Reconciliation	New Governor Limits for Transaction Matching Objects	Updated document. Revised Key Resources link.
24 MAY 2023	Tax Reporting	Enhanced Actual Regional Deduction	Updated document. Revised Key Resources link.
12 MAY 2023	Financial Consolidation and Close	Calculation Process for Movement Dimension Members	Updated document. Revised feature description.
12 MAY 2023	IMPORTANT Actions and Considerations	Financial Consolidation and Close	Updated document. Added a consideration.
03 MAY 2023	EPM Common	Data Management Feature Replacement by Data Integration	Updated document. Revised feature description.
27 APR 2023			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, May 5, 2023.

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

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, May 5, 2023.

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.

Helpful Information

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 are posted to a knowledge article on My Oracle Support. Click here to review. You must have a My Oracle Support login to access the article.

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.

Create and Run an EPM Center of Excellence

A best practice for EPM is to create a Center of Excellence (CoE). An EPM CoE is a unified effort to ensure adoption and best practices.

Business Benefit: A CoE drives transformation in business processes related to performance management and the use of technology-enabled solutions.

Learn more:

• Watch the webinar on Cloud Customer Connect: Creating and Running a Center of Excellence (CoE) for EPM Cloud
• Watch the videos: Overview: EPM Center of Excellence, Creating a Center of Excellence
• Get best practices, guidance, and strategies for your own EPM CoE: Creating and Running an EPM Center of Excellence

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.

Business Benefit: These resources can help you optimize your EPM implementation and user experience by providing valuable information and user assistance.

Oracle Cloud Readiness App

A new Readiness App is now available on the Oracle Cloud Application Update Readiness site. The app provides an .xlsx file listing all features released for one or more Cloud product(s), module(s) and update(s) that you designate. From the Readiness site, click the red Try Our Readiness App button in the upper right, or use this URL to access the app:

https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/readiness/app/index.html

NOTE: To ensure a complete feature listing, select EPM Common in addition to the business process(es) you wish to view. To determine whether an EPM Common feature applies to your business process, review the Applies To information in the Short Description column of the .xlsx file.

NOTE: The EPM Cloud Features tool, which contains EPM features from March 2018, will not be updated after June 2023.

Business Benefit: The Readiness App is an interactive tool that allows you to view a comprehensive listing of all features that have been released for one or more product(s), module(s) and update(s) that you designate.

EPM Common

OCI Migration: Oracle-Managed Migration Continues; Customer-Managed Migration Not Available Any Longer

One of Oracle's latest advancements, Oracle Cloud Infrastructure (OCI) is the foundation of Oracle's second generation cloud. OCI, a purpose-built, best-in-class platform for running enterprise applications, is engineered from the ground up to run mission-critical databases, workloads, and applications while providing end-to-end security. Oracle's data centers around the globe are standardizing on the new OCI architecture which will deliver even greater performance and reliability. There are a lot of EPM Cloud features that are available only in OCI. See Features Available only in OCI EPM Cloud Environments in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators.

Oracle plans to migrate all Classic Commercial environments to OCI by the end of 2023 using monthly migration waves.

Oracle is sending notifications for Oracle-managed migrations. When your environments are scheduled for migration, you will get notification specifying the migration schedule. Follow the instructions in the notification.

For customers whose environments were included in Wave 2 (February 2023 Migration Notification): The migration of application data and users from Classic to OCI environments and the DNS configuration change to route the existing Classic service URLs to OCI environments will occur in the 23.05 (May) monthly update. If you prefer not to have the migration take place in the 23.05  monthly update, please run the skipUpdate EPM Automate command to skip the 23.05 update.

• If your environments are included in Wave 3 (March 2023 Migration Notification), you must already have received your OCI instances. You should go through the optional migration steps, which include setting up SSO and IP Allowlist, and testing based on your requirements. See these information sources:
  • Oracle-Managed Migration in Oracle Enterprise Performance Management Cloud Operations Guide
  • Tasks to Perform After Cloning Environments in Administering Migration for Oracle Enterprise Performance Management Cloud

• If your environments are included in Wave 4 (April 2023 Migration Notification), you will receive your OCI instances in the beginning of May 2023.

• If your environments are included in Wave 5,  you will be notified in the beginning of May 2023.

For Migration waves schedule information, see EPM Cloud Classic to OCI Migration Schedule in Oracle Enterprise Performance Management Cloud Operations Guide.

Oracle is no longer accepting any service request for customer-managed migration. If only some of your environments were migrated using Customer-Managed Migration, the remaining environments will be migrated using Oracle-Managed Migration.

NOTE: At this time, the environments hosted in US-Gov and UK-Gov data centers are not eligible for migration to OCI.

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: OCI provides you a purpose-built, best-in-class platform that is engineered from the ground up to run mission-critical databases, workloads, and business processes while providing end-to-end security. This new architecture delivers greater performance and reliability, and a number of EPM Cloud features that are not available in Classic EPM Cloud.

Steps to Enable

Review and follow instructions: EPM Cloud Classic to Oracle Cloud Infrastructure (OCI) Migration in Oracle Enterprise Performance Management Cloud Operations Guide

Key Resources

• EPM Cloud Classic to Oracle Cloud Infrastructure (OCI) Migration in Oracle Enterprise Performance Management Cloud Operations Guide

• Features Available only in OCI EPM Cloud Environments in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators

New Translations Available for EPM Cloud Documentation

A new set of translated documentation is available for EPM Cloud.

Find the translated content for your business process by visiting the help center, going to your business process, and then clicking Translated Books.

Translations are available for these EPM Cloud business processes: Account Reconciliation, Enterprise Data Management, Financial Consolidation and Close, FreeForm, Narrative Reporting, Planning, Tax Reporting, Enterprise Profitability and Cost Management, and Profitability and Cost Management.

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

Business Benefit: Translated documentation allows global teams to access valuable content across the organization.

Update to Documentation for EPM Cloud REST API Implementation Best Practices

You now have additional helpful information in the EPM Cloud REST API Implementation Best Practices topic. In addition to the current best practices in this topic, you now have access to REST API troubleshooting information.

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 information gives you quick access to troubleshooting information while you are working with the REST API.

Steps to Enable

Review the REST service definition in the REST API guides to leverage (available from the Oracle Help Center > your apps service area of interest > APIs & Schema). If you are new to Oracle's REST services you may want to begin with the Quick Start section.

Tips And Considerations

Use the Quick Reference to see all of the EPM REST APIs at a glance.

Key Resources

• Implementation Best Practices in REST API for Oracle Enterprise Performance Management Cloud

Access Requirements

• Service Administrators

New Look and Feel for Help Center Books and Tutorials

A new template for books and tutorials will be provided soon. The new template incorporates feedback from customers, follows industry standards, and adds new features. It continues to lead the way for features like an extensive search. The new template is built with Oracle JET, a modular open source toolkit based on modern JavaScript/TypeScript, CSS3 and HTML5 design and development principles.

Key features include:

• Simplified layout: Increased visual priority on the content area of the page
• Wider pages: If you have a wide screen, your content area will expand to fill more of your screen
• Visual design updates: Updated user interface consistent with Oracle's brand design
• New features: Several new features including social sharing, prominent buttons, and display of publication metadata

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 new template improves the help center user experience, simplifies the page layout, and expands the content area of books and tutorials.

Key Resources

• The new template is provided for books and tutorials on the EPM help center.

New Ways to Access the EPM Center of Excellence

To help you make the most of EPM Cloud, we've provided new ways to access the EPM Center of Excellence (CoE). You can now find a link to the CoE in EPM guides as well as on the EPM Help Center.

A CoE is a best practice for Cloud EPM. An EPM CoE is a unified effort to ensure adoption and best practices. It promotes the most effective use of Cloud EPM and helps you deliver better business results.

Learn more:

• Use the checklist to create an EPM CoE.
• Understand the benefits and value proposition of a CoE.
• Build your business strategy.

Business Benefit: A CoE drives transformation in business processes related to performance management and the use of technology-enabled solutions.

Tips And Considerations

• Use the EPM CoE checklist to get started.

Key Resources

• Watch the webinar on Cloud Customer Connect: Creating and Running a Center of Excellence (CoE) for EPM Cloud
• Watch the videos: Overview: EPM Center of Excellence and Creating an EPM Center of Excellence
• Get best practices, guidance, and strategies for your own EPM CoE: Creating and Running an EPM Center of Excellence

Groovy Feature to Export Data with Alias Names

You can now use the Groovy DataExporter to export data with alias names by specifying the alias table name.  To enable this, you must first add an entry to the Alias table for each member and run a cube refresh. If the alias is not provided, or you do not run do a metadata refresh, the member name is included in the data export file. For details, see DataExporter.

Find additional examples to help with your project by clicking the examples link under Example Groovy Scripts in EPM Groovy Rules Java API Reference.

For details, see EPM Cloud Groovy Rules Java API Reference.

This feature can be used by any application that has access to Groovy.

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

Business Benefit: This allows you to to export data with alias names using Groovy Business Rules.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

To get a quick introduction to Groovy business rules, watch the Learning Groovy in EPM Cloud video.

Key Resources

• Learning Groovy in EPM Cloud video
• Creating a Groovy Business Rule in Designing with Calculation Manager for Oracle Enterprise Performance Management Cloud
• Introduction to Groovy Business Rules
• Groovy Tutorials
• EPM Cloud Groovy Rules Java API Reference

Access Requirements

• Calculation Manager Business Rule Designer

Integration with Custom SIEM Tools

The Getting Started Guide for Administrators now provides details on how you can satisfy the requirement of integration with SIEM (Security Information and Event Management) tool of your choice using Access Logs.

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: Integration with SIEM tool provides you access to your EPM Cloud environments in the SIEM analysis and filtering capabilities

Key Resources

• Integration with Custom SIEM Tools in Getting Started Guide for Administrators

Activity Report Now Includes Daily Maintenance Duration

The Activity Report now includes information about the duration of Daily Maintenance in 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: Customers can use this information to learn how long it takes for Daily Maintenance to run in their environment. This will help customers to schedule their jobs outside of the Daily Maintenance window.

Key Resources

• Interface Usage and Response Data in Getting Started Guide for Administrators

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

During ad hoc analysis you can now perform calc on the fly in your Financial Consolidation and Close and Tax Reporting business processes without having to submit changes to the database. This feature is already available for FreeForm, Planning, and Planning Modules from the March 2022 (22.03) update.

Applies to: Financial Consolidation and Close, Tax Reporting

Business Benefit: You can perform multiple calculations quickly without having to submit the changes to see the results.

Steps to Enable

Administrators must enable calc on the fly in the web application.

1. In the web application, click the Navigator, and under Application, click Settings.
2. In the Other Options section, select the Yes option from the Enable User Formulas in Ad Hoc list.
3. Click Save.

Users can also enable calc on the fly in their user preferences. This user preference setting overrides the application setting.

1. In the web application, click the Navigator, and under Tools, click User Preferences.
2. In the Preferences page, click the Display tab.
3. In the Other Options section, select the Yes option from the Enable User Formulas in Ad Hoc list.
4. Click Save.

Tips And Considerations

• In the web application, hover over a cell to see the formula associated with the cell.
• In Smart View, the formulas appear as tool tips in the cells with formulas.

Key Resources

• Financial Consolidation and Close
  • Specifying Application Settings in Administering Financial Consolidation and Close
  • Working with Financial Consolidation and Close
    • Setting Your Display Preferences
    • Performing Calculations Without Having to Submit Your Changes (Calc on the Fly)

• Tax Reporting
  • Specifying Application Settings in Administering Tax Reporting
  • Working with Tax Reporting
    • Setting Your Display Preferences
    • Performing Calculations Without Having to Submit Your Changes (Calc on the Fly)

• Performing Calculations Without Having to Submit Your Changes (Calc on the Fly) in Working with Oracle Smart View for Office

New "Save As" Option for Forms While Editing in the Simplified Interface

A new "Save As" option in the simplified interface enables you to save a form with a new name while you are editing the form in the Form Designer.

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

Previously if you wanted to edit a form and save the edits with a new name, you'd need to select the "Copy As" option from the listing page, then save the form with a new name, and then open the form in the Form Designer to edit it. With the new "Save As" option, while you are editing the form in the Form Designer, you can click "Save As" and provide a new name, thus reducing extra steps.

To view the new "Save As" button, from the Home page, click Data (for Tax Reporting, click Library). Expand a form folder, and then click the name of a form to open it. Click Form Designer. The "Save As" button is at the top of the edit page. Update the form, click "Save As," enter a new form name, and then click OK. The updated form with the new name is added to the form list. If Redwood Experience is enabled, the newly named form opens in a new dynamic tab.

Business Benefit: The ability to save a variant of a form with a new name while editing it increases convenience.

Key Resources

• Editing Simple Forms in Administering Financial Consolidation and Close
• Editing Forms in Administering FreeForm
• Editing Forms in Administering Planning
• Managing Forms in Administering Tax Reporting

New Integration Type and Task Type in Task Manager

Task Manager is enhanced with a new end user integration called Reports that allows you to create tasks with embedded reports within Financial Consolidation and Close, Tax Reporting, and Planning. These tasks are available for both local and remote Financial Consolidation and Close, Tax Reporting, and Planning connections.

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

Business Benefit: The new capability enables you to extend your Task Manager processes.

Key Resources

• Financial Consolidation and Close
  • Administering Financial Consolidation and Close
    • Managing Task Manager Integrations
    • Managing Task Types

• Tax Reporting
  • Administering Tax Reporting
    • Managing Task Manager Integrations
    • Managing Task Types

• Planning
  • Administering Planning
    • Managing Task Manager Integrations
    • Managing Task Types

Data Management Feature Replacement by Data Integration

Starting with the July (23.07) update, the four features listed in the table below will no longer be available in Data Management, but will be available in Data Integration. Data Integration is available now from the Data Exchange card from the home screen in the Cloud EPM Business Process, and users can access these features in the current Cloud EPM update. Data Management is not going away in 23.07 – we are only moving a few features now that have 100% parity with Data Integration.

Data Management Feature	Data Integration Feature	Data Integration Navigation Path
Source System	Configure Connections	From the Data Integration UI, select the Actions drop down, and then Applications. In Applications, there is an icon next to the drop down labeled Configure Connections.
Target Application	Applications	From the Data Integration UI, select the Actions drop down, and then Applications.
Period Mapping	Period Mapping	From the Data Integration UI, select the Actions drop down, and then Period Mapping.
Category Mapping	Category Mapping	From the Data Integration UI, select the Actions drop down, and then Category Mapping.

Data Integration is the next generation of the Data Management user interface, enabling users to easily build and manage Cloud EPM integrations. As feature parity between Data Integration and Data Management becomes complete, Data Management features will be turned off, and users will use the new Data Integration user interface instead.

This transition will be gradual; future What's New documents will include information about the first set of planned changes as well as updates about additional changes planned for the future.

All Data Integration features discussed in this document are currently generally available in the Cloud EPM business processes.

Integration definitions built with Data Management are also visible in Data Integration, which enables an easy transition. (Data Integration is a new user interface on the Data Management data model and does not require migration of content from Data Management to Data Integration).

Please note that additional new integration features will only be included in Data Integration, and will not be back-ported to Data Management. Critical bug fixes and security fixes will still be made to Data Management until all features are fully migrated.  In addition, all features from Data Management will be migrated to Data Integration with the exception of the following:

• The batch feature will be replaced by the new Pipeline feature.  The Pipeline feature should be available sometime in CY23. (Safe Harbor applies.)

• The Report Definition feature will not be migrated, only the Report Execution feature.  Please note that Account Reconciliation and Financial Consolidation and Close provide a feature to report against the Data Integration relational tables using a custom SQL and a BI Publisher report template.

For reference, please see the Data Integration guide available from the documentation library for your specific EPM business process. Select the desired business process, then Books, and then scroll down to the Administering Data Integration for Oracle Enterprise Performance Management Cloud documentation link.

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

Business Benefit: Data Integration is the next generation of the Data Management user interface. It enables users to more easily build and manage Cloud EPM integrations.

Key Resources

• Administering Data Integration for Oracle Enterprise Performance Management Cloud

Account Reconciliation

New Search Options and Filters in the Transaction Matching Jobs List

In Transaction Matching, you can now search the Jobs list using the account ID, data source ID, and match type ID.

A new filter has been added to the Jobs list for Match Type. Use this filter to select the match type whose jobs you want to display in the Jobs list.

Business Benefit: This feature enables users to easily and quickly search for the required Transaction Matching jobs.

Key Resources

• Searching for Jobs in the Jobs List in Reconciling Accounts with Account Reconciliation
• Filtering Jobs in the Jobs List in Reconciling Accounts with Account Reconciliation

New Governor Limits for Transaction Matching Objects

Various artifacts in Transaction Matching now have governor limits. The limits include the following: total number of match types, total number of data sources in match type, total number of data sources in the application, total number of attributes in a data source, total number of match processes in a match type, and total number of rules in a match process.

Business Benefit: Setting governor limits helps keep your application optimal.

Key Resources

• Setting Governor Limits in Setting Up and Configuring Account Reconciliation

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

Calculation Process for Movement Dimension Members

You now have the option to include Movement dimension members that are created outside of the FCCS_Movements hierarchy in the translation and consolidation process. To enable this feature, add a new substitution variable named ExtendMovementScope and set the value to True.

NOTE: Starting in the 23.09 (September) update, the default value for the ExtendMovementScope substitution variable will be set to True, and this feature will be enabled by default. To disable the feature, you can change the value of the substitution variable to False.

Business Benefit: When you enable the ExtendMovementScope substitution variable, the Movement members that are created outside of the FCCS_Movements hierarchy will be included in translation and consolidation calculations, including default translations, Translation Override rules, Translation Override entries, Configurable Calculation rules, On-Demand rules, and Configurable Consolidation rules.

Key Resources

• Translating Data in Administering Financial Consolidation and Close

Enhancements to Application Recommendations

The Recommendations page now includes a System Rescan feature, which creates a job that runs in the background to update the database with the latest recommendations. You can view the status of the rescan job from the Job console, then click Refresh to refresh the list on the Recommendations page. The page also includes a timestamp that shows the last date and time the rescan process was run.

Business Benefit: The ability to rescan and refresh the Recommendations list ensures that you are viewing the latest updates to recommendations for your application.

Key Resources

• Viewing Application Recommendations in Administering Financial Consolidation and Close

Change in Solve Order for Ratio Accounts in DSO Applications

In applications that use the Dense/Sparse Optimization (DSO) option, the Solve Order of some Account members has changed. The Solve Order values for Ratio Account members should now be set to 58.

Business Benefit: Changing the Solve Order value for these accounts ensures that Ratio Account members are included in the metadata validation process.

Key Resources

• Troubleshooting Financial Consolidation and Close Retrieval Performance in Administering Financial Consolidation and Close

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

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

Narrative Reporting

A New Persistent Message in the Report Package

After executing a data source refresh at the Report Package level, a new persistent message is shown on any linked Report Reference doclet, when a report object that was designated as available content is not found. This can occur when the report object has been deleted or renamed within the linked report.

The persistent message appears as a warning icon applied to the Report Reference doclet icon within the Report Center. Clicking on the warning icon displays the message to the user. Inspecting the doclet will show which Available Content has been impacted. The warning icon is removed once the impacted available content has been remapped or removed.

Business Benefit: This feature provides an easy way to troubleshoot processing errors in the report package.

Updated Narrative Reporting Extension for Smart View

An updated Narrative Reporting extension for Oracle Smart View for Office is now available to download and install. This updated includes general improvements and defect fixes.

Business Benefit: Downloading and installing the latest Narrative Reporting extension for Smart View gives you access to the latest features, improvements and defect fixes.

Steps to Enable

To take advantage of the features, improvements, and defect fixes in the Narrative Reporting extension, choose an option to install the extension update:

• From within Smart View, click the Check for Updates, New Installs, and Uninstalls link in the Options dialog, Extensions tab, select your Narrative Reporting instance, then follow the prompts.

• From the Narrative Reporting web interface, Downloads page, download the "Smart View Extension for EPM Cloud Narrative Reporting" SVEXT file, then double-click the file to install.

Key Resources

• Installing the Narrative Reporting Extension in Working with Oracle Smart View for Office

• Downloading and Installing Clients in Oracle Enterprise Performance Management Cloud Getting Started with Oracle Enterprise Performance Management Cloud for Administrators

• Downloading and Installing Clients in Oracle Enterprise Performance Management Cloud Getting Started with Oracle Enterprise Performance Management Cloud for Users

Planning

Enabling Task Manager within Existing Planning Applications

If you are currently using task lists in Planning or if you selected the Task List task flow type during Planning application creation, you can enable Task Manager within the Planning application.

Some things you'll need to consider before enabling Task Manager:

• After enabling Task Manager, you cannot convert back to task lists.
• You cannot migrate existing tasks and task lists to Task Manager. You must delete your tasks and task lists before enabling Task Manager.
• Enabling Task Manager is only supported if Redwood Experience is enabled.
• You must log out and log in again to see the newly enabled Task Manager.

To enable Task Manager, click Application, and then click Overview. Then from the Actions menu, select Enable Task Manager. Log out and log in again to see the newly enabled Task Manager.

Business Benefit: You can easily enable Task Manager from within the Planning application.

Key Resources

• Enabling Task Manager from within Planning in Administering Planning

Enhancements for Change Job Feature in Workforce

There are several enhancements in the Change Job feature in Workforce.

• Compensation data is now automatically calculated for the source job when you run Change Job. You no longer need to run the Calculate Compensation rule.

• You can now enter comments when you run the Change Job rule. The comments appear on the Mass Update forms Process Data and Synchronize Defaults and Process Updated Data.

• All properties are now cleared in the source job after the transferred month when you run Change Job.

• The error message is enhanced if you run the Change Job rule when the Source Job and Target Job are the same to ensure that you select a different Target Job. If the Source Job and Target Job are left the same, the rule clears the data. The same error message enhancement is available in the Transfer Headcount rule to ensure you select different source and target.

Business Benefits:

• Automatic calculations make Workforce easier to use and more intuitive, and you see your changes reflected right away.
• The addition of Comments allows you to add information about the reasons for a job change.
• Clearing the properties now aligns Change Job with the Transfer functionality.
• Enhanced error messages ensure you have valid entries for source and target.

Key Resources

• Working with Planning Modules
  • Changing an Employee's Job

Workforce Transfer Headcount Rule Now Calculates Compensation Automatically

In a Job Only model, compensation data is now automatically calculated for the source job when you run the Transfer Headcount rule. You are no longer required to run the Calculate Job Compensation rule.

Business Benefit: Automatic calculations make Workforce easier to use and more intuitive, and you see your changes reflected right away.

Key Resources

• Working with Planning Modules
  • Transferring Employees

New Custom Template in Workforce for Easier Customization and Updates

Workforce now provides a custom template, OWP_Custom Template, with two blank script blocks for each supported rule, which allows you to customize the supported rules. For example, use the script blocks to include custom employee properties when you transfer an employee or change an employee's job.

The following rules support OWP_Custom Template and will read any of the modifications you make to the custom script blocks:

• OWP_Change Job
• OWP_Transfer
• OWP_Transfer In
• OWP_Transfer Out

You no longer need to make changes to any of the following templates to copy your custom properties. Use OWP_Custom Template instead.

• OWP_Assign Target Defaults
• OWP_Change Job
• OWP_Transfer_T
• OWP_Transfer In_T
• OWP_Transfer Out_T

Business Benefit: OWP_Custom Template is not considered for updates, so it’s easier for you to write and maintain your custom, flexible code in one place. For example, the custom template ensures that any custom Employee Properties you may have added in the Account dimension are copied to the target job when you run the Change Job or Transfer rules. Because you make your customizations in OWP_Custom Template, you don’t need to edit the other provided rules or templates. This makes the other provided rules and templates easier to maintain during updates because you don’t need to reapply any customizations you have made.

Tips And Considerations

The descriptions in the script blocks in OWP_Custom Template give you more information about how to use the script blocks and where to insert them.

Key Resources

• Administering Planning Modules
  • Using a Custom Workforce Template to Support Workforce Customizations

Effective Date Option Added to Change Requisition in Workforce

When you change a hiring requisition Hiring Status to Closed, you can now specify an Effective Date for the change. The End Date is updated based on the Effective Date.

Business Benefit: Previously, when you changed a hiring requisition status to Closed, you specified only the Year. Compensation data is more accurately calculated when you close a requisition using the Effective Date.

Tips And Considerations

• The End Date for the closed hiring requisition is updated to be one day before the Effective Date. Compensation data is recalculated based on the End Date.

• The End Date is populated based on the Effective Date for the Closed status but not for other statuses.

Key Resources

• Working with Planning
  • Updating Hiring Requisitions

Profitability and Cost Management

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

Enterprise Profitability and Cost Management

Ability to Find and Replace Members That No Longer Exist in a Dimension

The Find Member field in the rule designer Mass Edit tab now allows you to enter a member name that no longer exists in a dimension. Once you find a member not used in a dimension, you can then replace that member reference with another member selected from the dimension hierarchy. This allows you to fix multiple broken rules that are referencing an invalid member.

Business Benefit: It is now easier to repair large numbers of rules that reference dimension members that no longer exist in a dimension.

Key Resources

• Replacing Members in Rules in Administering and Working with Enterprise Profitability and Cost Management

New Default Form for Rule Balancing

A default form for Rule Balancing is now available to use when generating a Rule Balancing report.

Business Benefit: The default Rule Balancing form provide users with a template layout to start with, and eliminates the need to create a Rule Balancing form from scratch.

Key Resources

• Administering and Working with Enterprise Profitability and Cost Management
  • About Rule Balancing
  • Designing Data Forms for Rule Balancing
  • Generating a Rule Balancing Report

Tax Reporting

Please be sure to review the Important Actions and Considerations section for Audit Purge related information.

Support for Configurable Dimensionality and Optimizing the Application Model for Hybrid Aggregation

In Tax Reporting, when you create an application, you can configure up to two custom dimensions. Also, the application model is now optimized for Hybrid aggregation. You can convert an existing application to a Hybrid-optimized application model in Performance Settings (Application -> Configuration).

A Hybrid-optimized application model differs from a non-hybrid model in several significant ways including dimension performance settings (Movement and Period dimensions are configured as Dense), dimension member Data Storage configuration, and Essbase configuration settings.

NOTE: This option applies only to applications that are running on Hybrid-enabled Essbase.

Business Benefit:

• Configurable dimensionality - allows you to configure your applications with up to 2 custom dimensions, applicable only when you create new application.

• Faster Refresh Database - the Account dimension in a hybrid-optimized application is configured as Sparse. This enables modifications to Account members, such as regular book account updates, without triggering a potentially lengthy Essbase dense restructure and greatly reduces the time taken to refresh database.

• Performance - the system leverages hybrid aggregation and optimized dimension performance settings to drive performance gains in Consolidation and data retrieval. 

• Reduced application size - you may notice a significant reduction in the Essbase database size due to the fact that Account is now a sparse dimension which generally results in smaller block size and fewer and denser blocks.

• Ability to export dynamically calculated members of Sparse dimensions with Data Integration. See the All Data Data Extract Option in Defining Data Integration Options in Administering Data Integration for Oracle Enterprise Performance Management Cloud

Steps to Enable

Before optimizing the application model for Hybrid aggregation:

• Ensure there are no pending metadata changes, and that Refresh Database has been successfully performed.
• Take a backup of the application.
• Disable scheduled jobs.
• Reschedule the automatic maintenance window so it’s unlikely to kick off while the application is being converted.
• Confirm that the application is in administrator mode.

Next, perform these steps:

• On the Home page, click Application, and then Configuration.

• Select Performance Settings to launch the process.

• Confirm that you have completed the pre-conversion steps, then click Next and follow the prompts. 

• Wait for the application to be converted. The process will need to perform a dense database restructure which may take a significant amount of time. You can also monitor progress via the Make Period and Movement Dense job in the Job Console (Application->Jobs). When the process is complete log out of the application and log back in.

• Also see Post-Conversion Steps after Optimizing the Application for Hybrid in Administering Tax Reporting.

Key Resources

• In Administering Tax Reporting:
  • Optimizing the Application Model for Hybrid Aggregation
  • Converting the Application Model to Hybrid-Optimized
  • Adding Custom Dimension
  • Working with Member Formulas

Enhanced Actual Regional Deduction

Tax Reporting is now enhanced to allow users to deduct actual taxes paid in P13 to derive a Return to Accrual (RTA) adjustment. The difference is included as state tax RTA, and this state tax RTA is not deductible for Federal provision. The deduction is included in the Federal RTA posted to the current provision.

Business Benefit: With this new capability, users who deduct state taxes paid with their state return on their Federal return will now have the ability to include those state taxes paid and deducted on their RTA.

Key Resources

• Using RTA Actual Regional Deduction in Working with Tax Reporting

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

Plan to Discontinue Support for Non-Redwood Experience Themes

Oracle's Redwood UX Design is helping organizations improve user productivity, reduce training costs, and increase user satisfaction. As such, it has gained wide adoption across our Oracle Cloud user base. Within Cloud EPM the Redwood Theme has had significant adoption, and major new platform innovations over the past few years have primarily been released only within the Redwood theme. Going forward, future innovations in Cloud EPM and Redwood UX Design patterns are likewise targeted to be available within the Redwood theme only. In a future update (planned towards December 2023), Oracle EPM Cloud plans to support only the Redwood Experience theme. All non-Redwood themes are planned to be de-supported, and non-Redwood themes will no longer appear as options on the Appearance page for new applications. Customers are advised to plan on shifting their user base to the Redwood Experience theme. All new implementations are recommended to be initiated with Redwood theme only.

More details are covered in this Cloud Customer Connect session in April 2023: EPM – Why You Should Be Using The Redwood Theme in EPM Cloud

This session covers why users should be adopting the Redwood theme, customizations available within the theme (such as company logo), and the future plans around non-Redwood themes for Cloud EPM.

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

Plan for the User Variables Dimension Column to Honor the Alias Setting in User Preferences

In a future update, the Dimension column on the User Variables page within User Preferences will honor the Alias Setting in User Preferences. So if an alias name is defined for a dimension, then the Dimension column on the User Variables page will show that dimension’s alias based on the alias table selected in User Preferences. If no alias is defined for the dimension, the dimension name will be displayed.

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

Plan to Restrict the 0x1A Character and 0xA0 Character in Member Names, Aliases, and Attribute Names

In a future update, the 0x1A ASCII substitute character (zero-width space) and the 0xA0 Unicode character (no-break space) will no longer be allowed in member names, aliases, and attribute names.

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

Plan to Transition from Identity Cloud Service (IDCS) to Identity and Access Management (IAM)

EPM Cloud environments on OCI (Gen 2) will transition from Identity Cloud Service (IDCS) to Identity and Access Management (IAM) domains in the coming months. For information on IAM, see Overview of Identity and Access Management.

After this transition, existing IDCS administration and My Profile functionalities will remain the same, but will be hosted on Oracle Cloud Console. The Oracle Cloud sign-in page will have an updated design to match the latest Oracle Cloud design guidelines.

Please see Schedule - Identity Domains to Existing OCI Tenancies for the estimated schedule for introducing OCI IAM identity domains to different OCI regions.

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

Enhanced Integration API and Drill Type UI Options in Data Management System Settings

In the System Settings option of Data Management, the Enhanced Integration API and Drill Type UI options have been removed from the list of options in this update.

Formerly, the Enhanced Integration API setting was added temporarily to address backward compatibility considerations.

The Drill Type UI setting formerly enabled users to select either the Classic or Simplified user interface when drilling down in Oracle Enterprise Performance Management. The default drill type user interface is now the Simplified User Interface and the Classic option for the user interface of Drill Landing Page is no longer available.

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

Deprecation of Calculation Manager Administrator Application Role

Oracle will deprecate the Calculation Manager Administrator application role in a monthly update in the near future.

The deprecation of this role does not affect the current access rights granted through application role assignments. If you have any concerns about this update, please open a service request that identifies your concerns.

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

Forms 2.0 and Dashboards 2.0

Within the next 6 months, Forms 2.0 and Dashboards 2.0 functionality will be available. Forms 2.0 and Dashboards 2.0 use Oracle JET technology for faster rendering, sophistication, ease of use, improved flexibility, better visualization, and additional designs. To work with Forms 2.0 and Dashboards 2.0, you must enable the Redwood Experience. Forms 1.0 and 2.0 and Dashboard 1.0 and 2.0 versions will continue to coexist in the same business process at the same time.

Forms 2.0 features:

• Forms runtime-only improvements
• Usability improvements
• Better scalability and enhanced performance
• Greater consistency between Web forms and Smart View forms
• Easily switch from Forms 1.0 to Forms 2.0 and back using an application setting

Dashboards 2.0 enhancements:

• Introduces a new Grid chart type which renders Forms 2.0 inside Dashboards 2.0
• New URL and Commentary types of Dashboard objects
• Custom formatting of titles and support for background colors in URL, Commentary, and Grid objects
• New user interface for associating business rules
• Ability to display multiple Gauge, Pie, and Doughnut charts inside one Dashboard object
• New menu options for opening and editing forms directly from the Dashboard
• New Information icon for the Dashboard and all Dashboard objects
• Ability to easily convert 1.0 Dashboards to 2.0 individually and at the folder level on the Dashboards listing page

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

Calculation Manager Errors and Warnings Enforcement

In a future update, Calculation Manager will enforce the execution of the Errors & Warnings diagnostic tool for any rule being launched, validated, or deployed from it. If there are errors that result from this new process, Calculation Manager will not execute, validate, or deploy the rule. This new process will apply to all new applications once released. Existing applications will have a finite period of time to bypass this new process to allow you to modify the rules that violate the new Errors & Warnings diagnostic analysis. In all cases, existing rules that are already deployed will continue to run as-is without any change in behavior.

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

Change in Behavior for Grids Created from Groovy and REST APIs for ASO Cubes

In a future update, the suppression behavior for grids created via Groovy DataGridDefinitionBuilder and the exportdataslice REST API for ASO cubes will be made consistent with that of the run time data grids created using the Form Designer. Previously, if a grid was built for an ASO cube in Groovy or REST API, then the system used the NON EMPTY MDX clause to suppress missing rows when the suppressMissingBlocks flag was true. Now, when a grid is built for an ASO cube, it will use the NON EMPTY MDX clause when suppressMissingRows is true, and suppressMissingBlocks will be ignored. This means that ASO grids with suppressMissingRows true and suppressMissingBlocks false will now start using MDX. Likewise, ASO grids with suppressMissingRows false and suppressMissingBlocks true will no longer use MDX. Grids where the suppressMissingRows and suppressMissingBlocks flags had the same value will not be impacted. These changes may result in a change in behavior or performance for some ASO grids. If this happens and is undesirable, consider toggling the value of suppressMissingRows from the builder or the JSON payload in case of the REST API.

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

Mandatory Steps Required to Make the Explore Repository Artifacts Accessible to Users

Prior to the July (22.07) update, Oracle Enterprise Performance Management Cloud used the WORLD pre-seeded group to grant access to Explore Repository artifacts such as reports and folders. Starting with the July (22.07) update, the WORLD group was removed. If you previously used the WORLD group to grant access to repository artifacts, complete these steps to ensure that users can access Repository artifacts:

1. Create a group in Access Control with all EPM Cloud users as its members.
2. In Explore Repository, grant access privileges to the group you created in the preceding step.

For detailed steps, see Granting Access Permissions to Document Repository Users in Working with Financial Reporting for Oracle Enterprise Performance Management Cloud.

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

Task Manager Email Notification Settings

Starting in the April (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.

NetSuite Enterprise Performance Management as a Provider

In this 23.05 update, EPM business processes will support NetSuite Enterprise Performance Management as a provider for NetSuite customers with an active license for Oracle NetSuite Planning and Budgeting Cloud Service or Oracle NetSuite Account Reconciliation Cloud Service only. The Connections page displays NetSuite Enterprise Performance Management as a supported provider for EPM business processes.

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

Purging of Audit Information

Since the March (23.03) update, audit records older than 365 days are automatically purged. Purged audit records are not stored or accessible. As a best practice, you may want to take a backup of historical audit data. To do this, select one of the following options:

• Export: Select the Export option on the Actions menu from the Audit card by selecting the appropriate filters.

• EPM Automate command: Use the exportAppAudit command. See exportAppAudit in Working with EPM Automate for Oracle Enterprise Performance Management Cloud.

• EPM Automate script: Use the Windows or Linux scripts to automate the process of exporting and archiving application audit data to a local computer. See Automate the Archiving of Application Audit Records in Working with EPM Automate for Oracle Enterprise Performance Management Cloud.

Submit a service request if you encounter problems backing up historical audit data.

Applies to: Financial Consolidation and Close, 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

Internet Explorer 11 End of Support and Smart View

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

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://support.oracle.com/epmos/faces/DocumentDisplay?id=2877741.1

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

Updated Smart View Browser Extension Required for Chrome and Edge

An updated Smart View browser extension for Google Chrome and Microsoft Edge is available. This extension is required for Oracle Smart View for Office to interact with supported browser-based EPM Cloud business processes in these ways:

• Starting in a form or ad hoc grid in Smart View, use drill-through to launch an application web page in a browser.
• Starting in a web application, launch a form or ad hoc grid in Smart View for Excel.
• Starting in a Task List in Smart View, opening a task in a browser.

This required browser extension update is strictly for the Chrome and Edge browsers only. This is not an update for extensions, such as the Planning Admin or Narrative Reporting extensions, within Smart View.

This update is required only if your default browser is Chrome or Edge. If your default browser is Mozilla Firefox, then this update does not affect you.

The extension is available in the Chrome Web Store from either the Chrome or Edge browser. In the Chrome Web Store, search for "smart view" to locate the extension update. The version number is 22.200. Then follow the instructions for Google Chrome or Microsoft Edge in Installing Browser Add-ons in the Oracle Smart View for Office Installation and Configuration Guide.

Note that from January 1, 2023, the earlier version of the browser extension does not work with Chrome or Edge. You must update your extension in order to continue interactions between Smart View and browser-based business processes in EPM Cloud.

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

Office 365 Add-ins Command Change by Microsoft to Impact Buttons in Smart View (Mac and Browser)

To improve security in Office Add-ins, Microsoft Office 365 has made changes to its ExecuteFunction add-in command from October 30, 2022. Since Smart View for Office (Mac and Browser) uses this command in its ribbon buttons and menus, some buttons may stop working from October 30. For example, buttons such as Undo, Redo, or Refresh on the Smart View and provider ribbons. This issue is resolved in the latest Smart View update of 22.11. As the changes are limited to server update, you are not required to create and deploy a new manifest file again for resolving this issue.

For more information on Microsoft’s announcement, see Announcing changes to Office Add-ins’ ExecuteFunction commands.

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

Oracle Financial Reporting Statement of Direction

Please refer to the Statement of Direction for Oracle Financial Reporting:

Oracle Support Document 2910806.1 (EPM Cloud Financial Reporting Statement of Direction)

Oracle Financial Reporting “Expand All” Feature Statement of Direction

Please refer to Statement of Direction for Oracle Financial Reporting “Expand All” feature:

Oracle Support Document 2920293.1 (EPM Cloud Financial Reporting: Expand All Feature Statement of Direction)

ACCOUNT RECONCILIATION

Renaming of Group Views

In a future update, Group Views will be renamed Pivot Views.

Renaming of Saved Lists

In a future update, Saved Lists will be renamed Saved Views.

Governor for Pre-mapped Transactions Load Process

Pre-mapped transactions load process now has a governor added to set a maximum limit of 500,000 transactions per file. Imports larger than this should be broken up into multiple files.

ENTERPRISE DATA MANAGEMENT

Query Request API No Longer Returns Workflow Information for Requests by Default

In a future release, when using the Query Requests API to retrieve summary information for requests, workflow information (such as request invitees, approvers, and commits) will no longer be returned by default for performance reasons. Instead, the option to return workflow information will be available via a parameter in the API.

Key Resources

• Query Requests in REST API for Oracle Enterprise Data Management Cloud Service

FINANCIAL CONSOLIDATION AND CLOSE

ExtendMovementScope for Movement Dimension Members Calculation

If the FCCS_Opening Balance Movement member is shared outside of the FCCS_Movements hierarchy, an issue occurs when you use the ExtendMovementScope substitution variable with value set to True to include these Movement members in translation and consolidation. This issue will be fixed in the June (23.06) update.

Predict Consolidation Time Rule

The Predict Consolidation Time rule is no longer enabled by default, and will not automatically run as part of the Consolidation process. To run the Predict Consolidation Time rule automatically whenever the Consolidation rule is run, you must add a Substitution Variable named EnablePredictConsolidate and set the value to True. You can also run the rule manually at any time.

FCCS_Global Assumptions Member

The FCCS_Global Assumptions member and its descendants (if any), from the Entity dimension will be restricted member(s) for On Demand Rules starting from the June (23.06) update. Financial Consolidation and Close users won’t be able to use the FCCS_Global Assumptions member and its descendants (if any) as Run Time Prompts (RTPs) while running On Demand Rules.

Future Updates to Ownership Management Locking / Unlocking

Currently there is a single Process Management Approval Unit for all instances of a shared entity. As a result, when data for one instance is Locked in Process Management, all instances are Locked. The same Locking logic will apply to Ownership Management. When data is locked for an Approval Unit POV, Ownership Management settings are also locked for the same Approval Unit POV. As noted above, this link from Process Management Locking / Unlocking to Ownership Management settings can be disabled using a Substitution Variable. Note that this ability to disable the link will be temporary.

When future updates to improve Organization-by-Period functionality are made available, there will be one Process Management Approval Unit for each instance of a shared entity rather than one Approval Unit for all instances. When this is first implemented, the same Locking / Unlocking logic will apply. When the Process Management Approval Unit is locked, then both data and Ownership Management settings will be Locked, but on an instance-by-instance basis for shared entities. At this point, the link between Approval Unit Locking / Unlocking and Ownership Management settings Locking / Unlocking will no longer be able to be disabled. This is to ensure that a change in Ownership settings cannot cause Locked data to be impacted.

A further update will then be implemented to provide a little more flexibility in Locking / Unlocking Ownership Management settings. These settings will be able to be Locked before the Process Management Approval Unit for the same POV is Locked. Ownership Management settings will only be able to be Unlocked if the matching Process Management Approval Unit is unlocked. This will allow users to work on updating data without worrying about ownership settings affecting their results. Again, the link and dependency between Locking / Unlocking data and Ownership Management settings will not be able to be disabled.

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 July (22.07) update, if you post data against Global Assumptions, an error occurs.

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 March (22.03) update and import it to the February (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 the February (22.02) update.

Enterprise Journal Dimension Persistence

In a future update, all Enterprise Journal dimension attributes will persist their values once they are set in the Journal.

Consolidation Journal Application Roles Not Automatically Mapped to Any Predefined Role

In a future update, the following consolidation journal-related application roles will no longer be mapped to any predefined role, including Service Administrator.

• Create Journals
• Submit Journals
• Approve Journals
• Post Journals
• Un-Post Journals
• Manage Journal Periods

These roles will need to be explicitly assigned to new users from the Manage Application Role tab of Access Control. However, your existing users who already have these journal roles assigned will continue to have these roles assigned to them.

If you have any concerns, please open a service request.