Custom Fixed Choice Lists On Sales Account Object Are Not Showing Under BI Subject Area (Doc ID 2136860.1)

Last updated on JULY 29, 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, Custom Fixed Choice Lists

ACTUAL BEHAVIOR  
---------------
Custom Fixed Choice Lists(FCL) on Sales Account object are not showing under BI Subject Area  

Customer has several custom Fixed Choice Lists and text fields that have been added to the Sales Account object and are available through the UI.
However, when using the "Sales - CRM Opportunities and Products Real Time" Subject Area in BI Answers, the FCL's are not available under Sales Account - Extension. All of the other fields are available.

EXPECTED BEHAVIOR
-----------------------
The custom FCLs should show up in BI Subject Areas under the relevant Folders.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Added FCL custom fields in Application Composer under Application: Sales, Object: Sales Account
2. Run "Reload Files and Metadata" under BI Administration tab.
3. Go to BI Answers and start a new Analysis
4. Select the Sales - CRM Opportunities and Products Real Time Subject Area
5. Navigate to Sales Account/Sales Account - Extension
6. The FCL's do not show up.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use the custom FCL's for Reporting.

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