成本计算下的投入产出表选择成本中心打开出错

成本计算下的投入产出表选择成本中心打开出错

INSERT /*+append*/ INTO TMP73819C1492D611E7AA3E7CD30AC (FOWNERNAME,FSPECIFICATION,FPROORDERNO,FPROORDERSEQ,FPRODUCTID,FCOSTCENTERID,FPRODUCTNUMBER,FPRODUCTNAME,FPRODUCTTYPE,FPROORDERTYPE,FINITINPROQTY,FBASEUNITID,FPROORDERENTRYID) SELECT isnull(OOL.FNAME,' ') AS FOWNERNAME,isnull(MTL.FSPECIFICATION,' ') AS FSPECIFICATION,T1.FPRODUCTNO AS FPROORDERNO,T1.FBILLSEQ AS FPROORDERSEQ,MT.FMASTERID AS FPRODUCTID,ISNULL(T1.FCOSTCENTERID,0) AS FCOSTCENTERID,MT.FNUMBER AS FPRODUCTNUMBER,isnull(MTL.FNAME,' ') AS FPRODUCTNAME,T1.FPRODUCTTYPE AS FPRODUCTTYPE,T1.FPROORDERTYPE AS FPROORDERTYPE, CALEXP.FBEGINQTY AS FINITINPROQTY,MTB.FBASEUNITID AS FBASEUNITID,T1.FBILLENTRYID AS FPROORDERENTRYID FROM T_CB_PROORDERINFO T0 INNER JOIN T_CB_PROORDERDIME T1 ON T0.FProductDimeId=T1.FProductDimeId INNER JOIN T_CB_CostCalExpense CALEXP ON CALEXP.FID=T0.FID INNER JOIN T_HS_OUTACCTG AG ON AG.FID=T0.FACCTGID INNER JOIN T_HS_CALDIMENSIONS CALDIM ON CALDIM.FDIMENSIONID=AG.FDIMENSIONID LEFT JOIN T_ORG_ORGANIZATIONS_L OOL ON OOL.FORGID=T0.FBUSINESSORG AND OOL.FLOCALEID=2052 LEFT JOIN T_BD_LOTMASTER LOT ON LOT.FLOTID=T0.FLOT LEFT JOIN t_eng_bom BOM ON BOM.FID=T0.FBOMID INNER JOIN t_bd_Material MT ON T1.FPRODUCTID=MT.FMATERIALID INNER JOIN t_BD_MaterialBase MTB ON MT.FMATERIALID=MTB.FMATERIALID LEFT JOIN t_bd_Material_l MTL ON MT.FMATERIALID=MTL.FMATERIALID AND MTL.FLOCALEID=2052 WHERE CALDIM.FACCTSYSTEMID=1 AND CALDIM.FFINORGID=1 AND CALDIM.FACCTPOLICYID=1 AND AG.FYEAR=2017 AND AG.FPERIOD=7 AND T0.FENDINITKEY='0' and CC.FNumber >= 'BM000001' and CC.FNumber <= 'BM000001' and T1.FPROORDERTYPE in ('PO','SPO','OUTSRC','REM')

Server stack trace:
at Kingdee.BOS.App.Data.Sql.SqlDatabase.ExecuteBatch(List`1 sqlArray, Int32 batchSize, Int32 commandTimeout)
at Kingdee.BOS.App.Data.DBUtils.ExecuteBatchWithTime(Context ctx, List`1 sqlArray, Int32 batchSize, Int32 commandTimeout)
at Kingdee.K3.FIN.CB.App.Report.PutInOutPutRpt.InsertDataToTempTable(String tempTable)
at Kingdee.K3.FIN.CB.App.Report.PutInOutPutRpt.BuilderReportSqlAndTempTable(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__DisplayClass55.b__51()