Not Able To See Any Data In Seeded Reports on Sales Dashboard (Doc ID 1602167.1)

Last updated on NOVEMBER 05, 2016

Applies to:

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

Symptoms

When attempting to open some seeded reports that were added in Sales Dashboard, no result are displayed.

 

ERROR
"Open Opportunities" seeded report is, there are filters such as "Enterprise Quarter is equal to / is in 2011 Q 2" so closed periods

OR the following error displays:

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)

 

STEPS
1. Navigator > Sales dashboard > Administration > Customize Salas Dashboard page
2. Add some seeded reports

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