Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Table name with Delivery Configuration details

I am looking for the tables that has the delivery configuration details. I want to fetch the email address from this page to use in a DM SQL.
Navigation: Administration>Publisher>Manage Publisher>Delivery>Delivery Configuration
Also, can we use any email address as the from address in the bursting SQL? If I use anything different to what is configured in delivery configurations it stops sending out emails.
Thanks
Best Answer
-
Hi,
To answer your first question related to delivery details, these details are not stored in any fusion tables. So, you can't query these.
Fusion BIP: Tables that Stores SFTP Details And How A BIP Bursting Query Can Get Default SFTP Details (Doc ID 2804172.1)
There is already an idea submitted for same, please evaluate and upvote:
BIP Report SFTP Configuration Tables — Oracle Analytics
Though the idea is specifically for SFTP but is applicable to all configuration done at delivery level.
For your second query, please check below MOS notes:
Fusion BIP Bursting Emails are Not Delivered (Doc ID 2649606.1)
Fusion BI Publisher - BI Publisher Bursting Query From Email Address Parameter 3 - Bursting Alerts - Bursting Notifications - SMTP / OCI CNS - Email Domain - Bursting Job is Successful But the Mail is Not Received (Doc ID 2621045.1)
Thanks.
1
Answers
-
@uocam -
Please let us know if you are using the OBIA application or a standalone BI Publisher application. All the queries posted are related to BI Publisher alone. We also have a community dedicated for BIP, hence checking with you to suggest accordingly. Thanks!
0 -
Hi Sumanth, this is query about Data Model SQL for BI publisher report. Can you please let me know where I need to post the question
0 -
Hi @uocam ,
No need to post it anywhere else. Publisher is just a different category in this community (not a different community). Your question has been moved there (from the OBIA category).
If you want a direct link to the Publisher category it is this one:
1 -
@MandeepGupta Thank you!
0