Oracle Fusion OTBI: BI Report fails with [nQSError: 14081] when adding the Cost Center Code (Doc ID 2071595.1)

Last updated on OCTOBER 28, 2015

Applies to:

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

Symptoms

On : 11.1.10.0.0 version, Technology Management - Reports/Analytics

Every time you add the the "-Cost Center Segment"."Cost Center Code" to the report, it fails with the following error

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

[nQSError: 14081] You may be able to evaluate this query if you remove one of the following column references: Dim - Cost Center.Cost Center Code.
[2015-10-27T13:16:54.217+00:00] [OracleBIServerComponent] [TRACE:2] [] [] [ecid: 0058lN^FYWKFg4Y5trL6iX0003LJ000Ayu,0:4:1:1:5] [tid: 37b31940] [messageid: USER-52] [requestid: d1c7001a] [sessionid: d1c70000] [username: pmenon] -------------------- Expression 'Journal Line Accounted Amount Credit:[DAggr(Fact - Fins - GL Journals Real Time.Journal Line Accounted Amount Credit by [ Dim - Date Fiscal Calendar.Row Wid, Dim - GL Account.General Ledger Code Combination Identifier, Dim - Cost Center.Cost Center Code, Dim - Posting Status.Posting Status Description, Dim - Date Fiscal Calendar.Fiscal Date] SB GL Lines)]' converted to NULL because [nQSError: 14025] No fact table exists at the requested level of detail:


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an OTBI report using the following select:

SELECT
  "General Ledger - Journals Real Time"."- Account"."General Ledger Code Combination Identifier" s_1,
  "General Ledger - Journals Real Time"."- Cost Center Segment"."Cost Center Code" s_2,
  "General Ledger - Journals Real Time"."Posting Status"."Posting Status Description" s_3,
  "General Ledger - Journals Real Time"."Time"."Fiscal Date" s_4,
  "General Ledger - Journals Real Time"."- Lines"."Journal Line Accounted Amount Credit" s_5,
  "General Ledger - Journals Real Time"."- Lines"."Journal Line Accounted Amount Debit" s_6
FROM "General Ledger - Journals Real Time"

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