My Oracle Support Banner

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

Last updated on JANUARY 08, 2018

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

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
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.