Sales CRM Pipeline Subject Area And Activity Failing In A Combined Report (Doc ID 2166480.1)

Last updated on NOVEMBER 05, 2016

Applies to:

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

Goal

We have a custom report build out of Opportunity and revenue line item and when we try to add the activity to the report it throwing error message,

This error message :

 Error
  View Display Error
 
You may be able to evaluate this query if you remove one of the following column references: Dim - Activity.ROW_ID, Dim - Customer.Customer Name, Dim - Customer.Customer Row ID, Dim - Opportunity Extension.Extension Attribute Character 011, Dim - Opportunity Extension.Extension Attribute Character 031, Dim - Opportunity Extension.Extension Attribute LOV 014, Dim - Opportunity Extension.Extension Attribute LOV 046, Dim - Opportunity Extension.Extension Attribute Number 004, Dim - Opportunity Extension.Extension Attribute Timestamp 002, Dim - Opportunity.Opportunity ID, Dim - Opportunity.Owner Name, Dim - Opportunity.Sales Stage Code, Dim - Opportunity.Sales Stage Name, Dim - Revenue Extension.Extension Attribute Number 010, Dim - Revenue.Expected Close Date, TimestampDiff(SQL_TSI_DAY, DATE '2016-07-25', Dim - Opportunity Extension.Extension Attribute Timestamp 002) (HY000)
  Error Details
 

Solution

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