Cannot do Bursting with FILE (DEV_CHANNEL)
I want to do bursting with FILE (DEV_CHANNEL) so that i can store the report at my Laptop.
But when i do it, it's not working.
Here are my SQL :
select
"HZ_PARTIES"."PARTY_NAME" as "KEY",
'PDF' as OUTPUT_FORMAT,
'FILE' as DEL_CHANNEL,
'C:/Users/LENOVO/Desktop/' as PARAMETER1,
'AP_' || "HZ_PARTIES"."PARTY_NAME" || '.PDF' as PARAMETER2
from
"FUSION"."HZ_PARTIES" "HZ_PARTIES",
"FUSION"."POZ_SUPPLIERS" "POZ_SUPPLIERS",
"FUSION"."AP_INVOICES_ALL" "AP_INVOICES_ALL"
where
"AP_INVOICES_ALL"."VENDOR_ID"="POZ_SUPPLIERS"."VENDOR_ID"
and "POZ_SUPPLIERS"."PARTY_ID"="HZ_PARTIES"."PARTY_ID"