Receiving Error Message When Joining Subject Areas Cannot join Account with "Sales Stage Snapshot" subject area.
(Doc ID 2154467.1)
Last updated on DECEMBER 22, 2020
Applies to:Oracle Fusion Sales Cloud Service - Version 126.96.36.199.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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document