发生时间: 2016-09-20 04:59:13
错误编号: BOS_ExecuteNonQuery
错误信息: ORA-00600: internal error code, arguments: [rwoirw: check ret val], [], [], [], [], [], [], [], [], [], [], []
Sql语句: INSERT INTO TM_FA_ASSERTDEPR (FNUMBER, FOWNERORGID, FASSETTYPEID, FASSETID, FALTERID, FYEAR, FPERIOD, FDEPRREMAIN, FSHOULDDEPR, FDEPR, FDEPRRATE, ISLASTPERIOD, FCLEARDEPRPOLICY, FISAFFECTDEPR, FASSETCURSTATUS, FQUANTITY, FACCTPOLICYID, FCURRENTYEAR, FCURRENTPERIOD, FORGVAL, FACCUMDEVALUE, FACCUMDEPR, FPREACCUMDEPR, FRESIDUALVALUE, FLIFEPERIODS, FDEPRPERIODS, FISCAL, FDEPROPTION, FISMODIFYDEPRFAC, FISDEPRFACTORYMODIFY, FDEPRMETHOD, FPERIODCOUNT, FREMAINYEAR, FLIFEYEAR, FISLASTTWOYEAR, FERRORDESCRIPTION, FFORMULACONTENT, FDOCUMENTSTATUS, FYTDDEPRPERIOD, FISNEXTFIRSTPERIOD, FAmountDigits, FISCURRPERIODADD, FISCUMPUTALTER, FPREDICTWORKLOAD, FTOTALWORKLOAD, FPERIODWORKLOAD, FWORKLOADUNITID, FDEPRWORKLOAD, FYEARPERIOD) SELECT C.FNumber, B.FOwnerOrgID, C.FAssetTypeID, B.FASSETID, C.FAlterID, F.Fyear, F.FPeriod, (((((B.FORGVALP + B.FORGVALINC) - B.FORGVALDEC) - ((B.FDECPREP + B.FDECPREINC) - B.FDECPREDEC)) - ((B.FACCUMDEPRP + B.FACCUMDEPRINC) - B.FACCUMDEPRDEC)) - F.FRESIDUALVALUE) FDEPRREMAIN, B.FShouldDepr, B.FDepr, B.FDeprRate, DECODE((F.FLifePeriods - B.FDeprPeriods), 1, 1, 0) ISLASTPERIOD, D.FCLEARDEPRPOLICY, D.FISAFFECTDEPR, C.FAssetCurStatus, C.FQuantity, F.FACCTPOLICYID, T.FCurrentYear, T.FCurrentPeriod, F.FOrgVal, F.FAccumDevalue, F.FAccumDepr, DECODE(B.FACCUMDEPRP, 0, B.FACCUMDEPRINC, B.FACCUMDEPRP) FPREACCUMDEPR, F.FResidualvalue, F.FLifePeriods, B.FDeprPeriods, 0 FISCAL, M.FDEPROPTION, FIsModifyDeprFac, FIsDeprFactoryModify, F.FDeprMethod, AC.fperiodcount, (((1.00 * F.FLifePeriods) - F.FDeprPeriods) / Fperiodcount) FREMAINYEAR, ((1.00 * FLifePeriods) / Fperiodcount) FLIFEYEAR, 0 FISLASTTWOYEAR, ' ' FERRORDESCRIPTION, ' ' FFORMULACONTENT, NVL(da.FDocumentstatus, ' ') FDOCUMENTSTATUS, FYtdDeprPeriod, FIsNextFirstPeriod, BC.FAmountDigits, DECODE(B.FORGVALP, 0, 1, 0) FISCURRPERIODADD, 1 FISCUMPUTALTER, NVL(F.FPredictWorkLoad, 0) FPREDICTWORKLOAD, NVL(((B.Fdeprworkload - F.Finitialdeprworkload) + f.finitialtotalworkload), 0) FTOTALWORKLOAD, NVL(wle.FPERIODWORKLOAD, 0) FPERIODWORKLOAD, NVL(F.FWorkLoadUnitId, 0) FWORKLOADUNITID, NVL(B.Fdeprworkload, 0) FDEPRWORKLOAD, ((F.Fyear * 100) + F.FPeriod) FYEARPERIOD FROM T_FA_CARD C INNER JOIN T_FA_STATUS S ON (C.FAssetStatusID = S.FID AND S.FWHETHERDEPR = 1) INNER JOIN T_FA_FINANCE F ON C.FAlterID = F.FAlterID INNER JOIN ( select COLUMN_VALUE as FID from table(cast(:FALTERID_udt as udt_inttable))) fc ON FC.FID = F.FAlterID INNER JOIN T_FA_BALANCE B ON ((C.FAssetID = B.FASSETID AND B.FIsNewRec = '2') AND B.FACCTPOLICYID = F.FACCTPOLICYID) INNER JOIN T_FA_ACCTPOLICY P ON P.FACCTPOLICYID = F.FACCTPOLICYID INNER JOIN T_FA_ACCTPOLICYASSET E ON (P.FACCTPOLICYID = E.FACCTPOLICYID AND E.FASSETTYPEID = C.FAssetTypeID) INNER JOIN t_BD_ACCOUNTCALENDAR AC ON P.FACCTCALENDARID = AC.FID INNER JOIN T_FA_DEPRPOLICY D ON D.FPOLICYID = E.FDEPRPOLICYID INNER JOIN T_bd_Currency BC ON P.Fcurrencyid = BC.FCURRENCYID INNER JOIN T_FA_DEPRMETHOD M ON M.FID = F.FDeprMethod INNER JOIN V_FA_SYSTEMPROFILE T ON ((F.FACCTPOLICYID = T.FACCTPOLICYID AND C.FOwnerOrgID = T.FOrgID) AND B.FOwnerOrgID = T.FOrgID) INNER JOIN TM_FA_ASSETANDALTERID MA ON (Ma.FAlterID = C.FAlterID AND Ma.FAssetID = C.FAssetID) LEFT OUTER JOIN t_fa_depradjust DA ON (((da.FOWNERORGID = B.FOWNERORGID AND da.FACCTPOLICYID = F.FACCTPOLICYID) AND da.FYear = T.FCurrentYear) AND da.FPeriod = T.FCurrentPeriod) LEFT OUTER JOIN T_FA_WorkLoad WL ON ((((wl.FYEAR = T.FCurrentYear AND wl.FPeriod = T.FCurrentPeriod) AND wl.FOWNERORGID = T.FOrgID) AND wl.FACCTPOLICYID = T.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.FFORBIDSTATUS = 'A') AND ((C.FAssetCurStatus IN ('1', '2', '3', '4', '7')) AND (((F.FLifePeriods >= (B.FDeprPeriods + 1)) AND (F.Fdeprmethod < '4')) OR (F.Fdeprmethod = '4' AND ((F.Fpredictworkload > B.Fdeprworkload) OR (F.Fpredictworkload IS NULL) OR (B.Fdeprworkload IS NULL)))))) ORDER BY C.FOWNERORGID ASC, C.FNUMBER ASC
===================================================
调用堆栈:
Server stack trace:
at Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
at Kingdee.BOS.App.Data.DBUtils.ExecuteBatch(Context ctx, List`1 lstSqlObj)
at Kingdee.K3.FIN.FA.App.Core.AssetDeprService.GetMainTableData(Context ctx, Dictionary`2 dtTableName, Dictionary`2 dParam)
at Kingdee.K3.FIN.FA.App.Core.AssetDeprService.AssetDepr(Context ctx, List`1 lst, Dictionary`2 dParam)
at Kingdee.K3.FIN.FA.App.ServicePlugIn.Disposal.Save.BeginOperationTransaction(BeginOperationTransactionArgs e)
at Kingdee.BOS.App.Core.PlugInProxy.OperationServicePlugInProxy.FireBeginOperationTransaction(BeginOperationTransactionArgs e)
at Kingdee.BOS.App.Core.AbstractOprerationService.CallOperation(DynamicObject[]& objs)
at Kingdee.BOS.App.Core.AbstractOprerationService.CallOperatinTransaction(DynamicObject[] objs)
at Kingdee.BOS.App.Core.AbstractOprerationService.DoExcete()
at Kingdee.BOS.App.Core.AbstractOprerationService.Excute(DynamicObject[] dataEntities)
at Kingdee.BOS.App.Core.SaveService.Save(Context ctx, BusinessInfo info, DynamicObject[] dataEntities, OperateOption option, String operationNumber)
Exception rethrown at [0]:
at Kingdee.BOS.ServiceHelper.BusinessDataServiceHelper.Save(Context ctx, BusinessInfo businessInfo, DynamicObject dataObject, OperateOption option, String operationNumber)
at Kingdee.BOS.Model.Bill.BillModel.Save(OperateOption option)
at Kingdee.BOS.Business.Bill.Operation.Submit.DoSaveBill(OperateOption option, IOperationResult fullResult)
at Kingdee.BOS.Business.Bill.Operation.Submit.ExecuteBillOperation(OperateOption option)
at Kingdee.BOS.Business.Bill.Operation.Submit.ExecuteOperation()
at Kingdee.BOS.Core.DynamicForm.AbstractDynamicFormOperation.Operation(CallBackWfAfterOperation callbackwf, IOperationResult result)