Subject Areas Errors In BI Report (Doc ID 2255105.1)

Last updated on MAY 03, 2017

Applies to:

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

Symptoms

On : 11.1.11.1.0 version, Analytics

Analysis with Subject Areas: Sales - CRM Sales Activity and Sales - CRM Opportunity Resource keeps getting an error when attempting to combine fields in the layout.


ERROR
-----------------------

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.Activity Type, Dim - Activity.Activity Type Code, Dim - Activity.Due Date, Dim - Activity.Status, Dim - Activity.Status Code, Dim - All Employee.Employee Name, Dim - Employee.Employee Name, Dim - Opportunity.Opportunity ID, Dim - Opportunity.Opportunity Name (HY000)
  Error Details
Error Codes: :U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 14025] No fact table exists at the requested level of detail: [,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Opty Detail,,,,,,,,,,,,,[Dim - Activity.Due Date, Dim - Activity.Activity Type, Dim - Activity.Activity Type Code, Dim - Activity.Status Code, Dim - Activity.Status],,,,,,Employee Detail,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Detail,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,





STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to BI --> new Analysis --> Combine two subject ares "Sales - CRM Sales Activity and Sales - CRM Opportunity Resource"

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot get the desired report

Cause

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