My Oracle Support Banner

RPASCE Cloud: RSE_FCST_DEMAND_SRC_EXP Fails with Error "ORA-20999: ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT" (Doc ID 3027806.1)

Last updated on JUNE 10, 2024

Applies to:

Oracle Retail Demand Forecasting Cloud Service - Version 23.2 and later
Oracle Retail AI Foundation Cloud Service - Version 24.1 and later
Oracle Retail Lifecycle Pricing Optimization Cloud Service Advanced Edition - Version 24.1 and later
Information in this document applies to any platform.

Goal

An error occurred when importing the RSE_FCST_DEMAND_SRC_EXP interface.

Validating Interface : RSE_FCST_DEMAND_SRC_EXP
Getting Run ID ..
Calling Generic Importer procedure intf_generic_imp for Run ID : 1788
ORA-20999: ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
ORA-06512: at "RPAS_DATA_MART_PDS.RP_G_PARALLEL_TASK_PKG", line 395

How can this be resolved?
 

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.