Qlik Sense Dynamic View Oracle Giving Error Illegal Zero Length Identifier

[piyush_s11]

Hi,

I am getting illegal zero length identifier error while connecting to oracle database. I making dynamic view.

I have observed that the error seems to be in the where clause of script. please find below script I am using.

SQL SELECT "COB_DATE",

    "DEPOT_ID",

    "GBM_ATOM_CODE",

    "GBM_DEPT",

    "BOOK_SHORT_CODE",

    "BOOK_DESC",

    "DTD_PL_FCCY",

    "MTD_PL_FCCY",

    "DTD_MM_FCCY",

    "DTD_NT_FCCY",

    "DTD_VAL_FCCY",

    "DTD_PROV_FCCY",

    "DTD_CARRY_FCCY",

    "DTD_FEE_FCCY",

    "DTD_PLTR_FCCY",

    "MTD_MM_FCCY",

    "MTD_NT_FCCY",

    "MTD_VAL_FCCY",

    "MTD_PROV_FCCY",

    "MTD_CARRY_FCCY",

    "MTD_FEE_FCCY",

    "MTD_PLTR_FCCY",

    "LAST_MODIFIED"

    FROM "PCIT_CORE"."CORE_PL_GPL"//;

            WHERE "COB_DATE" IN ($(odags_COB_DATE){"quote": ""})

            AND GBM_DEPT IN ($(odags_GBM_DEPT){"quote": ""});

Please help.

@avinashelite, @kushalthakral, @tresesco, @prabir_c, @eliran, @ts_anandrjs, @MK_QSL, @Anbu1984, @Marcus_sommer, @Daniel_kusiak,

@avinashelite , @kushalthakral , @tresB , @prabir_c ,  @eliran , @its_anandrjs , @MK_QSL , @anbu1984 , @marcus_sommer , @daniel_kusiak 

Thanks in Advance.