FUSION APPLICATIONS: REPORT ERROR MESSAGE LIMIT SIZE (1048576) OF THE PGA HEAP SET BY EVENT 10261 EXCEED

(Doc ID 1961113.1)

Last updated on JULY 08, 2016

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.1.8.0.0 and later
Information in this document applies to any platform.

Goal

Problem Description

When the below Reports are run in OTBI (Fusion Applications Analysis), the error shown below is returned.

/Shared Folder/Custom/Oracle/Human Capital Management/Core HR/Audits and Payroll/ HR Operations/Audit - Kronos Mgr License
/Shared Folder/Custom/Oracle/Human Capital Management/Core HR/Headcount/For Report Agents/Headcount - AB and AP ¿ EU


Error Message

 

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS.
[nQSError: 43119] Query Failed: [nQSError: 17001] Oracle Error code: 10260, message: ORA-10260: limit size (1048576) of the PGA heap set by event 10261 exceeded at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed. (HY000)

 

Solution

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