Sending Email notification to users when no data is returned from BI Report
SummarySending Email notification to users when no data is returned from BI Report
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
WHERE INVOICE_ID IS NULL
GROUP BY INVOICE_ID).When there is no data retrieved from this email notification should be sent to users.Appreciate your response.