BIP Bursting output with CSV file
Summary:
BIP Bursting output with CSV file
Content (please ensure you mask any confidential information):
I am trying to burst a CSV file to an FTP server and I am having issues with no output generating. I have the bursting report template defined as follows:
I have my bursting query in the data model defined as follows:
SELECT 'H' "KEY"
,'rpt1' "TEMPLATE"
,'RTF' "TEMPLATE_FORMAT"
,'en-US' "LOCALE"
,'CSV' "OUTPUT_FORMAT"
,'FTP' "DEL_CHANNEL" -- FTP
,'OIC_PROD_SFTP' "PARAMETER1" -- Server name
,NULL "PARAMETER2" -- UserName
,NULL "PARAMETER3" -- Password
,'/integration/queue' "PARAMETER4" -- Remote Directory
,'GL_BALANCES_' || TO_CHAR(SYSDATE, 'MM-DD-YYYY')||'.csv' "PARAMETER5" -- Remote File Name