Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to schedule Seeded Trial Balance report to SFTP using Bursting Query?
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.
Answers
-
To start you should be able to schedule the report and choose SFTP as the destination, no Bursting required.
If you are new to bursting I would suggest logging an SR to get direct assistance.
Rgds,
Kevin
1 -
Hi @User_A8934,
Please take a look into the following Oracle note which might be helpful for you to get answers to your queries.
Hope this help.
Cheers,
0 -
Can you please check the following table:
FUSION_IAU_VIEWER.BIPUBLISHER_V
Cheers,
0 -
Are you running it from ESS? If yes, there is no way to send it to SFTP from scheduled processes.
Thanks.
0 -
@Kevin M-Oracle I tried sending the report directly without bursting as well but the report sending the data in an unreadable format.
0 -
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.
0
