My Oracle Support Banner

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 DECEMBER 27, 2020

Applies to:

Oracle iProcurement - Version 12.2.4 and later
Information 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]
..
..



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


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