Oracle Transactional Business Intelligence Idea Lab

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

Expose Table for Bursting Output Results

301
Views
12
Comments

Currently, Oracle gives us access to some BIP Auditing data for Fusion SaaS pods but it does not include the status of bursting output details.

As is shown in the example below, It is possible to have one report job that ended with a "Problem", but have some of the bursted documents delivered successfully while others fail. We know how to get that overall status. We can't seem to find the table which would allow us to ensure we don't resend the email that went out successfully, while ensuring that we do try to resend the ones that ended in "Problem".

Oracle should expose either this table directly or make it available in one of the existing fusion_iau_viewer schema objects such as bipublisher_v. This helps with auditing to ensure that all BI Publisher outputs are delivered successfully, particularly when there is an outage or some other issue that can cause notifications to occasionally be delayed or fail to send.

31
31 votes

Submitted · Last Updated

«1

Comments

  • Dharmendra Shukla
    Dharmendra Shukla Rank 3 - Community Apprentice

    Voting for this idea. Looking for the root cause of mail delivery failure cases from Job History is impractical especially when the number of recipients is more. Also, the case mentioned in the idea is a real one and I am sure many customers must be having similar issues. It would be of great help if this information is available in a table.

  • Aaron Leggett
    Aaron Leggett Rank 5 - Community Champion

    Voted - this is essential for organizations that utilize scheduled email deliveries via BIP. It's currently not practical, nor manageable, to decipher which emails bounced or failed to deliver via the current interface available to us.

  • User_1PTBO
    User_1PTBO Rank 1 - Community Starter

    Voting for this idea. It's important to know which one failed and which one success, It's required to resend only the failed ones.

  • Nikki K
    Nikki K Rank 3 - Community Apprentice

    Also voting on this idea!! It would be a great enhancement.

  • Srini Devara
    Srini Devara Rank 2 - Community Beginner

    I vote for this idea, this much needed feature for clients to get failed result from oracle Bursting

  • Service Desk Claremont
    Service Desk Claremont Rank 1 - Community Starter

    I vote for this idea, this much needed feature for clients to get failed result from oracle Bursting

  • Sudheer YN
    Sudheer YN Rank 3 - Community Apprentice

    we need it too

  • Vamsi Krishna
    Vamsi Krishna Rank 1 - Community Starter

    we need it too

  • Suprit
    Suprit Rank 2 - Community Beginner

    I vote for this Idea. Will be a great addition

  • Velidi Supraja
    Velidi Supraja Rank 1 - Community Starter

    This is very much needed as customers wants to get notified with the UCM content ID when we delivery BIP report out to UCM content server