I am trying to FTP bursting for a standard BIP report "InvoicePrintReport", but it is not working.
In the schedule page output, i cannot see the name of the file i gave in the query also FTP bursting is not working, Also I can see the report in the output of the scheduled job. I tried email bursting and that is working fine.
Below is the code I am using:
SELECT
ps.customer_trx_id || '_' || ps.payment_schedule_id as "KEY",
:TEMPLATE_NAME TEMPLATE,
'RTF' TEMPLATE_FORMAT,
'en-US' LOCALE,
'PDF' OUTPUT_FORMAT,
ps.trx_number || '_' || ps.terms_sequence_number output_name,
'FTP' DEL_CHANNEL,
:server_name PARAMETER1,
:username PARAMETER2,
:password PARAMETER3,
'/Test/FromCust/' PARAMETER4,