Oracle EPM - Advanced Predictions Now Available

 Advanced Predictions Now Available

This is the big one for the month. Advanced Predictions brings multivariate predictions to Auto Predict. Up to now, Auto Predict used univariate predictions. 

What does that mean, you ask? In basic terms, univariate predictions are based on one variable, such as analyzing historical sales volume to predict future sales volume. 

Multivariate predictions bring in the ability to use more than one variable to predict future data. For example, you can analyze volumes, average sales prices, and GDP rates to predict future sales volume. 

Multivariate will make Auto Predictions more accurate. Before this update to take advantage of multivariate predictions, you would need to bring in an ML model created outside of EPM (which is still available).

Some important considerations.

• You must opt in to use Advance Predictions
• You must have an EPM Enterprise subscription
• There is no additional cost required to deploy OCI Data Science; it is embedded in Fusion Cloud EPM
• Explainability is only available on the web and not in Smart View
• Lastly, this appears to only apply to Auto Predict and not Predictive Planning.

Oracle EPM August 2025 update - New Audit and Jobs Roles !

 New Audit and Jobs Application Roles

Four new roles are available to give users the ability to review audit and job information. 

The roles are

Audit – Manage: Allows users to view and delete audit records

Audit – View: Allows users to view audit records

Jobs – Manage: Allows users to view and delete job status records

Jobs – View: Allows users to view job status records

Oracle ARCS - Loading Bank Files - New Length Format !

Oracle Account Reconciliation and Loading Bank BAI Files 

Length of Bank Text Column Increased to 1200 Characters When Using BAI Format Bank Files

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. For example, if the Bank Text is 850 characters, then it is loaded into the Bank Text, Bank Text2, and Bank Text3 columns.

Business Benefit: This feature enhances the usability of BAI Bank Format files by allowing users to load longer Bank Text values and then use these during matching.

Integrating BAI, SWIFT MT940, and CAMT.053 Format Bank File Transactions

When loading bank file data, you create a data source associated with the bank file source system. Data Integration converts the BAI, SWIFT MT940, or CAMT.053 file formats to CSV format for loading into Transaction Matching. The CSV load file can be viewed in the Transaction Matching Jobs results.

The source application for BAI Format Bank File Transactions has the following pre-defined constant columns and headers:

• Account
• Amount
• Transaction Type
• Currency
• Transaction Date
• Bank Reference
• Customer Reference
• Bank Text
• Bank Text2, Bank Text3, and Bank Text4

The source application for a Swift MT940 Format Bank File Transactions has the following pre-defined constant fields:

Oracle EPM - New Data Integration Administrator Role !

In the July 2025 update, we have seen Oracle release a new  Application Role - Data Integration - Administrator

The Data Integration - Administrator application role can now be assigned to any user, regardless of their predefined role, allowing broader access to all functional activities within Data Integration. 

Users with this role can:

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

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

Business Benefit: This update supports flexible role-based access, empowering non-Service Administrators to take ownership of data integration tasks, improving efficiency and operational control across teams.