Unable To Report On Employee Custom Field (Doc ID 2244678.1)

Last updated on JULY 29, 2017

Applies to:

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

Symptoms

On : 11.1.11.1.0 version, Analytics

ACTUAL BEHAVIOR
---------------
Unable to report on Employee custom field

Unable to report on Employee custom field - Channel.

Custom field definition in Sales Cloud --
1. Created Custom field (Fixed Choice List) in Employee table
2. Channel filed Consist of DMK / IMK values
3. While creating the user we need to select the Channel

We are using subject area "Sales - CRM Contact Resource" to report for the custom field Channel for a user.
For a specific user, when we bring in the field for Channel - "Sales - CRM Contact Resource"."Employee Extension"."Extension Attribute LOV 003" into the report, there is no data displayed.


EXPECTED BEHAVIOR
-----------------------
Report should be displayed

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to BI --> New analysis --> Sales - CRM Contact Resource

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot report channel custom field values

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