My Oracle Support Banner

R12 AP: ECC Data Load Error: "ORA-20001: No value is set for the profile option CE: Available Transactions Range for ECC" (Doc ID 2981480.1)

Last updated on OCTOBER 23, 2023

Applies to:

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

Symptoms

When user executed the Full Data Load or Incremental Data Load programs end in error.

Error can be found in the log for each program:

2023-09-21 09:41:51.897 [pool-5-thread-2] ERROR 1.o.e.i.u.s.i.DataLoadControllerServiceImpl - job failed with error code:There is Exception while applying load rule for dataset ce-recon-available for job 1,041,555  There is Exception while applying load rule for dataset ce-recon-available for job 1,041,555 exception details: 
java.sql.SQLException: ORA-20001: No value is set for the profile option "CE: Available
                Transactions Range for ECC". Please set the date value from which you want to load data in
                DD-MON-RRRR (Example 01-JAN-2020) format and run the data load.
ORA-06512: at "APPS.CE_ECC_UTIL_PVT", line 2717
ORA-06512: at line 1

	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) ~[ojdbc8.jar:19.3.0.0.0]
	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) ~[ojdbc8.jar:19.3.0.0.0]
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) ~[ojdbc8.jar:19.3.0.0.0]
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550) ~[ojdbc8.jar:19.3.0.0.0]
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268) ~[ojdbc8.jar:19.3.0.0.0]
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655) ~[ojdbc8.jar:19.3.0.0.0]
	at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:265) ~[ojdbc8.jar:19.3.0.0.0]
	at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:86) ~[ojdbc8.jar:19.3.0.0.0]
	at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:965) ~[ojdbc8.jar:19.3.0.0.0]
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205) ~[ojdbc8.jar:19.3.0.0.0]
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666) ~[ojdbc8.jar:19.3.0.0.0]
	at oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1358) ~[ojdbc8.jar:19.3.0.0.0]
	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3713) ~[ojdbc8.jar:19.3.0.0.0]
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1167) ~[ojdbc8.jar:19.3.0.0.0]
	at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:144) ~[com.bea.core.datasource6.jar:12.2.1.4]
	at oracle.ecc.index.update.services.impl.DataLoadControllerServiceImpl.invokeDataLoad(DataLoadControllerServiceImpl.java:1949) [ecc-ir-1.0.0.jar:na]
	at oracle.ecc.index.update.services.impl.DataLoadControllerServiceImpl.loadDataForDataset(DataLoadControllerServiceImpl.java:693) [ecc-ir-1.0.0.jar:na]
	at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.startJob(IRDataLoadServiceImpl.java:966) [ecc-ir-1.0.0.jar:na]
	at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.tryToStartJob(IRDataLoadServiceImpl.java:550) [ecc-ir-1.0.0.jar:na]
	at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.lambda$runLoadDataForApplicationWorkFlow$22(IRDataLoadServiceImpl.java:2242) [ecc-ir-1.0.0.jar:na]
	at java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1640) ~[na:1.8.0_321]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_321]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_321]
	at java.lang.Thread.run(Thread.java:750) ~[na:1.8.0_321]
Caused by: oracle.jdbc.OracleDatabaseException: ORA-20001: No value is set for the profile option "CE: Available
                Transactions Range for ECC". Please set the date value from which you want to load data in
                DD-MON-RRRR (Example 01-JAN-2020) format and run the data load.
ORA-06512: at "APPS.CE_ECC_UTIL_PVT", line 2717
ORA-06512: at line 1

	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513) ~[ojdbc8.jar:19.3.0.0.0]
	... 23 common frames omitted

Steps to reproduce it:

1. Log into ECC Developer responsibility.

2. Run the ECC Incremental Load Program.

3. Invoice should move from Pending Accounting Events to Untransferred Journals tab in ECC which is not happening.

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
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.