折旧明细表查询出错!急
金蝶云社区-186xxxx3391
186xxxx3391
0人赞赏了该文章 544次浏览 未经作者许可,禁止转载编辑于2015年11月12日 13:16:19

k3cloud5.0 10。15补丁
ORACLE库
什么情况?在ORACLE SQL Developer 工具下,select那段 数据可以查询到

查询出现异常。ORA-00600: internal error code, arguments: [rwoirw: check ret val], [], [], [], [], [], [], [], [], [], [], []

CREATE TABLE TMP6992FDE688FC11E5AB98005056B AS SELECT * FROM (SELECT ROW_NUMBER() OVER( ORDER BY C.FNUMBER ASC) FIDENTITYID, 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, 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, b.forgvalp, b.FPERIOD, b.faccumdeprp, (b.forgvalp - b.faccumdeprp) FNETVALUEP, b.FDECPREP, ((b.forgvalp - b.faccumdeprp) - b.fdecprep) FKHSNETVALUEP, b.forgvalinc, b.forgvaldec, b.faccumdeprinc, b.facc