How to List All Activity Types on a Report, even if "# Of Activities" is 0 (zero) ? (Doc ID 2223720.1)

Last updated on JANUARY 23, 2017

Applies to:

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

Goal

On : 11.1.11.1.0 version, Analytics

Need to List all Activity Types on a report, even if the "# of Activities" is 0

You have an 'Activity' report that lists the Activity Types found/used, for example, within a Territory.
and also the "# of Activities" for each 'Activity Type'.

In other words, like this:
Column a:  Activity Type
Column b:  # of Activities

You need to show all the 'Activity Types' in the report, even if the # of Activities is 0.
Currently, the report lists only the Activity Types which have been used across a given Territory.
 

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