My Oracle Support Banner

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
error detailoracle.ecc.client.exceptions.EccResponseException
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

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