Financial Report That Retrieves Large Amount Of Data Displays Error 1200613 When Submitted
Last updated on AUGUST 29, 2016
Applies to:Oracle Fusion General Ledger Cloud Service - Version 18.104.22.168.0 and later
Oracle Fusion General Ledger - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
On : 126.96.36.199.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 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.]
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.
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