Odbc Error In Analytics Reports (Doc ID 2171873.1)

Last updated on AUGUST 01, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.11.1.0 version, Technology Management - BI & Reporting

ODBC error with some OOTB reports


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='User Preferred Currency 1';SELECT 0 s_0, "Sales - CRM Siebel Forecasting"."Currency"."BI Common Currency Code" s_1, "Sales - CRM Siebel Forecasting"."Employee"."Employee Login" s_2, "Sales - CRM Siebel Forecasting"."Forecast"."Forecast Date" s_3, "Sales - CRM Siebel Forecasting"."Time"."Quarter" s_4, "Sales - CRM Siebel Forecasting"."Time"."Year" s_5,
[...]


ERROR
-----------------------
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P



STEPS
-----------------------
1) Go to Analytics in SUI.
2) search for the word "forecast"
3) Open "My Current Year Forecast" report

(You can also navigate to this report and its sibling reports underneath Siebel Content folders in the BI Catalog here:
/Shared Folders/Sales/Analytic Library/Siebel Content)


BUSINESS IMPACT
-----------------------
This results in confusion for new BI Administrator users exploring the reports to which they have access.

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