SFTP using Oracle BI Bursting is not working: Oracle Fusion Cloud Applications 23D (11.13.23.10.0)

Jhansi Rani Dasari

Hi Team,

Please advise if any one has faced issue using BI report bursting for SFTP and share the solution/idea please.

We are trying to send file to SFTP location using report bursting by scheduling report but it is failing with below error message.

*********ERROR MESSAGE*************

Document delivery failed

[INSTANCE_ID=bip.bi_server1] [DELIVERY_ID=-1]

Delivery is completed

[INSTANCE_ID=bip.bi_server1] [FTPProcessor]Delivery to SFTP completed with failure Server [sftp.myonex.com] does not exist or user does not have permission to access the server.

=> Working Scenario:

If we schedule the report and open from "REport Job History" and use the Option "Send" then select Destination Type as "FTP" the file is sent successfully to SFTP server. 

********Sample Bursting Script which we used*********

select distinct

receipt_num as "KEY"

,'PRODUCT LABEL REPRINT' TEMPLATE

,'en-US' LOCALE 

,'XML' OUTPUT_FORMAT

,receipt_num OUTPUT_NAME

,'FTP' DEL_CHANNEL

,'sftp.***.com' PARAMETER1 -- Server Name

,'dummy' PARAMETER2 -- Username

,'dummy' PARAMETER3 -- Password

,'/Reprint/'   PARAMETER4 --Remote Directory

,receipt_num||'_reprint.xml' PARAMETER5 -- Remote Filename

,'true' PARAMETER6 --Secure (set this value to 'true' to enable Secure FTP)

from rcv_shipment_headers where receipt_num  = :ReceiptNumber

Appreciate your suggestions.

Thanks,

Jhansi

Ohmesh Suraj

Issue/Fix: We need to configure the FTP Server in Oracle FA BI Admin and use the name defined there for Parameter1 in the bursting SQL.