Win Probability On BI Report Not Returning Values (Doc ID 2756567.1)

Last updated on MARCH 03, 2021

Applies to:

Symptoms

On : 11.13.20.10.0 version, Analytics

ACTUAL BEHAVIOR
---------------
Win Probability on BI Report not returning values

When creating a report to review Revenue, when trying to add the opportunity revenue - "win probability" field to the report no values are returned. This occurs when trying to add it as a column with other fields and as a lone column. The field displayed on the Opportunity UI is the Revenue Win Probability field.

EXPECTED BEHAVIOR
-----------------------
Win Probability should show the win probability on revenue line

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create analysis using below query, win probability shows blank:

SET VARIABLE QUERY_SRC_CD='Report',SAW_SRC_PATH='/shared/Reports/Opportunity Revenue',PREFERRED_CURRENCY='User Preferred Currency 1';SELECT
  0 s_0,
  "Sales - CRM Pipeline"."Opportunity"."Opportunity Name" s_1,
  "Sales - CRM Pipeline"."Opportunity"."Owner Name" s_2,
  "Sales - CRM Pipeline"."Product"."Product Name" s_3,
  "Sales - CRM Pipeline"."Revenue"."Recommended Win Probability" s_4,
  "Sales - CRM Pipeline"."Pipeline Detail Facts"."Opportunity Line Revenue" s_5
FROM "Sales - CRM Pipeline"
ORDER BY 1, 3 ASC NULLS LAST, 2 ASC NULLS LAST, 4 ASC NULLS LAST, 5 ASC NULLS LAST
FETCH FIRST 250001 ROWS ONLY

Changes

Cause

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