You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Sending Email notification to users when no data is returned from BI Report

edited Aug 11, 2018 11:36PM in Reporting and Analytics for ERP 2 comments

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!