Bursting To FTP server Not Working

Summary:

Bursting To FTP server Not Working

Content (required):

Hi All,

I have developed one report where I want to place the file in the ftp server and for that i have written the below SQL query.

SQL query :

SELECT 'BURSTKEY' "KEY",

    GB.LEDGER_ID AS LEDGER,

    GCC.SEGMENT1 AS COMPANY,

    GCC.SEGMENT2 AS LOCATION,

    GCC.SEGMENT4 AS COST_CENTER,

    GCC.SEGMENT3 AS ACCOUNT,

    GCC.SEGMENT6 AS INTERCOMPANY,

    GCC.ACCOUNT_TYPE AS ACCOUNT_TYPE,

    vb.attribute1 AS LOC_TYPE,

    vb.ATTRIBUTE2 AS LOC_STATUS,

    GB.CURRENCY_CODE AS BASE_CURRENCY,

    GB.PERIOD_YEAR AS FISCAL_YEAR,

    GB.PERIOD_NAME AS INPUT_PERIOD,