My Oracle Support Banner

Reporting On Assets Based On Logged In User as Account Owner (Doc ID 2158167.1)

Last updated on MARCH 08, 2017

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 attempt to cross subject areas by adding Employee.Employee Id from Sales - CRM Customer Overview, the custom analysis shows No Results

EXPECTED BEHAVIOR
-----------------------
Expected to show up the Account Owner and make sure that the employees only see their customer list.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Created analysis based in the following SQL
SELECT
  0 s_0,
  "Sales - CRM Asset"."Customer Organization Extension"."Extension Attribute Character 007" s_1,
  "Sales - CRM Asset"."Customer Organization Extension"."Extension Attribute LOV 010" s_2,
  "Sales - CRM Asset"."Customer"."Account Owner Name" s_3,
  "Sales - CRM Asset"."Customer"."Customer City" s_4,
  "Sales - CRM Asset"."Customer"."Customer Street Address" s_5,
  "Sales - CRM Asset"."Customer"."Level 1 Account Name" s_6,
  "Sales - CRM Asset"."Customer"."Postal Code" s_7,
  "Sales - CRM Asset"."Industry"."Industry Name" s_8,
  "Sales - CRM Asset"."Product"."Product Name" s_9,
  "Sales - CRM Customer Overview"."Employee"."Employee Party Id" s_10,
  DESCRIPTOR_IDOF("Sales - CRM Asset"."Industry"."Industry Name") s_11,
  CASE WHEN "Sales - CRM Asset"."Asset Facts"."# of Assets"=0 THEN 1 ELSE 1 END s_12
FROM "Sales - CRM Asset"
ORDER BY 1, 4 ASC NULLS LAST, 11 ASC NULLS LAST, 7 ASC NULLS LAST, 6 ASC NULLS LAST, 5 ASC NULLS LAST, 8 ASC NULLS LAST, 2 ASC NULLS LAST, 9 ASC NULLS LAST, 3 ASC NULLS LAST, 10 ASC NULLS LAST
FETCH FIRST 75001 ROWS ONLY

2. Report returns No Results

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot filter by Employee

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


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.