Bulk Plan Fails with Error: "ORA-01438: Value Larger than Specified Precision Allowed for This Column" (Doc ID 2019277.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version 6.3.1 and later
Information in this document applies to any platform.

Symptoms

When attempting to run Bulk Plan, the following error occurs:

ORA-01438: value larger than specified precision allowed ERR
java.sql.BatchUpdateException: ORA-01438: value larger than specified precision allowed for this column

  at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10345)
  at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230)
  at weblogic.jdbc.wrapper.PreparedStatement.executeBatch(PreparedStatement.java:210)
  at glog.util.jdbc.SqlUpdate.processBatch(SqlUpdate.java:145)
  at glog.util.jdbc.SqlUpdate.resetArguments(SqlUpdate.java:244)
  at glog.util.jdbc.SqlUpdate.resetArguments(SqlUpdate.java:166)
  at glog.util.jdbc.SqlUpdate.execute(SqlUpdate.java:91)
  at glog.util.beandata.BeanDataInserter.insertDBBatch(BeanDataInserter.java:358)
  at glog.util.beandata.BeanDataInserter.insertDB(BeanDataInserter.java:302)
  at glog.util.beandata.BeanDataInserter.insert(BeanDataInserter.java:197)
  at glog.util.beandata.BeanDataInserter.insert(BeanDataInserter.java:232)
  at glog.util.beandata.BeanDataInserter.insert(BeanDataInserter.java:171)
  at glog.business.util.EntitySaver.insert(EntitySaver.java:208)
  at glog.business.util.Persistence.insertupdate(Persistence.java:303)
  at glog.business.shipment.PlanningObjectCommitter.commitTShipment(PlanningObjectCommitter.java:949)
  at glog.business.shipment.ShipmentUpdateSessionBean.commitShipmentNode(ShipmentUpdateSessionBean.java:660)

The issue can be reproduced at will with the following steps:
1. Run Bulk Plan for multiple orders
2. It fails with the above errors.

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