How Can I Email An ESS Job's BI Report Only If There Is Output In The Report?

(Doc ID 1565675.1)

Last updated on SEPTEMBER 22, 2015

Applies to:

Oracle Fusion Applications Common Components - Version 11.1.5.0.0 and later
Oracle Fusion Application Toolkit - Version 11.1.5.0.0 and later
Information in this document applies to any platform.

Goal

Customer have a need to email an exception report to group of users, but only want to email the report if there is an actual exception (detail printed on the report).

We can setup the ESS job to email the output but it emails an empty report if there is nothing to report on.

How can we email a report only when there is output on the report?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms