Oracle Fusion Applications Business Intelligence - OTBI Analysis on "Sales - CRM Pipeline" with "Deal Size" Column Gives ODBC Errors ORA-12154

(Doc ID 1504363.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Fusion Transactional Business Intelligence - Version 11.1.4.0.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

You are running an analysis based on the Sales - CRM Pipeline Subject Area. The report runs successfully unless you include the Deal Size column from the Opportunity DIM.  With this column included the analysis end with error:

Error
View Display Error

Error
View Display Error

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: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified at OCI call OCIServerAttach. [nQSError: 17014] Could not connect to Oracle database. (HY000)
SQL Issued: SET VARIABLE PREFERRED_CURRENCY='Local Currency';SELECT 0 s_0, "Sales - CRM Pipeline"."Employee"."Employee Name" s_1, "Sales - CRM Pipeline"."Opportunity"."Deal Size" s_2, "Sales - CRM Pipeline"."Opportunity"."Opportunity Name" s_3, SORTKEY("Sales - CRM Pipeline"."Opportunity"."Deal Size") s_4 FROM "Sales - CRM Pipeline" FETCH FIRST 65001 ROWS ONLY

 

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