生成凭证报错,ora-01722
金蝶云社区-崔小齐
崔小齐
0人赞赏了该文章 822次浏览 未经作者许可,禁止转载编辑于2018年02月01日 11:23:51

折旧调整单生成凭证时报错,ora-01722。
[{"operation":"BAS_BusinessVoucher.MBIClick.tbMakeVoucher"}]
发生时间: 2018-02-01 10:44:15
错误编号: BOS_ExecuteScalar
错误信息: ORA-01722: invalid number
Sql语句: SELECT Max(FLOOR(TO_NUMBER(FBILLNO))) FBILLNO FROM T_GL_Voucher WHERE FACCOUNTBOOKID = :FAccountBookId
===================================================
调用堆栈:
在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteScalar(DbCommand command, SqlParam[] paramList)
在 Kingdee.BOS.App.Data.DBUtils.ExecuteScalar[T](Context ctx, String strSql, T defaultValue, SqlParam[] paramList)
在 Kingdee.K3.FIN.App.Core.BuildVoucher.BuildPolicy.BuildVoucherLogic.SaveBuildVchResult.SetVoucherBillNo(List`1 glVoucherObjs)
在 Kingdee.K3.FIN.App.Core.BuildVoucher.BuildPolicy.BuildVoucherLogic.SaveBuildVchResult.DoAction()
在 Kingdee.K3.FIN.App.Core.BuildVoucher.BuildVoucherEngine.DoEverySourceBill(VchSelectBookInfor book, VchSelectSourceBillInfor sourceBill, Int32& iBill)
在 Kingdee.K3.FIN.App.Core.BuildVoucher.BuildVoucherEngine.BuildVoucher(BizVchMakeSchemeInfor buildVoucherScheme)
在 Kingdee.K3.FIN.App.Core.BuildVoucher.BuildVoucherService.BuildVoucher(Context ctx, BizVchMakeSchemeInfor buildVoucherScheme)
在 Kingdee.K3.FIN.GL.ServiceHelper.BuildVoucherServiceHelper.BuildVoucher(Context ctx, BizVchMakeSchemeInfor buildVoucherScheme)
在 Kingdee.K3.FIN.GL.Business.PlugIn.BusinessVoucherEdit.MakeGlVoucher()
在 Kingdee.K3.FIN.GL.Business.PlugIn.BusinessVoucherEdit.DoActionUnderNetWorkCtrl(String oparation, String interId, BizAction bizAction)
在 Kingdee.K3.FIN.GL.Business.PlugIn.BusinessVoucherEdit.BarItemClick(BarItemClickEventArgs e)
在 Kingdee.BOS.Core.DynamicForm.PlugIn.DynamicFormViewPlugInProxy.FireBarItemClick(BarItemClickEventArgs e)
在 Kingdee.BOS.Web.DynamicForm.DynamicWebFormView.BarItemClick(String parentKey, String barItemKey, BarDataManager bar, Int32 bartype)
在 Kingdee.BOS.Web.DynamicForm.DynamicWebFormView.MainBarItemClick(String barItemKey)
在 Kingdee.BOS.Web.DynamicForm.DynamicWebFormController.MainBarItemClick(String itemKey, JSONArray postDatas)

QQ:1316072520.电话18310050069.