Fusion CRM OTBI: Organization and Contact Object fields are triggering ORA-00904 errors in analyses
Last updated on SEPTEMBER 21, 2016
Applies to:Oracle Fusion Application Toolkit Cloud Service - Version 126.96.36.199.0 and later
Oracle Fusion Common CRM - Version 188.8.131.52.0 and later
Oracle Fusion Application Toolkit - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
On : 220.127.116.11.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
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.
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