Trying To Load Collections Metrics Gets Error: Cannot Perform Cube View Operation. Essbase Error (1200601). Not Enough Memory For Formula Execution. Set MAXFORMULACACHESIZE Configuration Parameter To [86362]KB And Try Again

(Doc ID 2415105.1)

Last updated on JUNE 25, 2018

Applies to:

Oracle Fusion Advanced Collections Cloud Service - Version 11.13.18.02.0 and later
Information in this document applies to any platform.

Symptoms

On Oracle Fusion, 11.13.18.02.0 version, Trying to load collections metrics is getting error:

ERROR:
----------------
Cannot perform cube view operation. Essbase Error (1200601). Not enough memory for formula execution. Set MAXFORMULACACHESIZE configuration parameter to [86362]KB and try again


EXPECTED BEHAVIOR
-----------------------
Expecting to be able to load metrics into collections


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. On Navigator
2. Go to Collections > Metrics (button)
3. Enter customer or Business Unit
4. Click Search and observed the error described appears

Note: This is happening to all users


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms