My Oracle Support Banner

Biz Error Message: oracle.apps.scm.advancedPlanning.planningAnalytics.services.exception.ProportRunTimeException: java.sql.SQLException: ORA-01652 (Doc ID 2652609.1)

Last updated on APRIL 23, 2020

Applies to:

Oracle Demand Management Cloud Service - Version 11.13.20.01.0 and later
Information in this document applies to any platform.

Symptoms



When attempting to run demand plan, the following error occurs.

ERROR
-----------------------
Execution started at : 18-Mar-2020 11:06:42-578
 JOB PARAMETERS:
===========================================================
 Plan ID: 300000014368744
 Granularity ID: 135
 Profile List: 4731,6731
 Web Service Method Name: calculateProportionsAsync
 Parent Job ID: 50593
===========================================================
Job Completion Status : oracle.apps.scm.advancedPlanning.planningAnalytics.services.exception.ProportRunTimeException: oracle.apps.scm.advancedPlanning.planningAnalytics.services.exception.ProportRunTimeException: java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace FUSION_TEMP
ORA-06512: at "FUSION.MSC_PROPORT", line 753
ORA-06512: at line 1

Biz Error Message: oracle.apps.scm.advancedPlanning.planningAnalytics.services.exception.ProportRunTimeException: oracle.apps.scm.advancedPlanning.planningAnalytics.services.exception.ProportRunTimeException: java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace FUSION_TEMP
ORA-06512: at "FUSION.MSC_PROPORT", line 753
ORA-06512: at line 1


STEPS TO REPRODUCE

-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Demand Management
2. Manage Plans
3. Run plan
4. See Scheduled Processes work area for confirmation.


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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.