版本：V7.0+PT121127
问题：折旧明细表打开报错
QQ：412089718
CREATE TABLE TMPEDB711F54E1B11E896BEE04F437 AS SELECT ROW_NUMBER() OVER( ORDER BY TABLEB.FNUMBER ASC) FIDENTITYID, TABLEB.* FROM (SELECT cl.FNAME FASSETNAME, C.FALTERID, C.FNUMBER FASSETID, CASE WHEN fa.FDEPRMETHOD = '4' THEN wle.FPredictWorkLoad ELSE fa.FLifePeriods END FLIFEPERIODS, CASE WHEN fa.FDEPRMETHOD = '4' THEN b.FDeprWorkLoad ELSE b.FDeprPeriods END FDEPRPERIODS, CASE WHEN ((fa.FDEPRMETHOD = '4' AND (NVL(b.FDeprWorkLoad, 0) > 0)) AND (NVL(FWORKLOADUNITID, 0) <> 0)) THEN (SELECT FPrecision FROM T_BD_UNIT WHERE FUNITID = fa.FWORKLOADUNITID) ELSE 0 END FPRECISION, OOL.FNAME FOWNERORGNAME, st_l.fname FASSETSTATUS, stg_l.fname FASSETSTATUSGROUP, ty_l.fname FASSETTYPE, tyg_l.fname FASSETTYPEGROUP, at_l.fname FALTERMODE, C.FNUMBER, cy.FAMOUNTDIGITS, CASE WHEN b.FDEPR = 0 THEN 0 ELSE (b.FDEPRRATE * 100) END FDEPRRATE, FA.FACCTDATE, b.forgvalp FORGVALP, ((b.FYEAR * 100) + b.FPERIOD) FPERIOD, b.faccumdeprp FACCUMDEPRP, (b.forgvalp - b.faccumdeprp) FNETVALUEP, b.FDECPREP FDECPREP, ((b.forgvalp - b.faccumdeprp) - b.fdecprep) FKHSNETVALUEP, b.forgvalinc FORGVALINC, b.forgvaldec FORGVALDEC, b.faccumdeprinc FACCUMDEPRINC, b.faccumdeprdec FACCUMDEPRDEC, b.fdecpreinc FDECPREINC, b.fdecpredec FDECPREDEC, b.fdepr FDEPR, CASE WHEN (B.FYEAR < 2018) THEN 0 ELSE B.FCURYEARDEPR END FYEARDEPR, ((b.forgvalp + b.forgvalinc) - b.forgvaldec) FORGVALF, (((b.faccumdeprp + b.faccumdeprinc) - b.faccumdeprdec) + b.fdepr) FDEPRF, ((((((b.forgvalp + b.forgvalinc) - b.forgvaldec) - b.faccumdeprp) - b.faccumdeprinc) + b.faccumdeprdec) - b.fdepr) FNETVALUEF, ((b.fdecprep + b.fdecpreinc) - b.fdecpredec) FDECPREF, (((((((((b.forgvalp + b.forgvalinc) - b.forgvaldec) - b.faccumdeprp) - b.faccumdeprinc) + b.faccumdeprdec) - b.fdepr) - b.fdecprep) - b.fdecpreinc) + b.fdecpredec) FRECOVERAMOUNTF FROM t_Fa_card C INNER JOIN t_fa_balance B ON C.Fassetid = b.fassetid LEFT OUTER JOIN T_ORG_ORGANIZATIONS_L OOL ON (OOL.FORGID = C.FOWNERORGID AND OOL.FLOCALEID = 2052) LEFT OUTER JOIN T_FA_ACCTPOLICY PY ON py.FACCTPOLICYID = b.FACCTPOLICYID INNER JOIN (SELECT FAssetID, max(F.FAlterID) FALTERID, F.FACCTPOLICYID FROM T_FA_CARD CC INNER JOIN T_FA_FINANCE F ON cc.FAlterID = F.Falterid WHERE (F.FYearPeriod <= ((2018 * 100) + 3)) GROUP BY FAssetID, F.FACCTPOLICYID) "TEMP" ON ((("TEMP".FAssetID = B.FAssetID AND "TEMP".FAlterID = C.FAlterID) AND "TEMP".FACCTPOLICYID = b.FACCTPOLICYID) AND "TEMP".FACCTPOLICYID = py.FACCTPOLICYID) LEFT OUTER JOIN t_fa_finance FA ON ("TEMP".FalterId = fa.Falterid AND fa.facctpolicyid = "TEMP".facctpolicyid) LEFT OUTER JOIN T_BD_CURRENCY CY ON cy.FCURRENCYID = py.FCURRENCYID LEFT OUTER JOIN t_fa_status ST ON C.fassetstatusid = st.fid LEFT OUTER JOIN t_fa_status_l ST_L ON (st.fid = st_l.fid AND st_l.fLocaleId = 2052) LEFT OUTER JOIN t_fa_statusgroup_l STG_L ON (st.fparentid = stg_l.fid AND stg_l.fLocaleId = 2052) LEFT OUTER JOIN t_Fa_Assettype TY ON C.fassettypeid = ty.fid LEFT OUTER JOIN t_fa_assettype_l TY_L ON (ty.fid = ty_l.fid AND ty_l.fLocaleId = 2052) LEFT OUTER JOIN t_fa_assettypegroup_l TYG_L ON (ty.fgroup = tyg_l.fid AND tyg_l.fLocaleId = 2052) LEFT OUTER JOIN t_fa_altermode_l AT_L ON (C.faltermodeid = at_l.fid AND at_l.fLocaleId = 2052) LEFT OUTER JOIN TMPEDB711F64E1B11E896BEE04F437 M ON M.Fassetid = C.FASSETID LEFT OUTER JOIN t_fa_card_l CL ON ("TEMP".FAlterID = cl.FAlterID AND cl.FLocaleID = 2052) LEFT OUTER JOIN T_FA_WorkLoad WL ON ((((wl.FYEAR = b.FYEAR AND wl.FPeriod = b.FPERIOD) AND wl.FOWNERORGID = C.FOwnerOrgID) AND wl.FACCTPOLICYID = fa.FACCTPOLICYID) AND wl.FDOCUMENTSTATUS = 'C') LEFT OUTER JOIN T_FA_WorkLoadEntity WLE ON (wl.FID = wle.FID AND wle.FAssetID = C.FAssetID) WHERE ((C.FDOCUMENTSTATUS = 'C' AND ((C.fassetcurstatus < '5') OR (C.FassetCurStatus = '5' AND (M.FYEARPERIOD > 201803)))) AND (((b.FOwnerOrgID IN (1)) AND b.FACCTPOLICYID = 1) AND ((b.Fyear = 2018 AND b.FPeriod = 3) OR ((C.fassetcurstatus = '4' AND b.FisNewRec = 2) AND (b.FYearPeriod <= 201803)))))) TABLEB WHERE (Forgvalp IS NOT NULL)
Server stack trace:
at Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
at Kingdee.BOS.App.Data.Oracle.OracleDatabase.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.FA.App.Report.DeprDetailListService.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.GetListAndReportData(IRptParams filter)
at Kingdee.BOS.App.Core.PlugInProxy.SysReportServicePlugInProxy.GetListAndReportData(MoveReportServiceParameter parameter)
at Kingdee.BOS.App.Core.SysReportService.GetListAndReportData(MoveReportServiceParameter 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.GetListAndReportData(MoveReportServiceParameter parameter)
at Kingdee.BOS.ServiceHelper.SysReportServiceHelper.GetListAndReportData(MoveReportServiceParameter parameter)
at Kingdee.BOS.Model.Report.MoveReportModel.GetData(Int32 start, Int32 rows)
at Kingdee.BOS.Web.Report.SysReportView.GetListData()
at Kingdee.BOS.Web.Report.SysReportView.<>c__DisplayClass55.