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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms