My Oracle Support Banner

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

Last updated on MARCH 24, 2019

Applies to:

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


On : version, Analytics

Custom report does not retrieve inactive products

Expected to see revenue history even if product is inactive.

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

 "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

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


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

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