After R12 Upgrade, Reports Based on Custom Subject Area Are Not Working With Error " [nQSError: 15018] Incorrectly defined logical table source (for fact table Fact - xxxxxxxxxxxxx) does not contain mapping for..." (Doc ID 2277243.1)

Last updated on JULY 31, 2017

Applies to:

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

Symptoms

After R12 upgrade, custom reports based on custom subject areas (CSA) are not working. 

ERROR
-----------------------
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 15018] Incorrectly defined logical table source (for fact table Fact - custExt4ba32300_7007_4cce_b26f_c29833852df9) does not contain mapping for [Dim - Customer.Country Code, case when Dim - Customer.State is null then Dim - Customer.Province else Dim - Customer.State end ]. (HY000)
SQL Issued: SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1',ENABLE_DIMENSIONALITY=1;SELECT 0 s_0, "custExt4ba32300_7007_4cce_b26f_c29833852df9"."Campaign_c"."ROIReferenceNumber_c" s_1, "custExt4ba32300_7007_4cce_b26f_c29833852df9"."Lead0"."CustomerId" s_2, "custExt4ba32300_7007_4cce_b26f_c29833852df9"."Lead0"."ExtnAttributeChar003" s_3, "custExt4ba32300_7007_4cce_b26f_c29833852df9"."Lead0"."ExtnAttributeChar004" s_4, "custExt4ba32300_7007_4cce_b26f_c29833852df9"."Lead0"."ExtnAttributeChar006_Meaning" s_5, "custExt4ba32300_7007_4cce_b26f_c29833852df9"."Lead0"."ExtnAttributeChar039" s_6, "custExt4ba32300_7007_4cce_b26f_c29833852df9"."Lead0"."ExtnAttributeTimestamp002" s_7, "custExt4ba32300_7007_4cce_b26f_c29833852df9"."Lead0"."LeadCustomerName" s_8, "custExt4ba32300_7007_4cce_b26f_c29833852df9"."Lead0"."LeadId" s_9, "custExt4ba32300_7007_4cce_b26f_c29833852df9"."Organization0"."ExtnAttributeChar003_Meaning" s_10, "custExt4ba32300_7007_4cce_b26f_c29833852df9"."Organization0"."ExtnAttributeChar013_Meaning" s_11, "custExt4ba32300_7007_4cce_b26f_c29833852df9"."Organization0"."ExtnAttributeChar019_Meaning" s_12, "custExt4ba32300_7007_4cce_b26f_c29833852df9"."Organization0"."ExtnAttributeChar021_Meaning" s_13, "custExt4ba32300_7007_4cce_b26f_c29833852df9"."Organization0"."OrgPartyPrimaryPhoneCountryCode"||"custExt4ba32300_7007_4cce_b26f_c29833852df9"."Organization0"."OrgPartyPrimaryPhoneAre....


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot see reports that were working before

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