Oracle EPM April 2026: Two Quiet Changes That Can Break Your Automations

The April 2026 (26.04) Oracle EPM update looks calm on the surface — but behind the scenes, two technical changes can impact almost every EPM technical team if they’re not spotted early.

This blog focuses on only two changes, but both are high‑risk if ignored:

1. EPM Automate – Windows installation path change
2. Groovy rules – HTTP (insecure) authentication now disallowed

Both are documented by Oracle, but neither will show up as a shiny UI banner. If you rely on automation, scripts, or Groovy‑based integrations, this blog is for you.

All About Oracle EPM FreeForm!!

 If you’ve ever tried to force a complex planning or reporting problem into a standard Planning application, you already know the pain: required dimensions that don’t fit, workaround hierarchies, and logic that feels “almost right”—but never quite clean.

That’s exactly the gap Oracle FreeForm apps were designed to fill.

FreeForm is not a lighter version of Planning, and it’s not just Essbase in the cloud. It’s Oracle EPM’s most flexible application type, built for scenarios where your business model should dictate the structure—not the other way around.                                   Refer Doc -[docs.oracle.com]

 

All about Advanced Predictions in Oracle EPM.

Advanced Predictions – Why This Feature Matters

Forecasting in the real world is rarely driven by a single number. Revenue is influenced by pricing, promotions, volume, market growth, seasonality, macro‑economic conditions, and many other factors. Until now, Oracle EPM’s Auto Predict and Predictive Planning features looked at only one measure at a time, which limited how realistic and explainable forecasts could be.

With the August 2025 Oracle Cloud EPM release, Oracle introduces Advanced Predictions – a significant shift toward driver‑based, machine‑learning forecasting that feels native to finance teams, not data scientists.

Unlocking EPM Power: Get User Variables with Oracle Planning REST APIs!

Retrieving User Variables in Oracle EPM Using REST APIs

If you’re building integrations with Oracle Enterprise Performance Management (EPM), sooner or later you’ll run into User Variables. They are everywhere—driving form personalization, security filters, default selections, and even calculation behavior.

The good news? Oracle EPM provides powerful REST APIs that let you retrieve user variable values programmatically.

In this blog, we’ll break down two commonly used REST APIs:

• GetUserVariablesForUser
• GetUserVariablesForUserAndMember

You’ll learn:

• What user variables are and why they matter
• When to use each API
• How to call them
• What the response looks like
• Common real‑world use cases

All examples and explanations are provided with reference 

 

What Are User Variables in Oracle EPM?

User Variables are configurable placeholders that dynamically resolve to dimension members based on the logged‑in user. They are widely used across Planning, FreeForm, FCC, and other EPM modules to personalize the experience.

Typical use cases include:

• Default Entity, Version, or Scenario for a user
• Security‑driven data access
• Dynamic filtering in forms and dashboards
• Personalized calculations and rules

From a technical perspective, user variables help avoid hardcoding dimension members and allow applications to scale across users with different responsibilities. [docs.oracle.com]

 

Why Retrieve User Variables via REST APIs?

While user variables are usually set and managed through the UI, integrations often need them programmatically. Common scenarios include:

• External applications that need to respect EPM personalization
• AI agents or middleware dynamically resolving context
• Audit and validation of user setup
• Mass analysis of user configurations
• Integration testing and automation

Oracle addresses these needs through the User Variable Values REST APIs available in Planning REST API v3. [docs.oracle.com]

 

API #1 - What This API Does

This API retrieves ser variable values set for all users and for all user variables defined for the application.

 

REST Endpoint

GET {{BASE_URL}}/HyperionPlanning/rest/v3/applications/EPBCS/uservariablevalues

Response

API #2 - What This API Does

To retrieve user variable values set for all users for a user variable with a specific name.

REST Endpoint  

GET {{BASE_URL}}/ /HyperionPlanning/rest/v3/applications/EPBCS/uservariablevalues/Asset - Buy

API #3 - What This API Does

GET {{BASE_URL}}//HyperionPlanning/rest/v3/applications/EPBCS/uservariablevalues?q={"userName":"dayalan.example@example.com"}

to retrieve user variable values for one or more users.

Example Use Case

• An external planning portal needs to open with the same defaults as EPM
• A batch job validates that users have all mandatory variables assigned
• AI‑driven workflows resolve default dimension context before executing rules

 

 

Security and Access Considerations

• Service Administrators can retrieve variables for any user
• Regular users can retrieve only their own variables
• APIs follow standard EPM REST authentication (Basic Auth or OAuth2)

Oracle also enhanced these APIs in recent releases to allow retrieving multiple users’ variables in a single request, improving performance for administrative use cases. [docs.oracle.com]

 

Real‑World Integration Patterns

Here’s how these APIs are commonly used in modern EPM architectures:

• AI agents translating natural language into EPM actions
• Data pipelines aligning user context across systems
• Automated testing validating environment consistency

If you’re building an EPM Control Center, middleware, or AI‑driven workflow, user variables are often the first API call you make.

 

Final Thoughts

User variables may look simple on the surface, but they are foundational to personalization and security in Oracle EPM. Oracle’s REST APIs make it easy to retrieve them in a clean, scalable, and secure way.

 

If you’re building advanced integrations or AI‑powered solutions on Oracle EPM, mastering these APIs is a must.

 

 Happy days on the cloud!

Dynamic Period Locking Using Smart List in Oracle EPM (using Groovy Rule)

Have you ever faced the challenge where business users need flexibility to edit data in some months, but strict control in others? This is a common scenario in Oracle EPM Planning, and managing it manually can quickly become a headache. Luckily, there’s a way to automate this process using Smart Lists combined with a Groovy rule—making your forms dynamic, business-controlled, and much more efficient.

 

Let’s dive into how this solution works and why it’s so powerful.

 

**Business Requirement**

Here’s the goal: We want a Smart List column (let’s call it Account = SL) that acts as a simple toggle for whether a month is editable. If the user selects “DoNotUpdate” for a month, then certain accounts (like A_77300 and A_77600) should become read-only for that period—while other months remain editable. This puts the control squarely in the hands of your business users, without the need for IT to lock and unlock forms each month.

Mastering EpmScript in Oracle Cloud EPM Groovy Rules!

 If you're building Groovy business rules in Oracle Cloud EPM, you've likely encountered EpmScript. It's not a class you import or instantiate—it's just there, quietly offering its powerful methods to control almost every part of your Planning application.

In this blog, we’ll demystify EpmScript, explore its capabilities, and walk through practical examples of how it unlocks dynamic planning automation.

Groovy Scripting in Oracle Cloud EPM: A Deep Dive!

 Groovy scripting in Oracle Cloud EPM Planning is not just a scripting tool—it's a superpower. With the ability to manipulate forms, validate data, execute calculations, and orchestrate workflows dynamically, Groovy turns your Planning environment into a living, breathing application.

Whether you’re validating input, enforcing business rules, or orchestrating complex data flows, Groovy scripting provides flexibility and control that traditional Planning business rules can only dream of.

Groovy most commonly used functions and codes!

 In the world of Cloud EPM Planning, where forms, calculations, and allocations rule the day—and multiple times, you need Groovy scripting to do what regular calc scripts simply can’t. This blog gives you the easy to use functions and codes that you can reuse work across projects.

Automating Emails in Oracle Cloud EPM with Groovy Email Template!

 Sometimes you just need to let someone know what’s going on in your EPM application—maybe a process finished, a check failed, or you just want to send a heads-up. This Groovy business rule makes it easy by sending emails right from EPM, using just a few runtime prompts.

Run Data Management rule on Autopilot: Streamlining DM Data Jobs with Groovy

Have you ever wanted to run a series of Data Management integrations in Oracle Cloud EPM automatically for specific forecast periods — all while staying user-friendly with runtime prompts and full-on status tracking?

Well, this Groovy business rule does exactly that. Let’s break it down

 

This Groovy rule is designed to automate and control the execution of Data Management (DM) integration jobs for forecast data. It dynamically interprets user input, validates required conditions, and executes the appropriate integration job for each forecast period in sequence.

The rule orchestrates the execution of multiple forecast data movement jobs in Oracle Cloud EPM. The jobs transfer forecast data from one scenario/version to another (like from mid-forecast to working version) using a Data Management (DM) integration job. The timing and execution logic is governed by runtime prompt inputs and substitution variables.

Data Copy using DataGridBuilder in Groovy!

 

 

In this blog, we will see how to perform an intercompany data translation with ease,  

 

This rule ensures intercompany data is clean, aligned, and instantly processed when users save a form. It applies standard naming and business logic automatically—no manual cleanup needed. Data flows straight into the target  cube or POV, reducing cycle time and reconciliation effort. It improves auditability and consistency across entities, accounts, and products. The result? Faster closes, fewer errors, and more trust in your numbers