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

Oracle Transactional Business Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

750
Views
1
Comments
Jhansi Rani Dasari
Jhansi Rani Dasari Rank 1 - Community Starter

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

Tagged:
2
2 votes

Submitted · Last Updated

Comments

  • Ohmesh Suraj
    Ohmesh Suraj Rank 2 - Community Beginner
    edited Feb 19, 2024 2:44PM

    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.