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


  1. August 2023 Update
  1. Revision History
  2. Overview
  3. Feature Summary
  4. Enterprise Performance Management
        1. Monthly Update Schedule
        2. Helpful Information
        3. Oracle Cloud Readiness App
    1. EPM Cloud Platform
      1. OCI Migration
        1. OCI Migration: Oracle-Managed Migration Continues; Customer-Managed Migration Not Available Any Longer
      2. Identity Cloud Service
        1. Documentation on How to Synchronize EPM Cloud Users and IDCS Groups with Other IDCS Instances Using SCIM
      3. Data Integration
        1. File Application Support in Data Integration
        2. Announcement: Data Management Feature Migration to Data Integration
      4. Data Integration Pipeline
        1. New Job Types in Pipeline
        2. New Job Type in the Job Scheduler: Integration Pipeline
      5. Smart View
        1. Updated EPM Books Extension for Smart View
        2. Member Selection Available for EPM Books POV when POV Definition is Set to Allow All Selections
      6. Task Manager
        1. Support for Data Exchange Integration Type and Task Type for Remote Account Reconciliation Connection
        2. Run Data Integration Type and Task Type in Task Manager
        3. Oracle Integration Cloud Generation 3 Support for EPM Adapter
      7. Digital Assistant
        1. Digital Assistant Integration with EPM Help Center Search
      8. Activity Report
        1. Display of Skip Update Requests
      9. Role Assignment Report
        1. Report Generation Refreshes User and Role Information
        2. Deactivated Users not Included
    2. Account Reconciliation
        1. Increase in the Number of Transactions Selected in the Unmatched Transactions Tab
        2. Additional Runtime Metrics in the Activity Report
    3. Enterprise Data Management
    4. Financial Consolidation and Close
        1. Performance Substitution Variables
    5. FreeForm
    6. Narrative Reporting
        1. Updated Narrative Reporting Extension for Smart View
    7. Planning
        1. Support for Calendars and Events in IPM Insights, Auto Predict, and Predictive Planning
    8. Profitability and Cost Management
        1. Simplified Calculation Process for Reclassification Rules
    9. Enterprise Profitability and Cost Management
        1. Simplified Calculation Process for Reclassification Rules
        2. Ability to View a Complete Rule Definition for a Single Rule
    10. Tax Reporting
        1. Translation to Reporting Currencies When an Entity is Locked
        2. Enhanced Periodic Currency Translation
  5. IMPORTANT Actions and Considerations

August 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
10 AUG 2023 Account Reconciliation Increase in the Number of Transactions Selected in the Unmatched Transactions Tab Updated document. Updated feature description.
04 AUG 2023

IMPORTANT Actions and Considerations

Financial Consolidation and Close Updated document. Added " Change to Reversal of Loading Closing Balance Input" consideration.
01 AUG 2023 EPM Cloud Platform New Job Types in Pipeline Updated document. Removed "Enterprise Profitability and Cost Management" from the "Applies to" line.
27 JUL 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

Column Definitions:

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

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

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

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

Ready for Use by End Users
(Feature Delivered Enabled)

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

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

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

Feature

Report

UI or
Process-Based:
Small Scale

UI or
Process-Based:
Larger Scale*

Enterprise Performance Management

EPM Cloud Platform

OCI Migration

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

Identity Cloud Service

Data Integration

File Application Support in Data Integration

Announcement: Data Management Feature Migration to Data Integration

Data Integration Pipeline

New Job Types in Pipeline

New Job Type in the Job Scheduler: Integration Pipeline

Smart View

Updated EPM Books Extension for Smart View

Member Selection Available for EPM Books POV when POV Definition is Set to Allow All Selections

Task Manager

Support for Data Exchange Integration Type and Task Type for Remote Account Reconciliation Connection

Run Data Integration Type and Task Type in Task Manager

Oracle Integration Cloud Generation 3 Support for EPM Adapter

Digital Assistant

Digital Assistant Integration with EPM Help Center Search

Activity Report

Display of Skip Update Requests

Role Assignment Report

Report Generation Refreshes User and Role Information

Deactivated Users not Included

Account Reconciliation

Increase in the Number of Transactions Selected in the Unmatched Transactions Tab

Additional Runtime Metrics in the Activity Report

Financial Consolidation and Close

Performance Substitution Variables

Narrative Reporting

Updated Narrative Reporting Extension for Smart View

Planning

Support for Calendars and Events in IPM Insights, Auto Predict, and Predictive Planning

Profitability and Cost Management

Simplified Calculation Process for Reclassification Rules

Enterprise Profitability and Cost Management

Simplified Calculation Process for Reclassification Rules

Ability to View a Complete Rule Definition for a Single Rule

Tax Reporting

Translation to Reporting Currencies When an Entity is Locked

Enhanced Periodic Currency Translation

>>Click for IMPORTANT Actions and Considerations

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, August 4, 2023.

Production Environments: Oracle will apply this monthly update during the first daily maintenance that occurs at or after 22:00 UTC on Friday, August 18, 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, August 4, 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:

Join Oracle Cloud Customer Connect

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

To join, go to https://community.oracle.com/customerconnect/ and select Register in the upper right.

After you have joined and logged in, to access the forums (Categories), from the Cloud Customer Connect home page, select Categories, then Enterprise Resource Planning, and then make your selection under Enterprise Performance Management.

To ensure you are always in the know, confirm you have your notification preferences set for EPM Announcements as well as each Category you're following.

To set notification preferences for EPM Announcements, go to Categories, then Announcements, and then Enterprise Performance Management. Next, select the Notification preferences drop down.

To set notification preferences for each Category, navigate to the Category page and select the Notification preferences drop down. You must go to each category page separately and select the Notification preferences drop down.

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

Use the Readiness App available on the Oracle Cloud Application Update Readiness site to review information about features released for Oracle Cloud. 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. The EPM Cloud Features tool will not be updated beginning in this update.

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 Readiness App includes features from Oct 2021 and later. The EPM Cloud Features tool includes EPM features from March 2018 through June 2, 2023 only.

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 Cloud Platform

OCI Migration

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 5 (May 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.08 (August) monthly update. If you prefer not to have the migration take place in the 23.08  monthly update, please run the skipUpdate EPM Automate command to skip the 23.08 update.

  • All Classic environments in the Abu Dhabi (EM8) Data Center are scheduled to be migrated to OCI in Wave 4 during the 23.08 update even if you set skip update for the 23.08 monthly update. The resulting OCI environment will then have the same monthly update as the Classic environment; skip update will be active on this OCI environment.
  • If your environments are included in Wave 6 (June 2023 Migration Notification), you must already have received your OCI environments. 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:
  • If your environments are included in Wave 7 (July 2023 Migration Notification), you will receive your OCI environments in August 2023. Because your OCI environments may be provisioned at different times, you may not receive notification emails for all the environments at the same time.
  • All Classic Commercial environments that are not yet scheduled for migration will be included in Wave 8. The notifications for Wave 8 will be sent on August 7, 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

Identity Cloud Service

Documentation on How to Synchronize EPM Cloud Users and IDCS Groups with Other IDCS Instances Using SCIM

The Getting Started with Oracle Enterprise Performance Management Cloud for Administrators guide now includes step-by-step instructions on how you can use System for Cross-domain Identity Management (SCIM) to synchronize EPM Cloud users and IDCS groups with other IDCS instances.

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

You can use SCIM to automatically synchronize EPM Cloud users and IDCS groups so that you do not need to duplicate users and groups defined in other IDCS instances. For example, you can use SCIM to synchronize EPM Cloud users and IDCS groups defined in your central IDCS instance. You can do the same to synchronize EPM Cloud users and IDCS groups between two different EPM Cloud environments that use different identity domains.

Business Benefit: Synchronization across different IDCS instances helps you unify EPM Cloud environments and reduces the administrative overhead to maintain user, group, and role assignments.

Steps to Enable

See Using SCIM to Synchronize Users and Groups Across Identity Domains in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators

Key Resources

Data Integration

File Application Support in Data Integration

Customers can now register a file as a data source in the Applications option of Data Integration. Customers can optionally specify a drill URL for a custom drill.

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

Application Option to Register a File Application

Business Benefit: This feature allows a business user to easily import and register data from any file-based source by way of a file format, and requires limited technical help, if any, when loading into an EPM Cloud application. Additionally, customer can specify different file sources to logically group files based on content.

Key Resources

Announcement: Data Management Feature Migration to Data Integration

Starting with the September (23.09) update, the user interface pages 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.09 – we are only moving a few features now that have 100% parity with Data Integration. Profitability and Cost Management customers will not be affected by the migration and will see no change in their Data Management user interface. REST APIs are not impacted by this change.

Data Management Data Integration 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 was available in the June (23.06) update.
  • 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 build and manage EPM Cloud integrations more easily.

Key Resources

Data Integration Pipeline

New Job Types in Pipeline

In this update, new job types are available in the Pipeline:

  • Clear Cube—Clear specific data within input and reporting cubes. The Clear Cube job type deletes the data you specify within input and reporting cubes, but it does not delete the application definition in the application's relational tables.
  • EPM Platform Job—Execute various jobs supported by the “EPM Platform Jobs Framework” by providing the job name, job type, and parameters. Some jobs are expected to be defined in the corresponding EPM Cloud application, with some or all the required parameters saved within the job definition. For these job types, the parameters can be either provided within the job definition or overwritten at runtime. The parameters names should match the ones supported by the corresponding REST APIs. The remaining jobs can be triggered at runtime without a saved job definition.

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

Business Benefit: The Clear Cube job type enables customers to clear specific data within input and reporting cubes. The EPM Platform Job job type enables customers to execute jobs by providing the job name and type defined in the EPM Cloud business process for the job.

Key Resources

New Job Type in the Job Scheduler: Integration Pipeline

A new Integration Pipeline job type is now available in the job scheduler.

Applies to: FreeForm, Planning, Planning Modules

The new Pipeline feature orchestrates a series of jobs as a single process. In addition, you can orchestrate EPM Cloud jobs across instances from one location. Using the Pipeline, you get better control and visibility of full extended data integration process of preprocessing, data loading, and post processing jobs.

For information about creating and running a Pipeline process, see Using the Pipeline in Administering Data Integration for Oracle Enterprise Performance Management Cloud.

After creating a Pipeline process in Data Integration, you can schedule an Integration Pipeline job. To schedule an Integration Pipeline job in your business process and select job parameters, from the Home page, click Application, then Jobs, and then click Schedule Jobs. Scroll to the end of the jobs list to select the Integration Pipeline job.

Business Benefit: Use the Integration Pipeline job type to add and execute or run integrations in the Pipeline extracting metadata and data from an Enterprise Resource Planning (ERP) source system (a direct integration) or data from a file, and then pushing it to an Enterprise Performance Management (EPM) target application.

Key Resources

Smart View

Updated EPM Books Extension for Smart View

An updated EPM Books extension for Oracle Smart View for Office is now available to download and install. Along with general improvements and defect fixes, this update includes support for enhanced member selection in the POV, described in Member Selection Available for EPM Books POV when POV Definition is Set to Allow All Selections.

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

Business Benefit: Downloading and installing the latest EPM Books 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 EPM Books extension:

From within Smart View, in the Options dialog, Extensions tab, click the Check for Updates, New Installs, and Uninstalls link.

Select your business process instance, then follow the prompts.

Key Resources

Member Selection Available for EPM Books POV when POV Definition is Set to Allow All Selections

When editing the POV for an imported or exported Book in Excel using the Smart View EPM Books extension, users can now choose members using the Member Selection dialog if the Book designer has enabled member selection for one or more POV dimensions.

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

When a Book's POV setting is set to "Allow All Selections" instead of "Display Suggestions Only," viewers will see "Select..." as the last item in the POV drop-down list: For example:

New "Select" Item in POV Drop-down Menu

Choose the Select option to display the Member Selection dialog, from which any member in the dimension can be selected. In the following example, the user has selected Q1 for the Fiscal Calendar dimension:

Member Selection Showing Q1 Selected for the Book POV

Click OK in Member Selection to close the dialog, and then click OK in the Select POV dialog. A message notifies you that a refresh of the Book is in progress. Refresh the job in the Jobs Console until the job is complete and then reopen the Book.

Business Benefit: EPM Books users are now able to make POV selections that are not limited to only the suggested list of members.

Steps to Enable

To enable users to select from all members to which they have access for the Book Point of View:

  1. Open a Book in edit mode of the Book Designer.
  1. To set POV option for a dimension, click the Action icon next to a POV dimension.
  1. Toggle between Allow All Selections and Display Suggestions Only, choosing Allow all Selections to allow Book viewers to select from all members for the selected POV dimension.

Key Resources

Task Manager

Support for Data Exchange Integration Type and Task Type for Remote Account Reconciliation Connection

Task Manager now supports the end user integration and task type called Data Exchange for remote Account Reconciliation connection within Financial Consolidation and Close, Planning, Planning Modules, and Tax Reporting. It allows you to streamline the data exchange integration tasks with monthly close process.

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

Business Benefit: You can now run integrations defined in Data Exchange from Task Manager. This allows the integration of data loads defined in data exchange easily into the monthly processing schedule.

Key Resources

Run Data Integration Type and Task Type in Task Manager

Task Manager is enhanced with a new automated integration and task type called Run Data Integration that allows you to execute an integration or data load rule based on how periods are processed and the source filters. This integration is available for:

  • Local and remote Financial Consolidation and Close, Planning, Planning Modules, and Tax Reporting
  • Remote Account Reconciliation and remote Enterprise Profitability and Cost Management

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

Business Benefit: This allows the integration of data loads defined in Data Exchange easily into the monthly processing schedule.

Key Resources

Oracle Integration Cloud Generation 3 Support for EPM Adapter

Task Manager’s EPM Adapter is now supported within Oracle Integration Cloud 3. Task Manager uses the EPM Adapter to communicate with Oracle Integration Cloud to execute integrations.

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

Business Benefit: Oracle Integration Cloud Generation 3 provides the latest generation of Oracle Integration Cloud when extending Task Manager’s Intelligent Process Automation (IPA) to non-EPM cloud applications.

Key Resources

Digital Assistant

Digital Assistant Integration with EPM Help Center Search

When EPM Digital Assistant does not have an appropriate answer to match the utterance with an intent, the assistant responds to the user with a generic message, and provides an option to search the EPM Documentation Library.

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

Business Benefit: This functionality provides the user an option to search the EPM Documentation Library when the assistant does not have relevant information for an utterance.

Key Resources

  • Getting Help in Getting Started with the Digital Assistant for Oracle Cloud Enterprise Performance Management

Activity Report

Display of Skip Update Requests

The Activity report has been updated to include information on skip update requests set for the 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

The Activity Report generated after you set skip updates to an environment now indicates the monthly updates that will be skipped for the environment. Skip update requests are reported in the Operational Metrics table.

Operational Metrics

Business Benefit: The Skip Updates information helps you identify the monthly updates during which your environment is exempted from the monthly update cadence.

Role Assignment Report

Report Generation Refreshes User and Role Information

Starting with this monthly update, generating the Role Assignment Report or the Provision Report results in updated user information being populated in Access Control screens and reports. For example, if you assign some users to predefined roles and then generate Role Assignment Report using the roleAssignmentReport EPM Automate command, the Role Assignment Report REST API, or using Access Control, the list of users shown in Access Control screens will reflect the most up-to-data information available in your identity domain, including new users and changes in role assignments. Additionally, data in Access Control will be refreshed to remove deactivated and deleted users.

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 change provides an easy way to get up-to-date user information in Access Control.

Key Resources

  • Generating Reports in Administering Access Control for Oracle Enterprise Performance Management Cloud

Deactivated Users not Included

Starting with this monthly update, OCI (Gen 2) EPM Cloud business processes considers deactivated users as being similar to users not assigned to predefined roles even though such users may have been assigned to predefined roles. Information on deactivated users are not included in the Role Assignment Report. You can generate the Role Assignment Report using the roleAssignmentReport EPM Automate command, the Role Assignment Report REST API, or using Access Control.

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: Not including deactivated users in the Role Assignment Report helps you figure out the active users that have been provisioned to access EPM Cloud environments.

Key Resources

Account Reconciliation

Increase in the Number of Transactions Selected in the Unmatched Transactions Tab

Users can now select up to 20,000 transactions in the Unmatched Transactions tab of the Matching dialog. You can perform the following operations on the selected transactions: create exact match, create match with adjustment, adjust, delete, and edit. For the support action, users can select up to 5,000 transactions.

Business Benefit: This feature enables users to perform actions on a larger number of unmatched transactions.

Key Resources

Additional Runtime Metrics in the Activity Report

The Activity report has been updated to include these additional Account Reconciliation runtime metrics.

  • ARCS TM Transactions Supported in 1 Day: This metric identifies the number of transactions for which additional justification  for why they could not be matched in a given period was provided over the last 24 hours.
  • ARCS TM Transactions Supported in Last 30 Days: This metric identifies the transactions for which additional justification  for why they could not be matched in a given period was provided over the last 30 days.

Account Reconciliation Runtime Metrics

Business Benefit: Updates to the Account Reconciliation metrics help you identify the number of transactions for which additional justification for why they could not be matched in a given period was provided.

Enterprise Data Management

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

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 Cloud Platform section.

Narrative Reporting

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

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

Planning

Support for Calendars and Events in IPM Insights, Auto Predict, and Predictive Planning

When defining IPM insights, Auto Predict predictions, and when running Predictive Planning from forms on the web, you can now specify a calendar and events to associate with the prediction. Events are typically one-off or recurring events that historically led to spikes or declines in the data. You can choose to take these spikes or declines into consideration during predictions, so that historical spikes or declines are also reflected in future predictions. For example, a North American calendar might include an event for Christmas, or an APAC calendar might include an event for Diwali, when sales would typically spike. By including the historical data spikes in the prediction, you see the spikes in the predicted data, so you can plan ahead for volume or to make use of the opportunity.

Without events, spikes or falls in data are normalized and distributed over the prediction period, potentially leading to less accurate predictions.

Alternatively, you can choose to skip the historical data spikes or falls, so that the data for the event is completely excluded from the prediction.

These dashboards illustrate the effect of including events in the prediction.

In this example, the upper chart shows the historical data, which includes several spikes. The lower chart shows the prediction results without events. Notice that the predicted data is spread and normalized so that there are no spikes.

Prediction Without Events

In this example, the upper chart shows the same historical data, which includes several spikes. The lower chart shows the prediction results with events. Notice that the spikes are evident in the predicted data. In this example, using events significantly improves the prediction accuracy.

Prediction With Events

The user interface is updated to support calendars and events in IPM Insights, Auto Predict, and Predictive Planning.

To use calendars and events with IPM Insights and Auto Predict:

  1. Define calendars. From the Home page, click IPM, then click Configure, and then click the Calendar tab.
  1. Define events. From the Home page, click IPM, then click Configure and then click the Events tab.
  1. When configuring an IPM Insights job or an Auto Predict prediction definition, associate a calendar with the insight or Auto Predict job. Then, select whether to include events in the prediction. From the Home page, click IPM, then click Configure, and then click the IPM tab. Events are an option for the Anomaly insight job type and Auto Predict.

Select Calendar Page of IPM Configuration

Events and calendars are also available in non-Redwood themes for use with Auto Predict and Predictive Planning in forms and for Auto Predict users without access to IPM Insights, such as legacy non-Enterprise SKU users:

  1. From the Home page, click Application, then click Overview, and then from the Actions menu, select Auto Predict.
  2. From the Actions menu, select Calendar to define calendars or select Events to define events.

You can use calendars and events with Predictive Planning on forms.

  • When designing a form, the Form Designer Layout tab now includes Prediction Options to specify a calendar to associate with the prediction for the form, and an option to select whether to include events in the prediction by default. This selection is saved with the form, so it is the default option for all users of the form.
  • When running a prediction from a form, you can use the Settings option to select a calendar to use for the prediction and whether to include events in the prediction. Use the Chart Settings to specify whether to show events on the chart. You can also choose to exclude Skip events. Changes to these settings are for the current user session. These settings revert to defaults for each new login session.

Events in Predictive Planning on a Web Form

You can import events from a csv file using an events template file. (You can create an events template file by exporting events you’ve already created; use this file as the import template for other events.) To import events, on the Events tab of IPM Configure, click Import Events, select the file, and then click Import. You can then review the Import Events job. From the Home page, click Application, then click Jobs and then click the Import Events job that was run. This process is valuable for auditing and troubleshooting event definition.

Business Benefit: Without events, spikes or falls in data are normalized and distributed over the prediction period, potentially leading to less accurate predictions. Using events helps you plan ahead for the events and take advantage of opportunities by allowing you to see anticipated spikes and falls in the predicted data for specific events. Using events with IPM Insights, Auto Predict, and Predictive Planning simplifies predictions and significantly improves the prediction accuracy for complex and volume based industry verticals such as air travel, public transportation, retail, E-commerce, brick and mortar stores, FMCG, and automobiles.

Tips And Considerations

  • Defining events and calendars is optional.
  • Events are available only on the web, not in Smart View. Because events aren’t supported in Smart View, if you run a prediction on a web form that includes events, and then you open the same form in Smart View and run a prediction, you might see different prediction results on the web and in Smart View.
  • You can use calendars with each insight type and with Auto Predict. Events are an option for the Anomaly insight job type and Auto Predict.
  • Events and calendars are available in non-Redwood themes for use with Auto Predict and Predictive Planning in forms and for Auto Predict users without access to IPM Insights, such as legacy non-Enterprise SKU users.
  • If you define a Skip event that is shorter than your seasonality, it can affect the accuracy of the historical data. For example, you might define an event for Covid that is three months long, but your season is twelve months, so that you have only nine months of data. You lose seasonality because the data is skewed. In these cases, it might be more effective to skip the entire season.

Key Resources

Profitability and Cost Management

See Oracle Support Document 2955235.1 (Oracle Profitability and Cost Management Application Type Statement of Direction)

Simplified Calculation Process for Reclassification Rules

The calculation process for reclassification rules has been simplified. In the Execution Statistics Report, these rules show as rule type SR or CR.

Business Benefit: This feature potentially reduces the run times for SR and CR rule types. It may also result in fewer scripts and fewer cells being updated.

Key Resources

Enterprise Profitability and Cost Management

Simplified Calculation Process for Reclassification Rules

The calculation process for reclassification rules has been simplified. In the Calculation Statistics Report, these rules show as rule type SR  or CR.

Business Benefit: This feature potentially reduces the run times for SR and CR rule types. It may also result in fewer scripts and fewer cells being updated.

Key Resources

Ability to View a Complete Rule Definition for a Single Rule

You can now view the complete rule definition (rule details, rule set details, member selections, and formulas) for each rule displayed on the Waterfall Setup tab, the Mass Edit tab, and the Rule Balancing page.

Business Benefit: The ability to view a complete rule definition for a single rule all on one page without having to scroll through all the rules in the Model Documentation report is valuable as you create and manage your rules.

Key Resources

Tax Reporting

Review the Important Actions and Considerations section for Audit Purge related information.

Translation to Reporting Currencies When an Entity is Locked

You can now translate data to a reporting currency even if the entity is locked and its calculation status is “OK” or “System Changed”.

Business Benefit: This change eliminates the need for users to unlock an entity before translating data to a reporting currency, and enables the entity to remain locked for consolidation.

Key Resources

Enhanced Periodic Currency Translation

Tax Reporting is now enhanced to make Period P13 and P14 use Periodic Foreign Exchange (FX) translation instead of Year-to-Date (YTD) translation. You can enable this feature in Tax Settings (Application - >Configuration -> Tax Settings -> Currency Translation for P13 and P14 -> select Enable Periodic Currency Translation for P13 and P14 checkbox).

Business Benefit:

With this new capability:

  • After finalizing P12 and copying as a starting point for the return in P13, the values can be translated using periodic methodology
  • When P13 is finalized, the values can be analyzed between P12 and P13

Key Resources

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.

This update includes Important Actions and Considerations for:

  • EPM Cloud Platform
  • Account Reconciliation
  • Planning
  • Profitability and Cost Management
  • Enterprise Profitability and Cost Management
  • Financial Consolidation and Close

EPM CLOUD PLATFORM

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. Customers are encouraged to deploy their applications using Redwood theme only.

Customers are encouraged to watch the 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.

Effective during the first quarter of 2024 (subject to change, safe harbor applies), the Redwood Experience will offer a default Oracle theme and these two additional appearance options: Custom Light and Custom Dark. Appearances of all EPM Cloud environments that currently use the Redwood Experience will automatically be shifted to either the default Oracle theme or the Custom Dark theme based on currently deployed background appearance of these environments.

Environments that have not deployed Redwood Experience will not currently be impacted by this change. In an update planned for the second quarter of 2024, Oracle will automatically migrate these environments to use the Redwood Experience.

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

Embedding Google Sheets, Google Drive Files, and Microsoft Office 365 Files in Navigation Flows

Customers can embed the third-party pages listed below in EPM Cloud Application navigation flows. Though not supported by Oracle, using instructions provided by the third-party sites, you can now embed links to these resources within navigation flow cards, tabs, and sub tabs:

  • Google Sheets
  • Files stored in Google Drive (for example, PDF and Excel)
  • Files stored in Microsoft Office 365

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

For more information about embedding third-party pages in EPM Cloud applications, see the following documentation:

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

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

EPM Cloud environments on OCI (Gen 2) are transitioning from Identity Cloud Service (IDCS) to Identity and Access Management (IAM) domains. For information on IAM, see Overview of Identity and Access Management.

After this transition, existing IDCS administration and My Profile functionalities remain the same, but are hosted on Oracle Cloud Console. The Oracle Cloud sign-in page has an updated design to match the latest Oracle Cloud design guidelines. To learn more on what to expect with this transition, see Introducing OCI IAM Identity Domains: What customers need to know.

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

As of the June (23.06) update, the Enhanced Integration API and Drill Type UI options have been removed from the list of options in the System Settings option of Data Management.

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

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

Plan to Disable the Print Option in Web Ad Hoc Grids and Forms 2.0

Starting with the September (23.09) update, we are disabling the print option within Web ad hoc grids. Forms 2.0 (to be released soon) will also not have a print option. You can use the browser's print feature or the Excel Print feature in Smart View if you require printing.

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

Removal of Support for Custom Application in Data Management

Starting with the September (23.09) update, custom target applications can no longer be added in Data Management. This type of application was used to extract data from the EPM Cloud, and then the data was pushed into a flat file instead of being loaded to an EPM Cloud application. The custom application was superseded by the Data Export to File feature in an earlier update. The Data Export to File feature has enhanced functions and capabilities.

If you still have a custom target application, it is recommended that you use the Upgrade Custom Applications option to migrate your existing custom target application to a data export to file application. For more information, see Upgrade Custom Applications at: https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/erpia/upgrade_custom_applications_100x438d5119.html.

The migration converts existing file formats from the custom target application to the file formats used in the data export to file option and retains all the existing setup. When the custom target application has been converted, you can run same integration as before. Data export file applications are available both in Data Management and Data Integration.

Applies to: Account Reconciliation, 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

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

Report Import/Export to Excel: Font Installation Requirements for Text Boxes in Excel

Due to performance and rendering quality enhancements to Report text boxes when exported to Excel, Report text boxes may appear distorted or with overlapping text while importing or exporting to Excel when the fonts used within the text boxes are not installed on the client machine. To fix this, install the missing fonts used within the text boxes on the client machine.

Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Narrative Reporting, 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)

Please note that the Oracle Financial Reporting tentative deprecation dates have been moved to mid-to-late CY24.

For more information:

  • On June 8, the most recent Oracle Cloud Customer Connect event, Migrating Your Financial Reporting to Reports, was presented. There is a presentation, an event recording, and an FAQ sheet accessible. In order to view the event recording and documentation, you must log in to Cloud Customer Connect.

ACCOUNT RECONCILIATION

Changes to Application Roles

The Drill Through and Calculation Manager applications roles had no effect in Account Reconciliation and are no longer displayed.

FINANCIAL CONSOLIDATION AND CLOSE

Change to Reversal of Loading Closing Balance Input

Prior to this update, you could not utilize Closing Balance Input for both Balance Sheet and P&L in the same file and have reversals zero out closing balance. This was because previously Financial Consolidation and Close reversed out the previous period’s Periodic closing balance and carried over the P&L from the prior year in the first period. Starting in this update, Financial Consolidation and Close is now reversing the YTD closing balance from the prior period, and is not reversing for FCCS_Net Income/FCCS_Owner’s Income in the first period. This allows you to be able to load to Closing Balance Input for both Balance Sheet and Income accounts.

Enterprise Journal Dimension Persistence

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

FCCS_Global Assumptions Member

As of the June (23.06) update, the FCCS_Global Assumptions member and its descendants (if any), from the Entity dimension are restricted member(s) for On Demand Rules. 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.

Metadata Validation Update

The Metadata Validation process will no longer display an error for this condition: “Children of Parent with Data Storage Label Only Must not Aggregate”. When you add a child member under a parent with the Label Only property in the Account, Data Source or Movement dimension, the Label Only child member property does not need to be set to Ignore or Never. The removal of this restriction will eliminate potential errors in the FCCS_Balance Sheet hierarchy.

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.

Substitution Variables

Substitution variables allow you to enable or disable new Financial Consolidation and Close features as needed. The following substitution variables are available:

  • ReportingTransEPAEEA

When enabled, the FCCS_Entity Proportion Adj and FCCS_Entity Elimination Adj members are translated to Reporting Currency.

Starting in the October (23.10) update, the default value will be set to True, and this feature will be enabled by default.

  • ExtendMovementScope

When enabled, the Movement members that are created outside of the FCCS_Movements hierarchy will be included in translation and consolidation calculations.

Starting in the September (23.09) update, the default value will be set to True, and this feature will be enabled by default.

PLANNING

Sales Planning Statement of Direction

Please refer to the Statement of Direction for Oracle Sales Planning Cloud Service (SPCS): Oracle Support Document 2963628.1 (Oracle Sales Planning Cloud Service Statement of Direction). Oracle will discontinue offering Sales Planning Cloud Service (SPCS) in September 2023. The replacement product for SPCS is Enterprise Performance Management (EPM) Enterprise Cloud. There will be no loss in functionality with this change in product licensing. Sales Planning is scheduled to be a separate application type within the EPM Enterprise Cloud Planning Business Process.

The timing of this change and discontinuation of old price list product numbers is scheduled for September 2023. Customers should plan to replace their SPCS subscriptions with EPM Enterprise Cloud. In order to avoid interruption to your SPCS subscription, Oracle recommends executing a replacement order at least sixty (60) days in advance of the SPCS Date of Termination. Customers should speak with their Oracle Sales Representative to prepare for this change

Strategic Workforce Planning Statement of Direction

Please refer to the Statement of Direction for Oracle Strategic Workforce Planning Cloud Service (SWPCS): Oracle Support Document 2963631.1 (Oracle Strategic Workforce Planning Cloud Service Statement of Direction). Oracle will discontinue offering Strategic Workforce Planning Cloud Service (SWPCS) in September 2023. The replacement product for SWPCS is Enterprise Performance Management (EPM) Enterprise Cloud. There will be no loss in functionality with this change in product licensing. Strategic Workforce Planning is scheduled to be a separate application type within the EPM Enterprise Cloud Planning Business Process.

The timing of this change and discontinuation of old price list product numbers is scheduled for September 2023. Customers should plan to replace their SWPCS subscriptions with EPM Enterprise Cloud. In order to avoid interruption to your SWPCS subscription, Oracle recommends executing a replacement order at least sixty (60) days in advance of the SWPCS Date of Termination. Customers should speak with their Oracle Sales Representative to prepare for this change.

PROFITABILITY AND COST MANAGEMENT

Oracle Profitability and Cost Management Application Type Statement of Direction

The Oracle Profitability and Cost Management Application Type Statement of Direction provides an overview of the strategic plans and future direction of Oracle Profitability and Cost Management Cloud Service and Oracle Enterprise Performance Management Enterprise Cloud Service Profitability and Cost Management Business Process. Included is information about the change in Development focus to the newer Enterprise Profitability and Cost Management Application Type available exclusively with Enterprise Performance Management Enterprise Cloud Service.

Oracle Support Document 2955235.1 (Oracle Profitability and Cost Management Application Type Statement of Direction)

ENTERPRISE PROFITABILITY AND COST MANAGEMENT

Purging of Old Calculation Run Records

Each calculation rule execution logs several statistics about its execution that are used to populate the Calculation Statistics Report. For models with many rules, the volume of these statistics can accumulate quickly. To maintain responsiveness in the Calculation Analysis screen where calculation runs are viewed, Enterprise Profitability and Cost Management automatically purges old calculation run records and their associated statistics when the volume of runs or statistics grows to exceed certain thresholds. If you want to retain a longer history of calculation runs, it is best practice to frequently use the Export to Excel feature in the Calculation Analysis screen to archive calculation runs.