Oracle Fusion OTBI: BI Report fails with [nQSError: 14081] when adding the Cost Center Code
(Doc ID 2071595.1)
Last updated on MAY 15, 2023
Applies to:
Oracle Fusion General Ledger Cloud Service - Version 11.1.9.2.0 and laterInformation 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
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
Symptoms |
Cause |
Solution |