How to schedule Seeded Trial Balance report to SFTP using Bursting Query?

Question

I have a requirement to schedule the seeded Trial Balance report to sftp server . I tried writing the bursting query but as the seeded data model doesnt contain the standard tables the bursting is not working which results in sending blank file to the sftp server folder. I tried writing dual in the from statement bursting query and also copied the data model query in the from statement bursting query but still no luck.

Anyone worked on this before share the query so that I can use it in my project.

Thanks in advance.

MandeepGupta · Answer

https://community.oracle.com/products/oracleanalytics/discussion/comment/63108#Comment_63108

Can you please confirm the steps that you have followed? Additionally, what the output format you are receiving on the SFTP? These details can help in finding the root cause.

Thanks.

User_A8934 · Answer

@Kevin M-Oracle I tried sending the report directly without bursting as well but the report sending the data in an unreadable format.

MandeepGupta · Answer

https://community.oracle.com/products/oracleanalytics/discussion/24317/how-to-schedule-seeded-trial-balance-report-to-sftp-using-bursting-query

Are you running it from ESS? If yes, there is no way to send it to SFTP from scheduled processes.

Thanks.