Unable To See Inactive Products On BI Reports That Contain Opportunity Revenue Product Name (Doc ID 2297269.1)

Last updated on AUGUST 15, 2017

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
---------------
Custom report does not retrieve inactive products

EXPECTED BEHAVIOR
-----------------------
Expected to see revenue history even if product is inactive.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Created a report based on Sales - CRM Pipeline
E.g.

SELECT
 "Sales - CRM Pipeline"."Competitor"."Competitor Name" s_1,

  "Sales - CRM Pipeline"."Customer Organization Extension"."Extension Attribute Character 004" s_2,
  "Sales - CRM Pipeline"."Customer"."Customer Unique Name" s_3,
  "Sales - CRM Pipeline"."Opportunity"."Description" s_28,
  "Sales - CRM Pipeline"."Opportunity"."Opportunity Number" s_29,
  "Sales - CRM Pipeline"."Opportunity"."Owner Name" s_30,
  "Sales - CRM Pipeline"."Opportunity"."Reason Won or Lost" s_31,
  "Sales - CRM Pipeline"."Opportunity"."Revenue Probability" s_32,
  "Sales - CRM Pipeline"."Opportunity"."Sales Stage Name" s_33,
  "Sales - CRM Pipeline"."Opportunity"."Status Name" s_34,
  "Sales - CRM Pipeline"."Product"."Product Name" s_35,
  "Sales - CRM Pipeline"."Product"."Product Type" s_36,
  "Sales - CRM Pipeline"."Revenue Extension"."Extension Attribute Character 003" s_37,
  "Sales - CRM Pipeline"."Revenue Extension"."Extension Attribute Clob 001" s_38,
  "Sales - CRM Pipeline"."Revenue Extension"."Extension Attribute Clob 002" s_39,
  "Sales - CRM Pipeline"."Revenue Extension"."Extension Attribute LOV 011" s_40,
  "Sales - CRM Pipeline"."Revenue Extension"."Extension Attribute Number 006" s_41,
  "Sales - CRM Pipeline"."Revenue"."Quantity" s_42,
  "Sales - CRM Pipeline"."Revenue"."Quantity"*"Sales - CRM Pipeline"."Revenue"."Revenue Unit Price" s_43,
  "Sales - CRM Pipeline"."Revenue"."Revenue Expect Amt" s_44,
  "Sales - CRM Pipeline"."Revenue"."Revenue Number" s_45,
  "Sales - CRM Pipeline"."Win Loss Facts"."# of Competitors" s_98
FROM "Sales - CRM Pipeline"

2. Run and see product Name and Product Group are blank

3. If user navigates to the SUI, he can see revenue with product populated

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot see correct details in report

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