Cannot return correct Opportunity Line Revenue with columns Territory Name, Employee Name, Resource Quotas. (Doc ID 2191213.1)

Last updated on NOVEMBER 23, 2016

Applies to:

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

Symptoms

On : 11.1.11.1.0 version, Analytics

ACTUAL BEHAVIOR
---------------
An analysis having Territory Name, Employee Name, Resource Quotas and Employee Opportunities does not show the correct data.

You created a report that gets the Territory Name, Employee Name, Resource Quotas, and Employees' Opportunities; however, the report does not link these fields properly.


EXPECTED BEHAVIOR
-----------------------
Should be able to get proper data in the BI Report for Territory Name, Employee Name, Resource Quotas, and Opportunities.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Build a report that gets the Territory Name, Employee Name, Resource Quota, and Opportunity Line Revenue.
2. Note that the report does not return proper values for Opportunity Line Revenue.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, customer's BI Report is incorrect.

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