BI Report - How to return only rows where custom date field is 3 days away or less? (Doc ID 2200010.1)

Last updated on DECEMBER 14, 2016

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Goal

Qn1:How can I create a report that only returns records that are N days before the custom date field?
Qn2:Once this report is created, I need to create a scheduled job to send an email notification to the Sales Rep listing all the records returned by this report.
In this case the Sales Rep is the Account Owner.

How could this be done?
 

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