存货核算--委外材料核销报错
金蝶云社区-bin_mei_bingmeijun048183
bin_mei_bingmeijun048183
0人赞赏了该文章 844次浏览 未经作者许可,禁止转载编辑于2015年07月31日 14:21:57

问题:手工委外核销时,系统报错原因:委外入库单分录的采购成本、采购费用和材料成本有控制导致。
解决方案: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)