Report And Opportunity Data Mismatch

(Doc ID 2297482.1)

Last updated on JANUARY 01, 2018

Applies to:

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

Symptoms

On : 11.12.1.0.0 version, Analytics

ACTUAL BEHAVIOR
---------------
Report and Opportunity data mismatch

Hi,

Opportunity # 770759 is producing two entries in report. One has a revenue amount for $100,000 and the other for $70,350.
However, if we access then opportunity recoiord, there is only one revenue line with amount $70,350

When we pull pipeline and forecasting reports, the second opportunity for $100,000 is inflating our reports. Please advise on how we can correct

PFA screen shots

EXPECTED BEHAVIOR
-----------------------
opportunity should show only one revenue line amount

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Open the pipeline and forecasting reports

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, reports are getting inflated

Cause

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