LOADE1UOMCONVERSIONDATATOAPSPKG FAILED While Running "Collect Planning Data"
(Doc ID 2051856.1)
Last updated on OCTOBER 31, 2023
Applies to:
Oracle Data Integrator - Version 11.1.1.3.0 and laterOracle Value Chain Planning Integration Base Pack - Version 11.1 and later
Oracle Advanced Supply Chain Planning - Version 12.2.4 and later
Information in this document applies to any platform.
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
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 |
Cause |
Solution |
References |