"ORA-00913: too many values" Error When Planning More Than 1000 Order Movements (Doc ID 1602231.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Transportation Operational Planning - Version 6.0 to 6.3.4 [Release 6 to 6.3]
Information in this document applies to any platform.

Symptoms

An attempt to bulk plan more than 1000 order movements fails with an error similar to the following:

java.sql.SQLSyntaxErrorException: ORA-00913: too many values

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1187)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3386)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3430)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
at glog.util.jdbc.noserver.SqlQuery.executeQuery(SqlQuery.java:164)
at glog.util.jdbc.noserver.SqlQuery.open(SqlQuery.java:105)
at glog.util.beandata.BeanDataLoader.loadBeanData(BeanDataLoader.java:386)
at glog.util.beandata.BeanDataLoader.load(BeanDataLoader.java:338)
at glog.business.util.EntityLoader.loadBeanData(EntityLoader.java:357)
at glog.business.util.EntityLoader.loadDataContainers(EntityLoader.java:238)
at glog.business.util.DatabaseLoader.loadDataContainers(DatabaseLoader.java:239)
at glog.business.util.DatabaseLoader.loadDataContainers(DatabaseLoader.java:180)
at glog.business.util.DatabaseLoader.loadDataContainers(DatabaseLoader.java:162)
at glog.business.shipment.TSShipUnit.load(TSShipUnit.java:823)
at glog.business.shipment.ShipmentLoader.load(ShipmentLoader.java:746)
at glog.business.shipment.ShipmentLoader.loadShipments(ShipmentLoader.java:383)
at glog.business.shipment.ShipmentLoader.loadShipments(ShipmentLoader.java:236)
at glog.business.shipment.ShipmentLoader.loadShipments(ShipmentLoader.java:205)
at glog.business.shipment.ShipmentLoader.loadOrderMovements(ShipmentLoader.java:2917)
at glog.business.action.ordermovement.BulkPlanOrderMovementsAction.planUnassignedOrderMovements(BulkPlanOrderMovementsAction.java:387)
at glog.business.action.ordermovement.BulkPlanOrderMovementsAction.planAllOrderMovements(BulkPlanOrderMovementsAction.java:329)
at glog.business.action.ordermovement.BulkPlanOrderMovementsAction.execute(BulkPlanOrderMovementsAction.java:158)
at glog.business.session.OrderMovementActionSessionBean.bulkPlanOrderMovements(OrderMovementActionSessionBean.java:362)
at glog.business.session.OrderMovementActionSessionServerSideEJBWrapper.bulkPlanOrderMovements(OrderMovementActionSessionServerSideEJBWrapper.java:283)
at glog.business.session.OrderMovementActionSessionServerSideEJBWrapper_ak3ax7_EOImpl.bulkPlanOrderMovements(OrderMovementActionSessionServerSideEJBWrapper_ak3ax7_EOImpl.java:579)
at glog.server.workflow.adhoc.BulkPlan.executeOrderMovement(BulkPlan.java:113)
at glog.server.workflow.adhoc.BulkPlan.execute(BulkPlan.java:51)
at glog.server.workflow.SimpleWorkflow.execute(SimpleWorkflow.java:23)
at glog.server.workflow.WorkflowSessionBean.execute(WorkflowSessionBean.java:64)
at glog.server.workflow.WorkflowSessionNonTransServerSideEJBWrapper.execute(WorkflowSessionNonTransServerSideEJBWrapper.java:38)
at glog.server.workflow.WorkflowSessionNonTransServerSideEJBWrapper_t6tuwu_EOImpl.execute(WorkflowSessionNonTransServerSideEJBWrapper_t6tuwu_EOImpl.java:278)
at glog.server.workflow.WorkflowManager.execute(WorkflowManager.java:352)
at glog.server.workflow.Trigger.trigger(Trigger.java:122)
at glog.util.event.MemoryEventQueueRunnable.processEvent(MemoryEventQueueRunnable.java:146)
at glog.util.event.MemoryEventQueueRunnable.run(MemoryEventQueueRunnable.java:98)
at glog.util.event.EventThread.run(EventThread.java:86)
at java.lang.Thread.run(Thread.java:736)

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