Okl-ar-cm-appl Incremental Data Load Not Completing and Erroring with java.sql.SQLException: ORA-01652: unable to extend temp segment by 16 in tablespace (Doc ID 2989609.1)

Last updated on DECEMBER 19, 2023

Applies to:

Symptoms

When attempting to run the data load okl-ar-cm-appl, the incremental data load is not completing and erroring with the following:

Error Details:
13:22:22.867 [pool-5-thread-3] ERROR 1.o.e.i.u.s.i.DataLoadControllerServiceImpl - job failed with error code:There is Exception while applying load rule for dataset okl-ar-cm-appl for job 19,034 There is Exception while applying load rule for dataset okl-ar-cm-appl for job 19,034 exception details:
java.sql.SQLException: ORA-01652: unable to extend temp segment by 16 in tablespace TEMP1
ORA-06512: at "APPS.OKL_AR_ECC_UTIL_PVT", line 4847
ORA-06512: at "APPS.OKL_AR_ECC_UTIL_PVT", line 1399
ORA-06512: at line 1


The issue can be reproduced at will with the following steps:
1. Using lease administrator responsibility, run data load concurrent request for okl-ar-cm-appl.

Changes

Cause

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