Financial Report That Retrieves Large Amount Of Data Displays Error 1200613 When Submitted (Doc ID 1604685.1)

Last updated on AUGUST 29, 2016

Applies to:

Oracle Fusion General Ledger Cloud Service - Version 11.1.5.0.0 and later
Oracle Fusion General Ledger - Version 11.1.5.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.5.0.0 version, Financial Reporting and Analysis-Analyze Financial Performance

A custom trial balance report was created using FR Studio. When the report is submitted, it runs for a while and then returns an error.
The report is defined using level0 for multiple dimensions, essentially getting all the values for each dimension, at least 2 of which has something like 20k to 30k+ members.

ERROR
-----------------------
Error executing query: Error: Internal Essbase JAPI error: [Cannot perform cube view operation. Essbase Error(1200613): Internal error: Query is too large and cannot be executed. The product of member counts across all dimensions in the query exceeds 2^64.]


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a custom report of the GL Trial Balance report using FR Studio.
2. Submit the report and get the error.

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