Quick Report - SQL expression is wrong

Hello everyone!

I’m having trouble to create a quick report. I’m having an error message saying that my SQL expression is wrong, even though it runs on PLSQL developer and it runs on the SQL query tool.

I even created an IAL, that works on both methods I’ve mentioned, exepct when I try to save it as a quick report

Here is the query I’m trying to save as a quick report:

1SELECT FUR.IDENTITY AS USUARIO,
2       UF.COMPANY AS EMPRESA,
3       UGMF.USER_GROUP AS GRUPO_USUARIO,
4       CASE
5          WHEN UGMF.USER_GROUP = 'AC' THEN
6           'FINANCEIRO'
7          WHEN UGMF.USER_GROUP = 'CB' THEN
8           'CONTABILIDADE'
9          WHEN UGMF.USER_GROUP = 'FS' THEN
10           'FISCAL'
11          WHEN UGMF.USER_GROUP = 'FT' THEN
12           'FATURAMENTO'
13          WHEN UGMF.USER_GROUP = 'GR' THEN
14           'GERAL'
15          WHEN UGMF.USER_GROUP = 'LG' THEN
16           'LOGISTICA'
17          WHEN UGMF.USER_GROUP = 'TR' THEN
18           'TESOURARIA'
19          WHEN UGMF.USER_GROUP = 'YE' THEN
20           'FECHAMENTO ANUAL'
21       END DESCRICAO_GRUPO_USUARIO,
22       CASE
23          WHEN GLU.AUTH_CLASS IS NULL THEN
24           'SEM PERMISSÃO'
25          ELSE
26           'CLASSE DE AUTORIDADE MAX'
27       END FUNCAO_CONTABILIDADE,
28       CASE
29          WHEN OC.AUTHORIZE_CODE IS NOT NULL THEN
30           'COORDENADOR'
31          WHEN OC.AUTHORIZE_CODE IS NULL THEN
32           'SEM PERMISSÃO'
33       END FUNCAO_ESTOQUE_DISTRIBUICAO_GERAL,
34       CASE
35          WHEN (PB.BUYER_CODE IS NOT NULL AND PR.REQUISITIONER_CODE IS NOT NULL AND QCA.QC_CODE IS NOT NULL) THEN
36           'COMPRADOR - REQUISITANTE - CONTROLE DE QUALIDADE'
37          WHEN (PB.BUYER_CODE IS NOT NULL AND QCA.QC_CODE IS NOT NULL) THEN
38           'COMPRADOR - CONTROLE DE QUALIDADE'
39          WHEN (PR.REQUISITIONER_CODE IS NOT NULL AND QCA.QC_CODE IS NOT NULL) THEN
40           'REQUISITANTE - CONTROLE DE QUALIDADE'
41          WHEN (PB.BUYER_CODE IS NOT NULL AND PR.REQUISITIONER_CODE IS NOT NULL) THEN
42           'COMPRADOR - REQUISITANTE'
43          WHEN PB.BUYER_CODE IS NOT NULL THEN
44           'COMPRADOR'
45          WHEN PR.REQUISITIONER_CODE IS NOT NULL THEN
46           'REQUISITANTE'
47          WHEN QCA.QC_CODE IS NOT NULL THEN
48           'CONTROLE DE QUALIDADE'
49          ELSE
50           'SEM PERMISSÃO'
51       END FUNCAO_COMPRAS,
52       CASE
53          WHEN IPP.BUYER_CODE IS NOT NULL THEN
54           'PLANEJADOR'
55          ELSE
56           'SEM PERMISSÃO'
57       END FUNCAO_ESTOQUE,
58       CASE
59          WHEN SPS.SALESMAN_CODE IS NOT NULL THEN
60           'VENDEDOR'
61          ELSE
62           'SEM PERMISSÃO'
63       END FUNCAO_ORDEM_DE_VENDA,
64       CASE
65          WHEN PA.AUTHORIZER_ID IS NOT NULL THEN
66           'AUTORIZADOR CONTAB TÍTULO'
67          ELSE
68           'SEM PERMISSÃO'
69       END FUNCAO_TITULO_DO_FORNECEDOR,
70       CASE
71          WHEN CAU.CREDIT_ANALYST_CODE = 'MA' THEN
72           'GERENTE DE CRÉDITO'
73          WHEN CAU.CREDIT_ANALYST_CODE = 'CA' THEN
74           'ANALISTA DE CRÉDITO'
75          ELSE
76           'SEM PERMISSÃO'
77       END FUNCAO_GERENCIAMENTO_DE_CREDITO,
78       CASE
79          WHEN IFSGFT.SUPPORT_PERSON_API.Is_Support_User(FUR.IDENTITY) = 'TRUE' THEN
80           'USUÁRIO DE SUPORTE'
81          ELSE
82           'SEM PERMISSÃO'
83       END FUNCAO_CENTRO_DE_SUPORTE,
84       CASE
85          WHEN CE.COST_ESTIMATOR_ID IS NOT NULL THEN
86           'ESTIMADOR DE CUSTO'
87          ELSE
88           'SEM PERMISSÃO'
89       END FUNCAO_CUSTO,
90       CASE
91          WHEN ME.MANUF_ENGINEER_CODE IS NOT NULL THEN
92           'ENGENHEIRO DE MANUFATURA'
93          ELSE
94           'SEM PERMISSÃO'
95       END FUNCAO_MANUFATURA,
96       FUR.ROLE AS CONJ_PERMISSAO
97  FROM IFSGFT.FND_USER_ROLE_TAB FUR
98  LEFT JOIN IFSGFT.USER_GROUP_MEMBER_FINANCE UGMF ON UGMF.USERID = FUR.IDENTITY
99  LEFT JOIN IFSGFT.USER_FINANCE UF ON UF.USERID = FUR.IDENTITY
100  LEFT JOIN IFSGFT.GEN_LED_USER GLU ON GLU.USERID = FUR.IDENTITY
101                                   AND GLU.COMPANY = UF.COMPANY
102  LEFT JOIN IFSGFT.ORDER_COORDINATOR OC ON OC.AUTHORIZE_CODE = FUR.IDENTITY
103  LEFT JOIN IFSGFT.PURCHASE_BUYER PB ON PB.BUYER_CODE = FUR.IDENTITY
104  LEFT JOIN IFSGFT.PURCHASE_REQUISITIONER PR ON PR.REQUISITIONER_CODE = FUR.IDENTITY
105  LEFT JOIN IFSGFT.QUALITY_CTRL_ANALYST QCA ON QCA.QC_CODE = FUR.IDENTITY
106  LEFT JOIN IFSGFT.INVENTORY_PART_PLANNER IPP ON IPP.BUYER_CODE = FUR.IDENTITY
107  LEFT JOIN IFSGFT.SALES_PART_SALESMAN SPS ON SPS.SALESMAN_CODE = FUR.IDENTITY
108  LEFT JOIN IFSGFT.POSTING_AUTHORIZER PA ON PA.COMPANY = UF.COMPANY
109                                        AND PA.AUTHORIZER_ID = FUR.IDENTITY
110  LEFT JOIN IFSGFT.CREDIT_ANALYST_USER CAU ON CAU.USERID = FUR.IDENTITY
111                                          AND CAU.COMPANY = UF.COMPANY
112  LEFT JOIN IFSGFT.COST_ESTIMATOR CE ON CE.COST_ESTIMATOR_ID = FUR.IDENTITY
113  LEFT JOIN IFSGFT.MANUF_ENGINEER ME ON ME.MANUF_ENGINEER_CODE = FUR.IDENTITY

Can anyone help me figuring out what is wrong?

Thanks!