数据库升级后有个视图查询报错

数据库升级后有个视图查询报错：

视图定义如下：
CREATE OR REPLACE VIEW *** AS
SELECT distinct fygsy,nvl(fykm2,fykmx)fykm2,zxmc, bxbm,hd.departmentname sqmc,ssdq,hd1.departmentname dqmc,f.requestid,F.lcbh,bxr tdr,hr.lastname,
substr(fygsy,0,4) as dq_nd ,TO_CHAR(to_date(fygsy||'01','yyyy-mm-dd'), 'FMMM') AS dq_yf, TO_CHAR(to_date(fygsy||'01','yyyy-mm-dd'), 'Q') AS dq_jd,
dt1.bxje fy,dt1.id mxid,to_char(dt1.zy) zy ,to_char(dt1.xmbh) xmbh
FROM ** f ,formtable_main_1071_dt1 dt1,** hd ,** hd1,
** hr,** wcc
WHERE f.id = dt1.mainid
and wcc.requestid = F.requestid
and wcc.currentnodetype <> 0
and wcc.status not in ('提单人','报销人核对','省区经理')
and (nvl(zxmc,99) in (4,7,8) or nvl(zxmc,99)=99 )
and hd.id = bxbm
and hd1.id = ssdq
and bxr = hr.id
and wcc.currentnodetype <> 0
and dt1.fykm2 is not null
and fygsy is not NULL
UNION
SELECT a.FYGSY,
'业务招待费' as FYKM2,
NULL AS zxmc,
-- wr.STATUS,
a.szbm as bxbm,
hd.DEPARTMENTNAME sqmc,
a.sspqxtb as ssdq,
hd1.DEPARTMENTNAME dqmc,
a.REQUESTID,
a.SPBH,
a.SQR tdr,
hr.LASTNAME,
substr(a.fygsy, 0, 4) as dq_nd,
TO_CHAR(to_date(a.fygsy || '01', 'yyyy-mm-dd'), 'FMMM') AS dq_yf,
TO_CHAR(to_date(a.fygsy || '01', 'yyyy-mm-dd'), 'Q') AS dq_jd,
to_number( b.je) fy,
b.id mxid,
to_char(b.BZ) zy,
to_char(null) xmbh
FROM ** a
LEFT JOIN ** b
on a.ID = b.MAINID
LEFT JOIN ** wr
on wr.REQUESTID = a.requestid
LEFT JOIN ** hd
on hd.id = a.SZBM
LEFT JOIN ** hd1
on hd1.id = a.sspqxtb
LEFT JOIN ** hr
on hr.ID = a.SQR
LEFT JOIN ** wcc
ON WCC.REQUESTID = a.REQUESTID
where wcc.currentnodetype <> 0
and a. fygsy is not null
and wcc.status not in('提单人', '客户接待专员审核')
;

fygsy 样式为： 2025-10

执行下面的查询报错：
SELECT SUM(FY) FY
FROM CRM_YXFYMX_V
where fykm2 = '业务招待费'
AND nvl(zxmc, 10) = 10
AND DQ_ND = '2025'
AND DQ_YF = '1'
AND BXBM = '6509'
GROUP BY BXBM, DQ_ND, DQ_YF

报错代码：
ORA-01840

应该也是之前的问题 升级后19c 的检查更加严格

我之前考虑是 TO_CHAR(TO_DATE(fygsy || '-01', 'yyyy-mm-dd'), 'Q') AS dq_jd 通过这种方式处理发现还是不行
通过下面的将-去掉后运行正常
TO_CHAR(TO_DATE(REPLACE(fygsy, '-', '') || '01', 'yyyymmdd'), 'Q') AS dq_jd


另外修改优化器兼容性参数不知道行不行
optimizer_features_enable