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 and later
Information in this document applies to any platform.


On : version, Analytics

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.

Report should be displayed

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

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


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