My Oracle Support Banner

ECC V6: Incremental Data Load Errors with "ORA-01652: unable to extend temp segment by 128 in tablespace APPS_TS_TEMP " After Patch 32975452:R12.FA.C (Doc ID 2822800.1)

Last updated on DECEMBER 27, 2022

Applies to:

Oracle Enterprise Command Center Framework - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR

ECCRUNDL: ECC  Incremental Data Load errors with the following error after patch 32975452:R12.FA.C

at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.lambda$runLoadDataForApplicationWorkFlow$21(IRDataLoadServiceImpl.java:2152) [ecc-ir-1.0.0.jar:na] at java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1640) ~[na:1.8.0_281] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_281] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_281] at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_281]Caused by: oracle.jdbc.OracleDatabaseException: ORA-01652: unable to extend temp segment by 128 in tablespace APPS_TS_TEMP at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513) ~[ojdbc8.jar:19.3.0.0.0] ... 23 common frames omitted
 Error Details:
CP main completed runProgram for oracle.apps.fnd.ecc.dataload.EccDataLoadCP


STEPS

The issue can be reproduced at will with the following steps:

1/ Fixed Assets Manager
2/ Other >Request > Run > Assets Command Center Data Load - Incremental Load

Changes

 Patch 32975452:R12.FA.C has been applied.

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


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