My Oracle Support Banner

Extract Data From Fusion GL Failed With Error "Exceeds The Limit [1000000] Set By The QUERYRESULTLIMIT" (Doc ID 2751166.1)

Last updated on NOVEMBER 10, 2022

Applies to:

Oracle Planning and Budgeting Cloud Service - Version N/A and later
Oracle Financial Consolidation and Close Cloud Service - Version N/A and later
Oracle Enterprise Planning and Budgeting Cloud Service - Version N/A and later
Information in this document applies to any platform.


On : 21.01.28 version, PBCS

The following error displays while loading the data from the source Fusion Application to target the PBCS application through Data Management

ERROR from the Process log

INFO [AIF]: ExtractBalanceData:Error::Cannot perform cube view operation. Essbase Error(1200766): The number of query result cells exceeds the limit [1000000] set by the QUERYRESULTLIMIT configuration setting

FATAL [AIF]: Error in CommData.extractDataFromSource
Traceback (most recent call last):
File "<string>", line 2905, in extractDataFromSource
File "<string>", line 408, in executeFusionService
Exception: java.lang.Exception: Ess request has completed with errors.

FATAL [AIF]: Error in Comm Extract Data
INFO [AIF]: FDMEE Process End, Process ID: 72688




To view full details, sign in with your My Oracle Support account.

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

In this Document

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