19D/20A: Collections Performance Issue OR It Completes In Error: ORA-01652: unable to extend temp segment by 128 in tablespace FUSION_TEMP
(Doc ID 2660789.1)
Last updated on MARCH 12, 2021
Applies to:
Oracle Fusion Planning Central Cloud Service - Version 11.13.20.01.0 and laterInformation in this document applies to any platform.
Symptoms
Issue occurs after applying of the following CWB
20A : 02/21 Cumulative Weekly Bundle
19D : 02/28 Cumulative Weekly Bundle
After applying above CWB, Collections takes very long time OR it completes in following error in the ESS request "Pull Entity" for the entity BOM_COMPONENTS:
ORA-01652: unable to extend temp segment by 128 in tablespace FUSION_TEMP
ERROR Details from ESS Log file:
Is Attribute Based Planning Enabled = 2
The Extract Oracle Fusion Entity process started for entity BOM_COMPONENTS with refresh number 664494.
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_BOMS", line 2401
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_BOMS", line 2681
ORA-06512: at line 1
ORA-06512: at "FUSION.MSC_COLL_FRAMEWORK", line 1623
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_FRAMEWORK", line 1719
ORA-06512: at "FUSION.MSC_COLL_FRAMEWORK", line 2932
STEPS
The issue can be reproduced at will with the following steps:
1. Select the required entities
2. Opt-in the Items/Items Structures/Work Definitions under the reference data.
3. Run the Collections in the Target mode.
4. ESS job will end in an error status
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 |