Receiving Error Message When Joining Subject Areas Cannot join Account with "Sales Stage Snapshot" subject area.
Last updated on JANUARY 08, 2018
Applies to:Oracle Fusion Sales Cloud Service - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
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:
"You may be able to evaluate this query if you remove one of the following column references: Dim - Customer.Unique Name Alias, ...
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.
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