应付系统结账，报系统错误，ora-01652。急啊！！！！

应付系统结账，报系统错误，ora-01652

部分报错信息：
错误信息：null
Caused exception message is: java.sql.BatchUpdateException: error occurred during batching: ORA-01652: unable to extend temp segment by 128 in tablespace EAS_T_EAS002_STANDARD_02
\n脚本:\ninsert into VTE7Y0UR1UN1HVMULJTWX5CTRG select FCompanyID ,FAsstActTypeID ,FAsstActID ,FCurrencyID ,FPersonID ,FAdminOrgUnitID ,FAccountID ,sum(FDebitAmount) FTotalDebitAmount ,sum(FCreditAmount) FTotalCreditAmount ,sum(fdebitamountlocal) FTotalDebitAmountLoc ,sum(fcreditdebitamountlocal) FTotalCreditAmountLoc from (select FCompanyID,FAsstActTypeID,FAsstActID,FCurrencyID, FAccountCompanyID,FControlUnitID,FAccountTableID,FBillDate,FVoucherDate ,CASE ISNULL(RTRIM(LTRIM(FPersonID)),'z') WHEN 'z' THEN 'z' WHEN '' THEN 'z' ELSE FPersonID END AS FPersonID ,CASE ISNULL(RTRIM(LTRIM(FAdminOrgUnitID)),'z') WHEN 'z' THEN 'z' WHEN '' THEN 'z' ELSE FAdminOrgUnitID END AS FAdminOrgUnitID, FAccountID,FDirection,FDebitAmount,FCreditAmount,Fdebitamountlocal,Fcreditdebitamountlocal from v_ap_checkaccount where 1=1 and voucherBizStatus != 0
and voucherBizStatus != 2
and fperiodyear = 2016
and fperiodnumber = 3
and FCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' AND FVoucherCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' and (FAccountCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' or FAccountCompanyID='111') and FControlUnitID='/SSaRIj6SYivL0GYiGSK48znrtQ=' and FAccountTableID='590gfSC8RFWLeOLZtBsJNhdpjm0=' and FVoucherDate>={2016-03-01} and FVoucherDate<{2016-04-01} ) as bill group by FCompanyID,FAsstActTypeID,FAsstActID,FCurrencyID,FPersonID,FAdminOrgUnitID,FAccountID
insert into VTE7Y0UR1UN1HVMULJTWX5CTRG select FCompanyID ,FAsstActTypeID ,FAsstActID ,FCurrencyID ,FPersonID ,FAdminOrgUnitID ,FAccountID ,sum(FDebitAmount) FTotalDebitAmount
,sum(FCreditAmount) FTotalCreditAmount
,sum(fdebitamountlocal) FTotalDebitAmountLoc
,sum(fcreditdebitamountlocal) FTotalCreditAmountLoc
from (
SELECT bill.fbizdate fbilldate,
bill.fcompanyid fcompanyid,
bill.fasstacttypeid fasstacttypeid,
bill.fasstactid fasstactid,
bill.fcurrencyid fcurrencyid,
bill.FVoucherCompanyID FVoucherCompanyID,
accountUnion.FCompanyID FAccountCompanyID,
accountUnion.FControlUnitID as FControlUnitID,
accountUnion.FAccountTableID as FAccountTableID,
CASE ISNULL(RTRIM(LTRIM(bill.FPersonID)),'z') WHEN 'z' THEN 'z' WHEN '' THEN 'z' ELSE bill.FPersonID END AS FPersonID,
CASE ISNULL(RTRIM(LTRIM(bill.FAdminOrgUnitID)),'z') WHEN 'z' THEN 'z' WHEN '' THEN 'z' ELSE bill.FAdminOrgUnitID END AS FAdminOrgUnitID,
bill.faccountid faccountid,
bill.fdirection as fdirection,
case when bill.fdamount < 0 then accountUnion.fdatadirection * bill.fdc * bill.fdamount else bill.fdc * bill.fdamount end as fdebitamount,
case when bill.fdamount < 0 then accountUnion.fdatadirection * bill.fdc * bill.fdamountlocal else bill.fdc * bill.fdamountlocal end as fdebitamountlocal,
case when bill.fcamount < 0 then accountUnion.fdatadirection * ((1 - bill.fdc) * bill.fcamount) else (1 - bill.fdc) * bill.fcamount end as fcreditamount,
case when bill.fcamount < 0 then accountUnion.fdatadirection * ((1 - bill.fdc) * bill.fcamountlocal) else (1 - bill.fdc) * bill.fcamountlocal end as fcreditdebitamountlocal
FROM VTE7Y0URZ2BVPEAGRBYYYC4IRTV bill
INNER JOIN V_AR_AccountViewUnion accountUnion
ON bill.FAccountID = accountUnion.FAccountID
WHERE accountUnion.FSystem = 2
and accountUnion.fperiodyear = 2016
and accountUnion.fperiodnumber = 3
AND bill.fcompanyid = '/SSaRIj6SYivL0GYiGSK48znrtQ=' AND bill.FVoucherCompanyID = '/SSaRIj6SYivL0GYiGSK48znrtQ=' and (accountUnion.FCompanyID = '/SSaRIj6SYivL0GYiGSK48znrtQ=' or accountUnion.FCompanyID = '111') and accountUnion.FControlUnitID = '/SSaRIj6SYivL0GYiGSK48znrtQ=' and accountUnion.FAccountTableID = '590gfSC8RFWLeOLZtBsJNhdpjm0=' ) as bill
group by FCompanyID,FAsstActTypeID,FAsstActID,FCurrencyID,FPersonID,FAdminOrgUnitID,FAccountID
insert into VTE7Y0UR1UN1HVMULJTWX5CTRG select FCompanyID ,FAsstActTypeID ,FAsstActID ,FCurrencyID ,FPersonID ,FAdminOrgUnitID ,FAccountID ,sum(FDebitAmount) FTotalDebitAmount ,sum(FCreditAmount) FTotalCreditAmount ,sum(fdebitamountlocal) FTotalDebitAmountLoc ,sum(fcreditdebitamountlocal) FTotalCreditAmountLoc from (select FCompanyID,FAsstActTypeID,FAsstActID,FCurrencyID, FAccountCompanyID,FControlUnitID,FAccountTableID,FBillDate,FVoucherDate ,CASE ISNULL(RTRIM(LTRIM(FPersonID)),'z') WHEN 'z' THEN 'z' WHEN '' THEN 'z' ELSE FPersonID END AS FPersonID ,CASE ISNULL(RTRIM(LTRIM(FAdminOrgUnitID)),'z') WHEN 'z' THEN 'z' WHEN '' THEN 'z' ELSE FAdminOrgUnitID END AS FAdminOrgUnitID, FAccountID,FDirection,FDebitAmount,FCreditAmount,Fdebitamountlocal,Fcreditdebitamountlocal from v_ap_checkaccount2 where 1=1 and voucherBizStatus != 0
and voucherBizStatus != 2
and fperiodyear = 2016
and fperiodnumber = 3
and FCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' AND FVoucherCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' and (FAccountCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' or FAccountCompanyID='111') and FControlUnitID='/SSaRIj6SYivL0GYiGSK48znrtQ=' and FAccountTableID='590gfSC8RFWLeOLZtBsJNhdpjm0=' and FVoucherDate>={2016-03-01} and FVoucherDate<{2016-04-01} ) as bill group by FCompanyID,FAsstActTypeID,FAsstActID,FCurrencyID,FPersonID,FAdminOrgUnitID,FAccountID
insert into VTE7Y0UR1UN1HVMULJTWX5CTRG select FCompanyID ,FAsstActTypeID ,FAsstActID ,FCurrencyID ,FPersonID ,FAdminOrgUnitID ,FAccountID ,sum(FDebitAmount) FTotalDebitAmount ,sum(FCreditAmount) FTotalCreditAmount ,sum(fdebitamountlocal) FTotalDebitAmountLoc ,sum(fcreditdebitamountlocal) FTotalCreditAmountLoc from (select FCompanyID,FAsstActTypeID,FAsstActID,FCurrencyID, FAccountCompanyID,FControlUnitID,FAccountTableID,FBillDate,FVoucherDate ,CASE ISNULL(RTRIM(LTRIM(FPersonID)),'z') WHEN 'z' THEN 'z' WHEN '' THEN 'z' ELSE FPersonID END AS FPersonID ,CASE ISNULL(RTRIM(LTRIM(FAdminOrgUnitID)),'z') WHEN 'z' THEN 'z' WHEN '' THEN 'z' ELSE FAdminOrgUnitID END AS FAdminOrgUnitID, FAccountID,FDirection,FDebitAmount,FCreditAmount,Fdebitamountlocal,Fcreditdebitamountlocal from v_ap_checkaccount3 where 1=1 and voucherBizStatus != 0
and voucherBizStatus != 2
and fperiodyear = 2016
and fperiodnumber = 3
and FCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' AND FVoucherCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' and (FAccountCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' or FAccountCompanyID='111') and FControlUnitID='/SSaRIj6SYivL0GYiGSK48znrtQ=' and FAccountTableID='590gfSC8RFWLeOLZtBsJNhdpjm0=' and FVoucherDate>={2016-03-01} and FVoucherDate<{2016-04-01} ) as bill group by FCompanyID,FAsstActTypeID,FAsstActID,FCurrencyID,FPersonID,FAdminOrgUnitID,FAccountID
insert into VTE7Y0UR1UN1HVMULJTWX5CTRG select FCompanyID ,FAsstActTypeID ,FAsstActID ,FCurrencyID ,FPersonID ,FAdminOrgUnitID ,FAccountID ,sum(FDebitAmount) FTotalDebitAmount ,sum(FCreditAmount) FTotalCreditAmount ,sum(fdebitamountlocal) FTotalDebitAmountLoc ,sum(fcreditdebitamountlocal) FTotalCreditAmountLoc from (select FCompanyID,FAsstActTypeID,FAsstActID,FCurrencyID, FAccountCompanyID,FControlUnitID,FAccountTableID,FBillDate,FVoucherDate ,CASE ISNULL(RTRIM(LTRIM(FPersonID)),'z') WHEN 'z' THEN 'z' WHEN '' THEN 'z' ELSE FPersonID END AS FPersonID ,CASE ISNULL(RTRIM(LTRIM(FAdminOrgUnitID)),'z') WHEN 'z' THEN 'z' WHEN '' THEN 'z' ELSE FAdminOrgUnitID END AS FAdminOrgUnitID, FAccountID,FDirection,FDebitAmount,FCreditAmount,Fdebitamountlocal,Fcreditdebitamountlocal from v_ap_checkaccount4 where 1=1 and voucherBizStatus != 0
and voucherBizStatus != 2
and fperiodyear = 2016
and fperiodnumber = 3
and FCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' AND FVoucherCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' and (FAccountCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' or FAccountCompanyID='111') and FControlUnitID='/SSaRIj6SYivL0GYiGSK48znrtQ=' and FAccountTableID='590gfSC8RFWLeOLZtBsJNhdpjm0=' and FVoucherDate>={2016-03-01} and FVoucherDate<{2016-04-01} ) as bill group by FCompanyID,FAsstActTypeID,FAsstActID,FCurrencyID,FPersonID,FAdminOrgUnitID,FAccountID
insert into VTE7Y0UR1UN1HVMULJTWX5CTRG select FCompanyID ,FAsstActTypeID ,FAsstActID ,FCurrencyID ,FPersonID ,FAdminOrgUnitID ,FAccountID ,sum(FDebitAmount) FTotalDebitAmount ,sum(FCreditAmount) FTotalCreditAmount ,sum(fdebitamountlocal) FTotalDebitAmountLoc ,sum(fcreditdebitamountlocal) FTotalCreditAmountLoc from (select FCompanyID,FAsstActTypeID,FAsstActID,FCurrencyID, FAccountCompanyID,FControlUnitID,FAccountTableID,FBillDate,FVoucherDate ,CASE ISNULL(RTRIM(LTRIM(FPersonID)),'z') WHEN 'z' THEN 'z' WHEN '' THEN 'z' ELSE FPersonID END AS FPersonID ,CASE ISNULL(RTRIM(LTRIM(FAdminOrgUnitID)),'z') WHEN 'z' THEN 'z' WHEN '' THEN 'z' ELSE FAdminOrgUnitID END AS FAdminOrgUnitID, FAccountID,FDirection,FDebitAmount,FCreditAmount,Fdebitamountlocal,Fcreditdebitamountlocal from v_ap_checkaccount5 where 1=1 and voucherBizStatus != 0
and voucherBizStatus != 2
and fperiodyear = 2016
and fperiodnumber = 3
and FCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' AND FVoucherCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' and (FAccountCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' or FAccountCompanyID='111') and FControlUnitID='/SSaRIj6SYivL0GYiGSK48znrtQ=' and FAccountTableID='590gfSC8RFWLeOLZtBsJNhdpjm0=' and FVoucherDate>={2016-03-01} and FVoucherDate<{2016-04-01} ) as bill group by FCompanyID,FAsstActTypeID,FAsstActID,FCurrencyID,FPersonID,FAdminOrgUnitID,FAccountID
insert into VTE7Y0UR1UN1HVMULJTWX5CTRG select FCompanyID ,FAsstActTypeID ,FAsstActID ,FCurrencyID ,FPersonID ,FAdminOrgUnitID ,FAccountID ,sum(FDebitAmount) FTotalDebitAmount ,sum(FCreditAmount) FTotalCreditAmount ,sum(fdebitamountlocal) FTotalDebitAmountLoc ,sum(fcreditdebitamountlocal) FTotalCreditAmountLoc from (select FCompanyID,FAsstActTypeID,FAsstActID,FCurrencyID, FAccountCompanyID,FControlUnitID,FAccountTableID,FBillDate,FVoucherDate ,CASE ISNULL(RTRIM(LTRIM(FPersonID)),'z') WHEN 'z' THEN 'z' WHEN '' THEN 'z' ELSE FPersonID END AS FPersonID ,CASE ISNULL(RTRIM(LTRIM(FAdminOrgUnitID)),'z') WHEN 'z' THEN 'z' WHEN '' THEN 'z' ELSE FAdminOrgUnitID END AS FAdminOrgUnitID, FAccountID,FDirection,FDebitAmount,FCreditAmount,Fdebitamountlocal,Fcreditdebitamountlocal from v_ap_checkaccount6 where 1=1 and voucherBizStatus != 0
and voucherBizStatus != 2
and fperiodyear = 2016
and fperiodnumber = 3
and FCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' AND FVoucherCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' and (FAccountCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' or FAccountCompanyID='111') and FControlUnitID='/SSaRIj6SYivL0GYiGSK48znrtQ=' and FAccountTableID='590gfSC8RFWLeOLZtBsJNhdpjm0=' and FVoucherDate>={2016-03-01} and FVoucherDate<{2016-04-01} ) as bill group by FCompanyID,FAsstActTypeID,FAsstActID,FCurrencyID,FPersonID,FAdminOrgUnitID,FAccountID
insert into VTE7Y0UR1UN1HVMULJTWX5CTRG select FCompanyID ,FAsstActTypeID ,FAsstActID ,FCurrencyID ,FPersonID ,FAdminOrgUnitID ,FAccountID ,sum(FDebitAmount) FTotalDebitAmount ,sum(FCreditAmount) FTotalCreditAmount ,sum(fdebitamountlocal) FTotalDebitAmountLoc ,sum(fcreditdebitamountlocal) FTotalCreditAmountLoc from (select FCompanyID,FAsstActTypeID,FAsstActID,FCurrencyID, FAccountCompanyID,FControlUnitID,FAccountTableID,FBillDate,FVoucherDate ,CASE ISNULL(RTRIM(LTRIM(FPersonID)),'z') WHEN 'z' THEN 'z' WHEN '' THEN 'z' ELSE FPersonID END AS FPersonID ,CASE ISNULL(RTRIM(LTRIM(FAdminOrgUnitID)),'z') WHEN 'z' THEN 'z' WHEN '' THEN 'z' ELSE FAdminOrgUnitID END AS FAdminOrgUnitID, FAccountID,FDirection,FDebitAmount,FCreditAmount,Fdebitamountlocal,Fcreditdebitamountlocal from v_ap_checkaccount7 where 1=1 and voucherBizStatus != 0
and voucherBizStatus != 2
and fperiodyear = 2016
and fperiodnumber = 3
and FCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' AND FVoucherCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' and (FAccountCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' or FAccountCompanyID='111') and FControlUnitID='/SSaRIj6SYivL0GYiGSK48znrtQ=' and FAccountTableID='590gfSC8RFWLeOLZtBsJNhdpjm0=' and FVoucherDate>={2016-03-01} and FVoucherDate<{2016-04-01} ) as bill group by FCompanyID,FAsstActTypeID,FAsstActID,FCurrencyID,FPersonID,FAdminOrgUnitID,FAccountID
insert into VTE7Y0UR1UN1HVMULJTWX5CTRG select FCompanyID ,FAsstActTypeID ,FAsstActID ,FCurrencyID ,FPersonID ,FAdminOrgUnitID ,FAccountID ,sum(FDebitAmount) FTotalDebitAmount ,sum(FCreditAmount) FTotalCreditAmount ,sum(fdebitamountlocal) FTotalDebitAmountLoc ,sum(fcreditdebitamountlocal) FTotalCreditAmountLoc from (select FCompanyID,FAsstActTypeID,FAsstActID,FCurrencyID, FAccountCompanyID,FControlUnitID,FAccountTableID,FBillDate,FVoucherDate ,CASE ISNULL(RTRIM(LTRIM(FPersonID)),'z') WHEN 'z' THEN 'z' WHEN '' THEN 'z' ELSE FPersonID END AS FPersonID ,CASE ISNULL(RTRIM(LTRIM(FAdminOrgUnitID)),'z') WHEN 'z' THEN 'z' WHEN '' THEN 'z' ELSE FAdminOrgUnitID END AS FAdminOrgUnitID, FAccountID,FDirection,FDebitAmount,FCreditAmount,Fdebitamountlocal,Fcreditdebitamountlocal from v_ap_checkaccount8 where 1=1 and voucherBizStatus != 0
and voucherBizStatus != 2
and fperiodyear = 2016
and fperiodnumber = 3
and FCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' AND FVoucherCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' and (FAccountCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' or FAccountCompanyID='111') and FControlUnitID='/SSaRIj6SYivL0GYiGSK48znrtQ=' and FAccountTableID='590gfSC8RFWLeOLZtBsJNhdpjm0=' and FVoucherDate>={2016-03-01} and FVoucherDate<{2016-04-01} ) as bill group by FCompanyID,FAsstActTypeID,FAsstActID,FCurrencyID,FPersonID,FAdminOrgUnitID,FAccountID
insert into VTE7Y0UR1UN1HVMULJTWX5CTRG select FCompanyID ,FAsstActTypeID ,FAsstActID ,FCurrencyID ,FPersonID ,FAdminOrgUnitID ,FAccountID ,sum(FDebitAmount) FTotalDebitAmount ,sum(FCreditAmount) FTotalCreditAmount ,sum(fdebitamountlocal) FTotalDebitAmountLoc ,sum(fcreditdebitamountlocal) FTotalCreditAmountLoc from (select FCompanyID,FAsstActTypeID,FAsstActID,FCurrencyID, FAccountCompanyID,FControlUnitID,FAccountTableID,FBillDate,FVoucherDate ,CASE ISNULL(RTRIM(LTRIM(FPersonID)),'z') WHEN 'z' THEN 'z' WHEN '' THEN 'z' ELSE FPersonID END AS FPersonID ,CASE ISNULL(RTRIM(LTRIM(FAdminOrgUnitID)),'z') WHEN 'z' THEN 'z' WHEN '' THEN 'z' ELSE FAdminOrgUnitID END AS FAdminOrgUnitID, FAccountID,FDirection,FDebitAmount,FCreditAmount,Fdebitamountlocal,Fcreditdebitamountlocal from v_ap_checkaccount9 where 1=1 and voucherBizStatus != 0
and voucherBizStatus != 2
and fperiodyear = 2016
and fperiodnumber = 3
and FCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' AND FVoucherCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' and (FAccountCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' or FAccountCompanyID='111') and FControlUnitID='/SSaRIj6SYivL0GYiGSK48znrtQ=' and FAccountTableID='590gfSC8RFWLeOLZtBsJNhdpjm0=' and FVoucherDate>={2016-03-01} and FVoucherDate<{2016-04-01} ) as bill group by FCompanyID,FAsstActTypeID,FAsstActID,FCurrencyID,FPersonID,FAdminOrgUnitID,FAccountID
insert into VTE7Y0UR1UN1HVMULJTWX5CTRG select FCompanyID ,FAsstActTypeID ,FAsstActID ,FCurrencyID ,FPersonID ,FAdminOrgUnitID ,FAccountID ,sum(FDebitAmount) FTotalDebitAmount ,sum(FCreditAmount) FTotalCreditAmount ,sum(fdebitamountlocal) FTotalDebitAmountLoc ,sum(fcreditdebitamountlocal) FTotalCreditAmountLoc from (select FCompanyID,FAsstActTypeID,FAsstActID,FCurrencyID, FAccountCompanyID,FControlUnitID,FAccountTableID,FBillDate,FVoucherDate ,CASE ISNULL(RTRIM(LTRIM(FPersonID)),'z') WHEN 'z' THEN 'z' WHEN '' THEN 'z' ELSE FPersonID END AS FPersonID ,CASE ISNULL(RTRIM(LTRIM(FAdminOrgUnitID)),'z') WHEN 'z' THEN 'z' WHEN '' THEN 'z' ELSE FAdminOrgUnitID END AS FAdminOrgUnitID, FAccountID,FDirection,FDebitAmount,FCreditAmount,Fdebitamountlocal,Fcreditdebitamountlocal from v_ap_checkaccount10 where 1=1 and voucherBizStatus != 0
and voucherBizStatus != 2
and fperiodyear = 2016
and fperiodnumber = 3
and FCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' AND FVoucherCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' and (FAccountCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' or FAccountCompanyID='111') and FControlUnitID='/SSaRIj6SYivL0GYiGSK48znrtQ=' and FAccountTableID='590gfSC8RFWLeOLZtBsJNhdpjm0=' and FVoucherDate>={2016-03-01} and FVoucherDate<{2016-04-01} ) as bill group by FCompanyID,FAsstActTypeID,FAsstActID,FCurrencyID,FPersonID,FAdminOrgUnitID,FAccountID
insert into VTE7Y0UR2LHDIAY2VWOB14CG7O select FCompanyID ,FAsstActTypeID ,FAsstActID ,FCurrencyID ,FPersonID ,FAdminOrgUnitID ,FAccountID ,sum(FDebitAmount) FTotalDebitAmount ,sum(FCreditAmount) FTotalCreditAmount ,sum(fdebitamountlocal) FTotalDebitAmountLoc ,sum(fcreditdebitamountlocal) FTotalCreditAmountLoc from (select FCompanyID,FAsstActTypeID,FAsstActID,FCurrencyID, FAccountCompanyID,FControlUnitID,FAccountTableID,FBillDate,FVoucherDate ,CASE ISNULL(RTRIM(LTRIM(FPersonID)),'z') WHEN 'z' THEN 'z' WHEN '' THEN 'z' ELSE FPersonID END AS FPersonID ,CASE ISNULL(RTRIM(LTRIM(FAdminOrgUnitID)),'z') WHEN 'z' THEN 'z' WHEN '' THEN 'z' ELSE FAdminOrgUnitID END AS FAdminOrgUnitID, FAccountID,FDirection,FDebitAmount,FCreditAmount,Fdebitamountlocal,Fcreditdebitamountlocal from v_ap_checkaccount11 where 1=1 and voucherBizStatus != 0
and voucherBizStatus != 2
and fperiodyear = 2016
and fperiodnumber = 3
and FCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' AND FVoucherCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' and (FAccountCompanyID='/SSaRIj6SYivL0GYiGSK48znrtQ=' or FAccountCompanyID='111') and FControlUnitID='/SSaRIj6SYivL0GYiGSK48znrtQ=' and FAccountTableID='590gfSC8RFWLeOLZtBsJNhdpjm0=' and FVoucherDate>={2016-03-01} and FVoucherDate<{2016-04-01} ) as bill group by FCompanyID,FAsstActTypeID,FAsstActID,FCurrencyID,FPersonID,FAdminOrgUnitID,FAccountID
INSERT INTO VTE7Y0UR1K4FUP1FG855650P3M

补丁信息在附件中