Here is what is coming to your EPM instances as part of the July 2025 Updates. I missed publishing the June updates. However, I am planning a video to show you some of the updates form June. So watch out for that.
You can also read this article on Linkedin.
Integrations
Smart Split Data Load
A new Smart Split feature is available in Data Integration when importing a large volume of data that exceeds Essbase governor limits. This feature enables you to split a data load into multiple smaller loads by enabling you to define smaller data slices without having to create multiple integrations.
Steps to use the Smart Split feature:
create a base integration definition with the data to be loaded from the source application
Create a pipeline and use the new Integration with Smart Split job type in the Pipeline
Specify the integration name, Split dimension, Import and Export modes, Start and End periods, and Split method
Here is an example of how it would look like. Pay key attention to the additional parameters: Split Dimension, Split Method, Number of Groups etc.
Image Courtsey : Oracle
I will be creating a separate detailed blog and video about this feature in the coming days. Increasingly, Oracle is pushing new features in Pipeline. If you are not yet utilizing Pipeline, please do. If you organization is looking to learn more, please free to connect with me.
New Application Role - Data Integration - Administrator
The Data Integration - Administrator application role can now be assigned to any user, regardless of their predefined role. Users with this role are able to:
Create and manage integrations between source and target systems
Execute and monitor pipeline activities
Perform data and metadata extraction and transformation from on-premises sources using the EPM Integration Agent
FCC (Financial Consolidation and Close)
Here are the updates that are coming to FCC instance. It is great to see the option to add additional BSO Cubes and the support for IPM insights.
Ability to Create Additional Block Storage Cubes
You can now create four additional block storage cubes to store metadata and data. The cubes can be enabled by the Service Administrator on an as-needed basis. Note that when a cube is enabled, it cannot be disabled.
This feature is only for Dense/Sparse Optimized (DSO) applications.
This feature is only available on a restricted basis. Adding additional cubes results in more maintenance required for the application, so it is recommended only for specific use cases. To enable this feature, you must submit a technical Service Request (SR).
Support for IPM Insights
Financial Consolidation and Close now supports IPM Insights. To get started with IPM Insights, administrators configure insights and then run them. They can also schedule them to run on a regular basis. Users can then review and analyze insights on the Insights dashboard, and take appropriate action to improve the close process.
Considerations
IPM Insights requires an EPM Enterprise Cloud service subscription.
IPM Insights works with applications with Hybrid Essbase enabled.
IPM Insights only works with Dense/Sparse Optimized (DSO) applications.
Consolidation Job Analytics
It was intersting to see this one. I will have to see this in action to understand how useful of a feature this is.
A new Consolidation Setting called “Consolidation Job Analytics” is available. When this setting is enabled, a GenAI-based job summary will be generated for Consolidation jobs when the jobs have completed. You can view the analytics from the Job Details for the completed jobs in the Jobs console.
To use this setting, you must also enable the GenAI option application setting. From the Home page, click Application > Settings > Enable AI section > Generative AI.
Account Reconciliation
Bank Text Column Increased to 1200 Characters
When loading transactions using BAI Format Bank files, the Bank Text can now be up to 1200 characters long. Three new columns, Bank Text2, Bank Text3, and Bank Text4, are added.
If the Bank Text exceeds 300 characters, one or more of these new columns are used to store the Bank Text.
REST APIs
There are a few new REST APIs that will be introduced as part of the July updates. And enhancements to existing REST APIs.
REST APIs for Managing Users and Groups
List Users : generates a list of available users in the environment. This API identifies the userlogin, firstname, lastname, and email. Additionally, it can provide information about the EPM groups the users belong to and the application roles assigned to the users.
List Groups : generates a list of available groups in the environment. The API identifies the group name, description, type, and identity. Additionally, it can provide information about the groups/user members belonging to the groups and the application roles assigned to the groups.
User Login Report : generates a report for all the users logged into the environment. The report can be created for a specific user login and/or within a valid date range.
I am hoping we get JSON data back while using these REST APIs. I will be trying this out.
Get Available Roles REST API
The optional type query parameter has been added to the Get Available Roles REST API. This parameter can take the following values:
Enhancements to Role Assignment Report REST API
The Role Assignment Report Synchronous API has been enhanced to search for users across all user attributes (userlogin, firstname, lastname*,* and email). Previously, this API limited the search to the userlogin attribute.
Enhancements to the User Group Report REST API
The User Group Report synchronous API, which lists the direct or indirect membership of users assigned to groups, has been enhanced to search for users across all user attributes (userlogin, firstname, lastname*,* and email). Previously, this API limited the search to the userlogin attribute.
Those are major updates. There is a new version of SmartView, so make sure to update your SmartView.
What is your favorite feature form July updates? I am hoping to see more Gen AI and Pipeline features coming soon. Additionally, I am looking forward to seeing Advanced Prediction capabilities and Operational Modeling coming to EPM.
Here is a quick tip to all Oracle EPM consultants. Start learning Oracle Apex. I know it is one more new item to our ever growing list. However, you start learning now and you will thank me later. :)
