My Oracle Support Banner

Reporting on 'Industry Name' Field (Doc ID 1991414.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 11.1.8.0.0 version, Analytics

ACTUAL BEHAVIOR
---------------
When trying to build a report with Sales - CRM Customers and Contacts Real Time.Customer.Industry Name field, it is populating with __NOT__APPLICABLE__

EXPECTED BEHAVIOR
-----------------------
Expected to see Industry Name values on it

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a new analysis based on Sales - CRM Customers and Contacts Real Time or Sales - CRM Pipeline 
2. Select fields Customer Name, Owner, Industry Name, Contact, Contact Phone, Primary Email, Address…
3. Run the report
4. Industry Name show value__NOT__APPLICABLE__ for all rows

SQL Issue: 


SELECT
0 s_0,
"Sales - CRM Customers and Contacts Real Time"."Customer"."Customer Name" s_1,
"Sales - CRM Customers and Contacts Real Time"."Customer"."Industry Name" s_2,
DESCRIPTOR_IDOF("Sales - CRM Customers and Contacts Real Time"."Customer"."Industry Name") s_3,
SORTKEY("Sales - CRM Customers and Contacts Real Time"."Customer"."Industry Name") s_4
FROM "Sales - CRM Customers and Contacts Real Time"
ORDER BY 1, 2 ASC NULLS LAST, 5 ASC NULLS LAST
FETCH FIRST 75001 ROWS ONLY

 

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot see Industry Name field value

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.