Calculation Process Fails With ORA-30036 User-Defined Exception SQLERRM : ORA-10260: limit size (1048576) of the PGA heap set by event 10261 exceeded
(Doc ID 2119563.1)
Last updated on FEBRUARY 07, 2025
Applies to:
Oracle Fusion Incentive Compensation - Version 11.13.23.01.0 and laterOracle Fusion Incentive Compensation Cloud Service - Version 11.13.23.01.0 and later
Information in this document applies to any platform.
Symptoms
Calculation ends with the following :
ERROR MESSAGE
cn_tp_calculate_txns.jobs_dispatch.l_job_fail
cn_tp_calculations_pvt.calulate.g_exc_error
One or more of the physical batches have failed
SQLCODE : 1
SQLERRM : User-Defined Exception
End of cn_tp_calculate_txns.process_calc_batch for calc job id : 12001 with error.
Unexpected exception in revert_total_mode
SQLCODE : -10260
SQLERRM : ORA-10260: limit size (1048576) of the PGA heap set by event 10261 exceeded
cn_tp_eligibility_pvt.eligibility.g_exc_error
SQLCODE : 1
SQLERRM : User-Defined Exception
End of eligibility phase for logical batch id 14010 and physical batch id : 20
STEPS
Navigator > Credits and Earnings > Manage Calculation Processes
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |