Pipeline Facts.Expected Opportunity Revenue Is Blank (Doc ID 1667710.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 11.1.7.0.0 version, Technology Management - Reports/Analytics

ACTUAL BEHAVIOR
---------------
Customer created a custom OTBI report based on - CRM Opportunities and Products Real Time where the Pipeline Facts.Expected Opportunity Revenue field were returning zero as results

EXPECTED BEHAVIOR
-----------------------
Expected to see the value that displays in UI

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an analysis with following:
SELECT
  0 s_0,
  "Sales - CRM Opportunities and Products Real Time"."Customer"."Customer Row ID" s_1,
  "Sales - CRM Opportunities and Products Real Time"."Customer"."Customer Unique Name" s_2,
  "Sales - CRM Opportunities and Products Real Time"."Opportunity"."Opportunity ID" s_3,
  "Sales - CRM Opportunities and Products Real Time"."Opportunity"."Opportunity Name" s_4,
  Concat("Sales - CRM Opportunities and Products Real Time"."Opportunity"."Owner First Name","Sales - CRM Opportunities and Products Real Time"."Opportunity"."Owner Last Name") s_5,
  "Sales - CRM Opportunities and Products Real Time"."Pipeline Facts"."Expected Opportunity Revenue" s_6,
  "Sales - CRM Opportunities and Products Real Time"."Pipeline Facts"."Opportunity Revenue" s_7,
  REPORT_SUM("Sales - CRM Opportunities and Products Real Time"."Pipeline Facts"."Expected Opportunity Revenue" BY ) s_8,
  REPORT_SUM("Sales - CRM Opportunities and Products Real Time"."Pipeline Facts"."Opportunity Revenue" BY ) s_9
FROM "Sales - CRM Opportunities and Products Real Time"
WHERE
("Time"."Month" = VALUEOF("CURRENT_MONTH"))
2. Execute
3. It returns records but Pipeline Facts.Expected Opportunity Revenue returns 0.00

 

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