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 JUNE 28, 2017

Applies to:

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

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.

Changes

 

Cause

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 hundreds of Community platforms