My Oracle Support Banner

Oracle Sales Cloud Analytis: Display Manager Of Opportunity Owner in BI (Doc ID 2483915.1)

Last updated on DECEMBER 22, 2020

Applies to:

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

Symptoms

On : 11.13.18.05.0 version, Analytics

ACTUAL BEHAVIOR
---------------
Customer wants to display the Manager of Owner in his custom report, but current behavior is showing owner of revenue line instead of opportunity

EXPECTED BEHAVIOR
-----------------------
Expected to see the manager of opportunity owner and display the product itself.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Created a report based on:
SELECT
  0 s_0,
  "Sales - CRM Opportunities and Products Real Time"."Opportunity"."Opportunity Number" s_1,
  "Sales - CRM Opportunities and Products Real Time"."Opportunity"."Owner Name" s_2,
  "Sales - CRM Opportunities and Products Real Time"."Product"."Product Name" s_3,
  "Sales - CRM Opportunities and Products Real Time"."Revenue"."Revenue Id" s_4,
  "Sales - CRM Opportunities and Products Real Time"."Sales Resource"."Employee Name" s_5,
  "Sales - CRM Opportunities and Products Real Time"."Sales Resource"."Manager of Employee" s_6
FROM "Sales - CRM Opportunities and Products Real Time"
WHERE
("Opportunity"."Opportunity Number" = 'XXXXX')

2. It returns 2 Employee Names. "Name 1" is Opportunity Owner and has a Manager name. But Product shows blank
  "Name 2" shows as second Employee Name, has no manager but it is associated with Product

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot show correct data on the analysis

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.