Receiving Error Message When Joining Subject Areas Cannot join Account with "Sales Stage Snapshot" subject area. (Doc ID 2154467.1)

Last updated on JUNE 30, 2016

Applies to:

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

Symptoms

Receiving Error Message when Joining Subject Areas, possibly due to Subject Areas not Modeled.

Customer has created a report that pulls data from Subject Area 'CRM Opportunity Sales Stage Snapshot'.
This report runs without issue. When you add Subject Area 'Sales - CRM Pipeline' and any column, such as 'Account Name', from the 'Customer' folder, you receive this error message:


ERROR
"You may be able to evaluate this query if you remove one of the following column references: Dim - Customer.Unique Name Alias, ...


STEPS
The issue can be reproduced at will with the following steps:
1. Add a column from the Customer folder in the Subject Area 'Sales - CRM Pipeline' to a report already built using "CRM Opportunity Sales Stage Snapshot"
2. Click Results.
3. Note the error.






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