How to Fix Slow Planning Refreshes in Oracle EPM 11.2 with Essbase 21c

Written By Brad Spelman

The Problem: Slow Planning Refresh Times

We recently ran into a performance issue in an Oracle EPM 11.2.24 environment where Planning database refreshes were taking significantly longer than expected—sometimes up to 10 minutes per refresh.

For teams that rely on frequent metadata updates, these delays can quickly become a major bottleneck, impacting both administrators and business users.

What’s Causing the Issue?

After opening a Service Request (SR) with Oracle, we were directed to KB378566, which outlines a known product defect affecting Planning environments (version 11.2.15 and higher) when used with Essbase 21c.

The root cause is tied to how Essbase handles transactional editing during refresh operations under certain configurations.

What makes this tricky?
👉 This fix is not documented in standard installation guides or patch READMEs, so many environments may be impacted without realizing it.

The Fix: A Simple Configuration Change

To resolve the issue, add the following variable to your Planning server configuration:

ESSOTLEDITSERVERMODE=False

If you're running a Linux-based Planning server, Oracle KB860305 provides additional steps to ensure the change is applied correctly.

The Impact: From Minutes to Seconds

After applying this update, we saw an immediate and dramatic improvement:

  • Before: ~10 minutes per refresh

  • After: Just a few seconds

This type of performance gain can significantly improve development cycles, reduce user wait times, and streamline daily operations.

Why This Matters

If your organization is running Oracle EPM 11.2 with Essbase 21c, there’s a strong chance this issue could be affecting your environment—especially if refreshes feel slower than expected.

Because the fix isn’t widely documented, it’s often missed during implementations or upgrades.

Need Help Optimizing Your EPM Environment?

Performance issues like this highlight how small configuration details can have a big impact on your system’s efficiency.

At iArch Solutions, we help organizations get the most out of their Oracle EPM investments through:

  • Performance tuning and optimization

  • System troubleshooting and support

  • Implementation and upgrades

  • AI-driven enhancements and automation

👉 If you're experiencing slow performance or just want a proactive system health check, contact our team today for a discovery call.We’ll help you identify opportunities to improve speed, reliability, and overall user experience.

Schedule a Discovery Call
Brad Spelman
Next

OCI 101