LOADE1UOMCONVERSIONDATATOAPSPKG FAILED While Running "Collect Planning Data" (Doc ID 2051856.1)

Last updated on OCTOBER 31, 2023

Applies to:

Symptoms

On : 11.1 version, JDE to VCP Flow

LOADE1UOMCONVERSIONDATATOAPSPKG FAILED while running "Collect Planning Data" concurrent program.

24-AUG 10:38:40 : ODI Scenario PREPROCESSHOOKPKG execution is successful.
STARTING E1 APS Planning Data Pull
CHECKING INPUT PARAMETERS TO RUN SCENARIOS
INITIALIZING ODI ....
24-AUG 10:38:45 : ODI Initializion is successful
24-AUG 10:38:46 : ODI Scenario RESULT
24-AUG 10:38:46 : LOADE1UNITSOFMEASUREDATATOAPSPKG SUCCESS
24-AUG 10:38:47 : ODI Scenario RESULT
24-AUG 10:38:47 : ODI Scenario : LOADE1UOMCONVERSIONDATATOAPSPKG FAILED. Session #: 565003
24-AUG 10:38:47 : Error Message: ODI-1226: Step CollectNonPlanUom fails after 1 attempt(s).
ODI-1240: Flow CollectNonPlanUom fails while performing a Integration operation. This flow loads target table WR_BASE_UOM_NONPLANUOM.
ODI-1228: Task CollectNonPlanUom (Integration) fails on the target ORACLE connection WorkRepoDS.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CPreparedStatement.doOall
24-AUG 10:42:02 : Mail Execution SUCCESS
 

ERROR
-----------------------
ORA-00942: table or view does not exist

Cause

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