OM Command Center Data Loader Program Error Out ORA-01652: Unable to extend temp segment
(Doc ID 2787600.1)
Last updated on DECEMBER 09, 2022
Applies to:Oracle Enterprise Command Center Framework - Version 12.2.9 and later
Information in this document applies to any platform.
On : 12.2.9 version, ECC Order Management
After upgarding from R12.1.3 to R12.2.9 and configuring the ECC V5 version, when running the OM Command Center Data loader program the log file shows that an APPSTEMP table space issue is occurring.
Increasing APPSTEMP table space to 60GB, later 225 GB and finally 600 GB did not resolve the issue.
There is SQLException while applying load rule for dataset ont-lines for job 37,526
java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace APPSTEMP
ORA-06512: at "APPS.OE_ECC_UTIL_PVT", line 1955514208
Error while call to runProgramnull
CP main completed runProgram for oracle.apps.fnd.ecc.dataload.EccDataLoadCP
The issue can be reproduced at will with the following steps:
1) Oracle Order Management Responsibility,
2) Oracle Order Management,
3) Concurrent Programs,
4) OM Command Center Data Load
5) ECC - Run Data Load
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