科目余额表勾选未过账凭证这个参数后，查询报错，其他情况都可以正常查询。
报错信息：
查询出现异常。ORA-01438: value larger than specified precision allowed for this column
INSERT INTO TMP90907632F4BF11E682AF005056B (FBALANCETOTAL, FACCTID, FBALANCEID, FBALANCENAME, FLEVEL, FDC, FITEMDETAILID, FPARENTID, FGROUPID, FDETAILID, FDETAILNUMBER, FDETAILNAME, FCyID, FCyName, FISDETAIL, FAMOUNTDIGITS, FBeginBalanceFor, FBeginBalanceLocal, FEndBalanceFor, FEndBalanceLocal, FDebit, FDebitLocal, FCredit, FCreditLocal, FYtdDebit, FYtdDebitLocal, FYtdCredit, FYtdCreditLocal, FBeginDebit, FBeginDebitLocal, FBeginCredit, FBeginCreditLocal, FEndDebit, FEndDebitLocal, FEndCredit, FEndCreditLocal, FDataType) SELECT -1 FBALANCETOTAL, 0 FACCTID, 'ZZ' FBALANCEID, '合计' FBALANCENAME, 1 FLEVEL, 1 FDC, 1 FITEMDETAILID, 0 FPARENTID, 0 FGROUPID, 0 FDETAILID, ' ' FDETAILNUMBER, ' ' FDETAILNAME, -1 FCYID, '' FCYNAME, 0 FISDETAIL, NVL(Avg(B.FAMOUNTDIGITS), 2) FAMOUNTDIGITS, 0 FBEGINBALANCEFOR, 0 FBEGINBALANCELOCAL, 0 FENDBALANCEFOR, 0 FENDBALANCELOCAL, NVL(sum(B.FDebit), 0) FDEBIT, NVL(sum(B.FDebitLocal), 0) FDEBITLOCAL, NVL(sum(B.FCredit), 0) FCREDIT, NVL(sum(B.FCreditLocal), 0) FCREDITLOCAL, NVL(sum(B.FYtdDebit), 0) FYTDDEBIT, NVL(sum(B.FYtdDebitLocal), 0) FYTDDEBITLOCAL, NVL(sum(B.FYtdCredit), 0) FYTDCREDIT, NVL(sum(B.FYtdCreditLocal), 0) FYTDCREDITLOCAL, NVL(Sum(B.FBeginDebit), 0) FBEGINDEBIT, NVL(Sum(B.FBeginDebitLocal), 0) FBEGINDEBITLOCAL, NVL(Sum(B.FBeginCredit), 0) FBEGINCREDIT, NVL(Sum(B.FBeginCreditLocal), 0) FBEGINCREDITLOCAL, NVL(Sum(B.FEndDebit), 0) FENDDEBIT, NVL(Sum(B.FEndDebitLocal), 0) FENDDEBITLOCAL, NVL(Sum(B.FEndCredit), 0) FENDCREDIT, NVL(Sum(B.FEndCreditLocal), 0) FENDCREDITLOCAL, -2 FROM TMP90907632F4BF11E682AF005056B B LEFT OUTER JOIN (SELECT DISTINCT FParentID FROM TMP90907632F4BF11E682AF005056B WHERE (FParentID <> 0)) T ON B.FAcctID = T.FParentID WHERE (((T.FParentID IS NULL) AND B.FBalanceTotal = 0) AND ((B.FDETAILID <> 0) OR (B.FITEMDETAILID = 0 AND B.FDETAILID = 0)))
Server stack trace:
at Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
at Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL, IEnumerable`1 paramList, Boolean needTranslate)
at Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL)
at Kingdee.K3.FIN.GL.App.Core.AccountBalanceStatement.AccountBalanceExecute(Context ctx, String tableName, String filter, String orderby, Boolean isDelBalanceTable)
at Kingdee.K3.FIN.GL.App.Report.AccountBalanceService.BuilderSql(IRptParams filter, String tableName)
at Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.CreateTempTable(IRptParams filter, String tablename)
at Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetDataForVirtual(IRptParams filter)
at Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetData(IRptParams filter)
at Kingdee.BOS.App.Core.PlugInProxy.SysReportServicePlugInProxy.GetReportData(ReportServiceParameter parameter)
at Kingdee.BOS.App.Core.SysReportService.GetReportData(ReportServiceParameter parameter)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Kingdee.BOS.Contracts.ISysReportService.GetReportData(ReportServiceParameter parameter)
at Kingdee.BOS.ServiceHelper.SysReportServiceHelper.GetReportData(ReportServiceParameter parameter)
at Kingdee.BOS.Model.Report.SysReportModel.GetData(Int32 start, Int32 rows)
at Kingdee.BOS.Web.Report.SysReportView.GetListData()
at Kingdee.BOS.Web.Report.SysReportView.<>c__DisplayClass4d.