Related Object LOV Disabled While Creating Custom Analytics Subject Area For Two Object (Doc ID 1930141.1)

Last updated on AUGUST 30, 2016

Applies to:

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

Goal

On : 11.1.8.0.0 version, Customer Center and Common

Need to build a report for which related data is stored in two custom objects in OSC.

But related Object LOV Disabled while creating Custom Analytics Subject Area for two object

Test Case :
Object 1 : Territory details - having data related to Territory id, Territory Name, State, Region and Sales Reps assigned to it.
Object 2. Customer Sales History - This object has information related to customer and sales data - customer number, customer name, Territory id , product, quantity and amount.

Common link between the two is 'Territory id'.
Using relationship option under Application Composer, set the reference between these two objects.

Then trying to create custom subject area and want to include fields from both these objects.
While selecting Related Object option, we are not able to select anything. That option is greyed out(disabled).

How to have this option available ?


 

Solution

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