My Oracle Support Banner

Subject Areas Errors In BI Report (Doc ID 2255105.1)

Last updated on MAY 03, 2017

Applies to:

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


On : 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 Message:

  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,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

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"

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


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.