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 DECEMBER 22, 2020

Applies to:

Oracle Fusion Sales Cloud Service - Version 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

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