Fusion Financials GL: Inquire And Analyze Balances Essbase reporting Error(1200713): Mathematical operation results in integer overflow/underflow. Reduce the size of the query region (Doc ID 2047373.1)

Last updated on AUGUST 24, 2015

Applies to:

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

Symptoms

Fusion Financials OnPremise R8 - Financial Reporting Center > Inquire and Analyze Balances
OnPremise R8 PB14

Unexpected behavior
----------------------------------

'Cannot perform cube view operation. Essbase Error(1200713): Internal Error: Mathematical operation results in integer overflow/underflow. Reduce the size of the query region'

Steps
-------------
End users with role like Accountants
Where seen: Inquire and Analyze Balances, Inquire on Detail Balances
Some user see the error on analysis and drilldown
Happens when end users do not use filters / minimal filters when Searching on above screens

Filter sizing Details:
BU  approx 100
Customer Group: 1000
Cost center :? Thousands
Events 1000s
Accounts : 2000
Product 3000

Work-around
----------------------
Utilize drop-downs to apply filters which reduce the amount of work the system is doing


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