My Oracle Support Banner

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

Last updated on FEBRUARY 09, 2018

Applies to:

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


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(
  at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(
  at weblogic.jdbc.wrapper.PreparedStatement.executeBatch(
  at glog.util.jdbc.SqlUpdate.processBatch(
  at glog.util.jdbc.SqlUpdate.resetArguments(
  at glog.util.jdbc.SqlUpdate.resetArguments(
  at glog.util.jdbc.SqlUpdate.execute(
  at glog.util.beandata.BeanDataInserter.insertDBBatch(
  at glog.util.beandata.BeanDataInserter.insertDB(
  at glog.util.beandata.BeanDataInserter.insert(
  at glog.util.beandata.BeanDataInserter.insert(
  at glog.util.beandata.BeanDataInserter.insert(

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.


To view full details, 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 a vibrant support community of peers and Oracle experts.