Publish Planning Result Completes With Error VCP-JDE Integration ODI-1226, ODI-1232: Procedure UpdatePurchasePlanDetail execution fails. then ODI-1228 (Doc ID 2178053.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Value Chain Planning Integration Base Pack - Version 11.1 and later
Oracle Advanced Supply Chain Planning - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.

Symptoms

Publish Planning Result Completes with Error VCP-JDE Integration

**Starts**11-AUG-2016 17:31:55
**Ends**11-AUG-2016 17:35:06
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
11-AUG 17:31:56 : ODI Scenario PREPROCESSHOOKPKG execution is successful.
11-AUG 17:34:45 : ODI Initializion is successful
11-AUG 17:34:50 : ODI Scenario LOADAPSPURCHASEPLANDATATOE1PKG FAILED. Session # : 6909003
11-AUG 17:34:50 : Error : ODI-1226: Step UpdatePurchasePlanDetail fails after 1 attempt(s).
ODI-1232: Procedure UpdatePurchasePlanDetail execution fails.
ODI-1228: Task UpdatePurchasePlanDetail (Procedure) fails on the target XML connection E1PurchasePlanDS.
Caused By: java.sql.SQLException: statement is not in batch mode
at com.sunopsis.jdbc.driver.xml.SnpsXmlPreparedStatementRedirector.executeBatch(SnpsXmlPreparedStatementRedirector.java:711)
at oracle.odi.runtime.agent.execution.sql.SQLCommand.end(SQLCommand.java:268)
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.endExecution(SQLExecutor.java:156)
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.endExecution(SQLExecutor.java:1)
at oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.jav
11-AUG 17:34:56 : ODI Scenario LOADAPSDEPLOYMENTPLANDATATOE1PKG execution is successful.
11-AUG 17:35:05 : ODI Scenario LOADAPSDETAILEDPRODPLANDATATOE1PKG FAILED. Session # : 6912003
11-AUG 17:35:05 : Error : ODI-1226: Step UpdateDetailedProdPlan2 fails after 1 attempt(s).
ODI-1232: Procedure UpdateDetailedProdPlan2 execution fails.
ODI-1228: Task UpdateDetailedProdPlan2 (Procedure) fails on the target XML connection E1DetailedProductionPlanDS.
Caused By: java.sql.SQLException: statement is not in batch mode
at com.sunopsis.jdbc.driver.xml.SnpsXmlPreparedStatementRedirector.executeBatch(SnpsXmlPreparedStatementRedirector.java:711)
at oracle.odi.runtime.agent.execution.sql.SQLCommand.end(SQLComma

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms