My Oracle Support Banner

R13 18C Update - User Report Does Not Run In 18C (Doc ID 2516349.1)

Last updated on DECEMBER 22, 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 below mentioned "report 2" does not run properly after 18C upgrade, but constantly tries with the progress wheel going round.

"Report 1" does run and report 2 is simply modeled on report 1 to display a monthly view of users in sales cloud.

The goal of this document is to improve the performance on Report 2.

Report 1:

SELECT
   0 s_0,
   "Sales - CRM Resource"."Employee"."Employee Job Title Name" s_1,
   "Sales - CRM Resource"."Employee"."Employee Login Name" s_2,
   "Sales - CRM Resource"."Employee"."Resource Primary Organization Name" s_3,
   "Sales - CRM Resource"."Resource Hierarchy"."User Organization Hierarchy Based Login" s_4,
   "Sales - CRM Resource"."User"."Creation Date" s_5,
   "Sales - CRM Resource"."User"."Email Address" s_6,
   "Sales - CRM Resource"."User"."First Name" s_7,
   "Sales - CRM Resource"."User"."Last Activity Date" s_8,
   "Sales - CRM Resource"."User"."Last Name" s_9,
   "Sales - CRM Resource"."User"."Last Updated By" s_10,
   "Sales - CRM Resource"."User"."User Account Status" s_11,
   DESCRIPTOR_IDOF("Sales - CRM Resource"."Employee"."Resource Primary Organization Name") s_12,
   DESCRIPTOR_IDOF("Sales - CRM Resource"."User"."User Account Status") s_13,
   "Sales - CRM Resource"."Resource Facts"."# of Users" s_14,
   "User System Usage"."Active Day Facts"."# of Active Days" s_15,
   REPORT_SUM("Sales - CRM Resource"."Resource Facts"."# of Users" BY ) s_16,
   REPORT_SUM("Sales - CRM Resource"."Resource Facts"."# of Users" BY DESCRIPTOR_IDOF("Sales - CRM Resource"."Employee"."Resource Primary Organization Name")) s_17,
   REPORT_SUM("User System Usage"."Active Day Facts"."# of Active Days" BY DESCRIPTOR_IDOF("Sales - CRM Resource"."Employee"."Resource Primary Organization Name"),DESCRIPTOR_IDOF("Sales - CRM Resource"."User"."User Account Status"),"Sales - CRM Resource"."User"."Email Address") s_18
FROM "Sales - CRM Resource"
WHERE
("Employee"."Employee Login Name" IS NOT NULL)
ORDER BY 1, 4 ASC NULLS LAST, 7 ASC NULLS LAST

 

Report 2:

SELECT
   0 s_0,
   "Sales - CRM Resource"."Employee"."Employee Job Title Name" s_1,
   "Sales - CRM Resource"."Employee"."Employee Login Name" s_2,
   "Sales - CRM Resource"."Employee"."Resource Primary Organization Name" s_3,
   "Sales - CRM Resource"."Resource Hierarchy"."User Organization Hierarchy Based Login" s_4,
   "Sales - CRM Resource"."User"."Creation Date" s_5,
   "Sales - CRM Resource"."User"."Email Address" s_6,
   "Sales - CRM Resource"."User"."First Name" s_7,
   "Sales - CRM Resource"."User"."Last Activity Date" s_8,
   "Sales - CRM Resource"."User"."Last Name" s_9,
   "Sales - CRM Resource"."User"."Last Updated By" s_10,
   "Sales - CRM Resource"."User"."User Account Status" s_11,
   "User System Usage"."Time"."Date" s_12,
   "User System Usage"."Time"."Month" s_13,
   DESCRIPTOR_IDOF("Sales - CRM Resource"."Employee"."Resource Primary Organization Name") s_14,
   DESCRIPTOR_IDOF("Sales - CRM Resource"."User"."User Account Status") s_15,
   "Sales - CRM Resource"."Resource Facts"."# of Users" s_16,
   "User System Usage"."Active Day Facts"."# of Active Days" s_17,
   REPORT_AGGREGATE("Sales - CRM Resource"."Resource Facts"."# of Users" BY DESCRIPTOR_IDOF("Sales - CRM Resource"."Employee"."Resource Primary Organization Name"),"Sales - CRM Resource"."Employee"."Employee Job Title Name","Sales - CRM Resource"."Resource Hierarchy"."User Organization Hierarchy Based Login","Sales - CRM Resource"."Employee"."Employee Login Name",DESCRIPTOR_IDOF("Sales - CRM Resource"."User"."User Account Status"),"Sales - CRM Resource"."User"."Last Updated By","Sales - CRM Resource"."User"."Last Name","Sales - CRM Resource"."User"."First Name","Sales - CRM Resource"."User"."Creation Date","Sales - CRM Resource"."User"."Email Address","Sales - CRM Resource"."User"."Last Activity Date") s_18,
   REPORT_SUM("Sales - CRM Resource"."Resource Facts"."# of Users" BY ) s_19,
   REPORT_SUM("Sales - CRM Resource"."Resource Facts"."# of Users" BY DESCRIPTOR_IDOF("Sales - CRM Resource"."Employee"."Resource Primary Organization Name")) s_20,
   REPORT_SUM("User System Usage"."Active Day Facts"."# of Active Days" BY DESCRIPTOR_IDOF("Sales - CRM Resource"."Employee"."Resource Primary Organization Name"),"Sales - CRM Resource"."Employee"."Employee Job Title Name","Sales - CRM Resource"."Resource Hierarchy"."User Organization Hierarchy Based Login","Sales - CRM Resource"."Employee"."Employee Login Name",DESCRIPTOR_IDOF("Sales - CRM Resource"."User"."User Account Status"),"Sales - CRM Resource"."User"."Last Updated By","Sales - CRM Resource"."User"."Last Name","Sales - CRM Resource"."User"."First Name","Sales - CRM Resource"."User"."Creation Date","Sales - CRM Resource"."User"."Email Address","Sales - CRM Resource"."User"."Last Activity Date") s_21,
   REPORT_SUM("User System Usage"."Active Day Facts"."# of Active Days" BY DESCRIPTOR_IDOF("Sales - CRM Resource"."Employee"."Resource Primary Organization Name"),DESCRIPTOR_IDOF("Sales - CRM Resource"."User"."User Account Status"),"Sales - CRM Resource"."User"."Email Address","User System Usage"."Time"."Month") s_22
FROM "Sales - CRM Resource"
WHERE
("Employee"."Employee Login Name" IS NOT NULL)
ORDER BY 1, 4 ASC NULLS LAST, 14 ASC NULLS LAST


 

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.