1.1报错日志

Caused exception message is: ORA-30926: 无法在源表中获得一组稳定的行

at com.kingdee.eas.util.app.DbUtil.execute(DbUtil.java:304)

at com.kingdee.eas.fi.gl.app.GLBalanceFacadeControllerBean.transBalanceToNextPeriodOracle(GLBalanceFacadeControllerBean.java:2444)

at com.kingdee.eas.fi.gl.app.GLBalanceFacadeControllerBean._transBalanceToNextPeriod(GLBalanceFacadeControllerBean.java:2332)

at com.kingdee.eas.fi.gl.app.AbstractGLBalanceFacadeControllerBean.transBalanceToNextPeriod(AbstractGLBalanceFacadeControllerBean.java:191)

at sun.reflect.GeneratedMethodAccessor6901.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:125)

at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_REQUIRED(TxInvokerBean.java:60)

at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_REQUIRED(Unknown Source)

at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:172)

at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:325)

at com.sun.proxy.$Proxy189.transBalanceToNextPeriod(Unknown Source)

at com.kingdee.eas.fi.gl.GLBalanceFacade.transBalanceToNextPeriod(GLBalanceFacade.java:169)

1.2 原因

此问题为余额表里存在重复数据导致

1.3 解决方案

    1.重算科目余额表即可：

13.更新2022年4月份补丁后，快捷键进入科目余额重算功能：

原文链接：https://vip.kingdee.com/questions/300217484903611904/answers/300217484903611904?productLineId=8&isKnowledge=2

总账余额重算工具 ：

原文链接：https://vip.kingdee.com/school/210051437387618816?productLineId=31  

    2.重算完给对应余额表根据链接加上唯一索引即可：

总账余额表索引调整：设置唯一索引

原文链接：https://vip.kingdee.com/article/281469111597424896?productLineId=8&isKnowledge=2