nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Table name with Delivery Configuration details

uocam

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

Find more posts tagged with

Accepted answers

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/24152/table-name-with-delivery-configuration-details

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.

All comments

Sumanth V -Oracle

@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!

uocam

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

Gianni Ceresa

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: https://community.oracle.com/products/oracleanalytics/categories/bi-publisher

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/24152/table-name-with-delivery-configuration-details

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.

uocam

@MandeepGupta Thank you!