Oracle Analytics Publisher

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

Table name with Delivery Configuration details

Accepted answer
80
Views
5
Comments
uocam
uocam Rank 1 - Community Starter
edited Dec 30, 2024 9:28AM in Oracle Analytics Publisher

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

  • MandeepGupta
    MandeepGupta Rank 8 - Analytics Strategist

    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.

Answers