问题:手工委外核销时,系统报错原因:委外入库单分录的采购成本、采购费用和材料成本有控制导致。
解决方案:up2date t_im_purinwarehsentry set fpurchasecost = 0 where fpurchasecost is null
日志:java.sql.SQLException: ORA-01407: cannot update ("XMQGJT"."T_IM_PURINWAREHSENTRY"."FACTUALCOST") to NULL
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:744)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:965)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10643)
at com.kingdee.bos.sql.shell.KDPreparedStatement.executeBatch(KDPreparedStatement.java:354)
at com.apusic.jdbc.adapter.StatementHandle.executeBatch(Unknown Source)
at com.apusic.jdbc.adapter.PreparedStatementHandleJWP.executeBatch(Unknown Source)
at com.kingdee.eas.scm.cal.app.DevolveWriteOffFacadeControllerBean.saveDevolveInWarehsBillInfo(DevolveWriteOffFacadeControllerBean.java:875)
推荐阅读