跪求帮忙！！！材料出库核算一直报错，找不到原因

栏目：eas cloud知识作者：金蝶来源：金蝶云社区发布：2024-09-16浏览：1

报错提示如图。报错信息为：
错误信息：null
Caused exception message is: error occurred during batching: ORA-01427: single-row subquery returns more than one row

错误详细堆栈信息：com.kingdee.bos.BOSException: null
Caused exception message is: error occurred during batching: ORA-01427: single-row subquery returns more than one row

at com.kingdee.eas.scm.common.app.util.SysTempTableHelper.execute(SysTempTableHelper.java:152)
at com.kingdee.eas.scm.common.app.util.SysTempTableHelper.execute(SysTempTableHelper.java:117)
at com.kingdee.eas.scm.cal.app.calculate.WeightedAverageCalculateNew.calculateStrategy(WeightedAverageCalculateNew.java:172)
at com.kingdee.eas.scm.cal.app.calculate.AbstractCalculateCost.calculateCost(AbstractCalculateCost.java:120)
at com.kingdee.eas.scm.cal.app.CalculateFacadeControllerBean.weightAvgeCalcalate(CalculateFacadeControllerBean.java:514)
at com.kingdee.eas.scm.cal.app.CalculateFacadeControllerBean.costSubCalculate(CalculateFacadeControllerBean.java:458)
at com.kingdee.eas.scm.cal.app.CalculateFacadeControllerBean._costCalculate(CalculateFacadeControllerBean.java:167)
at com.kingdee.eas.scm.cal.app.AbstractCalculateFacadeControllerBean.costCalculate(AbstractCalculateFacadeControllerBean.java:138)
at sun.reflect.GeneratedMethodAccessor1662.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:116)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_NEVER(TxInvokerBean.java:77)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_NEVER(Unknown Source)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:211)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:324)
at $Proxy155.costCalculate(Unknown Source)
at com.kingdee.eas.scm.cal.CalculateFacade.costCalculate(CalculateFacade.java:103)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_scm_1_cal_1_ICalculateFacade.pi11(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_scm_1_cal_1_ICalculateFacade.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceInvoke(RPCService.java:629)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:125)
at com.kingdee.bos.rpc.impl.ServiceDispatcher.run(ServiceDispatcher.java:153)
at com.kingdee.bos.rpc.impl.ThreadJob.run(ThreadJob.java:24)
at com.kingdee.bos.rpc.impl.ThreadPool2$Worker.run(ThreadPool2.java:103)
Caused by: java.sql.BatchUpdateException: error occurred during batching: ORA-01427: single-row subquery returns more than one row

at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:414)
at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:454)
at oracle.jdbc.driver.OracleStatement.executeBatch(OracleStatement.java:3964)
at com.kingdee.bos.sql.shell.KDStatement.executeBatch(KDStatement.java:415)
at com.apusic.jdbc.adapter.StatementHandle.executeBatch(Unknown Source)
at com.kingdee.eas.scm.common.app.util.SysTempTableHelper.execute(SysTempTableHelper.java:150)
at com.kingdee.eas.scm.common.app.util.SysTempTableHelper.execute(SysTempTableHelper.java:117)
at com.kingdee.eas.scm.cal.app.calculate.WeightedAverageCalculateNew.calculateStrategy(WeightedAverageCalculateNew.java:172)
at com.kingdee.eas.scm.cal.app.calculate.AbstractCalculateCost.calculateCost(AbstractCalculateCost.java:120)
at com.kingdee.eas.scm.cal.app.CalculateFacadeControllerBean.weightAvgeCalcalate(CalculateFacadeControllerBean.java:514)
at com.kingdee.eas.scm.cal.app.CalculateFacadeControllerBean.costSubCalculate(CalculateFacadeControllerBean.java:458)
at com.kingdee.eas.scm.cal.app.CalculateFacadeControllerBean._costCalculate(CalculateFacadeControllerBean.java:167)
at com.kingdee.eas.scm.cal.app.AbstractCalculateFacadeControllerBean.costCalculate(AbstractCalculateFacadeControllerBean.java:138)
at sun.reflect.GeneratedMethodAccessor1662.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:116)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_NEVER(TxInvokerBean.java:77)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_NEVER(Unknown Source)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:211)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:324)
at $Proxy155.costCalculate(Unknown Source)
at com.kingdee.eas.scm.cal.CalculateFacade.costCalculate(CalculateFacade.java:103)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_scm_1_cal_1_ICalculateFacade.pi11(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_scm_1_cal_1_ICalculateFacade.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceInvoke(RPCService.java:629)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:125)
at com.kingdee.bos.rpc.impl.ServiceDispatcher.run(ServiceDispatcher.java:153)
at com.kingdee.bos.rpc.impl.ThreadJob.run(ThreadJob.java:24)
at com.kingdee.bos.rpc.impl.ThreadPool2$Worker.run(ThreadPool2.java:103)