明细分类账按分类查询报错

Sql1 execute exception : /*dialect*/ INSERT INTO VTZ10ORLFC2EBGUK5V7E23U9TLYF(FAccountID,FPeriod,FBookedDate,FEndBalanceFor,FYearDebitFor,FYearCreditFor,FBalSeq)  SELECT  /*+ opt_param('_complex_view_merging','false') */ t1.FAccountID,t1.FPeriod,t1.FPeriodBeginDate,t1.FBeginBalanceFor FBeginBalanceFor,t1.FYearDebitFor - t1.FDebitFor FYearDebitFor,t1.FYearCreditFor - t1.FCreditFor FYearCreditFor,t1.FBalSeq FROM (SELECT av.fparentid FAccountID, b.FPeriod FPeriod, pd.FbeginDate FPeriodBeginDate, sum(b.FBeginBalanceFor) FBeginBalanceFor, sum(b.FYearDebitFor) FYearDebitFor, sum(b.FYearCreditFor) FYearCreditFor, 1 FBalSeq, sum(b.FDebitFor) FDebitFor, sum(b.FCreditFor) FCreditFor FROM T_GL_AssistBalance_5F b LEFT OUTER JOIN T_BD_AssistantHG hg ON hg.FID = b.FAssistGrpId LEFT OUTER JOIN T_BD_PERIOD pd ON pd.FNumber = b.FPeriod AND pd.FTypeID = '3dIAAAAAAGhfaYmm' LEFT OUTER JOIN (SELECT ssc.fcompanyid, startPeriod.fnumber fstartperiod, currPeriod.fnumber fcurrperiod FROM t_bd_systemstatusctrol ssc INNER JOIN t_bd_systemstatus ss ON ss.fid = ssc.fsystemstatusid AND ss.fname = 6 INNER JOIN t_bd_period startPeriod ON startPeriod.fid = ssc.fstartperiodid INNER JOIN t_bd_period currPeriod ON currPeriod.fid = ssc.fcurrentperiodid) ssc ON b.FOrgUnitID = ssc.fcompanyid INNER JOIN VTZ10ORLFCZ2DK4IGLQPN7LP397WA av ON av.fid = b.FAccountID WHERE b.FOrgUnitID IN ('3dIAAAAAADLM567U', '3dIAAAAAAC/M567U') AND b.FPeriod IN (201903) AND (b.FPeriod >= ssc.fstartperiod) AND ((b.FPeriod >= ssc.fcurrperiod) OR (b.FPeriod >= 201903)) AND b.FCurrencyID = 'dfd38d11-00fd-1000-e000-1ebdc0a8100dDEB58FDC' AND hg.FAsstAccountID IN ('3dIAAAAADm5GWhD4', '3dIAAAAADoNGWhD4', '3dIAAAAADppGWhD4', '3dIAAAAADqZGWhD4', '3dIAAAAG6n5GWhD4', '3dIAAAAADnRGWhD4') AND hg.FCustomerID IN (SELECT fcustomerid FROM T_BD_CustomerGroupDetail t WHERE Fcustomergroupid IN ('3dIAAAAyraF6JWmi')) AND b.FAssistGrpId IN (SELECT hg.fid FROM t_bd_assistanthg hg WHERE EXISTS (SELECT 1 FROM T_BD_Customer customer INNER JOIN T_BD_CustomerGroupDetail gpd ON gpd.fCustomerid = customer.fid INNER JOIN T_BD_CSSPGroup gp ON gp.fid = gpd.fCustomergroupid INNER JOIN T_BD_CSSPGroup pgp ON (CHARINDEX((pgp.flongnumber || '!'), gp.flongnumber) = 1 OR gp.fid = pgp.fid) WHERE customer.fid = hg.FCustomerID AND pgp.fid IN ('3dIAAAAyraF6JWmi'))) GROUP BY av.fparentid, b.FPeriod, pd.FbeginDate) t1 

Caused exception message is: ORA-00904: "CHARINDEX": 标识符无效

关联提单：R20190528-2081
适用版本：EAS8.5

解决方案：更新补丁PT138290