My Oracle Support Banner

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 DECEMBER 22, 2020

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.4.0.0 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

 

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.