EPM November 2025 Updates

The November 2025 Oracle EPM updates are on the way. Some great updates to Advanced Predictions as well as several other ones. Updates will go to test environments November 7^th and prod environments November 21^st. Here is my summary.

Upgrade of All Environments to Essbase Version 21.7.xx

All Cloud EPM environments will be upgraded to Essbase version 21.7.xx. An important aspect of this upgrade is that environments on 21.7.xx cannot be imported into an environment on version 11.1.2.4.516.xxx. However, the opposite can be done, version 11.1.2.4.516.xxx can be imported to 21.7.xx environments. Keep this in mind if you have any plans in November for migrating from Test to Prod. You can check the Essbase version of your environment from Overview>Activity Reports.

New Migration REST APIs

New migration REST APIs will help to automate the EPM lifecycle. I think the two I find most interesting are “Updated Artifacts” and “Get Snapshot Modification History”. Here is the full list.

Get Artifact Categories: This API gets the artifact categories, which group the artifacts based on the modules used by the business process.
List Artifacts in a Category: This API lists the details of different artifacts available within a specific category.
Export Categories Artifacts: This API creates an incremental backup of specific artifacts in a category in the environment. Generally, you use incremental backup of artifacts of a category to update another environment with incremental changes.
Updated Artifacts: This API lists the application artifacts modified in a specific date range. This API retrieves information similar to that present in the Artifact Updates Report.
List Snapshot Details: This API gets the list of categories within the snapshots available in the environment and the actions that can be performed with the snapshot.
Get Snapshot Modification History: This API lists the application artifacts that were modified after the snapshot was originally created. Identifying changed artifacts helps you create new snapshots to back up the changes. This API retrieves information similar to that contained in the Modification History report.
List Artifacts in a Snapshot: This API gets a list of all artifacts of a specified category within a snapshot.
List Import Options: This API gets the import option effective in the environment for the groups and group members information available in snapshots. This option specifies the conditions for importing group membership data of users and groups into an environment from snapshots.
Set Import Options: This API sets the import option that specifies how the import of group membership is handled during import of groups from a snapshot or file.
Get Migration Status: This API gets information on the artifact migrations that were performed. This API retrieves information similar to that contained in the Migration Status report.

Updates to the recreate EPM Automate Command and REST API

The recreate command is being improved to make all archived snapshots in Oracle Object Storage unusable if the option is set to true. This will ensure that all artifacts related to the environment being recreated are rendered unavailable.

Support for Substitution Variables in simulateConcurrentUseage EPM Automate Command and REST API

The Open Form and Save Form use cases in simulateConcurrentUseage could not use substitution variables. That is now corrected and substitution variables can be utilized.

Mandatory Groovy Update Scheduled for 26.01

While originally planned for November, and then rescheduled for December, this update is now happening in January 2026. The Groovy engine is being updated with stricter validation rules. Check your scripts ASAP and make necessary corrections now to avoid problems later. I wrote recently about the script validator.

Updated EPM Books Extension for Smart View

There is an updated EPM Books extension for Smart View. As always, I recommend updating Smart View extensions when they are available.

Additional Parameters Available for RelativeMember Function in Reports

Two optional parameters are being added to the RelativeMember member selection function in Reports. Relative Member List allows the use of a member list for the selection of the member. Use First Descendant returns the first descendant under the specified member parameter.

Advanced Predictions: Explainability Enhanced with Feature Importance

The explainability function in Advanced Predictions is being improved with a Feature Importance panel. This will show the influence of the drivers on the target in a chart form.

Advanced Predictions: Prediction Accuracy Improved with Feature Engineering and Feature Selection

Another improvement to Advanced Predictions, this one can perform Feature Engineering and Feature Selection on data before running predictions. This will improve prediction accuracy.

Advanced Predictions: Ability to Generate Advanced Predictions for Dynamic Calc Members

And yet another improvement to Advanced Predictions! Dynamic Calc members can be used to generate Advanced Predictions. There are some important considerations to use this functionality, be sure to read the documentation to fully understand.

Auto Predict: Enhanced Configuration for Auto Predict and Ability to Generate Auto Predict Predictions for Dynamic Calc Members

This is a welcome improvement. Auto Predict can now use Dynamic Calc members for source data. And, like the above with Advanced Predictions, Dynamic Calc members can be used as targets for the predictions. Refer to the documentation for important details.

Upper-Level Data Entry in FreeForm Grids

Significant improvement to FreeForm grids, data can now be entered directly at parent members. This helps with top-down planning allowing users to input, allocate, and refine summary level targets similar to traditional Essbase. To enable this feature, select Upper Level Write Back in Application Settings in the FreeForm application.

Updated Narrative Reporting Extension for Smart View

There is an updated Narrative Reporting extension for Smart View. As always, I recommend updating Smart View extensions when they are available.

New Profitability and Cost Management Application Settings

EPCM is being updated with new application settings.

Allocation Rules Use Non Empty Tuple: Indicates whether Non Empty Tuple (NET) optimization is enabled. Allocation rules on sparse cubes may perform better by setting this preference to “Yes”.
Skip Scripts When Data Missing (Beta): Indicates whether Skip Scripts optimization is enabled. Selecting “Yes” allows allocation rules to skip processing steps when data conditions make them unnecessary, thus improving performance.
Skip Scratch Cell Generation (Beta): Indicates whether scratch cell optimization is enabled. Selecting “Yes” skips unnecessary rule execution steps and improve allocation rule performance.
Designer Version: Which version of the Rule Designer to open. Designer 1.0 opens the older version of the Rule Designer. Designer 2.0 opens the new Rule Designer UI with enhanced features.

IMPORTANT Actions and Considerations

I missed this in a previous update.

Accelerator Templates Available in the EDM Sample Application

Starting with the October (25.10) update, the accelerator application templates for Oracle Financial Services Accounting Foundation Cloud Service (AFCS) and Oracle Financial Services Data Foundation Cloud Service (DFCS) applications can be exported from the EDM Sample application. Accelerator application templates help to expedite the application creation process in EDM by providing a template that contains the basic dimensions, node types, properties, and validations for an application so that you do not have to create all of those objects manually. Previously, these templates were only available by entering a service request. For additional information, see Working with Accelerator Applications in Administering and Working with Oracle Fusion Cloud Enterprise Data Management.

As usual, I only highlighted a portion of what is coming. Check out the full document and be prepared when environments are updated.

As always, happy EPM’ng!