Full Load Program (ECCRUNDL) for iProcurement (ICX) Gets Error ORA-00947 Not Enough Values ORA-06512 At APPS.ICX_ECC_UTIL_PVT
(Doc ID 2765183.1)
Last updated on JUNE 09, 2023
Applies to:
Oracle iProcurement - Version 12.2.5 and laterOracle Enterprise Command Center Framework - Version 12.2.5 and later
Information in this document applies to any platform.
Symptoms
ACTUAL BEHAVIOR
Executing Full Load Run Program for iProcurement errors this behavior after patch 31805171:R12.ICX.D
ERROR
ECCRUNDL: ECC Run Data Load
CP main executing runProgram for oracle.apps.fnd.ecc.dataload.EccDataLoadCP
Concurrent request ID is 166716619
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
...
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-00947: not enough valuesORA-06512: at "APPS.ICX_ECC_UTIL_PVT", line 176ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ~[ojdbc8.jar:12.2.0.1.0] ... 23 common frames omitted
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 |