My Oracle Support Banner

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

Last updated on JANUARY 20, 2020

Applies to:

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


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


[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:

The issue can be reproduced at will with the following steps:
1. Create an OTBI report using the following 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"


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.