Se produjo un error al consultar la base de datos

Estimados, buen día:
Estoy trabajando en la creación de un dashboard, pero el sistema me está arrojando el error mencionado en el título.
¿Podrían ayudarme, por favor?
Gracias de antemano.
Saludos cordiales,

select
    d.end_date as "Fecha",
    ifnull(
        sum(case when l."DocDate" >= d.begin_date and t."ItmsGrpNam" = 'PFE INY' then l."OutQty" else 0 end) * 100 / 
        nullif(sum((l."InQty" - l."OutQty") * (case when l."DocDate" >= d.begin_date and t."ItmsGrpNam" = 'PFE INY' then 0.5 else 1 end)), 0), 
        0
    ) as "Porcentaje (%) de rotación de inventario"
from 
    OIVL l 
    right outer join (
        select 
            ADD_YEARS(NEXT_DAY(LAST_DAY(ADD_MONTHS(CURRENT_DATE, -1))), -1) begin_date, 
            LAST_DAY(ADD_MONTHS(CURRENT_DATE, -1)) end_date 
        from dummy 
        union all 
        select 
            ADD_YEARS(NEXT_DAY(LAST_DAY(ADD_MONTHS(CURRENT_DATE, -2))), -1) begin_date, 
            LAST_DAY(ADD_MONTHS(CUR
            RENT_DATE, -2)) end_date 
        from dummy 
        union all 
        select 
            ADD_YEARS(NEXT_DAY(LAST_DAY(ADD_MONTHS(CURRENT_DATE, -3))), -1) begin_date, 
            LAST_DAY(ADD_MONTHS(CURRENT_DATE, -3)) end_date 
        from dummy 
        union all 
        select 
            ADD_YEARS(NEXT_DAY(LAST_DAY(ADD_MONTHS(CURRENT_DATE, -4))), -1) begin_date, 
            LAST_DAY(ADD_MONTHS(CURRENT_DATE, -4)) end_date 
        from dummy 
        union all 
        select 
            ADD_YEARS(NEXT_DAY(LAST_DAY(ADD_MONTHS(CURRENT_DATE, -5))), -1) begin_date, 
            LAST_DAY(ADD_MONTHS(CURRENT_DATE, -5)) end_date 
        from dummy 
        union all 
        select 
            ADD_YEARS(NEXT_DAY(LAST_DAY(ADD_MONTHS(CURRENT_DATE, -6))), -1) begin_date, 
            LAST_DAY(ADD_MONTHS(CURRENT_DATE, -6)) end_date 
        from dummy 
    ) d on l."DocDate" <= end_date 
    left join OITM i on l."ItemCode" = i."ItemCode"
    left join OITB t on i."ItmsGrpCod" = t."ItmsGrpCod"
group by 
    d.end_date;