Fusion OTBI - "Compensation - Workforce Compensation Real Time" Error: ORA-10260: limit size (1048576) of the PGA heap set by event 10261 exceeded

(Doc ID 2330000.1)

Last updated on DECEMBER 22, 2017

Applies to:

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

Symptoms

STEPS TO REPRODUCE

Create Prompt on

Subject Area - "Compensation - Workforce Compensation Real Time"
Folder - "Compensation Manager"
Filed - "Manager Name".

Below is the SQL Issued:

SELECT
0 s_0,
"Compensation - Workforce Compensation Real Time"."Compensation Manager"."Manager Name" s_1,
DESCRIPTOR_IDOF("Compensation - Workforce Compensation Real Time"."Compensation Manager"."Manager Name") s_2
FROM
"Compensation - Workforce Compensation Real Time"
ORDER BY 1, 2 ASC NULLS LAST, 3 ASC NULLS LAST FETCH FIRST 75001 ROWS ONLY

It throws error as below.
"Odbc driver returned an error (SQLExecDirectW).
Error Details

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