Fusion CRM OTBI: Organization and Contact Object fields are triggering ORA-00904 errors in analyses (Doc ID 1608328.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Fusion Application Toolkit Cloud Service - Version 11.1.7.0.0 and later
Oracle Fusion Common CRM - Version 11.1.7.0.0 and later
Oracle Fusion Application Toolkit - Version 11.1.7.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.7.0.0 version, Technology Management - BI & Reporting

My issue is the following the R7 upgrade

Fields are now available in BI but not working:
As soon as I add one field of Contact Extension folder (using Sales - CRM Customers and Contacts Real Time Subject Area), I get an ODBC error

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


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users may encounter ORA errors when running some analyses.

This same behaviour may be seen with other field and table references but all will manifest with the same 'Invalid Identifier' 'ORA-00904' error messages.

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