ORA-01652: unable to extend temp segment: Error pulling data from MRP_AP_PROCESS_EFFECTIVITY_V to MSC_ST_PROCESS_EFFECTIVITY
Last updated on DECEMBER 18, 2017
Applies to:Oracle Advanced Supply Chain Planning - Version 11.5.10 and later
Information in this document applies to any platform.
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.
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.
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