Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    sriharsha vemulapalli
    Sending Email notification to users when no data is returned...
    Topic posted August 11, 2018 by sriharsha vemulapalli, tagged OTBI 
    64 Views, 2 Comments
    Title:
    Sending Email notification to users when no data is returned from BI Report
    Summary:
    Sending Email notification to users when no data is returned from BI Report
    Content:

    We have implemented OCR(Invoice scanning) functionality in R13 Fusion cloud and would like to send email alert when there no invoices processed on that day.Is there any way from BI report to send email notification to users when there is no data returned from BI Report (Data model used for this scenario(SELECT COUNT(0) CNT,INVOICE_ID
    FROM AP_INVOICES_ALL
    WHERE INVOICE_ID IS NULL
    AND TRUNC(CREATION_DATE)=TRUNC(SYSDATE)
    AND SOURCE='IMAGE'
    GROUP BY INVOICE_ID).When there is no data retrieved from this email notification should be sent to users.Appreciate your response.

     

    Thanks,

    Harsha.

    Comment

     

    • Pras Ramakrishnan

      Hi Harsha,

      Have you tried the 'Condition' option on a BI Agent? At a high level you could do this assuming you have a report that generates no data when there are no invoices.

      1. Create a new BI Agent that looks for the condition that the report (refer to my assumption above) has a rowcount = 0
      2. If the condition is successful, the Agent would email a subject of your choice (For e.g., along the lines of "Alert: No invoice data was generated")

      Thanks,

      pras

    • Mark daynes

      Just glancing at that, is INVOICE_ID ever null on the table?

      Mark