My Oracle Support Banner

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 later
Oracle 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


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