iProcurement ECC Data Load Completes With Errors - There is SQLException while applying load rule for dataset icx-catalog - ORA-00942 and ORA-06512 at APPS.ICX_ECC_UTIL_PVT
(Doc ID 2739900.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle iProcurement - Version 12.2.4 and laterInformation in this document applies to any platform.
Symptoms
In Oracle iProcurement, Release 12.2.9 with Enterprise Command Center version 4 (ECCv4) or higher, an error occurs when running the Full Load for the iProcurement ECC Data Load concurrent program.
The errors below are from the concurrent request log file.
Sometimes the program completes with the errors, and other times it completes successfully.
Due to this issue, the iProcurement ECC data does not always get loaded into the environment for the iProcurement users.
Error
The error information is seen in the concurrent request log file:
CP main executing runProgram for oracle.apps.fnd.ecc.dataload.EccDataLoadCP
APPS_FRAMEWORK_AGENT: http://*********.******.**.**:8001
Concurrent request ID is 166386809
PARAMETERS LIST :
SystemId -> EBS
Application Short Name -> icx
Load Type -> FULL_LOAD
DataSet Key ->
Language ->
Trace Flag ->
Log Level -> ERROR
INFO: Language parameter is not specified. Hence defaulting to base language US
Running Full Load
..
..
status: SUCCESS
statusMessage: There are 10,222 documents processed successfully and 0 documents failed to be processed.
JOB Details:
Please check the output Log of Concurrent program for error details
@@[B@546ca120
Reading server response
13:24:03.605 [pool-4-thread-2] ERROR 4.o.e.i.u.s.i.DataLoadControllerServiceImpl - There is SQLException while applying load rule for dataset icx-catalog for job 45,333java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not existORA-06512: at "APPS.ICX_ECC_UTIL_PVT", line 158ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:223) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:56) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:907) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1300) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3822) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1165) ~[ojdbc8.jar:12.2.0.1.0] at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:144) ~[com.bea.core.datasource6.jar:12.2.1.3] at oracle.ecc.index.update.services.impl.DataLoadControllerServiceImpl.invokeDataLoad(DataLoadControllerServiceImpl.java:986) [ecc-ir-1.0.0.jar:na] at oracle.ecc.index.update.services.impl.DataLoadControllerServiceImpl.loadDataForDataset(DataLoadControllerServiceImpl.java:297) [ecc-ir-1.0.0.jar:na] at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.startJob(IRDataLoadServiceImpl.java:592) [ecc-ir-1.0.0.jar:na] at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.tryToStartJob(IRDataLoadServiceImpl.java:492) [ecc-ir-1.0.0.jar:na] at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.lambda$runLoadDataForApplicationWorkFlow$1(IRDataLoadServiceImpl.java:172) [ecc-ir-1.0.0.jar:na] at java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1626) ~[na:1.8.0_141] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_141] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_141] at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_141]Caused by: oracle.jdbc.OracleDatabaseException: ORA-00942: table or view does not existORA-06512: at "APPS.ICX_ECC_UTIL_PVT", line 158ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ~[ojdbc8.jar:12.2.0.1.0] ... 23 common frames omitted
[B@27c6672d
Error Details:
13:24:03.605 [pool-4-thread-2] ERROR 4.o.e.i.u.s.i.DataLoadControllerServiceImpl - There is SQLException while applying load rule for dataset icx-catalog for job 45,333java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not existORA-06512: at "APPS.ICX_ECC_UTIL_PVT", line 158ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:223) ~[ojdbc8.jar:12.2.0.1.0]
..
..
APPS_FRAMEWORK_AGENT: http://*********.******.**.**:8001
Concurrent request ID is 166386809
PARAMETERS LIST :
SystemId -> EBS
Application Short Name -> icx
Load Type -> FULL_LOAD
DataSet Key ->
Language ->
Trace Flag ->
Log Level -> ERROR
INFO: Language parameter is not specified. Hence defaulting to base language US
Running Full Load
..
..
status: SUCCESS
statusMessage: There are 10,222 documents processed successfully and 0 documents failed to be processed.
JOB Details:
Please check the output Log of Concurrent program for error details
@@[B@546ca120
Reading server response
13:24:03.605 [pool-4-thread-2] ERROR 4.o.e.i.u.s.i.DataLoadControllerServiceImpl - There is SQLException while applying load rule for dataset icx-catalog for job 45,333java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not existORA-06512: at "APPS.ICX_ECC_UTIL_PVT", line 158ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:223) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:56) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:907) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1300) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3822) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1165) ~[ojdbc8.jar:12.2.0.1.0] at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:144) ~[com.bea.core.datasource6.jar:12.2.1.3] at oracle.ecc.index.update.services.impl.DataLoadControllerServiceImpl.invokeDataLoad(DataLoadControllerServiceImpl.java:986) [ecc-ir-1.0.0.jar:na] at oracle.ecc.index.update.services.impl.DataLoadControllerServiceImpl.loadDataForDataset(DataLoadControllerServiceImpl.java:297) [ecc-ir-1.0.0.jar:na] at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.startJob(IRDataLoadServiceImpl.java:592) [ecc-ir-1.0.0.jar:na] at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.tryToStartJob(IRDataLoadServiceImpl.java:492) [ecc-ir-1.0.0.jar:na] at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.lambda$runLoadDataForApplicationWorkFlow$1(IRDataLoadServiceImpl.java:172) [ecc-ir-1.0.0.jar:na] at java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1626) ~[na:1.8.0_141] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_141] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_141] at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_141]Caused by: oracle.jdbc.OracleDatabaseException: ORA-00942: table or view does not existORA-06512: at "APPS.ICX_ECC_UTIL_PVT", line 158ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ~[ojdbc8.jar:12.2.0.1.0] ... 23 common frames omitted
[B@27c6672d
Error Details:
13:24:03.605 [pool-4-thread-2] ERROR 4.o.e.i.u.s.i.DataLoadControllerServiceImpl - There is SQLException while applying load rule for dataset icx-catalog for job 45,333java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not existORA-06512: at "APPS.ICX_ECC_UTIL_PVT", line 158ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) ~[ojdbc8.jar:12.2.0.1.0] at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:223) ~[ojdbc8.jar:12.2.0.1.0]
..
..
Steps To Reproduce
The issue can be reproduced at will with the following steps:
1. Log in to Oracle Applications.
2. Navigate to a Purchasing responsibility > Requests > Run
3. Submit the iProcurement ECC Data Load concurrent program with Load Type = Full.
Sometimes the program completes with the errors, and other times it completes successfully.
Changes
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 |