My Oracle Support Banner

BI Performance Issue. (Doc ID 2525259.1)

Last updated on SEPTEMBER 15, 2020

Applies to:

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

Goal

The goal of this document is to establish a way to improve the performance of the following report:

 

SET VARIABLE QUERY_SRC_CD='Report',SAW_DASHBOARD='/shared/Custom/_portal/TPL Dashboard',SAW_DASHBOARD_PG='Lead',SAW_SRC_PATH='/shared/Custom/Customer Relationship Management/TPL Common/Lead Details',PREFERRED_CURRENCY='User Preferred Currency 1';SELECT
   0 s_0,
   "Marketing - CRM Leads"."Contact"."Contact Row ID" s_1,
   "Marketing - CRM Leads"."Contact"."Full Name" s_2,
   "Marketing - CRM Leads"."Customer"."Customer Row ID" s_3,
   "Marketing - CRM Leads"."Customer"."Customer Unique Name" s_4,
   "Marketing - CRM Leads"."Lead Status"."Lead Status Name" s_5,
   "Marketing - CRM Leads"."Lead"."Channel Type Name" s_6,
   "Marketing - CRM Leads"."Lead"."Industry Classification Name" s_7,
   "Marketing - CRM Leads"."Lead"."Lead Creation Date" s_8,
   "Marketing - CRM Leads"."Lead"."Lead Id" s_9,
   "Marketing - CRM Leads"."Lead"."Lead Name" s_10,
   "Marketing - CRM Leads"."Lead"."Lead Owner" s_11,
   "Marketing - CRM Leads"."Time"."Month" s_12,
   "Marketing - CRM Leads"."Time"."Year" s_13,
   DESCRIPTOR_IDOF("Marketing - CRM Leads"."Lead Status"."Lead Status Name") s_14,
   DESCRIPTOR_IDOF("Marketing - CRM Leads"."Lead"."Channel Type Name") s_15,
   DESCRIPTOR_IDOF("Marketing - CRM Leads"."Lead"."Industry Classification Name") s_16,
   SORTKEY("Marketing - CRM Leads"."Lead Status"."Lead Status Name") s_17,
   SORTKEY("Marketing - CRM Leads"."Lead"."Channel Type Name") s_18,
   SORTKEY("Marketing - CRM Leads"."Lead"."Industry Classification Name") s_19,
   "Marketing - CRM Leads"."Lead Facts"."# of Leads" s_20
FROM "Marketing - CRM Leads"
WHERE
("Resource Hierarchy"."User Organization Hierarchy Based Login" =  VALUEOF(NQ_SESSION."USER_PARTY_ID"))
ORDER BY 1, 5 ASC NULLS LAST, 10 ASC NULLS LAST, 13 ASC NULLS LAST, 20 ASC NULLS LAST, 8 ASC NULLS LAST, 17 ASC NULLS LAST, 14 ASC NULLS LAST, 19 ASC NULLS LAST, 7 ASC NULLS LAST, 16 ASC NULLS LAST, 18 ASC NULLS LAST, 6 ASC NULLS LAST, 15 ASC NULLS LAST, 11 ASC NULLS LAST, 9 ASC NULLS LAST, 3 ASC NULLS LAST, 12 ASC NULLS LAST, 4 ASC NULLS LAST, 2 ASC NULLS LAST
FETCH FIRST 75001 ROWS ONLY

 

Solution

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
Goal
Solution
References


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