Run query activity error

Help Activities
, ,
11

Hey @fairymemay
If I remember correctly Oracle is using the single quotes in string, so it can be cause of your issue.
Try it:

"Select 
    a.extract_date,
    a.due_date ""Due_Date"",
    c.l9_company_code ""Company_Code"",
    COUNT(*) ""BCV_Transaction"",
    SUM(a.actual_amount) ""BCV_Amount"",
    (Case 
        When c.l9_company_code = 'RF' THEN 'RF'
        When c.l9_company_code = 'RM' THEN 'RF'
        When c.l9_company_code = 'TS' THEN 'RF'
        When c.l9_company_code = 'TI' THEN 'TI'
        When c.l9_company_code = 'TD' THEN 'TD'
        When c.l9_company_code = 'VC' THEN 'VC'
        Else c.l9_company_code 
     End) As ""Company_Group""
From 
    AR1_DIRECT_DEBIT_REQUEST a, 
    CSM_ACCOUNT c
Where 
    a.account_id = c.ban (+)
    And a.request_status In ('E')
    And a.bank_code = '025' 
    And c.l9_company_code <> 'KC'
    And a.due_date = TO_DATE('20231030','yyyymmdd')
Group By 
    a.extract_date,
    a.due_date,
    c.l9_company_code"
3 Likes