My Oracle Support Banner

Collections Refresh Snapshot Fails After VCP Upgrade With Temp Space Issue ORA-01652 (Doc ID 2635513.1)

Last updated on MAY 04, 2020

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.6.3 and later
Information in this document applies to any platform.

Symptoms

MSCPDPW: Planning Data Pull Worker fails with

12-JUL 02:17:05 : Error pulling data from MRP_AP_COMPONENT_SUBSTITUTES_V to MSC_ST_COMPONENT_SUBSTITUTES.
12-JUL 02:17:05 : ORA-12801: error signaled in parallel query server P003
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP2
ORA-02063: preceding 2 lines from EBS...
12-JUL 02:17:05 : ORA-12801: error signaled in parallel query server P003
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP2
ORA-02063: preceding 2 lines from EBS...
12-JUL 02:17:05 : Error_Stack...
12-JUL 02:17:05 : ORA-12801: error signaled in parallel query server P003
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP2
ORA-02063: preceding 2 lines from EBS...

12-JUL 02:17:05 : Error_Backtrace...
12-JUL 02:17:05 : ORA-06512: at "APPS.MSC_CL_PULL", line 7045
ORA-06512: at "APPS.MSC_CL_PULL", line 1825

Changes

 

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
Changes
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.