My Oracle Support Banner

Getting Tablespace Error In BOM Load (Doc ID 2644751.1)

Last updated on APRIL 22, 2020

Applies to:

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

Symptoms

On : 11.13.19.10.0 version, Demand Collections

When running Load Planning Data from Flat Files to collect Item structures, the child processes Create Trees completes in error:

ERROR


Error while copying ODS data ORA-01652: unable to extend temp segment by 128 in tablespace FUSION_TEMP
ORA-01652: unable to extend temp segment by 128 in tablespace FUSION_TEMP

ORA-06512: at "FUSION.MSC_COLL_CTO_BOM_PKG", line 256

MSC_COLL_CTO_BOM_PKG.COLLECT_MODEL_BOM_COMPONENTS Error_Stack...
ORA-01652: unable to extend temp segment by 128 in tablespace FUSION_TEMP
MSC_COLL_CTO_BOM_PKG.COLLECT_MODEL_BOM_COMPONENTS Error_Backtrace...
ORA-06512: at "FUSION.MSC_COLL_CTO_BOM_PKG", line 256

Error while copying ODS data ORA-01652: unable to extend temp segment by 128 in tablespace FUSION_TEMP
ORA-01652: unable to extend temp segment by 128 in tablespace FUSION_TEMP

ORA-06512: at "FUSION.MSC_COLL_CTO_BOM_PKG", line 319
ORA-06512: at "FUSION.MSC_COLL_CTO_BOM_PKG", line 457

MSC_COLL_CTO_BOM_PKG.MANAGE_DP_CTO_BOM_DATA Error_Stack...
ORA-01652: unable to extend temp segment by 128 in tablespace FUSION_TEMP
MSC_COLL_CTO_BOM_PKG.MANAGE_DP_CTO_BOM_DATA Error_Backtrace...
ORA-06512: at "FUSION.MSC_COLL_CTO_BOM_PKG", line 319
ORA-06512: at "FUSION.MSC_COLL_CTO_BOM_PKG", line 457

 Error_Stack...
ORA-01652: unable to extend temp segment by 128 in tablespace FUSION_TEMP
 Error_Backtrace...
ORA-06512: at "FUSION.MSC_COLL_CTO_BOM_PKG", line 905
ORA-06512: at "FUSION.MSC_COLL_HIERARCHIES", line 221



STEPS

The issue can be reproduced at will with the following steps:
1. Prepare data in ScpBillofMaterialImportTemplate.xlsm FBDI
2. Load Planning Data from Flat Files
3. Process completes in error


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


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