Why Opportunity Line Revenue Is Not Fetching Correct Data In Report
Last updated on APRIL 29, 2016
Applies to:Oracle Fusion Sales Cloud Service - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
On : 126.96.36.199.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.
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