Home › Discussions › Questions & Answers › My scheduled alert report didn’t send an email when it was empty

My scheduled alert report didn’t send an email when it was empty

Avatar photoCustomer July 21, 2020 at 4:56 am

I scheduled an alert report designed to run daily. If it finds no exceptions (zero rows), no output file is delivered via email. Why is the email suppressed?

Viewing 6 reply threads
  • Author
    Replies
    • Support July 22, 2020 at 11:10 am  

      By default, if a scheduled Blitz Report retrieves zero rows, it does not send an empty output file. File delivery through Oracle standard’s delivery options is suppressed.

    • Avatar photoCustomer July 22, 2020 at 2:58 pm  

      Since this is an alert report, I need confirmation that it ran, even if it was empty. How do I force the email delivery?

    • Support July 23, 2020 at 11:02 am  

      You must override the default behavior using the profile option ‘Blitz Report Suppress Empty File Delivery’. To ensure that empty files are also sent for scheduled reports, set this profile option value to ‘No’.

    • Avatar photoCustomer July 23, 2020 at 10:43 pm  

      If I want to enforce this suppression behavior for a specific report that serves as a critical outbound interface, can I set it to ‘Protected’ type?

    • Support July 24, 2020 at 10:00 pm  

      Yes, if you want to give your outbound interface report an additional level of protection and allow modifications only by users with the ‘System’ access profile, you can set its Type to ‘Protected’.

    • Avatar photoCustomer July 26, 2020 at 7:07 am  

      Where can I review the log file if an execution fails?

    • Support July 27, 2020 at 10:59 am  

      If an error occurs, you should review the report concurrent logfile. The logfile shows error messages, the executed SQL, user-entered parameter values, and corresponding bind variables.

  • Author
    Replies
Viewing 6 reply threads
  • You must be logged in to reply to this post.

Login with:
Popular Posts
How to track master data changes using Oracle EBS Audit function and Blitz Report™ 123747

Oracle Enterprise Command Center Framework Release 12.2 installation and integration with Oracle EBS 12.2.8 19801

Oracle Discoverer replacement – importing worksheets into Blitz Report™ 14615

How to check if a patch is applied in Oracle EBS 12.2 14389

Oracle Discoverer 11.1.1.7 installation and integration with Oracle EBS R12.1.3 14073

Oracle E-Business Suite 12.2.8 upgrade to version 12.2.9 11965

Oracle E-Business Suite 12.2.7 upgrade to version 12.2.8 9899

Migration to Java Web Start in Oracle EBS 12.2 instance 9891

Securing sensitive data with Oracle VPD 7794

EBS 12.1.3 BI Publisher Excel templates generate XLS instead of XLSX and limit row number to 65,536 6449

Blog Archive
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
Recent Events
2026
2025
2024
2023
2022
2021
2020
2019
2018