How To Create Sales Stage Duration Report On Opportunities (Doc ID 2115885.1)

Last updated on MAY 12, 2016

Applies to:

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

Goal

We would like to obtain Metrics on the amount of time it takes to go through our Sales Stages contained in Sales Methods. How can we find/use behind the scene time/date stamping as an Opportunity goes through the defined Sales Stages? If we see them, then we can review average times it takes for the Opportunity cycle and also look at the variation within Sales Stages.

Here's an example of the type of data I'm looking for on an Opportunity:

OPPY NAME         Sales Stage 1               Start Sales Stage 1     End Sales Stage 2         Start Sales Stage 2     End Sales Stage 3         Start Sales Stage 3
-----------------      ------------------------      -----------------------     ------------------------      -----------------------     ------------------------       ------------------------
Opportunity #1    2/26/2016                   2/28/2016                  2/28/2016                   3/1/2016                    3/1/2016                      3/4/2016
Opportunity #2    2/2/2016                     2/8/2016                    2/8/2016                     2/15/2016                  2/15/2016                    2/25/2016

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