Fusion CRM OTBI cross subject area analysis, with extension columns :[nQSError: 14025] No fact table exists at the requested level of detail (Doc ID 1611172.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Fusion Common CRM Cloud Service - Version 11.1.4.0.0 and later
Oracle Fusion Application Toolkit - Version 11.1.1.5.1 and later
Information in this document applies to any platform.

Symptoms

Fusion CRM OTBI Cloud 11.1.7.0.0 - Cross Subject Area custom analysis, with "CRM App Composer"-created extension columns


Error Codes
---------------------------------------------------
Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 14025] No fact table exists at the requested level of detail

Problem Description
---------------------------------------------------
Report Name: Activity History by consultant and Date

A new custom analysis details are attached in the document.

When a analysis is run getting below error:

tate: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 14025] No fact table exists at the requested level of detail: [,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Detail,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Program,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,[Dim - Interaction.Interaction Description, Dim - Interaction.Interaction Created By, Dim - Interaction.Interaction Creation Date],,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,[Dim - Interaction Detail.Interaction Type Code],,,,,,,,,,,,,,,,,,,,,,,,,,,[Dim - Interaction Extension.Extension Attribute Character 010],,,[Dim - Customer Person Extension.Extension Attribute Timestamp 002, Dim - Customer Person Extension.Extension Attribute Number 004, Dim - Customer Person Extension.Extension Attribute Character 037],,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,]. (HY000)SQL Issued: SET VARIABLE PREFERRED_CURRENCY='Local Currency';SELECT 0 s_0, "Marketing - CRM Campaigns and Contacts Real Time"."Customer Person Extension"."Extension Attribute Character 037" s_1, "Marketing - CRM Campaigns and Contacts Real Time"."Customer Person Extension"."Extension Attribute Number 004" s_2, "Marketing - CRM Campaigns and Contacts Real Time"."Customer Person Extension"."Extension Attribute Timestamp 002" s_3, "Marketing - CRM Campaigns and Contacts Real Time"."Marketing Source"."Program Name" s_4, "Marketing - CRM Interactions Real Time"."Contact"."Full Name" s_5, "M




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