报错问题初步定位在： INNER JOIN (SELECT \*+ CARDINALITY(B 1) *\

FID

FROM (select COLUMN_VALUE as FID

from table(cast(:FALTERID_udt as udt_inttable))) b) FC

ON FC.FID = F.FAlterID

生成的sql报错代码：

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, FISINIT) 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, CASE WHEN (F.FDEPRMETHOD = '4' AND FISMODIFYDEPRFAC = '1') THEN ((B.FACCUMDEPRP + B.FACCUMDEPRINC) - B.FACCUMDEPRDEC) ELSE F.FACCUMDEPR END 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, CASE WHEN D.FISDEPRASBE

产品问题调用固定资产处置单webapi时生成的sql时保存报错

产品问题 调用固定资产处置单webapi时生成的sql时保存报错

恭喜您！

产品问题
调用固定资产处置单webapi时生成的sql时保存报错

产品问题调用固定资产处置单webapi时生成的sql时保存报错