My Oracle Support Banner

Unable To Report On Campaigns Created By Other Users (Doc ID 2150928.1)

Last updated on APRIL 27, 2018

Applies to:

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

Symptoms

On : 11.1.10.0.0 version, Analytics

ACTUAL BEHAVIOR
---------------
When attempting to report on Leads and Campaigns, the report only return Campaign details that the user running report creates, others shows blank

EXPECTED BEHAVIOR
-----------------------
Expected to see all campaigns

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create analysis
SELECT
  0 s_0,
  "Marketing - CRM Campaigns and Leads Real Time"."Marketing Source"."Program Name" s_1,
  "Marketing - CRM Leads"."Lead Extension"."Extension Attribute LOV 010" s_2,
  "Marketing - CRM Leads"."Lead Extension"."Extension Attribute LOV 024" s_3,
  "Marketing - CRM Leads"."Lead Status"."Lead Status Name" s_4,
  "Marketing - CRM Leads"."Lead"."Lead Creation Date" s_5,
  "Marketing - CRM Leads"."Lead"."Lead Id" s_6,
  "Marketing - CRM Leads"."Lead"."Lead Name" s_7,
  "Marketing - CRM Leads"."Lead"."Lead Owner" s_8,
  DESCRIPTOR_IDOF("Marketing - CRM Leads"."Lead Status"."Lead Status Name") s_9,
  SORTKEY("Marketing - CRM Leads"."Lead Status"."Lead Status Name") s_10,
  "Marketing - CRM Leads"."Lead Facts"."# of Qualified Leads" s_11,
  "Marketing - CRM Leads"."Lead Facts"."Avg Lead Age (Days)" s_12
FROM "Marketing - CRM Campaigns and Leads Real Time"
WHERE
(DESCRIPTOR_IDOF("Marketing - CRM Leads"."Lead Status"."Lead Status Name") = 'UNQUALIFIED')
ORDER BY 1, 13 ASC NULLS LAST, 9 ASC NULLS LAST, 3 ASC NULLS LAST, 11 ASC NULLS LAST, 2 ASC NULLS LAST, 4 ASC NULLS LAST, 8 ASC NULLS LAST, 7 ASC NULLS LAST, 6 ASC NULLS LAST
FETCH FIRST 75001 ROWS ONLY

2. Run
3. Only the campaigns created by runner shows in report

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot see all campaigns

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.