My Oracle Support Banner

Fusion OTBI - Errors in OTBI Subject Area Innovation Management - Ideas Real Time (Doc ID 2107979.1)

Last updated on NOVEMBER 17, 2017

Applies to:

Oracle Fusion Project Management Cloud Service - Version 11.1.10.0.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 11.1.10.0.0 and later
Oracle Fusion Application Toolkit - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Symptoms

When creating an analysis in OTBI in the Innovation Management - Ideas Real Time we get an error.

This is a very simple report, only showing "count of ideas" and Time (Month). Without Time dimension we get the count of idea's as expected.

Odbc driver returned an error (SQLExecDirectW).

Error Details
 
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: 17001] Oracle Error code: 904, message: ORA-00904: "V515120561"."CREATION_DATE1": invalid identifier at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed. (HY000)

SQL Issued: SET VARIABLE PREFERRED_CURRENCY='Document Currency';SELECT 0 s_0, "Innovation Management - Ideas Real Time"."Time"."Month" s_1, "Innovation Management - Ideas Real Time"."Ideas"."Count of Ideas" s_2 FROM "Innovation Management - Ideas Real Time" FETCH FIRST 75001 ROWS ONLY

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.