SQL Error when attempting to run the Rejected Items Summary analytic in a CRM environment (Doc ID 2062884.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Fusion Product Hub Cloud Service - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

Issue
--------
In Fuse/Simplified UI, when clicking on "Analytics" and finding any item related analytic, on clicking on these get ODBC errors such as :

Error in Rejected Items summary -
Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27047] Nonexistent table: "PIM - Item". (HY000)
SQL Issued: {call NQSGetQueryColumnInfo('SELECT "Time"."Quarter" FROM "PIM - Item"')}
SQL Issued: SELECT "Time"."Quarter" FROM "PIM - Item"

Steps to Duplicate
---------------------------
1)Log into CRM environment FUSE UI
2)Click on Analytics
3)Find any item related analytics (such as Rejected Items summary)
4)select it and get error

Expected Behaviour
-----------------------------
Not to get errors

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