Display Top 10 Distinct Opportunities With Revenue Line Items (Doc ID 2203686.1)

Last updated on DECEMBER 20, 2016

Applies to:

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

Goal

Why doesnt my report display the correct Opportunity and Revenue amounts?

There is a report where top 10 opportunity details should be shown based on ACV val (custom field on opportunity) along with revenue and product information.
Unfortunately report displays the first 10 revenue line instead of first 10 opportunities.

ie: if an opportunities have 5 line items,then the report will displays only first two opportunities. How to display top 10 opportunities irrespective of the number of revenue lines associated.
 

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