Error Creating a Pivot Table in Analytics: Exceeded Configured Maximum Number of Allowed Input Records (Doc ID 2755603.1)

Last updated on APRIL 03, 2023

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
When creating an Analytics pivot table, the following error is generated

ERROR
-------------

Exceeded configured maximum number of allowed input records.
ResultRowLimit(table) OR CubeMaxRecords(Pivot/Chart) needs to be reset in the config file. Please check with your administrator.
  Error Details
Error Codes: EKMT3FK5

WHAT IS WORKING
-----------------------
Removing the Project Id will generate the table, but with incorrect values

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Log into Analytics Dev
2. Create a Cash flow analysis:
   • Criteria:
   • Project ID
   • Cash Flow Name
   • Month Name
   • Baseline(Baseline)
3. Check the results
4. Create the Pivot table
5. Notice the error:
   • View Display Error
   • Exceeded configured maximum number of allowed input records.
   • ResultRowLimit(table) OR CubeMaxRecords(Pivot/Chart) needs to be reset in the
   • config file. Please check with your administrator.
   •   Error Details
   • Error Codes: EKMT3FK5
6. Remove Project ID
7. Notice the values are much higher than expected

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.