Error while generating the report and exporting data to excel

(Doc ID 2369654.1)

Last updated on MARCH 05, 2018

Applies to:

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

Symptoms

On : 11.12.1.0.0 version, Analytics

When attempting to execute a custom report, the following error occurs.

ERROR
-----------------------
 Error Details
Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
Please have your System Administrator look at the log for more details on this error. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS.
Please have your System Administrator look at the log for more details on this error. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed:
Please have your System Administrator look at the log for more details on this error. (HY000)
State: HY000. Code: 14025. [nQSError: 14025] No fact table exists at the requested level of detail: [,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,[Dim - Revenue.Quantity, Dim - Revenue.Currency, Dim - Revenue.Revenue Unit Price, Dim - Revenue.CRM Currency Conversion Rate],,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,[Dim - Partner Extension.Extension Attribute Number 004, Dim - Partner Extension.Extension Attribute Character 058],,,,,,,[Dim - Opportunity Extension.Extension Attribute Character 018, Dim - Opportunity Extension.Extension Attribute Character 053, Dim - Opportunity Extension.Extension Attribute Character 054, Dim - Opportunity Extension.Extension Attribute Character 055, Dim - Opportunity Extension.Extension Attribute Character 056, Dim - Opportunity Extension.Extension Attribute Character 057, Dim - Opportunity Extension.Extension Attribute Character 058, Dim - Opportunity Extension.Extension Attribute Character 059, Dim - Opportunity Extension.Extension Attribute Character 065, Dim - Opportunity Extension.Extension Attribute Character 073, Dim - Opportunity Extension.Extension Attribute Character 115, Dim - Opportunity Extension.Extension Attribute Character 150, Dim - Opportunity Extension.Extension Attribute Character 180, Dim - Opportunity Extension.Extension Attribute LOV 018, Dim - Opportunity Extension.Extension Attribute LOV 053, Dim - Opportunity Extension.Extension Attribute LOV 073, cast(Dim - Opportunity Extension.Extension Attribute Clob 002 as VARCHAR ( 2500 )) , cast(Dim - Opportunity Extension.Extension Attribute Timestamp 009 as DATE ) ],,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Opty Detail,,Customer Detail,,[Dim - Item.Part Number, Dim - Item.Key Id],,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,[Dim - Customer Organization Extension.Extension Attribute Character 018],,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,[Dim - Partner.Partner Organization Name, Dim - Partner.Partner Id, Dim - Partner.Partner Tier Name, Dim - Partn
Please have your System Administrator look at the log for more details on this error. (HY000)
State: HY000. Code: 14025. er.Channel Manager Person Name],,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Detail,[Dim - Deal Registration Extension.Extension Attribute Character 002, Dim - Deal Registration Extension.Extension Attribute LOV 004, Dim - Deal Registration Extension.Extension Attribute Number 005, case when Dim - Deal Registration Extension.Extension Attribute Character 031 in ([ 'Asia South', 'Greater China', 'India', 'Japan', 'Korea', 'Pacific'] ) then 'APJ' when Dim - Deal Registration Extension.Extension Attribute Character 031 in ([ 'Central', 'EMEA Central', 'EMEA Emerging', 'EMEA MIDIS', 'EMEA North', 'EMEA South', 'Emerging', 'MIDIS', 'North', 'Northern', 'South', 'Southern'] ) then 'EMEA' when Dim - Deal Registration Extension.Extension Attribute Character 031 in ([ 'Canada', 'United States'] ) then 'NAM' when Dim - Deal Registration Extension.Extension Attribute Character 031 = 'Latin America' then 'LAM' else Dim - Deal Registration Extension.Extension Attribute Character 031 end ],,[Dim - Deal Registration Product Extension.Extension Attribute LOV 004, Dim - Deal Registration Product Extension.Extension Attribute LOV 005],,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,].
Please have your System Administrator look at the log for more details on this error. (HY000)
State: HY000. Code: 14081. [nQSError: 14081] You may be able to evaluate this query if you remove one of the following column references: Dim - Customer Organization Extension.Extension Attribute Character 018, Dim - Customer.Customer Row ID, Dim - Deal Registration Extension.Extension Attribute Character 002, Dim - Deal Registration Extension.Extension Attribute LOV 004, Dim - Deal Registration Extension.Extension Attribute Number 005, Dim - Deal Registration Product Extension.Extension Attribute LOV 004, Dim - Deal Registration Product Extension.Extension Attribute LOV 005, Dim - Deal Registration.Deal Id, Dim - Item.Key Id, Dim - Item.Part Number, Dim - Opportunity Extension.Extension Attribute Character 018, Dim - Opportunity Extension.Extension Attribute Character 053, Dim - Opportunity Extension.Extension Attribute Character 054, Dim - Opportunity Extension.Extension Attribute Character 055, Dim - Opportunity Extension.Extension Attribute Character 056, Dim - Opportunity Extension.Extension Attribute Character 057, Dim - Opportunity Extension.Extension Attribute Character 058, Dim - Opportunity Extension.Extension Attribute Character 059, Dim - Opportunity Extension.Extension Attribute Character 065, Dim - Opportunity Extension.Extension Attribute Character 073, Dim - Opportunity Extension.Extension Attribute Character 115, Dim - Opportunity Extension.Extension Attribute Character 150, Dim - Opportunity Extension.Extension Attribute Character 180, Dim - Opportunity Extension.Extension Attribute LOV 018, Dim - Opportunity Extension.Extension Attribute LOV 053, Dim - Opportunity Extension.Extension Attribute LOV 073, Dim - Opportunity.Opportunity ID, Dim - Partner Extension.Extension Attribute Character 058, Dim - Partner Extension.Extension Attribute Number 004, Dim - Partner.Channel Manager Person Name, Dim - Partner.Partner Id, Dim - Partner.Partner Organization Name, Dim - Partner.Partner Tier Name, Dim - Revenue.CRM Currency Conversion Rate, Dim - Revenue.Currency, Dim - Revenue.Qu
Please have your System Administrator look at the log for more details on this error. (HY000)
State: HY000. Code: 14081. antity, Dim - Revenue.Revenue Unit Price, case when Dim - Customer Organization Extension.Extension Attribute Character 018 like 'EMEA%' then 'EMEA' when Dim - Customer Organization Extension.Extension Attribute Character 018 in ([ 'Asia South', 'Greater China', 'India', 'Japan', 'Korea', 'Pacific'] ) then 'APJ' when Dim - Customer Organization Extension.Extension Attribute Character 018 = 'Latin America' then 'LAM' when Dim - Customer Organization Extension.Extension Attribute Character 018 in ([ 'Canada', 'United States'] ) then 'NAM' else Dim - Customer Organization Extension.Extension Attribute Character 018 end , case when Dim - Deal Registration Extension.Extension Attribute Character 031 in ([ 'Asia South', 'Greater China', 'India', 'Japan', 'Korea', 'Pacific'] ) then 'APJ' when Dim - Deal Registration Extension.Extension Attribute Character 031 in ([ 'Central', 'EMEA Central', 'EMEA Emerging', 'EMEA MIDIS', 'EMEA North', 'EMEA South', 'Emerging', 'MIDIS', 'North', 'Northern', 'South', 'Southern'] ) then 'EMEA' when Dim - Deal Registration Extension.Extension Attribute Character 031 in ([ 'Canada', 'United States'] ) then 'NAM' when Dim - Deal Registration Extension.Extension Attribute Character 031 = 'Latin America' then 'LAM' else Dim - Deal Registration Extension.Extension Attribute Character 031 end , cast(Dim - Opportunity Extension.Extension Attribute Clob 002 as VARCHAR ( 2500 )) , cast(Dim - Opportunity Extension.Extension Attribute Timestamp 009 as DATE )
Please have your System Administrator look at the log for more details on this error. (HY000)


The report was working fine yesterday evening

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open BI,
2.SAW_SRC_PATH='/shared/Custom/Veritas_PRM/PRM Reports/Tile Partner Opportunites by Partner Reg Status Detail'
3. Error occurs

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot see detail report

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