EAS703固定资产结账错误，请教怎么处理

EAS Cloud-知识分享

云社区用户18x81234

1,822次浏览编辑于2015年11月01日 15:13:00

EAS703固定资产结账错误，截图及错误提示如下，请教怎么处理？

错误提示：
错误信息：Sql1 execute exception : update T_Fa_FaCurCard set

(fcreatorid,fcreatetime,flastupdateuserid,flastupdatetime,fcontrolunitid,fnumber,fbizd

ate,fhandlerid,fdescription,fhaseffected,fauditorid,fsourcebillid,fsourcefunction,fcom

panyid,fassetcatid,fassetname,fassetamt,fmeasureunitid,faccountdate,foriginmethodid,fu

sestatusid,feconomicpurpid,fstorecityid,fspecs,fparea,fmfr,flevfrdate,fpaperno,fdeptid

,fkeeperid,forigintype,foriginunit,fremark,fcurrencyid,fexrate,foriginamt,fassetvalue,

fbuyvalue,fbuyaccudepr,faddons,fdeliverdate,fstartusedate,fdeprtermcount,fusetermcount

,fuseyears,faccudepr,faccudeprtyear,fneatremvalue,fdecvalue,fmeasureunitwlid,fneatvalu

e,fneatamt,fdeprmethodid,faccudeprchg,faccudepraccuchg,faccudepraccuclean,fdeprtterm,f

accudeprchgtyear,faccudepraccuchgtyear,faccudepraccucleantyear,faccudeprall,fdecvaluec

hg,fdecvalueaccuchg,faccountassetid,faccountaccudeprid,faccountdecvalueid,foriginflag,

fhasdisabled,fbizstatus,fcheckedstatus,fdeletedstatus,feffectedstatus,fblockedstatus,f

evalleftperiod,finitevalvalue,flastevalvalue,forigindif,foriginaccudif,fhaschanged,fha

scleared,fhasevaled,fhasnew,fhassplited,fisneedredepr,fperiodid,flastbillid,fleftyear,

faccudeprforcal,fleftyearup,fdeprcount,flastperiodcount,fwelldeprvalue,ftempdeprmethod

,ftempdeprtermcount,ftempusetermcount,fisinitchange,fisevaledbefore,fmonthdeprerate,fi

soveraged,ffairvalue,ftreatmentincome,fneatleftrate,faddonfare,fworkloadfordap,fdecval

uefordap,ffiaccountdate,fleasestatus,fevalreinaccountdate,fevaldeprperiodnum,fevaldepr

modeid,fevalmonthrate,fevaladddepr,fevalremvalue,fevalyeardepr,fevaldecvalue,fevalneat

value,fevalneatamt,foldnumber,fevalassetvalue,fevaltaxleftperiod,fevalmeasureunitwl,fe

valusetermcount,fevaldeprtterm,fevalneatleftrate,flastperiodchange,flaterperioddata,fg

roupnumberstatus,fgroupnumber,fvouchernumber,finputtax,fwrtyperiod,fwrtynumber,fleftye

artwo,fbarcode,fbarcodestatus,fisrequisitioned,fisborrowing,fabstract
) = ( Select mon.fcreatorid as fcreatorid,mon.fcreatetime as

fcreatetime,mon.flastupdateuserid as flastupdateuserid,mon.flastupdatetime as

flastupdatetime,mon.fcontrolunitid as fcontrolunitid,mon.fnumber as

fnumber,mon.fbizdate as fbizdate,mon.fhandlerid as fhandlerid,mon.fdescription as

fdescription,mon.fhaseffected as fhaseffected,mon.fauditorid as

fauditorid,mon.fsourcebillid as fsourcebillid,mon.fsourcefunction as

fsourcefunction,mon.fcompanyid as fcompanyid,mon.fassetcatid as

fassetcatid,mon.fassetname as fassetname,mon.fassetamt as fassetamt,mon.fmeasureunitid

as fmeasureunitid,mon.faccountdate as faccountdate,mon.foriginmethodid as

foriginmethodid,mon.fusestatusid as fusestatusid,mon.feconomicpurpid as

feconomicpurpid,mon.fstorecityid as fstorecityid,mon.fspecs as fspecs,mon.fparea as

fparea,mon.fmfr as fmfr,mon.flevfrdate as flevfrdate,mon.fpaperno as

fpaperno,mon.fdeptid as fdeptid,mon.fkeeperid as fkeeperid,mon.forigintype as

forigintype,mon.foriginunit as foriginunit,mon.fremark as fremark,mon.fcurrencyid as

fcurrencyid,mon.fexrate as fexrate,mon.foriginamt as foriginamt,mon.fassetvalue as

fassetvalue,mon.fbuyvalue as fbuyvalue,mon.fbuyaccudepr as fbuyaccudepr,mon.faddons as

faddons,mon.fdeliverdate as fdeliverdate,mon.fstartusedate as

fstartusedate,mon.fdeprtermcount as fdeprtermcount,mon.fusetermcount as

fusetermcount,mon.fuseyears as fuseyears,mon.faccudepr as faccudepr,mon.faccudeprtyear

as faccudeprtyear,mon.fneatremvalue as fneatremvalue,mon.fdecvalue as

fdecvalue,mon.fmeasureunitwlid as fmeasureunitwlid,mon.fneatvalue as

fneatvalue,mon.fneatamt as fneatamt,mon.fdeprmethodid as

fdeprmethodid,mon.faccudeprchg as faccudeprchg,mon.faccudepraccuchg as

faccudepraccuchg,mon.faccudepraccuclean as faccudepraccuclean,mon.fdeprtterm as

fdeprtterm,mon.faccudeprchgtyear as faccudeprchgtyear,mon.faccudepraccuchgtyear as

faccudepraccuchgtyear,mon.faccudepraccucleantyear as

faccudepraccucleantyear,mon.faccudeprall as faccudeprall,mon.fdecvaluechg as

fdecvaluechg,mon.fdecvalueaccuchg as fdecvalueaccuchg,mon.faccountassetid as

faccountassetid,mon.faccountaccudeprid as faccountaccudeprid,mon.faccountdecvalueid as

faccountdecvalueid,mon.foriginflag as foriginflag,mon.fhasdisabled as

fhasdisabled,mon.fbizstatus as fbizstatus,mon.fcheckedstatus as

fcheckedstatus,mon.fdeletedstatus as fdeletedstatus,mon.feffectedstatus as

feffectedstatus,mon.fblockedstatus as fblockedstatus,mon.fevalleftperiod as

fevalleftperiod,mon.finitevalvalue as finitevalvalue,mon.flastevalvalue as

flastevalvalue,mon.forigindif as forigindif,mon.foriginaccudif as

foriginaccudif,mon.fhaschanged as fhaschanged,mon.fhascleared as

fhascleared,mon.fhasevaled as fhasevaled,mon.fhasnew as fhasnew,mon.fhassplited as

fhassplited,mon.fisneedredepr as fisneedredepr,mon.fperiodid as

fperiodid,mon.flastbillid as flastbillid,mon.fleftyear as

fleftyear,mon.faccudeprforcal as faccudeprforcal,mon.fleftyearup as

fleftyearup,mon.fdeprcount as fdeprcount,mon.flastperiodcount as

flastperiodcount,mon.fwelldeprvalue as fwelldeprvalue,mon.ftempdeprmethod as

ftempdeprmethod,mon.ftempdeprtermcount as ftempdeprtermcount,mon.ftempusetermcount as

ftempusetermcount,mon.fisinitchange as fisinitchange,mon.fisevaledbefore as

fisevaledbefore,mon.fmonthdeprerate as fmonthdeprerate,mon.fisoveraged as

fisoveraged,mon.ffairvalue as ffairvalue,mon.ftreatmentincome as

ftreatmentincome,mon.fneatleftrate as fneatleftrate,mon.faddonfare as

faddonfare,mon.fworkloadfordap as fworkloadfordap,mon.fdecvaluefordap as

fdecvaluefordap,mon.ffiaccountdate as ffiaccountdate,mon.fleasestatus as

fleasestatus,mon.fevalreinaccountdate as fevalreinaccountdate,mon.fevaldeprperiodnum

as fevaldeprperiodnum,mon.fevaldeprmodeid as fevaldeprmodeid,mon.fevalmonthrate as

fevalmonthrate,mon.fevaladddepr as fevaladddepr,mon.fevalremvalue as

fevalremvalue,mon.fevalyeardepr as fevalyeardepr,mon.fevaldecvalue as

fevaldecvalue,mon.fevalneatvalue as fevalneatvalue,mon.fevalneatamt as

fevalneatamt,mon.foldnumber as foldnumber,mon.fevalassetvalue as

fevalassetvalue,mon.fevaltaxleftperiod as fevaltaxleftperiod,mon.fevalmeasureunitwl as

fevalmeasureunitwl,mon.fevalusetermcount as fevalusetermcount,mon.fevaldeprtterm as

fevaldeprtterm,mon.fevalneatleftrate as fevalneatleftrate,mon.flastperiodchange as

flastperiodchange,mon.flaterperioddata as flaterperioddata,mon.fgroupnumberstatus as

fgroupnumberstatus,mon.fgroupnumber as fgroupnumber,mon.fvouchernumber as

fvouchernumber,mon.finputtax as finputtax,mon.fwrtyperiod as

fwrtyperiod,mon.fwrtynumber as fwrtynumber,mon.fleftyeartwo as

fleftyeartwo,mon.fbarcode as fbarcode,mon.fbarcodestatus as

fbarcodestatus,mon.fisrequisitioned as fisrequisitioned,mon.fisborrowing as

fisborrowing,mon.fabstract as fabstract
From T_Fa_FaMonCard mon Where mon.FFaCurCardID = T_Fa_FaCurCard.FID
And mon.FFaPeriodID = '1aIAAAAK9i6COIxM' And mon.FCompanyID in ('1aIAAAAAFbPM567U'))

where T_Fa_FaCurCard.FCompanyID in ('1aIAAAAAFbPM567U')

Caused exception message is: ORA-01427: single-row subquery returns more than one row

错误详细堆栈信息：com.kingdee.bos.BOSException: Sql1 execute exception : update

T_Fa_FaCurCard set