ORA-01652: unable to extend temp segment: Error pulling data from MRP_AP_PROCESS_EFFECTIVITY_V to MSC_ST_PROCESS_EFFECTIVITY (Doc ID 1481538.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

Using Advanced Supply Chain Planning / Standard Data Collection
When attempting to perform Planning Data Pull the EBS Source instance consumes over 30 GB of Temp tablespace, then the following error occurs in a Planning Data Pull Worker.

ERROR
-----------------------
Procedure MSC_CL_BOM_PULL.LOAD_PROCESS_EFFECTIVITY started.
Error pulling data from MRP_AP_PROCESS_EFFECTIVITY_V to MSC_ST_PROCESS_EFFECTIVITY

Some customers encounter 
ORA-01652: unable to extend temp segment by 256 in tablespace TEMP

instead of a timeout if the execution runs out of space before it runs out of time.

-- Steps To Reproduce:

Customer states the issue can be reproduced at will at customer site with the following steps:
1. (R) Advanced Supply Chain Planner
2. (N) Collections / Oracle Systems / Standard Collection
3. Include Bills of Material entity in the collection
4. Observe that a Planning Data Pull worker fails with message noted.

Cause

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