"ORA-01438: value larger than specified precision allowed for this column" Error When Running Action: "Process Unprocessed Rate Factors" (Doc ID 1593231.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Transportation Management - Version 6.2.0 to 6.3.4 [Release 6.2 to 6.3]
Information in this document applies to any platform.

Symptoms

The following error is encountered when trying to execute the "Process Unprocessed Rate Factors" action


{call pkg_rate_factor.proc_factors()=null}
java.sql.SQLDataException: ORA-01438: value larger than specified precision allowed for this column
ORA-06512: at "GLOGOWNER.PKG_RATE_FACTOR", line 164
ORA-06512: at "GLOGOWNER.PKG_RATE_FACTOR", line 686
ORA-06512: at "GLOGOWNER.PKG_RATE_FACTOR", line 917
ORA-06512: at "GLOGOWNER.PKG_RATE_FACTOR", line 1004
ORA-06512: at "GLOGOWNER.PKG_RATE_FACTOR", line 1020
ORA-06512: at line 1

java.sql.SQLDataException: ORA-01438: value larger than specified precision allowed for this column
ORA-06512: at "GLOGOWNER.PKG_RATE_FACTOR", line 164
ORA-06512: at "GLOGOWNER.PKG_RATE_FACTOR", line 686
ORA-06512: at "GLOGOWNER.PKG_RATE_FACTOR", line 917
ORA-06512: at "GLOGOWNER.PKG_RATE_FACTOR", line 1004
ORA-06512: at "GLOGOWNER.PKG_RATE_FACTOR", line 1020
ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:204)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1041)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3685)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.jav a:4714)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1376)
at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
at glog.util.jdbc.SqlCall.execute(SqlCall.java:70)
at glog.util.jdbc.SqlCall.executeOut(SqlCall.java:126)
at glog.util.jdbc.SqlCall.execute(SqlCall.java:114)
at glog.util.jdbc.SqlCall.execute(SqlCall.java:120)
at glog.business.action.RateActionExecutor.processRateFactors(RateActionExecutor.java:288)
at glog.business.session.RateActionSessionBean.processRateFactors(RateActionSessionBean.java:370)
at glog.business.session.RateActionSessionServerSideEJBWrapper.processRateFactors(RateActionSessionServerSideEJBWrapper.java:478)
at glog.business.session.RateActionSessionHome_a6s4b5_EOImpl.processRateFactors(RateActionSessionHome_a6s4b5_EOImpl.java:935)
at glog.business.session.RateActionSessionHome_a6s4b5_EOImpl_WLSkel.invoke(Unknown Source)
at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:589)
at weblogic.rmi.cluster.ClusterableServerRef.invoke(ClusterableServerRef.java:230)
at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:477)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:147)
at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:473)
at weblogic.rmi.internal.wls.WLSExecuteRequest.run(WLSExecuteRequest.java:118)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)

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