Why Opportunity Line Revenue Is Not Fetching Correct Data In Report (Doc ID 2132430.1)

Last updated on APRIL 29, 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

On : 11.1.10.0.0 version, Analytics

Opportunity line revenue not fetching correct data in report

Created a report based on opportunities to fetch data related to opportunities.
Subject area: Sales-CRM opportunities and product real time.(Standard).
Field: “Opportunity line revenue” from pipeline detail facts
Quantity from Revenue- Quantity
The Report output for “line revenue” should be (quantity * Unit price) ideally. Which is correct at most of the places. But, with some opportunities the data is not coming up correctly.

Issue 1: Merging Revenue lines: If opportunity has 5 revenue lines in which 2 our exactly duplicate in every aspect, the report is merging the revenue for it but showing quantity and unit price for single line.

Issue 2: Data not Matching with Amount: For some opportunities, Instead of single line revenue. The data for Line revenue is not correct in report output

Issue 3: Recurring Schedule: For some opportunities, where there is a recurring schedule attached. 2 lines are created for the opportunity in report one gives total revenue but single recurring line quantity and unit price. And another gives full quantity with zero revenue.
 

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